How to link my access database to ODBC?

[karpaga]

I create a mdb access file i want to link it to the ODBC system dsn programatically.can anyone give me a solution?

[MikeS81]

Hi kavi,

this link shows a VB solution.

http://www.vbforums.com/showthread.php?p=2154170#post2154170

Mike

[karpaga]

HI mike

Thanks for the support u r giving me.

I dont know VB is there is any other solution labview 

[MikeS81 · Accepted solution]

Hi kavi,

attached you'll find an example to create an udl link to your database. You need a template udl file for that, create it it for an existing database. The attached vi, needs this template as an input to copy the file and change the liked mdb.

Hope it helps.

Mike

[Neil_Li]

kavi,

LabVIEW Database Connectivity toolkit is the tool you need to connect to mdb by ODBC. It has a bunch of examples show how to connect to database, query/insert data.

[jcarmody]

http://sql-lv.sourceforge.net/

[karpaga]

HI

i already create a mbd using create mdb vi .I attached it.

Then for connecting it to system dsn in ODBC i have to go into control panel ..........and do it. How to do it programatically?

[MikeS81]

Hi kavi,

did you try my solution with the udl file? Where do you have problems with it?

Mike

[karpaga]

is it a solution for ODBC system dsn link?I cand understand.

I tried ur logic

[MikeS81]

Hi kavi,

the new database path shall contain the path to the database to create not to an udl file. It should be something like "test.mdb". The other path input is the path to the udl template, which will be copied and updated with the new information. The result is the udl file which you need for the "DB Tools Open Connection.vi" to open your new created database.

Mike