ODBC drivers

Hi
On our SQL 2000 Std server, when creating a ODBC there are no drivers to
chose from (i.e SQL DSN etc). Even when installing addtional SQL instance
we get a Cannot find default Data Source message)
I have tried reinstalling MDAC 2.7 but the ODBC drivers does not appear in
the drivers tabs in ODBC admin tool.
I am stuck to why this is happening. Any help/advice to resolve this
strange problem.
p.s i can use Enterprise Manager from my working station to connect to the
SQL server ( but not on the server itself)
Regards
James DownesI have solved the problem. I imported the ODBC registry keys from a working
ODBC server.
Regards
Z
"Zenduce" <james@.zenduce.net> wrote in message
news:#EFueg4SDHA.1916@.TK2MSFTNGP12.phx.gbl...
> Hi
> On our SQL 2000 Std server, when creating a ODBC there are no drivers to
> chose from (i.e SQL DSN etc). Even when installing addtional SQL
instance
> we get a Cannot find default Data Source message)
> I have tried reinstalling MDAC 2.7 but the ODBC drivers does not appear
in
> the drivers tabs in ODBC admin tool.
> I am stuck to why this is happening. Any help/advice to resolve this
> strange problem.
> p.s i can use Enterprise Manager from my working station to connect to
the
> SQL server ( but not on the server itself)
> Regards
> James Downes
>sql

ODBC driver needed for Compact Edition

I have the newest 'Everywhere' Compact Edition installed, and have created a new desktop database using VS 2005 after installing the VS 2005 SP1 Beta, all successfully. I have no need to use the Mobile components and no need to syncronize to a mobile device. I can connect to the database programatically in VB.NET no problem.

Instead, I want to connect to the desktop database using MS Access. So far, I can't connect using the standard (old) SQLServer ODBC driver, and haven't found any new driver, either. Am I just premature and need to be patient? Does anyone know if there's one in the works? Or am I the only one to have thought of it?

Any help would be appreciated.

Thanks

Merle Nicholson

SQL Server Compact (was Everywhere) Edition does not have ODBC Driver. It has OLEDB and ADO.NET providers right now.

Thanks,

Laxmi