Print

[osm]

Trying to use an *.odbc connection file to import data.  I created the file using the import connection wizard.  Below is the error that appears.  
Database connection error!
DB Exception: Driver's SQLSetConnectAttr failed
Invalid connection string attribute

Check[CONNECT] section parameters in the <File Location>
Connection string: "DRIVER={Microsoft ODBC for Oracle};UID=<username>;PWD=<password>;SERVER=<databasename>;;="
What am I missing?  When I create the file, I can connect without any problems.

Thank you

[Forum Administrator]

osm,

Thank you for contacting the OrgPlus Support Team.

Can you please let us know what type of database you are trying to connect to? "Microsoft ODBC for Oracle" If it's Oracle please use the Oracle selection, if it's SQL then please use that selection, for everything else (like My SQL, Access, and others) us ODBC connection. Also, it's important to note that the ODBC connections must be built from windows and not inside OrgPlus. OrgPlus just uses what was already created via "ODBC Data Source Administrator".

You can find additional support at our online Support Center at:

http://www.humanconcepts.com/support.

If you require further assistance please feel free to contact the OrgPlus Support Team by clicking here: http://humanconcepts.com/servlets/res02.WebSupport.

Sincerely,

The OrgPlus Support Team
OrgPlus. Organize. Visualize. Strategize

HumanConcepts
www.orgplus.com