How to connect Oracle

Results 1 to 2 of 2

Thread: How to connect Oracle

  1. #1
    Join Date
    Dec 1969

    Default How to connect Oracle

    Hello to all<BR>Can i connect oracle throungh DSN/ODBC<BR>If yes then please some one tell me what will be the procedure<BR>Any help will be appreciated<BR><BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: How to connect Oracle

    I&#039;m not sure if you can connect to an Oracle database throungh DSN/ODBC if someone out there knows how then please come forward but I do know how to connect to an Oracle database using OLEDB which is faster then a DSN-Less connection OR a DSN/ODBC connection. The trick is to use the Provider instead of the Driver.<BR><BR>So your connection string might look something like that:<BR><BR>"Provider=MSDAORA; Data Source=2; User Id=Vlince; Password=me"<BR><BR>The Provider part is different for each and every type of database, the one for Oracle is MSDAORA<BR><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