ASP connect to SQL database

Results 1 to 2 of 2

Thread: ASP connect to SQL database

  1. #1
    bikeman2000 Guest

    Default ASP connect to SQL database

    I can&#039t seem to find information on a simple process. I need to know the code to connect to a SQL database with a DSN-Less connection. My code for MS access looks as such...<BR><BR>DatabaseConnection.Open "DBQ=" & Server.MapPath("/new/Components/Database/data.mdb") & ";Driver={Microsoft Access Driver (*.mdb)}<BR><BR>what do I have to change to get SQL connection?

  2. #2
    Join Date
    Dec 1969

    Default RE: ASP connect to SQL database

    "provider=SQLOLEDB;server=(servername);uid=(userna me);pwd=(pass);database=(database name)"<BR><BR>take the brackets away when you add your own info<BR><BR>jason

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts