---
title: "SQL Server connection"
type: "forum-thread"
url: "https://www.webforum.nu/amne/asp/163767-sql-server-connection"
topic: "ASP"
topic_url: "https://www.webforum.nu/amne/asp"
author: "firstchoice"
published: "2007-08-23T10:10:19.000Z"
updated: "2007-08-23T10:11:44.000Z"
replies: 1
views: 372
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/163767-sql-server-connection"
---

# SQL Server connection

## #1 — firstchoice, 2007-08-23T10:10Z

min kod:

```
dbConnection = Server.CreateObject("ADODB.Connection")
dbConnection.ConnectionString = "Driver={SQL Native Client};Server=SERVER1;Database=db;Uid=test;Pwd=test;"
dbConnection.Open()
```

felbeskrivning:

> Microsoft VBScript runtime error '800a01a8' 
> 
> Object required: '' 
> 
> default2.asp, line 8

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

## #2 — @nders, 2007-08-23T10:11Z

Du måste använda set när du skapar objekt.

```
[b]set[/b] dbConnection = Server.CreateObject("ADODB.Connection")
```

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

---

Tråden på webben: https://www.webforum.nu/amne/asp/163767-sql-server-connection