06-28-2007 09:00 PM
06-28-2007 09:11 PM - edited 06-28-2007 09:11 PM
Message Edited by mikeporter on 06-28-2007 10:12 PM
06-28-2007 10:13 PM
06-29-2007 03:33 AM
hai
check wheather you have installed the MySQL is installed properly, and ensure in ODBC connection the Driver is added and it is installed correctly, check the server host id and user name password and port id are corect, try reinstalling the MySQL and check once from the MySQL query browser wheather the connection is established. if it is then it should work with the DB Open function. else i will get back with furthur solutions.
06-29-2007 04:08 AM
06-29-2007 05:04 AM
06-29-2007 05:07 AM
06-29-2007 05:20 AM
ok Thanksss a lot...
But the test connection was successful for user dsn and system dsn and in that cases the database names were also appearing.
But i think labview can deal with file dsn only as the user dsn and system dsn were giving me errors.
Thats why i tried to create file dsn.Dont know what is happening.
Any way i tried to establish a connection wthout using dsn by giving connection information of the DB tools connect as follows
DRIVER=MySQL ODBC 3.51 Driver; DB=dmu; server=Localhost; UID=root; PWD=pwd; OPTION=785
it can connect to my sql.But when executing query i have specify the database name also along with the table name
say....select * from dmu.tab1(tab1 be the table name)So i changed to Data Source Name instead of DB but still the same.
So any way i have to create file dsn.
I will check the Driver installation is proper as told by u,once again.And if not if possible can u send me the working one pls?
Thanks once again
06-29-2007 05:40 AM