sql server - Script Component - ODBC exception password incorrect - package validation -


i'm trying insert rows filemaker using script component. followed article creating odbc destination script component

when edit script here set connection string:

public override void acquireconnections(object transaction) {      string connectionstring;     //connectionstring = this.connections.fmconnection.connectionstring;     odbcconn = new odbcconnection("uid=someuid;dsn=fm;pwd=somepassword");     odbcconn.open();  } 

i connection string this.connections object , set new odbcconnection object. not work keep getting exception. tried setting connection string manually can see above. still exception.

in other parts of package use connection manager filemaker , works. not in script component.

the exceptions i'm getting is:

error @ mypackagename: [filemaker] password incorrect

what wrong?


Comments

Popular posts from this blog

php - Vagrant up error - Uncaught Reflection Exception: Class DOMDocument does not exist -

vue.js - Create hooks for automated testing -

Add new key value to json node in java -