Oracle connection

Results 1 to 3 of 3

Thread: Oracle connection

  1. #1
    Join Date
    Dec 1969
    Posts
    15

    Default Oracle connection

    How do i connect to an oracle database?<BR>I already have sql*net installed and the right dirvers.<BR><BR>What would my connection string look like?

  2. #2
    Join Date
    Dec 1969
    Posts
    7

    Default RE: Oracle connection

    If you use ADO, you can do just like you use to...<BR><BR>Set Con = Server.CreateObject("ADODB.Connection")<BR>Con.Ope n "DSN=mydsn;UID=myuid;PASSWORD=mypass;"<BR><BR>..wo rks fine for me..

  3. #3
    Join Date
    Dec 1969
    Posts
    15

    Default RE: Oracle connection

    thanks for that.. <BR><BR>but i have another Problem. I tested this in an access databsae.<BR>and it works fine.. but when i query an oracle database i get this<BR><BR>Oracle][ODBC Oracle Driver][Oracle OCI]ORA-00942: table or view does not exist. <BR><BR>do i need to adjust something in my sql

Posting Permissions

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