Page 1 of 1

Error configuring ODBC data source

Posted: Tue Apr 26, 2011 7:28 am
by QooScho
Hello,
In my IA9 project I try to install and configure an ODBC entry for MySQL

Install ODBC Driver D:\Q8Install.Aware\Sources\myodbc\lib\myodbc5.dll as MySQL ODBC 5.1 Driver
Create ODBC DSN MyTestDSN (uses driver MySQL ODBC 5.1 Driver)

Installation seems ok, but then I get the error:

Error configuring ODBC data source: MyTestDSN, ODBC error 11: Invalid keyword-value pairs. Error with ConfigDSN or ConfigTranslator. Verify that the file MyTestDSN exists and that you can access

It seems that the Datasource name "MyTestDSN" is the problem. But why? I only want to create a new DSN Name.
If I got to control panel, Data Source ODBC and create the entry manually, I have no problem.

any ideas?

thanks a lot
regards
Hansjoerg

Re: Error configuring ODBC data source

Posted: Tue Apr 26, 2011 8:02 am
by giaviv
Dear Hansjoerg,

Could you please send me your project and your driver DLL to support at installaware.com?

Thanks!

Re: Error configuring ODBC data source

Posted: Tue Apr 26, 2011 8:26 am
by QooScho
Dear Aviv,

thank a lot for help.
Do you want the complete project folder or is the .mia and .mpr file enough?

regards
Hansjoerg

Re: Error configuring ODBC data source

Posted: Tue Apr 26, 2011 9:16 am
by giaviv
Just the IA skeleton - mia, mpr and dfm files. No need for your actual software (minus the driver of course).

Thanks

Re: Error configuring ODBC data source

Posted: Tue Apr 26, 2011 9:30 am
by QooScho
I have sent the project files to you.
Thanks a lot,

My Attributes for create dsn and the MySQL ODBC 5.1 driver

DESCRIPTION=MyServer Server MySQL
DRIVER=[WINSYSDIR]\myodbc5.dll
SERVER=localhost
UID=myuser
PWD=mypassword
DATABASE=mydb
PORT=3306

Perhaps there is something wrong with that?

regards
Hansjoerg

What that?

Posted: Tue Apr 26, 2011 12:55 pm
by QooScho
Hmmm??

what is that for a post?
nothing to do with the problem

regards
Hansjoerg

Re: Error configuring ODBC data source

Posted: Tue Apr 26, 2011 5:22 pm
by giaviv
It was spam - the user was banned. Sorry about that.
I haven't received anything from you - could you please verify?

Thanks!

Re: Error configuring ODBC data source

Posted: Wed Apr 27, 2011 1:02 am
by QooScho
I have send the project again with my company address

regards
Hansjoerg

Re: Error configuring ODBC data source

Posted: Wed Apr 27, 2011 9:11 am
by QooScho
Dear Aviv,
have you received my project files?
have you any idea why ODBC DSN is not configured?

regards
Hansjoerg