connection string

Sheraz Khan · July 5th, 2007, 06:44 AM

hi
i m trying to connect my web application page to the default northwind database of sql server 2000. The database is on my local system.
Can some one tell me what i m doing wrong?

Cheers

Code:

Dim con As SqlConnection
        Dim com As SqlCommand
        Dim dr As SqlDataReader

        con = New SqlConnection("data source=localhost;database=northwind;")

        com = New SqlCommand("select * from customers")
        con.Open()
        dr = com.ExecuteReader
        dr.Close()
        Response.Write("Connection closed")
        con.Close()

mike_remember · July 5th, 2007, 07:03 AM

Use the connection string below:

"Data Source=yourmachinename;initial catalog=Northwind;Integrated Security=SSPI;Persist Security Info=False"

Regards
Mike

Don't expect too much, too soon.

Sheraz Khan · July 5th, 2007, 07:17 AM

Mike after apended the code i m getting the error message"
SQL Server does not exist or access denied. "

Cheers

Code:

Dim con As SqlConnection
        Dim com As SqlCommand
        Dim dr As SqlDataReader

        'con = New SqlConnection("data source=localhost;database=northwind;user id=sa;password=opensesame")

        con = New SqlConnection("data source=sherazpc;initial catalog=Northwind;Integrated Security=SSPI;Persist security info=false")

        com = New SqlCommand("select * from customers")
        con.Open()
        dr = com.ExecuteReader
        dr.Close()
        Response.Write("Connection closed")
        con.Close()

Cheers
Sheraz

mike_remember · July 5th, 2007, 08:33 AM

Well

You need to put in the correct machine name/or sql server name in the data source part. To determine the same in a simpler way, I suggest that you manually drag a dataset to your form design and from the properties set the connectionstring, once the connectionstring is set, you will be able to track the sql server name from there.

Regards
Mike

Don't expect too much, too soon.