Where to find the table I made in SQL Server 2012 if I want to connect to that table in Labview?

[manny09]

I have made a table on SQL server express 2012. I want to connect to that table using Labview. I am using DB tools open connection.vi to connect to the table. I am thinking I need to provide the path in the connection information where the table is saved. But somehow, I am not able to find out where the file is located. Is there a way I can use the connection information to connect to that table using Labview. Or if there are some suggestion on how to connect to the table I want to modify using Labview?

[JoeySpinella]

Hi Manraj,

I think this KB is helpful: Connection Methods in the Enterprise Connectivity Toolkit. It shows the 5 different ways we can address the Open DB Connections.vi.

You will not be able to programmatically determine the location of the database file. I believe the table is saved as part of the database, which is configured in server express.

Basic Youtube Server Express how to:

http://www.youtube.com/watch?v=PrPk4qvyAxo

http://www.youtube.com/watch?v=PGUnUrkQWi8