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?
--
Respectfully,
Jonathan Lulich
