DSN Connection to Access


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: DSN Connection to Access

  1. #1
    Kyle Guest

    DSN Connection to Access


    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?


  2. #2
    Douglas J. Steele Guest

    Re: DSN Connection to Access

    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?
    >




Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center