| abersmay 2006-02-12, 6:40 pm |
| The problem i'm having is trying to connect to my ms access database on my
remote server. The odbc dsn is setup correctly as
http://swirlybird.co.uk/testodbc.asp connects fine.
The code i used for that is:
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Open "db_swirlybird"
set rs=Server.CreateObject("ADODB.recordset")
rs.Open "Select * from users", conn
for each x in rs.fields
response.write(x.name)
response.write(" = ")
response.write(x.value)
next
%>
When i type in the dsn name (db_swirlybird) dreamweaver says the testing
server timed out.
I then tried using connection strings:
"DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" &
Server.MapPath("/private/db_swirlybird.mdb") & ";"
"Driver={Microsoft Access Driver
(*.mdb)};Dbq=/private/db_swirlybird.mdb;Uid=Admin;Pwd=;
Just keeps saying testing server timed out. I'm sure its something very
simple.
I've had a look at previous posts on the subject but none have had the answer.
Any help would be much appreciated
|