DSN less connection

Results 1 to 2 of 2

Thread: DSN less connection

  1. #1
    balakrishna Guest

    Default DSN less connection

    How to Connect to MS SQL-6.5 using ASP page without a USER ID & Password created on DSN. is it possible?<BR><BR>

  2. #2
    sampath Guest

    Default RE: DSN less connection

    For DSN less connection <BR>use this syntax .<BR>set conn = server.createObject("ADODB.Connection")<BR>conn.co nnectionstring ="Driver=(Microsoft Access Driver (*.mdb)_<BR> ;DBQ = path for your database(.mdb)"<BR>conn.open<BR>This is for access.<BR>The same syntax with Sql server driver to be used .<BR><BR>Driver = Microsoft Sql server then your server name database name<BR><BR>All this write in global.asa file so that you can use in all your asp pages.<BR>

Posting Permissions

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