2. ASPRunnerPro General questions
  3. [SOLVED]  Error with ODBC MS ACCESS 2003
This topic is locked
[SOLVED]

 Error with ODBC MS ACCESS 2003

 		7/14/2010 5:20:54 AM
ASPRunnerPro General questions
S
 shiv_mahima author

please help me guys!
i tried to setup using ms access database which has a odbc connection. when i load the page i get error
Microsoft JET Database Engine (0x80004005)

ODBC--connection to 'RiO' failed.

/Project1/include/aspfunctions.asp, line 1234
when i put my network login username i get this error
Error Type:

Microsoft JET Database Engine (0x80040E4D)

Cannot start your application. The workgroup information file is missing or opened exclusively by another user.

/Project1/include/dbcommon.asp, line 48
the ms access odbc database uses active directory and does not require any password... please help....
please help urgently as i want to prove to my director this software is brilliant and we need to purchase it urgently.
thanks!
A
 		ann 7/14/2010

Hi,
here is helpful article:

http://xlinesoft.com/asprunnerpro/docs/error_the_microsoft_jet_database_engine_cannot%20open%20the%20file%20(unknown).htm
Admin 7/14/2010

Most probably this is an issue with IUSR_... user permissions.
If your database file resides on network share make <IUSR_machinename> user has WRITE permissions on this folder.

More info: http://xlinesoft.com/asprunnerpro/docs/how_to_work_with_access_database_stored_on_the_remote_computer.htm
S
 		shiv_mahima author 7/14/2010

just tried above still getting
Cannot start your application. The workgroup information file is missing or opened exclusively by another user.

/Project1/include/dbcommon.asp, line 48
i tried to recreate using odbc source but it doesnt display any sources....
Admin 7/14/2010

I recommend to connect to your MS Access database directly using approach described at http://xlinesoft.com/asprunnerpro/docs/how_to_work_with_access_database_stored_on_the_remote_computer.htm
S
 		shiv_mahima author 7/14/2010



I recommend to connect to your MS Access database directly using approach described at http://xlinesoft.com/asprunnerpro/docs/how_to_work_with_access_database_stored_on_the_remote_computer.htm


I did this now getting
Format of the initialization string does not conform to the OLE DB specification.
i have localhost v5.1, still cannot workout what the dam issue is... doesnt look good as my boss urgently wants to see this working...
thanks for all your help guys!
Admin 7/15/2010

I recommend to open a ticket at http://support.xlinesoft.com providing the following info:

  • location of your MS Access database file in \\server\share\database.mdb form
  • your connection string that can be found in include/dbconnection.asp file
S
 		shiv_mahima author 7/15/2010



I recommend to open a ticket at http://support.xlinesoft.com providing the following info:

  • location of your MS Access database file in \\server\share\database.mdb form
  • your connection string that can be found in include/dbconnection.asp file


thanks for your help, before i log a call can you tell me if the database tables are linked tables, will this prevent it from working as i just created a new database but imported the tables rather than link and it worked the issue is i need it to be link tables rather than import. i also tried to do sql database but got message something about NT login and Annonamous users restricted.
the good thing is i can do a demo based on the insert tables, i believe my client will be impressed and we will be buying the full product.
thanks again!