Thread: Error when configuring a dataadapter

Hi

I get the following error when I try to configure my dataadapter

I have tested the connections in the server explorer and they work

"DRIVER={MySQL ODBC 3.51 Driver};SERVER=localhost;DATABASE=myDatabase;USER= myUsername;PASSWORD=myPassword;OPTION=3;"




I am new at this so its probably something obvious

I take it your using Visual Studio..

Try using the wizard to make the connection then copy the code it produces.

This is the error when I try using the wizard

(yep its visual studio on windows xp)

Unless I'm missing it, I beleive you have failed to include the error message.

Evidently you are trying to establish an ODBC connection but as Paszt noted you haven't included the Exception/Error message ... btw have you checked that certain ODBC connection is existing on your machine? Waiting for your feedback

Cheers

added: Also be sure that you are entering the right UID and PWD as when you first install MySQL, it creates a " root " user account (in the sys datbase's user table) with a blank password.

Hi

It seems to be working again after I restarted the pc.
The connections were correct as I was able to see the tables in server explorer

I have attached the error message
(I mustent have uploaded the file previously)

Thanks

Evidently you haven't installed the appropriate driver ... google for "Install mySQL driver"

Cheers