I am trying to write a program to iterate through data in a SQL server table to us in a http request. I found the following code to use:
'replace the database information <source>, <catalog>, <table> with your database information
Dim conn As SqlConnection = New SqlConnection("Data Source=<source>; Integrated Security=SSPI; Initial Catalog=<catalog>")
'open the database connection
conn.Open()
Is there an easy way to find the path to substitute for <source> & <catalog>? I used C:\Documents and Settings\Brian\My Documents\SQL Server Management Studio Express\Databases\Database
s and the database I am using is not there! Also, what do they mean by catalog?
Start Free Trial