I have done all that’s required, downloaded 64 bit Access database engine but I cannot get the connection to the database.
Where it states ‘Server/Host’ what exactly should go here.
Using the ODBC Data Sources name does not help, and I noticed that the ODBC does not show a 64 Bit source.
Any help here would be most appreciated.
Just what should go in the "server/host’ place?
thanks for your help
Is Access on the same server? If so, it is just localhost or 127.0.0.1.
m
If you are trying to connect via ODBC you should write the connection name. Be shure that the configuration of the system is correct.
If it is via ADO you should write the file name with the complete path.
Thanks for your help.
Still using the following a cannot get a connection:-
Server/Host (Name or IP)
Server=localhost; Driver={Microsoft Access Driver (*.mdb, *.accdb)}; DBQ=C:\waistorage\storage.accdb;
I get the following error
Connection Error
odbc_connect(): SQL error: [Microsoft][ODBC Microsoft Access Driver]Invalid connection string attribute Server, SQL state 01S00 in SQLConnect
What am I doing wrong!!!
It seems that the error comes from the ODBC conexion configuration. Review the conexion.
If you can test the conexion with other tool try it just to isolate the problem.