SQL Connectivity

Page 1 of 1

1 Replies - 583 Views - Last Post: 19 April 2010 - 02:12 PM Rate Topic: -----

#1 shaboury  Icon User is offline

  • D.I.C Head

Reputation: 3
  • View blog
  • Posts: 52
  • Joined: 30-May 09

SQL Connectivity

Posted 19 April 2010 - 01:32 PM

i have a problem with SQL server 2005 connectivity using the ODBC data source admin. in os: windows 7
1) i add the SQL file using the tab "System DSN"
2) i add a new data source name and the sql server i want to connect to (.\SQLEXPRESS)
3) and i set the authenticity of login ID to " With windows NT authenticity using the network login ID"
but i got an error SQLSTATE:'01000'
SQL server Error: '11001'
Connection failed
SQLSTATE:'08000'
SQL server Error: '6'
Specified SQL server not found

i made the same steps on another computer (os:windows XP ) and it works !

Is This A Good Question/Topic? 0
  • +

Replies To: SQL Connectivity

#2 PsychoCoder  Icon User is offline

  • Google.Sucks.Init(true);
  • member icon

Reputation: 1619
  • View blog
  • Posts: 19,853
  • Joined: 26-July 07

Re: SQL Connectivity

Posted 19 April 2010 - 02:12 PM

Well that error is saying the SQL server with that name cannot be found, pretty self explanatory message
Was This Post Helpful? 0
  • +
  • -
Page 1 of 1