03-01-2011 03:53 AM
Hi all,
I am using labsql(and m quite new to it) and Mysql server 5.1.I wanted to know how to connect to the database without manually changing the dsn name from the administrative tools/ODBC driver 5.1. I want to install exe in multiple PC's and it would be of great help if I could do the connection directly though my Vi.
I went through many of the forums and came to know that "Provider=ProviderName; Data Source=DatabaseSource; Initial Catalog=DatabaseName; User ID=UserID; Password=Password" , should solve the problem.But where in my case I m still confused. The above connection string does not work fine with me.
Can anyone please help me out.
Solved! Go to Solution.
03-01-2011 04:13 AM
I haven't used labsql, but in Database Connection kit you can a string constant with the information you posted rather directly. That string can be made by making a .udl file and opening it in e.g. notepad and stealing the text (or most of it)
/Y
03-01-2011 04:35 AM
03-01-2011 04:49 AM
Have a look here, where I include a picture to show how to form a string constant to connect to the database. Some of the subsequent posts in that thread should also be helpful.
Good luck!
Ian