MS SQL Server ODBC - native client not listed in odbc control panel

Author

native client not listed in odbc control panel

Citizen10Bears@gmail.com

2006-02-07, 9:23 am

on my pc I have sqlserver2000 and sqlserver2005

in odbc control panel, I create a new connection, but native client is
not listed.

I have uninstalled and reinstalled native client several times.
I have checked the registry and it seems to make reference to the
correct dll there.

Why can't I see it?

It works on every other machine I use!

Even stranger, if I pick sqlserver as the driver, although the 2005
instance isn't listed I can type it's name and it works fine, where as
this wont work on other machines!

any tips?

how can I make the native option display in the odbc wizard?

your speedy responses would be most welcome.

Tim

Sylvain Lafontaine

2006-02-11, 1:23 pm

Quite probably the SQL-Server Browser Service is off, so try starting it.

However, like you said, you don't really need it to etablish a connection if
you already know the name of the instance that you want to connect to.

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF

< Citizen10Bears@gmail
.com> wrote in message
news:1139323726.790992.124920@g47g2000cwa.googlegroups.com...
> on my pc I have sqlserver2000 and sqlserver2005
>
> in odbc control panel, I create a new connection, but native client is
> not listed.
>
> I have uninstalled and reinstalled native client several times.
> I have checked the registry and it seems to make reference to the
> correct dll there.
>
> Why can't I see it?
>
> It works on every other machine I use!
>
> Even stranger, if I pick sqlserver as the driver, although the 2005
> instance isn't listed I can type it's name and it works fine, where as
> this wont work on other machines!
>
> any tips?
>
> how can I make the native option display in the odbc wizard?
>
> your speedy responses would be most welcome.
>
> Tim
>

Sponsored Links