Microsoft JET Database Engine Unspecified error ISS 8.5 WINDOWS 2012 R2

Question

User166850416 posted

Hello;
We have project writen by ASP CLASSIC.We user VCLOUD SERVER.In this server run only this project.We use ASP CLASSIC,ACCESS (MDB) and MSSQL.All user use different ACCESS (MDB) file.Sometimes one user get long TSQL and server is very busy and slowly.I get this error message.

I get this Error Message::::
Category=Microsoft JET Database Engine
Column=-1
Description=Unspecified error
File=/vt.asp
Line=21
Number=-2147467259

Database Connection:::::::::
dim conn
set conn=server.createobject("adodb.connection")
conn.provider="microsoft.jet.oledb.4.0"
conn.open=server.mappath("db/"& Session("subekodu") &".mdb")

I get printscreen IIS 8.5 , Asp Option and Application Pool.
http://www.seker.fr/sunucu/1_system.jpg
http://www.seker.fr/sunucu/2_windows_temp.jpg
http://www.seker.fr/sunucu/3_inetpub_db_izinler.jpg
http://www.seker.fr/sunucu/4_domain_asp_ayarlari1.jpg
http://www.seker.fr/sunucu/5_domain_asp_ayarlari2.jpg
http://www.seker.fr/sunucu/6_domain_asp_ayarlari3.jpg
http://www.seker.fr/sunucu/7_default_asp_ayarlari1.jpg
http://www.seker.fr/sunucu/8_default_asp_ayarlari2.jpg
http://www.seker.fr/sunucu/9_default_asp_ayarlari3.jpg
http://www.seker.fr/sunucu/10_applicationpool_default1.jpg
http://www.seker.fr/sunucu/11_applicationpool_default2.jpg
http://www.seker.fr/sunucu/12_applicationpool_domain1.jpg
http://www.seker.fr/sunucu/13_applicationpool_domain2.jpg
http://www.seker.fr/sunucu/14_taskmanager.jpg
http://www.seker.fr/sunucu/14_taskmanager_cpu.jpg
http://www.seker.fr/sunucu/15_access_dosyalari.jpg

Where is the problem.What I forget or make wrong.Please help me. Thanks.

Answer 1

User-801366587 posted

Hi,

Hope, this can help you - http://blogs.iis.net/bills/tips-for-classic-asp-developers-on-iis7

Microsoft KB document - https://support.microsoft.com/en-us/kb/926939

Mark as answer if this helped you

Answer 2

User166850416 posted

Thanks Bharath :)

I try before but not resolved :(

http://www.seker.fr/sunucu/2_windows_temp.jpg

http://www.seker.fr/sunucu/16_windows_appdata_local_temp.jpg

 

Answer 3

User-1122936508 posted

set conn=server.createobject("adodb.connection")
conn.provider="microsoft.jet.oledb.4.0"
conn.open=server.mappath("db/"& Session("subekodu") &".mdb")

Before you call conn.open, can you call Response.Write(server.mappath("db/"& Session("subekodu") &".mdb")

Verify that the path to the DB is correct.

Answer 4

User-2064283741 posted
Also think about moving away from using access as a database engine on a web site. It has never been recommended to be used for IIS.

Answer 5

User166850416 posted

Thanks Ken Schaefer,

It is working database connection.Sometimes server give this error.When Server was very request after give this error.

Answer 6

User166850416 posted

Thanks Rovastar;

We will move to MSSQL. we must change come code and need time.May I need change IIS options

Answer 7

User1183424175 posted

Hi,

About configuring IIS to access sql server, we can set the application pool identity as networkservice and creat sql serverl account. For more information, please refer to the document:

http://www.codeproject.com/Articles/674930/Configuring-IIS-ASP-NET-and-SQL-Server

Or we can use sql server authentication.