| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: ODBC connect VB - Oracle 7
What type of driver are you using ? MS ODBC for
Oracle or ODBC for Oracle or something else ?
Arpita
In article <38ba7fd3.0_at_news.profitkey.com>,
"Pierre Gagnon" <pgagnon_at_profitkey.com> wrote:
> 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=sp
ooky;Persist
> Security Info = False;"
> 'sConnStr
= "ODBC;DATABASE=pkdb726;UID=pkdb726;PWD=pkdb726;D
SN=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
>
> -- - Direction or suggestions would be
appreciated
>
>
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Mon Mar 06 2000 - 16:13:48 CST
 |
 |