Getting Data From Access via DSN

[rpbenito]

ok...here's my problem...I rented web space from a server and I am trying to make a DHTML document to retrieve data from ACCESS. I am having trouble getting it to work....here is my code...

Private Function Connect_onclick() As Boolean
Dim conn As ADODB.Connection
Dim conn_string As String
Set conn = New Connection
conn_string = "Provider=Microsoft.Jet.OLEDB.3.51;DSN=Pat;Database=biblio.mdb"
conn.Open
conn.Close
End Function

I have created a DSN on my local machine called Pat to test it...it doesn't work on my local machine.(I wanted to test it on my machine before creating the dsn on the server) Can someone help me out as to what I am doing wrong? Thank you so much.

 

[zemp]

Just use:

conn_string ="DSN=Pat"

The DSN already stores the required information to make your connection.

Thanks and Good Luck!

zemp