ASP works normally, but the Microsoft Jet Database Engine error is prompted as long as you connect to the database.

Source: Internet
Author: User

ASP works normally, but the Microsoft Jet Database Engine error is prompted as long as you connect to the database.

'123456', my computer cannot run because it is used to clear files in batches.
1. Check the database connection statement for no errors found;
2. All the permissions for viewing folders have been granted to everyone;
3. When the database is opened, the system will create a temporary file in the Temporary Folder % SystemRoot %/temp/, while %

Systemroot %/temp/has insufficient Permissions
Solution: % SystemRoot %/temp/permission plus (iuser _ computer name read/write)

2. If an error is not specified, there is another way to do this first.
In fact, it takes only a few simple steps. :
Start... Run... Regsvr32 jscript. dll
Start... Run... Regsvr32 VBScript. dll
Start... Run... Iisreset

Microsoft Jet Database Engine (0x80004005) unspecified error resolution
1. The system may not have registered msjetoledb40.dll. The solution is:
Click Start ---> Run, enter regsvr32 msjetoledb40.dll, and press Enter;

2. Database folder Permissions
To open it, open my computer, click "Folder Options"> View on the menu, and then click "use simple text

Remove the hooks in front of folder sharing (recommended), click "OK", and return to the folder (Data Inventory

Folder), right click ---> properties ---> Security, and click "add" ---> "advanced" ---> Search now ---> and

Select "everyone" ---> OK ---> click "everyone" just added, and edit everyone in the following big box.

The permission is fully controlled. Save the permission.

3. You need to open the Guest user
Open my computer ---> Control Panel ---> Management Tools ----> Computer Management ---> local users and groups --- users ---

Find "guest", double-click it, and then remove the hook before the pop-up crazy "account stopped", and save it.

4. Temp (Temporary Folder) Permission
Open Method: Windows ---> temp, right-click and choose-properties, you will see an option called "security", add

Add an everyone, set the permission to full control, and then set the user you are using Windows to full control.

Limited
To open it, open my computer, click "Folder Options"> View on the menu, and then click "use simple text

Remove the hooks in front of folder sharing (recommended), click "OK", and return to the folder (Data Inventory

Folder), right click ---> properties ---> Security, and click "add" ---> "advanced" ---> Search now ---> and

Select "everyone" ---> OK ---> click "everyone" just added, and edit everyone in the following big box.

The permission is fully controlled. Save the permission.

 

I want to use ASP to import Excel Data in batches to the SQL database. I borrowed zhanghongwen (ROGUE mosquito)Code, As shown below

:
...
...
...
<%
Server. scripttimeout = 100000000
Sub data=sqlserver_ceritificate (strfilename, strsheetname, myconn)
'Definition
Dim myconnection
Dim strname
Dim rsxsl, rssql
Dim str_xsl, str_ SQL
Dim myconn_xsl
Dim cmd
Dim I, j
Dim maxid

Strname = strfilename
Set myconnection = server. Createobject ("ADODB. Connection ")
Set rsxsl = server. Createobject ("ADODB. recordset ")
Set rssql = server. Createobject ("ADODB. recordset ")
Set cmd = server. Createobject ("ADODB. Command ")
Cmd. activeconnection = myconn

Myconn_xsl = "provider = Microsoft. Jet. oledb.4.0; Data Source =" & strname

& "; Extended properties = Excel 8.0"

'Open the connection
Myconnection. Open myconn_xsl

'Open a table
Str_xsl = "select * from [" & strsheetname & "$]"
Rsxsl. Open str_xsl, myconnection, 1, 1
J = 1
Do while not rsxsl. EOF
'Retrieve the maximum value
Str_ SQL = "select max (ID) as maxid from fubiao"
Rssql. Open str_ SQL, myconn, 1, 3
If not rssql. EOF then
If not isnull (rssql ("maxid") then
Maxid = clng (rssql ("maxid") + 1
Else
Maxid = 1
End if
Else
Maxid = 1
End if
Rssql. Close '// close the object
'Join the database
Str_ SQL = "insert into fubiao values (" & maxid & ", '" & rsxsl (1) & "', '" & rsxsl (3)

& "','" & Rsxsl (4) & "','" & rsxsl (5) & "','" & rsxsl (6 )&"', '"& rsxsl (7) &"', '"& rsxsl (8)

& "','" & Rsxsl (9) & "','" & rsxsl (10) & "','" & rsxsl (11 )&"', '"& rsxsl (12) &"', '"& rsxsl (13)

& "','" & Rsxsl (14) & "','" & rsxsl (15) & "','" & rsxsl (16 )&"', '"& rsxsl (17) &"', '"& rsxsl (18)

& "','" & Rsxsl (19) & "','" & rsxsl (20) & "','" & rsxsl (21 )&"', '"& rsxsl (22) &"', '"& rsxsl (23)

& "','" & Rsxsl (24) & "','" & rsxsl (25) & "','" & rsxsl (26 )&"', '"& rsxsl (27 )&"')"
Cmd. commandtext = str_ SQL
Cmd. Execute ()

'''''''''''''''''''''''''''''''''''''''' '''''''''''''''''''''''''''''''''''''''' ''''''

'''
J = J + 1
Rsxsl. movenext
Loop

Response. Write "total import records <font color = 'red'>" & J-1 & "</font>

. <Br/>"
Response. Write "<a href = javascript: history. Back ()> OK </a>"
Set rsxsl = nothing
Set rssql = nothing
Set myconnection = nothing
Set cmd = nothing
End sub
...
...
...
File1 = request. Form ("filename2 ")
Strtj = mid (request. Form ("filename2"), limit Rev (file1, "\") + 1, (Limit Rev (file1 ,".")-

Rev (file1, "\")-1 ))
If file1 = "" then
Response. Write "select the Excel table you want to import! <P> </P>"
%>
<A href = javascript: history. Back ()> previous page </a>
<%
Response. End
End if
Myconn = "driver = {SQL Server}; server = (local); uid = sa; Pwd = sa; database = qjgsj_data"
Call data‑sqlserver_ceritificate file1, "" & strtj & "", myconn
...
...
%>
When opening the connection:
Myconnection. Open myconn_xsl

HTTP 500.100 _ internal server error _ ASP Error
Error Type:
Microsoft Jet Database Engine (0x80004005)
Line \... \ AA. asp xx
What is the problem?
Is there a problem with this connection sentence?
Myconn_xsl = "provider = Microsoft. Jet. oledb.4.0; Data Source =" & strname &

"; Extended properties = Excel 8.0"

My server system DSN has set up a data source for the SQL database, batch import Excel Data with ASP, also need

Excel driver settingsProgram?
Is zhanghongwen in? Number of questions: 80. replies: 4top

1 floor veryoldman(headless fly (www.gz meishi.com) reply to 14:53:46 score

80myconn_xsl = "provider = Microsoft. Jet. oledb.4.0; Data Source =" & server. mappath

("/Yourexcel.xls ")_
& "; Extended properties =" "Excel 8.0; HDR = yes ;"";"
SQL command: "select * from [yoursheetname $]"

I passed the test on my website www.gzmeishi.com! Top

On the second floor, zcxc (Zhichun xiaocao) replied that it still failed to score 0 at 14:18:59 on.
Does Microsoft. Jet. oledb.4.0 need to be configured on the server? Top

On the third floor, zcxc (Zhichun xiaocao) replied that it scored 0 at 18:36:27 !!!
Please help !!!
My server is configured as Windows Server 2000, IIS 5.0, and SQL Server 2000.
Use myconn_xsl = "provider = Microsoft. Jet. oledb.4.0; Data Source =" & strname &

"; Extended properties = Excel 8.0"
Or myconn_xsl = "provider = Microsoft. Jet. oledb.4.0; Data Source =" & server. mappath

("Strname ")_
& "; Extended properties =" "Excel 8.0; HDR = yes;" ";" Statement
An error occurred while opening the connection:
Microsoft Jet Database Engine (0x80004005)
/Http://www.cnblogs.com/aa.asp XX rows

Use myconn_xsl = "driver = {Microsoft Excel Driver (*. xls)}; DBQ =" & server. mappath

("Strname ")
When the connection is enabled, the following error occurs:
Microsoft ole db provider for ODBC drivers (0x80004005)
/Http://www.cnblogs.com/aa.asp XX rows

Excuse me:
Use myconn_xsl = "driver = {Microsoft Excel Driver (*. xls)}; DBQ =" & server. mappath

("Strname") How do I Configure the server for connection?
Use myconn_xsl = "provider = Microsoft. Jet. oledb.4.0; Data Source =" & strname &

"; Extended properties = Excel 8.0"
Or myconn_xsl = "provider = Microsoft. Jet. oledb.4.0; Data Source =" & server. mappath

("Strname ")_
& "; Extended properties =" "Excel 8.0; HDR = yes ;"";"
How can I Configure the server?
What is the cause of the above problem? What configuration is missing from the server or anything else?
Please give me some advice.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.