connection failed errors trying to set up a ODBC connection

connection failed errors trying to set up a ODBC connection

Post by barret bon » Sat, 09 Aug 2008 10:02:35



I get connection failed errors trying to set up a ODBC connection (On XP !
SQL Server 2005 !) ( I have S.M. Studio Express running, so it's there)

I get error 2 and 17


Does this really work, or is it all MS pretending they have a product again
? Back to
PHP and MYSQL or should I carry on ?
 
 
 

connection failed errors trying to set up a ODBC connection

Post by Andrew J. » Sat, 09 Aug 2008 11:39:58

That isn't much information to go on. How exactly are you trying to setup a
connection and what is "S.M. Studio Express"? SQL Server 2005 has been out
for several years now and hundreds of thousands of people connect every day
to it so I don't think MS is pretending anything.

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors

 
 
 

connection failed errors trying to set up a ODBC connection

Post by barret bon » Sun, 10 Aug 2008 00:10:11

Thanks for the reply.

From MS Access 2007 and ODBC setup I get the same error:

Connection failed
SQL state 01000
SQL error 2
SQL state 08001
SQL error 17

By "S.M. Studio Express" I meant SQL Server Management Studio Express
I'm able to use this utility to create a new DB and tables- so it's there
and running on this PC
Andrew, I tried to use SQL Server 10 and 6 years ago, and had the same kind
of issues; I couldn't connect, got frustrated
and went on to use open source tools.

I'd love to get it working and thanks for your help -
 
 
 

connection failed errors trying to set up a ODBC connection

Post by Andrew J. » Sun, 10 Aug 2008 10:59:13

Well that still doesn't tell me any details as to what settings etc you are
using. You are using Express and there are some particulars about it that
are covered in these articles. While there may be more than you need they
all may be of interest at one point or another if you are using Express. But
have a look at the connections ones anyway:


http://www.yqcomputer.com/
http://www.yqcomputer.com/
http://www.yqcomputer.com/
connecting
http://www.yqcomputer.com/
for Remote Access
https://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx
Configuring Remote Access
http://www.yqcomputer.com/
remote access
http://www.yqcomputer.com/
Apps
http://www.yqcomputer.com/
SSMS Express
http://www.yqcomputer.com/
Backing up Express


--
Andrew J. Kelly SQL MVP
Solid Quality Mentors