Wrox Programmer Forums
|
ASP.NET 2.0 Basics If you are new to ASP or ASP.NET programming with version 2.0, this is the forum to begin asking questions. Please also see the Visual Web Developer 2005 forum.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ASP.NET 2.0 Basics section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old July 5th, 2007, 06:44 AM
Authorized User
 
Join Date: May 2007
Posts: 73
Thanks: 4
Thanked 0 Times in 0 Posts
Default connection string

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()
__________________
Cheers
Sheraz
 
Old July 5th, 2007, 07:03 AM
Friend of Wrox
 
Join Date: Aug 2004
Posts: 550
Thanks: 0
Thanked 1 Time in 1 Post
Default

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.
 
Old July 5th, 2007, 07:17 AM
Authorized User
 
Join Date: May 2007
Posts: 73
Thanks: 4
Thanked 0 Times in 0 Posts
Default

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
 
Old July 5th, 2007, 08:33 AM
Friend of Wrox
 
Join Date: Aug 2004
Posts: 550
Thanks: 0
Thanked 1 Time in 1 Post
Default

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.





Similar Threads
Thread Thread Starter Forum Replies Last Post
Connection string MunishBhatia ASP.NET 2.0 Professional 4 May 16th, 2007 05:50 AM
Connection String jmss66 Oracle 4 August 8th, 2006 03:19 AM
Connection String slgknjn VB Databases Basics 2 February 26th, 2005 03:14 AM
Connection String fs22 Classic ASP Databases 3 August 30th, 2004 01:25 AM
Connection String Help. diamond2165 BOOK: ASP.NET Website Programming Problem-Design-Solution 1 November 7th, 2003 06:09 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.