---
title: "Andra gången = Table not exist"
type: "forum-thread"
url: "https://www.webforum.nu/amne/asp/104254-andra-gången-table-not-exist"
topic: "ASP"
topic_url: "https://www.webforum.nu/amne/asp"
author: "Jesper T"
published: "2004-05-24T18:31:33.000Z"
updated: "2004-05-24T18:36:42.000Z"
replies: 1
views: 196
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/104254-andra-gången-table-not-exist"
---

# Andra gången = Table not exist

## #1 — Jesper T, 2004-05-24T18:31Z

Andra gången så "finns inte" tabellen, varför?

```
Sub myDBget(calSql)
	Set calConn = Server.CreateObject("ADODB.Connection") 
	calConn.Open "Provider=MySQLProv;Data Source=*******;User Id=*******;Password=********;"
	Set calRS = calConn.Execute(calSql)
	If not calRS.EOF then arrcalRS = calRS.getrows()
	calRS.Close : Set calRS = Nothing
	calConn.Close : Set calConn = Nothing
End sub 

'...

call myDBget("SELECT calbody FROM myCal WHERE myDate=date()")
'Skriver ut
call myDBget("SELECT calbody FROM myCal")
[red][b]Provider error '80040e37' 

Table does not exist.[/b]
[/red]
```

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

## #2 — Jesper T, 2004-05-24T18:36Z

Ok, funkade när jag ändrat till MySQL ODBC Driver

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

---

Tråden på webben: https://www.webforum.nu/amne/asp/104254-andra-gången-table-not-exist