Groups | Blog | Home
all groups > sql server clients > march 2007 >

sql server clients : Multiple Servers in ODBC Client Setup


Richard K
3/16/2007 4:47:05 AM
OK, something weird is happening.

I have a standard Windows XP client and I am trying to set up a simple ODBC
entry. So I go to Control Panel/Administrative Tools/ODBC/System Tab. From
there I create a new ODBC entry connecting to a SQL Server. I enter in the
name of my ODBC and a descripton. When I hit the drop-down button to select
a server I see my 2 SQL Server machines (local machine also named "Jim" and
sbserver) but they are listed twice or even 3 times (see below) and the local
machine has even more entries. What gives and how do I clean this up? Both
seem to work when I "test" at the last step but I have a local application
using this ODBC and it is failing to run so I think it is having "issues"
with these multiple entries.

Thanks!

-Richard

e.g.
(local)
(local)
Jim
Jim
jim
sbserver
sbserver
Sue Hoegemeier
3/18/2007 10:24:37 PM
Make sure your MDAC installation isn't flaky - you can use
component checker to verity the MDAC version and
installation. You can download the tool from:
http://msdn2.microsoft.com/en-us/data/aa937730.aspx
How many instances do you have on each of those servers?
Do you get the same list if you execute the following from
the command prompt:
osql -L

-Sue

On Fri, 16 Mar 2007 04:47:05 -0700, Richard K
[quoted text, click to view]
AddThis Social Bookmark Button