Opening Connection to Database

[ryodoan]

Ok, I just did this at my school a while ago, but I have totaly forgotten how I did it... heh...

I remember how to code everything, but I forgot how to get the connection string...

For example.

Dim myDBConn As SqlClient.SqlConnection

Dim myConnection as string= "UID=school;PWD=password;DATABASE=School;WSID=L132DG301;APP=Microsoft Open Database Connectivity;Server=ElderSQL"

myDBConn.Open()
Dim _dt As New DataTable

I cant remember how we got the myConnection (the string)...

If anyone has any suggestions for a method to make a connection to a database, it doesnt have to be the above way, and anyhelp would be much appreciated.

 

[Paszt]

The connection string is dependent upon the type of dataSource and the connection settings you want to use.

Check out ConnectionStrings.com for examples for many different types of dataSources.