Oracle Woes

Results 1 to 3 of 3

Thread: Oracle Woes

  1. #1
    Conrad Guest

    Default Oracle Woes

    Has anyone ever created an Oracle connection with ADO?<BR>If so, please tell me how you accomplished this.<BR><BR>Thanks.<BR>Conrad

  2. #2
    Join Date
    Dec 1969

    Default RE: Oracle Woes a sample open of a recordset (didn&#039t need a connection object in this case)...<BR><BR> strsql, "Provider=MSDAORA.1;Data Source=ServerName;User ID=UserName;Password=Password;Persist Security Info=True;", 3, 1, 1<BR>

  3. #3
    Join Date
    Dec 1969

    Default RE: Oracle Woes

    the same as sql server, in this example i&#039m using a connection object<BR><BR> "DSN=...;UID=...;PWD=..."<BR><BR>DSN is the datasource (created on the web server in the ODBC control panel) that points to the Oracle database (you may have to install some Oracle drivers on the web server to do this). UID is the Oracle database username, PWD is the password.

Posting Permissions

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