DSN Connection to Access

[Kyle]

Is there a standard here? I know SQL connection strings, but this is my first
Access connection. I'm using an ODBC connection on our hosts server.
<%
set conn = server.createobject ("WhatGoesHere?.connection")
conn.open "Provider=WhatGoesHere?; Data Source=###.###.###.###/data;" &
_
"DSN=#######; Initial Catalog=#####;UId=######;pwd=######;"
%>
Am I way off?

[Douglas J. Steele]

There's no difference for the first point between SQL Server and Access.
It's set conn = server.createobject ("ADODB.connection")

Check Carl Prothman's site http://www.able-consulting.com/ado_conn.htm for
the second point.

http://support.microsoft.com/support.../Q300/3/82.ASP is also a
useful reference.

HTH

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele


"Kyle" <rkfinch@generationinformed.com> wrote in message
news:3bb9dcb2$1@news.devx.com...
>
> Is there a standard here? I know SQL connection strings, but this is my
first
> Access connection. I'm using an ODBC connection on our hosts server.
> <%
> set conn = server.createobject ("WhatGoesHere?.connection")
> conn.open "Provider=WhatGoesHere?; Data Source=###.###.###.###/data;" &
> _
> "DSN=#######; Initial Catalog=#####;UId=######;pwd=######;"
> %>
> Am I way off?
>