Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> ODBC connect VB - Oracle 7

ODBC connect VB - Oracle 7

From: Pierre Gagnon <pgagnon_at_profitkey.com>
Date: Mon, 28 Feb 2000 09:00:42 -0500
Message-ID: <38ba7fd3.0@news.profitkey.com>


I'm trying to connect to an Oracle 7 database with VB, I used the following code in my form Load procedure
The OraLink DSN is a System DSN I've got in Win98

Set mCon = New ADODB.Connection

'sConnStr = "DSN=OraLink;UID=pkdb726;PWD=pkdb726;"
'sConnStr = "UID=pkdb726;PWD=pkdb726;DRIVER={Oracle ODBC

Driver};SERVER=spooky;"

'sConnStr = "Provider=MSDAORA.1;UserID=pkdb726;DataSource=spooky;Persist
Security Info = False;"

'sConnStr = "ODBC;DATABASE=pkdb726;UID=pkdb726;PWD=pkdb726;DSN=OraLink;"

sConnStr = "DSN=OraLink;DBQ=spooky;UID=pkdb726;PWD=pkdb726;"

mCon.Provider = "MSDAORA.1"

mCon.Open sConnStr

I get this error:

ORA-12203 : TNS : Unable to connect to destination

Received on Mon Feb 28 2000 - 08:00:42 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US