02-23-2009 01:14 PM
Hi.
I'm using DB Connectivity Tools and MS Access Driver to connect to the database. My VI reads previous created data link. My problem is that I need do EXE file, and doesn't know how I can set the ODBC source in Windows directly in LabView, and create Datalink direct in LV (without using Tools->Create Data Link). Maybe somebody knows how to do this. Thanks in advance.
02-24-2009 04:10 AM
02-24-2009 06:15 AM
Help for your advice. It's very helpful.
So now, I'm trying to use odbccp32.dll, but it doesn't work. When I run the VI the ODBC sources don't change. Probably I do somethink wrong. I put a part of my VI to the JPG attachment.
02-24-2009 07:40 AM
02-24-2009 08:32 AM
02-24-2009 09:40 AM
02-24-2009 12:31 PM
Wiebe@CARYA wrote:
In the last string, don't seperate each parameter. Simply put a space
between two of them, not the quotes and \0. The \0 on the end is
automatically added by LabVIEW, so there is no need for that as well. Like I
mentioned, it should look like this: "DNS=databasename DBQ=filepath UID=user
PWD=password", where the quotes are not in the string. Perhaps the file path
needs quotes, if it contains spaces, but I don't think I use them, and it
works fine.
Instead of creating a DSN you can also simply pass those parameters to the "connection string" parameter of the DB Tools Open Connec (String).vi.
Rolf Kalbermatter
06-30-2009 05:23 AM
Can u send the program.I created a mdb file using create mdb vi,i attached.
Then i create system dsn in ODBC through control panel.how to do it programatically as like create mdb vi?