---
title: "Provider=MSDASQL.1;E"
type: "forum-thread"
url: "https://www.webforum.nu/amne/asp/92094-provider-msdasql-1-e"
topic: "ASP"
topic_url: "https://www.webforum.nu/amne/asp"
author: "LR^evil.sid"
published: "2003-12-07T23:12:25.000Z"
updated: "2003-12-07T23:43:16.000Z"
replies: 1
views: 198
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/92094-provider-msdasql-1-e"
---

# Provider=MSDASQL.1;E

## #1 — LR^evil.sid, 2003-12-07T23:12Z

index.asp

```
<%
	oCon = SetCon()
	SQL = "SELECT usr, message, posted FROM msgboard ORDER BY posted DESC LIMIT 0, 9"
[red]line 41	Set oRs = oCon.Execute(SQL)[/red]

	Function SetCon()
		Set oCon = Server.CreateObject("ADODB.Connection")
		oCon.Open(Application("ADODB"))
		SetCon = oCon
	End Function
%>
```

global.asa

```
Sub Application_OnStart
	Application.Lock
	Application("ADODB") = "driver={MySql ODBC 3.51 Driver};server=localhost;database=;uid=;pwd=;option=16387;"
	Application.UnLock
End Sub
```

Genererat ett felmeddelande jag aldrig förr sett:

```
Körningsfel i Microsoft VBScript ( 0x800A01A8 ) 
Objekt krävs.: 'Provider=MSDASQL.1;E'
line: 41
```

Vad betyder det och hur avhjälper jag det?

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

## #2 — niko, 2003-12-07T23:43Z

```
	Function SetCon()
		Set oCon = Server.CreateObject("ADODB.Connection")
		oCon.Open(Application("ADODB"))
		[b]set SetCon = oCon[/b]
	End Function
```

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

---

Tråden på webben: https://www.webforum.nu/amne/asp/92094-provider-msdasql-1-e