Hi Julie,

Actually when you list the server, it will call ListAvailableSQLServers,
which calls ODBC SQLBrowseConnect function. Generally,
ListAvailableSQLServers is listing all default sql server instances
available in the network. However, we do not guarantee that named instances
will be listed.

We recommend that you type the named instance SERVERNAME\INSTANCENAME
directly, as listing servers is slow and need to send a lof of network
packets.


Bill Cheng
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
--------------------
| Content-Class: urn:content-classes:message
| From: "Julie" <jas@capx.com>
| Sender: "Julie" <jas@capx.com>
| Subject: Instance names missing trying to create dsn
| Date: Mon, 15 Sep 2003 11:43:43 -0700
| Lines: 9
| Message-ID: <36fb01c37bb9$4a01e430$a501280a@phx.gbl>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Thread-Index: AcN7uUoBW68OyyzdT/y61xcKhKgZQQ==
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Newsgroups: microsoft.public.sqlserver.odbc
| Path: cpmsftngxa07.phx.gbl
| Xref: cpmsftngxa07.phx.gbl microsoft.public.sqlserver.odbc:39726
| NNTP-Posting-Host: tk2msftngxa13.phx.gbl 10.40.1.165
| X-Tomcat-NG: microsoft.public.sqlserver.odbc
|
| Hi,
| When I try to create a system dsn on 1 machine (logged
| in as myself) I go to pick the server portion and only see
| the server name not the two instances of that server?
|
| Log in as myself on another machine I see both server
| name and instance name?
|
| Any idea for this confused DBA....
|

Okay, I tried that and now I get

SQLState: '01000'
SQL Server Error: 11004
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]
ConnectionOpen(gethostbyname()()). Connection Failed
SQLState: '08001'
SQL Server Error: 11
[Micorsoft][ODC SQL Server Driver][TCP/IP Sockets]General
network error.

This error only occurs on some machines, other I connect
fine.....

What is going on???
>-----Original Message-----
>Hi Julie,
>
>Actually when you list the server, it will call
ListAvailableSQLServers,
>which calls ODBC SQLBrowseConnect function. Generally,
>ListAvailableSQLServers is listing all default sql server
instances
>available in the network. However, we do not guarantee
that named instances
>will be listed.
>
>We recommend that you type the named instance
SERVERNAME\INSTANCENAME
>directly, as listing servers is slow and need to send a
lof of network
>packets.
>
>
>Bill Cheng
>Microsoft Online Partner Support
>
>Get Secure! - www.microsoft.com/security
>This posting is provided "as is" with no warranties and
confers no rights.
>--------------------
>| Content-Class: urn:content-classes:message
>| From: "Julie" <jas@capx.com>
>| Sender: "Julie" <jas@capx.com>
>| Subject: Instance names missing trying to create dsn
>| Date: Mon, 15 Sep 2003 11:43:43 -0700
>| Lines: 9
>| Message-ID: <36fb01c37bb9$4a01e430$a501280a@phx.gbl>
>| MIME-Version: 1.0
>| Content-Type: text/plain;
>| charset="iso-8859-1"
>| Content-Transfer-Encoding: 7bit
>| X-Newsreader: Microsoft CDO for Windows 2000
>| Thread-Index: AcN7uUoBW68OyyzdT/y61xcKhKgZQQ==
>| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
>| Newsgroups: microsoft.public.sqlserver.odbc
>| Path: cpmsftngxa07.phx.gbl
>| Xref: cpmsftngxa07.phx.gbl
microsoft.public.sqlserver.odbc:39726
>| NNTP-Posting-Host: tk2msftngxa13.phx.gbl 10.40.1.165
>| X-Tomcat-NG: microsoft.public.sqlserver.odbc
>|
>| Hi,
>| When I try to create a system dsn on 1 machine
(logged
>| in as myself) I go to pick the server portion and only
see
>| the server name not the two instances of that server?
>|
>| Log in as myself on another machine I see both server
>| name and instance name?
>|
>| Any idea for this confused DBA....
>|
>
>.
>

Hi Julie,

What is the SQL Server version? Is it 7.0 SP4 or 2000 SP3? Is it on Windows
NT Server 4.0 and is a cluster?

If it is on Windows NT Server 4.0 and is a cluster, please check the
following article:
187708 Cannot Connect to SQL Virtual Server via Sockets in Cluster
http://support.microsoft.com/?id=187708

Try to use odbcping utility to test connection from problematic computer,
e.g. odbcping /Sserver_name\instance_name /Usa /PsaPassWord.

In addition, try to create TCP/IP or named pipe alias to point to the SQL
Server named instance on the problematic computer. Can you connect now?


Bill Cheng
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
--------------------
| Content-Class: urn:content-classes:message
| From: "Julie" <jas@capx.com>
| Sender: "Julie" <jas@capx.com>
| References: <36fb01c37bb9$4a01e430$a501280a@phx.gbl>
<7N6S4GDfDHA.540@cpmsftngxa07.phx.gbl>
| Subject: RE: Instance names missing trying to create dsn
| Date: Tue, 16 Sep 2003 06:08:25 -0700
| Lines: 77
| Message-ID: <416701c37c53$9d111ca0$a501280a@phx.gbl>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Thread-Index: AcN8U50Roiz2TAWsQC+KD2bvWeMrEg==
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Newsgroups: microsoft.public.sqlserver.odbc
| Path: cpmsftngxa07.phx.gbl
| Xref: cpmsftngxa07.phx.gbl microsoft.public.sqlserver.odbc:39738
| NNTP-Posting-Host: tk2msftngxa13.phx.gbl 10.40.1.165
| X-Tomcat-NG: microsoft.public.sqlserver.odbc
|
| Okay, I tried that and now I get
|
| SQLState: '01000'
| SQL Server Error: 11004
| [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]
| ConnectionOpen(gethostbyname()()). Connection Failed
| SQLState: '08001'
| SQL Server Error: 11
| [Micorsoft][ODC SQL Server Driver][TCP/IP Sockets]General
| network error.
|
| This error only occurs on some machines, other I connect
| fine.....
|
| What is going on???
| >-----Original Message-----
| >Hi Julie,
| >
| >Actually when you list the server, it will call
| ListAvailableSQLServers,
| >which calls ODBC SQLBrowseConnect function. Generally,
| >ListAvailableSQLServers is listing all default sql server
| instances
| >available in the network. However, we do not guarantee
| that named instances
| >will be listed.
| >
| >We recommend that you type the named instance
| SERVERNAME\INSTANCENAME
| >directly, as listing servers is slow and need to send a
| lof of network
| >packets.
| >
| >
| >Bill Cheng
| >Microsoft Online Partner Support
| >
| >Get Secure! - www.microsoft.com/security
| >This posting is provided "as is" with no warranties and
| confers no rights.
| >--------------------
| >| Content-Class: urn:content-classes:message
| >| From: "Julie" <jas@capx.com>
| >| Sender: "Julie" <jas@capx.com>
| >| Subject: Instance names missing trying to create dsn
| >| Date: Mon, 15 Sep 2003 11:43:43 -0700
| >| Lines: 9
| >| Message-ID: <36fb01c37bb9$4a01e430$a501280a@phx.gbl>
| >| MIME-Version: 1.0
| >| Content-Type: text/plain;
| >| charset="iso-8859-1"
| >| Content-Transfer-Encoding: 7bit
| >| X-Newsreader: Microsoft CDO for Windows 2000
| >| Thread-Index: AcN7uUoBW68OyyzdT/y61xcKhKgZQQ==
| >| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| >| Newsgroups: microsoft.public.sqlserver.odbc
| >| Path: cpmsftngxa07.phx.gbl
| >| Xref: cpmsftngxa07.phx.gbl
| microsoft.public.sqlserver.odbc:39726
| >| NNTP-Posting-Host: tk2msftngxa13.phx.gbl 10.40.1.165
| >| X-Tomcat-NG: microsoft.public.sqlserver.odbc
| >|
| >| Hi,
| >| When I try to create a system dsn on 1 machine
| (logged
| >| in as myself) I go to pick the server portion and only
| see
| >| the server name not the two instances of that server?
| >|
| >| Log in as myself on another machine I see both server
| >| name and instance name?
| >|
| >| Any idea for this confused DBA....
| >|
| >
| >.
| >
|