ODBC Error - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

ODBC Error

Author

Topic

Fatalsniper
Starting Member

45 Posts

Posted - 2005-06-07 : 21:28:47

Hi there,

I'm getting this error while I'm trying to create an ODBC Connection on my clients

The error I get says:

Connection failed
SQL Server error: 65
[Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionOpen
(CreateFile()).
Connection failed
SQLState: '08001'
SQLServer error: 2
[Microsoft][ODBC SQL Server Driver][Named Pipes]Access Denied.

Thanks a lot.....

raclede
Posting Yak Master

180 Posts

Posted - 2005-06-07 : 23:09:14

I think it has something to do with SQL Server Client Network Utility.
I've encountered the same error a long time ago

1. Run ->> type cliconfg.exe
2. In general tab enable the named pipes and tcp/ip
3. In Alias click Add --> Name Pipes --> Type ServerName
4. In Alias click Add --> TCP/IP --> Type ServerName

you connect using the servername

"If the automobile had followed the same development cycle as the computer, a Rolls-Royce would today cost $100, get a million miles per gallon, and explode once a year, killing everyone inside. "

raclede

Fatalsniper
Starting Member

45 Posts

Posted - 2005-06-08 : 13:33:39

Thanks a lot for the reply I tried that, but once I enabled named pipes alias (WINSERVER), I try to add TCP/IP alias as (WINSERVER) again and it says. There's already a protocol config, with that name (WINSERVER), to choose another one. I tried wih each one of 'em separately and still doens't work.

Thanks a lot.....

Fatalsniper
Starting Member

45 Posts

Posted - 2005-06-08 : 15:24:23

If I try using only TCP/IP config on Server and client I get this error:

Connection Failed
SQLState: '01000'
SQL Server Error: 11001
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]
ConnectionOpen(gethostbyname()()).
Connection Failed
SQLState: '08001'
SQL Server Error: 11
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]General Networking Error.

Thanks anyways...

Fatalsniper
Starting Member

45 Posts

Posted - 2005-06-08 : 19:44:53

I got it to work through ODBC TCP/IP Protocol, I had to type Alias Servername, and name just the IP of the server and it worked.
The only thing I couldn't do is to get it to work through pipes, I don't have it listed on my SQL Server Network library, I think it's probably that, how do I install that protocol on the server?

Thanks in advance...

derrickleggett
Pointy Haired Yak DBA

4184 Posts

Posted - 2005-06-08 : 22:14:17

Install the latest MDAC Fatal. You might need to do that anyway.

www.microsoft.com\data

What service pack of SQL Server are you on? Just curious.

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.

huynhhuong@hotmail.com
Starting Member

1 Post

Posted - 2005-06-28 : 19:01:40

quote:
Originally posted by Fatalsniper

I got it to work through ODBC TCP/IP Protocol, I had to type Alias Servername, and name just the IP of the server and it worked.
The only thing I couldn't do is to get it to work through pipes, I don't have it listed on my SQL Server Network library, I think it's probably that, how do I install that protocol on the server?

Thanks in advance...

derrickleggett
Pointy Haired Yak DBA

4184 Posts

Posted - 2005-06-28 : 22:31:47

That was an informative first post.

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources