I am in the process of creating a quick prototype from a MS Access database stored in a network folder. Here is what I have done so far.
I haved made sure that the logon used by the MSTR machine has access to the folder and the MSTR server instances is started with the same login. From the MSTR box, I am able to map the drive to the MS Access data base and run queries against it using the DSN created and Test ODBC.
The DSN has been defined by locating the DB by a mapped drive and I have also tried absolute path. Both results in the same error below.
I can also connect via 2-Tier using the same DSN.
The server has been rebooted and when I try to connect via 3-Tier using the same DSN, I get an error that states:
"... SQLDriverConnect.[S1009:-1023n HDBC][MicroSoft][ODBC MicroSoft Access Driver]'(unknown is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides...."
Thanks in advance...
I haved made sure that the logon used by the MSTR machine has access to the folder and the MSTR server instances is started with the same login. From the MSTR box, I am able to map the drive to the MS Access data base and run queries against it using the DSN created and Test ODBC.
The DSN has been defined by locating the DB by a mapped drive and I have also tried absolute path. Both results in the same error below.
I can also connect via 2-Tier using the same DSN.
The server has been rebooted and when I try to connect via 3-Tier using the same DSN, I get an error that states:
"... SQLDriverConnect.[S1009:-1023n HDBC][MicroSoft][ODBC MicroSoft Access Driver]'(unknown is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides...."
Thanks in advance...