Re: ODBC connect VB - Oracle 7

Does the oralink DSN actually work in win98. You could try odbctest which comes with the oracle client. The TNS error you are getting rather suggests that the database alias in your tnsnames.ora is setup incorrectly in which case the oDBC wouldn't work either.

also If I were you I probably wouldn't post usernames and passwords to newsgroups.

HTH "Pierre Gagnon" <pgagnon_at_profitkey.com> wrote in message news:38ba7fd3.0_at_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
>
>
> -- - Direction or suggestions would be appreciated
>
>
Received on Tue Feb 29 2000 - 03:24:15 CST