Oracle connection string help

Results 1 to 2 of 2

Thread: Oracle connection string help

  1. #1
    Join Date
    Dec 1969

    Default Oracle connection string help

    I am trying to connect to an oracle db with an asp<BR>I am trying to figure out where the username and password go in this segment of code or do you know how to make the db allow anonymous connections from asp, or if someone has a connection string to oracle I can look at?<BR>Dim objRS<BR>Dim objConn<BR>Dim strSQL<BR><BR>Set objConn = Server.CreateObject("ADODB.Connection")<BR>objConn .ConnectionString = "DSN=MyOracleDSN"<BR>objConn.Open &#039;DOES IT GO HERE LIKE BELOW?<BR>objConn.Open,"USERNAME","PASSWORD"<BR>Se t objRS = Server.CreateObject("ADODB.Recordset")<BR><BR>objR S.Open strSQL,objConn

  2. #2
    Join Date
    Dec 1969

    Default RE: DSNless....

    DRIVER={Microsoft ODBC for Oracle};SERVER=ServerName;UID=UserID;PWD=Password; <BR><BR>See:<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