Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Cannot connect to local sql server 2000 from VB.NET on pc ..

 
   Database Help (Home) -> Connect RSS
Next:  Which Sql Server error number is used when a tabl..  
Author Message
dee

External


Since: Feb 14, 2005
Posts: 1



(Msg. 1) Posted: Mon Feb 14, 2005 1:40 pm
Post subject: Cannot connect to local sql server 2000 from VB.NET on pc ru
Archived from groups: microsoft>public>sqlserver>connect (more info?)

Hi

I just installed SQL Server 2000 to run locally on a WinXP Pro SP2 PC.
When I run the following VB.NET code:

Protected Const SQL_CONNECTION_STRING As String = _
"Server=localhost;" & _
"DataBase=Northwind;" & _
"Integrated Security=SSPI"

Dim connectionString As String = SQL_CONNECTION_STRING

Dim cnnNW As New SqlConnection(connectionString)

I can't connect to sql server.
This code works fine on a Windows 2000 Pro SP2 pc.

Thanks for your help.

Dee

 >> Stay informed about: Cannot connect to local sql server 2000 from VB.NET on pc .. 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
remote server and local server - distributed queries? - I have a remote server that I'm able to successfully register on a local sql 2000 server through EntMgr, and make successful selects on both remote and local server databases via odbc. Here's the question - Can I have a local server with some..

Unable to connect to a production sql server 2000 database -

Unable to connect to a production sql server 2000 database -

So, how does it connect ?? - Hi , How does sql server client connect to SQL Server. Is there a sql.ini for sql server. If i add a alias entry in Client network utility where does it store the info. Thanks Neeraj

SBS 2003 and SQL 2000 unable to connect via internet - Hi, I have been reading everything I can in the Knowledge base and here about connection problems and am still unable to resolve my problem In the connection string I use the IP address for the SQL Server and it works fine when I'm connected to the..
   Database Help (Home) -> Connect All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]