webForumDet fria alternativet

Data source name not found and no default driver specified

1 svar · 307 visningar · startad av Eclipse

EclipseMedlem sedan juli 20003 825 inlägg
#1

Exempel från denna sidan: http://www.aspupload.com/manual_db.html

INSERT INTO [files] (bloImage, strFilename, strDescription, intFilesize) VALUES(?, 'Strategi.doc', '', 21504)

Persits.Upload.1 error '800a0018'

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

/files/confirm.asp, line 42

***

'## OPEN THE DATABASE
Set Conn = Server.CreateObject("ADODB.Connection")

'## SELECT SERVER
Conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("\Databas\syscare.mdb")

Set Upload = Server.CreateObject("Persits.Upload")

' Capture files
Upload.Save "d:\www-kunder\syscare.se\files\"

' Obtain file object
Set File = Upload.Files("FILE1")

If Not File Is Nothing Then
-- ' Build SQL INSERT statement
-- SQL = "INSERT INTO [files] (bloImage, strFilename, strDescription, intFilesize) VALUES(?, '"
-- SQL = SQL & File.Filename & "', '"
-- SQL = SQL & Replace(Upload.Form("DESCR"), "'", "''") & "', "
-- SQL = SQL & File.Size & ")"

response.write sql
-- ' Save to database
-- File.ToDatabase Conn, SQL ' <-- rad 42
-- Response.Write "File saved."
Else
-- Response.Write "File not selected."
End If

Engine^Medlem sedan dec. 20003 887 inlägg
#2

Jag undrar om du inte ska ta och kolla på ADO-based File Uploads istället för ODBC-based File Upload.

135 ms totalt · 3 externa anrop · v20260731065814-full.30151723
0 ms — hämta forumlista (cache)
0 ms — hämta statistik (cache)
132 ms — hämta tråd, inlägg och bilagor (db)