How do I create a DSN for the SQL toolkit

[Mark]

Is there some document that describes all of the steps to create a DSN so I can connect to a database via the LabVIEW SQL toolkit? Thanks

[Jared 323]

Mark,

See attached file. It was acquired from NI by someone at my company. I added a couple of the inputs to increase the flexibility.

A tip to using it. I put a variable '1stBoot' in my program's ini file and if its true this code will run. If DSN gets setup with no errors, i change the value of '1stBoot' to false.

Have fun,
Jared

[Dennis_Knutson]

I'm not sure this VI will work with a SQL Server DSN. I always just use the ODBC Data Source Administrator. The thing to remember is that every database could be a little different. Some Access databases require a system database (.mdw file) and others don't. Some SQL Server databases have Windows NT authentication of user ID and some use SQL Server itself for the authentication. The person who designed the database should be the best reference in deciding between all of the options.

[Jared 323]

Mark,

I forgot to tell you, its saved as a 6.0 file. If you need 5.1, i can do a save as last version for you. Just email me if you need the earlier version.

Jared