querying Oracle

Results 1 to 2 of 2

Thread: querying Oracle

  1. #1
    Join Date
    Dec 1969

    Default querying Oracle

    Hi<BR>I am trying to connect to an Oracle DB using ASP I was wondering if anyone knew what table in Oracle I would query to ensure correct user log-in. Also does anyone know the code to connect to an Oracle DB..thanks<BR>Mike

  2. #2
    Join Date
    Dec 1969

    Default A couple of connection strings

    cn.ConnectionString = "Provider=MSDASQL.1;Driver={Microsoft ODBC for Oracle};UID=" & username & ";PWD=" & password & ";SERVER=" & servername<BR><BR>cn.ConnectionString = "Provider=MSDAORA.1;Password=" & password & ";User ID=" & username & ";Data Source=" & servername & ";Persist Security Info=True"<BR><BR>I don&#039;t know about the table, but after you attempt to connect, you could check the errors collection of the connection object for this...<BR><BR>ORA-01017: invalid username/password; logon denied<BR><BR>I wonder if this would also toss an "ORA" error if the server was down...<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