Can someone provide me with a working example of Connection string for SQL Server 2005 EXPRESS?

[Dancho]

I tried connect to sql server 2005 by using "DBConnect()" and I have no idea how the connection string should be.

I didn't find any documention or example of connection string for MS SQL server 2005.

Best regards,

Dan.

[Kelly_R]

Hi Dan,

You have a couple of options here.   As for connection strings, the format is not inherent to CVI.  There are many good websites that can give you information on how to format a connection string.  This one is a good one to take look at. 

A second option you have is to use ODBC.  Here is a website with ODBC information.  CVI also ships with ODBC example programs, for example, a "Connect" program, which can be found at the following location:  C:\Documents and Settings\All Users\Documents\National Instruments\CVI\samples\sql\simple\connect.cws