My computer can not run because it cleans files with batch processing, only
1. View database connection statement no errors found;
2. The permissions to view the folders have all been given to everyone;
3. When you open the database, the system creates temporary files under the temporary folder%systemroot%/temp/, and%
systemroot%/temp/Not enough permissions.
Resolution:%systemroot%/temp/permission plus (iuser_ computer name read and write)
2, if the general unspecified error, there is a way, first
In fact, as long as a very simple few steps. ：
Begin... Run... regsvr32 jscript.dll
Begin... Run... regsvr32 vbscript.dll
Begin... Run... IISReset
Error resolution not specified by Microsoft JET Database Engine (0x80004005)
1, the system may not register Msjetoledb40.dll, the solution is
Point Start---> operation, input regsvr32 msjetoledb40.dll, enter can;
2, database folder permissions
Open the way: Open My Computer, then click "Folder Options" on the menu---> View, and then "use the simple text
Clip Share (recommended) "Before the hook is removed, then click" Confirm "; then go back to the folder where you want to open permissions (data inventory
folder), right---> Properties---> Security, then click "Add"---> "advanced"---> Find---> Now and then below
Place select "Everyone"---> OK---> Dot just joined the "everyone" and then edit everyone in the big box below
Permissions are fully controlled and can be saved.
3, need to open the Guest user
Open method: My Computer---> Control Panel---> Management tools----> Computer Management---> Local Users and Groups---users---
Find "Guest", double click, then remove the hook before the "account has been deactivated" on the mad, and save it.
4. Temp (temporary folder) permissions
Open method: Windows--->temp, right-click Select-Properties, you will see a "security" option, Tim
Add a everyone, permissions are set to Full control, and the user you are using Windows is also set to Full control. (Clip Right
Limit
Open the way: Open My Computer, then click "Folder Options" on the menu---> View, and then "use the simple text
Clip Share (recommended) "Before the hook is removed, then click" Confirm "; then go back to the folder where you want to open permissions (data inventory
folder), right---> Properties---> Security, then click "Add"---> "advanced"---> Find---> Now and then below
Place select "Everyone"---> OK---> Dot just joined the "everyone" and then edit everyone in the big box below
Permissions are fully controlled and can be saved.
I want to use ASP Bulk Import Excel data to the SQL database, borrowed the Zhanghongwen (rogue Mosquitoes) code, as follows
：
...
...
...
<%
server.scripttimeout=100000000
Sub Dataintosqlserver_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 connection
Myconnection.open myconn_xsl
' Open Table
Str_xsl= "SELECT * FROM [" & strSheetName & "$]"
Rsxsl.open str_xsl,myconnection,1,1
J=1
Do as not rsxsl.eof
' Remove 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 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 &" ', ' "&rsxsl (one) &" ', ' "&rsxsl (A) &" "," & Rsxsl (13)
& "," "&rsxsl &" ', ' "&rsxsl &" ', ' "&rsxsl &" ', ' "&rsxsl (m) &" ', ' " &rsxsl (18)
& "," "&rsxsl &" ', ' "&rsxsl &" ', ' "&rsxsl &" ', ' "&rsxsl (+) &" ', ' " &rsxsl (23)
& "," "&rsxsl &" ', ' "&rsxsl &" ', ' "&rsxsl (+) &", ' "&rsxsl (m) &" ")
Cmd.commandtext=str_sql
Cmd. Execute ()
''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
'''
J=j+1
Rsxsl.movenext
Loop
Response.Write "Total import <font color= ' Red ' >" & j-1 & "</font> record
.<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"), InStrRev (File1, "\") +1, (InStrRev (File1, ".") -
InStrRev (file1, "\")-1)
If file1= "" Then
Response.Write "Please select the Excel table you want to import!<p></p>"
%>
<a href=javascript:history.back () > Prev </a>
<%
Response.End
End If
Myconn= "Driver={sql SERVER}; server= (local); Uid=sa;pwd=sa;database=qjgsj_data "
Call Dataintosqlserver_ceritificate file1, "&strtj&" ", myconn
...
...
%>
When you open a connection:
Myconnection.open myconn_xsl
Occurrence: HTTP 500.100_ Internal server error _asp error
Error type:
Microsoft Jet Database Engine (0x80004005)
\.. \.. \aa.asp XX Line
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, import the Excel data in bulk with ASP, and also need to give the system DSN
Does excel set up the driver?
Zhanghongwen (Rogue mosquito)? Problem points: 80, reply times: 4Top
1/F Veryoldman (Headless Fly (www.gzmeishi.com)) reply to 2006-01-27 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$]"
On my own website: www.gzmeishi.com on the test pass! Top
2 Floor ZCXC (know spring grass) back to 2006-02-05 14:18:59 score 0 or not.
Does the microsoft.jet.oledb.4.0 need to be configured on the server? Top
3 Floor ZCXC (know spring grass) back in 2006-02-05 18:36:27 score 0 Depressed!!!
Please help the master!!!
My server is configured as Windows Server 2000,iis 5.0,sql Server 2000.
With 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)
/.. /.. /aa.asp XX Line
myconn_xsl= "Driver={microsoft Excel Driver (*.xls)};d bq=" &server.mappath
("StrName")
An error occurred while opening to connect:
Microsoft OLE DB Provider for ODBC drivers (0x80004005)
/.. /.. /aa.asp XX Line
Excuse me:
myconn_xsl= "Driver={microsoft Excel Driver (*.xls)};d bq=" &server.mappath
("StrName") statement to connect, how should the server be configured?
With 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; ""; "
To connect, how should the server be configured?
What are the reasons for this problem? What is the server missing configuration or something?
Please advise the master.
Errors are usually on line 8th when connecting to a database with Dreamweaver. And the problem will be there for a while. Normally it starts running normally, but a refresh will have the following problems:
HTTP Error 500.100-Internal server error-ASP error
Internet Information Services
--------------------------------------------------------------------------------
Technical information (for support staff)
Error type:
Provider (0x80004005)
Unspecified error
/xxxxxx.asp, line 8th.
Browser type:
mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1)
Web page:
Get/main.asp
Problem Reason:
The connection to the database code is not specification caused. There is a missing code.
Resolve Fangan:
Find the code that generates the connection database for the Mm_xxxxxx_string value statement, add the uid=; Pwd=
(This code is typically under the site's connections file)
For example:
Before the error: mm_xxxxx_string = "DSN=YYYY;"
After correction: mm_xxxx_string = "DSN=YYYY;" uid=; pwd=; "
Now try it yourself!
