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
Sergey Kornilov 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....
Sergey Kornilov 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!
Sergey Kornilov 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!