SQL DSN less connection

Results 1 to 2 of 2

Thread: SQL DSN less connection

  1. #1
    Join Date
    Dec 1969

    Default SQL DSN less connection

    is it possible to connect to SQL Server using DSN less connection? what will the source code look like in ASP?<BR><BR>thnx in advance

  2. #2
    NPKumar Guest

    Default RE: SQL DSN less connection

    Hi,<BR>Use the following code for Dsn Less Connection.<BR>&#060;%<BR>dim Conn_String<BR>Conn_String = "Provider=SQLOLEDB;Server=your server;Database=yourDatabase;UID=xxx;PWD=xxx;" <BR>dim Conn<BR>Set Conn=server.createobject("ADODB.Connection")<BR>Co nn.open Conn_String<BR>%&#062;<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