Error configuring ODBC data source

Got a problem you cannot solve? Try here.
Post Reply
QooScho
Posts: 152
Joined: Fri Apr 15, 2011 1:02 am

Error configuring ODBC data source

Post 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
giaviv
Posts: 2039
Joined: Fri Dec 17, 2010 1:39 pm

Re: Error configuring ODBC data source

Post by giaviv »

Dear Hansjoerg,

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

Thanks!
Aviv Giladi
InstallAware Software

White Papers (HowTos) - http://www.installaware.com/publication ... papers.htm
Product Guides - http://www.installaware.com/publication ... guides.htm
InstallAware Help -F1 anywhere in the InstallAware IDE
QooScho
Posts: 152
Joined: Fri Apr 15, 2011 1:02 am

Re: Error configuring ODBC data source

Post 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
giaviv
Posts: 2039
Joined: Fri Dec 17, 2010 1:39 pm

Re: Error configuring ODBC data source

Post by giaviv »

Just the IA skeleton - mia, mpr and dfm files. No need for your actual software (minus the driver of course).

Thanks
Aviv Giladi
InstallAware Software

White Papers (HowTos) - http://www.installaware.com/publication ... papers.htm
Product Guides - http://www.installaware.com/publication ... guides.htm
InstallAware Help -F1 anywhere in the InstallAware IDE
QooScho
Posts: 152
Joined: Fri Apr 15, 2011 1:02 am

Re: Error configuring ODBC data source

Post 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
QooScho
Posts: 152
Joined: Fri Apr 15, 2011 1:02 am

What that?

Post by QooScho »

Hmmm??

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

regards
Hansjoerg
giaviv
Posts: 2039
Joined: Fri Dec 17, 2010 1:39 pm

Re: Error configuring ODBC data source

Post by giaviv »

It was spam - the user was banned. Sorry about that.
I haven't received anything from you - could you please verify?

Thanks!
Aviv Giladi
InstallAware Software

White Papers (HowTos) - http://www.installaware.com/publication ... papers.htm
Product Guides - http://www.installaware.com/publication ... guides.htm
InstallAware Help -F1 anywhere in the InstallAware IDE
QooScho
Posts: 152
Joined: Fri Apr 15, 2011 1:02 am

Re: Error configuring ODBC data source

Post by QooScho »

I have send the project again with my company address

regards
Hansjoerg
QooScho
Posts: 152
Joined: Fri Apr 15, 2011 1:02 am

Re: Error configuring ODBC data source

Post by QooScho »

Dear Aviv,
have you received my project files?
have you any idea why ODBC DSN is not configured?

regards
Hansjoerg
Post Reply