Click here to Skip to main content
12,065,756 members (34,105 online)
Rate this:
 
Please Sign up or sign in to vote.
See more: VB VB.NET
Hi,
I am unable to connect ODBC to the Sql Server 2005. getting the sql server errors : Connection Failed
Sql state : '01000'
Sql Server Error : '11001'
Posted 7-Jan-11 22:15pm
Edited 9-Jan-11 20:30pm
v2
Comments
Estys 8-Jan-11 3:21am
   
What error, how are you trying to connect? Show us please.
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

You have stated that you're getting Error but you haven't taken care to state your error to be more precise.

HERE[^] is a Troubleshooter that can help you around.
  Permalink  
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 2

Please be specific with error message you are getting, because the reason may be different for different error message.

FYI

Standard Security
Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;
Use serverName\instanceName as Data Source to connect to a specific SQL Server instance.
Are you using SQL Server 2005 Express? Don't miss the server name syntax Servername\SQLEXPRESS where you substitute Servername with the name of the computer where the SQL Server 2005 Express installation resides.

Standard Security alternative syntax

This connection string produce the same result as the previous one. The reason to include it is to point out that some connection string keywords have many equivalents.
Server=myServerAddress;Database=myDataBase;User ID=myUsername;Password=myPassword;Trusted_Connection=False;

Trusted Connection

Data Source=myServerAddress;Initial Catalog=myDataBase;Integrated Security=SSPI;

Trusted Connection alternative syntax

This connection string produce the same result as the previous one. The reason to include it is to point out that some connection string keywords have many equivalents.
Server=myServerAddress;Database=myDataBase;Trusted_Connection=True;

Connecting to an SQL Server instance

The syntax of specifying the server instance in the value of the server key is the same for all connection strings for SQL Server.
Server=myServerName\theInstanceName;Database=myDataBase;Trusted_Connection=True;
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy | Mobile
Web04 | 2.8.160207.1 | Last Updated 10 Jan 2011
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100