Microsoft Access ODBC Driver - simple problem

[Jonathan Lulich]

Ok here's the setup:

moved all necessary databases including setup of iis from a windows 2003
server to 64-bit version

i have not found a single mdac download from microsoft for this verison of
windows server... seems that all the driver files were included.

here's my problem...

none of the ms access odbc drivers would show up in the odbc manager so....

I manaully copied all of the odbc registry settings from the original server
to the new one and linked all of the appropriate files in the new SysWOW
folder

still can't manage ms access odbc through odbc manager. still can not get
php to access driver and databases

receive following error:
Could Not Connect to ODBC Database!PHP Warning: odbc_connect()
[function.odbc-connect]: SQL error: [Microsoft][ODBC Driver Manager] Data
source name not found and no default driver specified, SQL state IM002 in
SQLConnect

i could not setup the data source name through the odbc manager interface -
the data source does exit and shows up only because I manually copied the
registry entries
driver file does exist and is specified in the registry.

any ideas?

[Jonathan Lulich]

also having this issue

"The setup routines for the driver could not bew loaded due to system error
code 193"

"Could not load the setup or translator library"

"The setup routines for the driver ODBC driver could not be loaded due to
system error code 126."

"Could not load the setup or translator library."

[unknown]

At this moment, there is no 64 bit ODBC Driver for Access (and if I were
you, I woudn't expect one soon); so you cannot directly access an Access
database (mdb or accdb) from a program running in 64 bit mode. However, if
you set up IIS to run in 32 bit mode then there will be no problem:

http://support.microsoft.com/default.aspx?scid=kb;en-us;894435

A second solution is to setup a SQL-Server Express installation - running in
32 bit mode - and use it to access the mdb file by creating a linked
database on this sql-server:

http://gorm-braarvig.blogspot.com/2005/11/access-database-from-sql-200564.html

For your ODBC registries, you must use the 32 bit version of the ODBC Data
Source Administrator tool if you want to access them from a 32 bit
environment:

http://support.microsoft.com/kb/942976/en-us

The ODBC registries between the 32 bit version and the 64 bit version are
not compatible between them. For the setup of IIS that you copied and for
PHP, I don't know.
--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)

Post by Jonathan Lulich
moved all necessary databases including setup of iis from a windows 2003
server to 64-bit version
i have not found a single mdac download from microsoft for this verison of
windows server... seems that all the driver files were included.
here's my problem...
none of the ms access odbc drivers would show up in the odbc manager so....
I manaully copied all of the odbc registry settings from the original
server to the new one and linked all of the appropriate files in the new
SysWOW folder
still can't manage ms access odbc through odbc manager. still can not get
php to access driver and databases
Could Not Connect to ODBC Database!PHP Warning: odbc_connect()
[function.odbc-connect]: SQL error: [Microsoft][ODBC Driver Manager] Data
source name not found and no default driver specified, SQL state IM002 in
SQLConnect
i could not setup the data source name through the odbc manager
interface - the data source does exit and shows up only because I manually
copied the registry entries
driver file does exist and is specified in the registry.
any ideas?
--
Respectfully,
Jonathan Lulich

[Jonathan Lulich]

thank you so much for your insight!
--
Respectfully,
Jonathan Lulich

"Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)>

Post by unknown
At this moment, there is no 64 bit ODBC Driver for Access (and if I were
you, I woudn't expect one soon); so you cannot directly access an Access
database (mdb or accdb) from a program running in 64 bit mode. However,
http://support.microsoft.com/default.aspx?scid=kb;en-us;894435
A second solution is to setup a SQL-Server Express installation - running
in 32 bit mode - and use it to access the mdb file by creating a linked
http://gorm-braarvig.blogspot.com/2005/11/access-database-from-sql-200564.html
For your ODBC registries, you must use the 32 bit version of the ODBC Data
Source Administrator tool if you want to access them from a 32 bit
http://support.microsoft.com/kb/942976/en-us
The ODBC registries between the 32 bit version and the 64 bit version are
not compatible between them. For the setup of IIS that you copied and for
PHP, I don't know.
--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)

Post by Jonathan Lulich
moved all necessary databases including setup of iis from a windows 2003
server to 64-bit version
i have not found a single mdac download from microsoft for this verison
of windows server... seems that all the driver files were included.
here's my problem...
none of the ms access odbc drivers would show up in the odbc manager so....
I manaully copied all of the odbc registry settings from the original
server to the new one and linked all of the appropriate files in the new
SysWOW folder
still can't manage ms access odbc through odbc manager. still can not get
php to access driver and databases
Could Not Connect to ODBC Database!PHP Warning: odbc_connect()
[function.odbc-connect]: SQL error: [Microsoft][ODBC Driver Manager] Data
source name not found and no default driver specified, SQL state IM002 in
SQLConnect
i could not setup the data source name through the odbc manager
interface - the data source does exit and shows up only because I
manually copied the registry entries
driver file does exist and is specified in the registry.
any ideas?
--
Respectfully,
Jonathan Lulich

[Jonathan Lulich]

If anyone else comes across this issue simply run the 32-bit version of the
odbc manager from the SysWOW64 folder. No need to copy drivers or change
registry settings as I mentioned; the drivers show up. Simply add your
database in the System DSN
--
Respectfully,
Jonathan Lulich

Post by Jonathan Lulich
moved all necessary databases including setup of iis from a windows 2003
server to 64-bit version
i have not found a single mdac download from microsoft for this verison of
windows server... seems that all the driver files were included.
here's my problem...
none of the ms access odbc drivers would show up in the odbc manager so....
I manaully copied all of the odbc registry settings from the original
server to the new one and linked all of the appropriate files in the new
SysWOW folder
still can't manage ms access odbc through odbc manager. still can not get
php to access driver and databases
Could Not Connect to ODBC Database!PHP Warning: odbc_connect()
[function.odbc-connect]: SQL error: [Microsoft][ODBC Driver Manager] Data
source name not found and no default driver specified, SQL state IM002 in
SQLConnect
i could not setup the data source name through the odbc manager
interface - the data source does exit and shows up only because I manually
copied the registry entries
driver file does exist and is specified in the registry.
any ideas?
--
Respectfully,
Jonathan Lulich