I am trying to make a ODBC connection to a MS Access 2003 database - but
there are only a SQL server odbc driver.
What shall I do?

Re: ODBC driver to MS access by Andre

Andre
Thu Nov 03 09:39:33 CST 2005

Check the microsoft.public.access.odbcclientsvr group and post a query about
this,
maybe they will give you some information about when support is coming.

Pascal wrote:
On an Windows 2003 SP1 x64 you can create a odbc connection on 32bit side of
the system or on the 64bit side of the system.

And a 32 bit application will only see 32bit side ODBC connection and a
64bits application only the 64bit side ODBC connection.
Each kind of application has is own registry.

To setup an ODBC link for 32bit application you must use
C:\WINDOWS\SysWOW64\odbcad32.exe and for 64bit application you must use
C:\WINDOWS\System32\odbcad32.exe

I hope this will help you;

Regards,

Pascal Deliot
--
Andre
Extended64 | http://www.extended64.com
Blog | http://www.extended64.com/blogs/andre
http://spaces.msn.com/members/adacosta
FAQ for MS AntiSpy http://www.geocities.com/marfer_mvp/FAQ_MSantispy.htm

"Morten Sørensen" <Morten Sørensen@discussions.microsoft.com> wrote in
message news:81E6561B-9CC1-4C02-8C45-43492A04F2FA@microsoft.com...
>I am trying to make a ODBC connection to a MS Access 2003 database - but
> there are only a SQL server odbc driver.
> What shall I do?



Re: ODBC driver to MS access by Ken

Ken
Sat Nov 05 05:59:24 CST 2005

Hi,

If you are using vs.net 2005 this should help.
http://www.vb-tips.com/default.aspx?ID=c8303e25-496d-4288-bc1d-58e5850daf5e

Ken
------------------
"Morten Sørensen" <Morten Sørensen@discussions.microsoft.com> wrote in
message news:81E6561B-9CC1-4C02-8C45-43492A04F2FA@microsoft.com...
>I am trying to make a ODBC connection to a MS Access 2003 database - but
> there are only a SQL server odbc driver.
> What shall I do?