Oracle and ASP

Results 1 to 3 of 3

Thread: Oracle and ASP

  1. #1
    Join Date
    Dec 1969
    DFW, TX

    Default Oracle and ASP

    Can someone give me the connection syntax to access a Oracle database from ASP.<BR><BR>Thanks in advance

  2. #2
    Join Date
    Dec 1969

    Default RE: Oracle and ASP

    dim cn<BR>dim strConnect<BR>dim rs<BR>dim strSQL<BR><BR><BR>strConnect= "DSN=..;UID=..;PWD=.."<BR>set cn=server.CreateObject("ADODB.Connection")<BR>cn.o pen strConnect<BR><BR>strSQL = "SELECT * FROM ..."<BR>set rs=server.CreateObject("ADODB.Recordset")<BR>rs.Op en strSQL, cn,adOpenStatic

  3. #3
    Join Date
    Dec 1969

    Default DSNLess method...

    Application("DbConn_ConnectionString") = "DRIVER=Microsoft ODBC for Oracle;UID=userID;PWD=password;SERVER=databasealia s;"<BR><BR>You would need to have the ORACLE client tools installed on the web server, and then set up a database alias. I believe you would have to do this for the DSN method also.<BR><BR>HTH<BR><BR>Jerry

Posting Permissions

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