---
title: "Data source name not found and no default driver specified"
type: "forum-thread"
url: "https://www.webforum.nu/amne/asp/76234-data-source-name-not-found-and-no-default-driver-specified"
topic: "ASP"
topic_url: "https://www.webforum.nu/amne/asp"
author: "Eclipse"
published: "2003-05-07T14:21:10.000Z"
updated: "2003-05-07T14:50:32.000Z"
replies: 1
views: 307
page: 1
pages: 1
language: "sv-SE"
site: "webForum — webforum.nu"
rights: "Upphovsrätten till varje inlägg tillhör dess författare."
attribution: "Citera som: webForum, https://www.webforum.nu/amne/asp/76234-data-source-name-not-found-and-no-default-driver-specified"
---

# Data source name not found and no default driver specified

## #1 — Eclipse, 2003-05-07T14:21Z

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

Permalänk: https://www.webforum.nu/p/76234

## #2 — Engine^, 2003-05-07T14:50Z

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

Permalänk: https://www.webforum.nu/p/1040239

---

Tråden på webben: https://www.webforum.nu/amne/asp/76234-data-source-name-not-found-and-no-default-driver-specified