Re: Sql*Net2 and Visual Basic

Hello,
I'm currently using Visual Basic 4.0 for Windows-NT. (32 bit OCX). I sure would like to find out how to connect to my RS/6000 Oracle Server & what I need from Oracle. I'm running Oracle 7.2.4. Do I need to go thru the ODBC Link ?

Thank You,
Patrick Tan

A little left of plumb wrote:
>
> In article <4ahrls$m26_at_natasha.rmii.com>, allros_at_rmii.com (Al Rose) writes:
>
> > I am currently insatlling Sql*Net 2.1 for all of my Oracle tools. I also
> > have one application using Visual Basic and I can't seem to be able to
> > get it to respond to Sql*Net 2. All suggestions will be greatly
> > appreciated. Thanks
>
> The following examples work for me...
>
> OO4O:
> Set MyDB = OraSession.DbOpenDatabase(Connect_String$, "scott/tiger", 0&)
>
> ODBC:
> T$ = "ODBC;DSN=" & ODBC_DataSourceName$ & ";"
> T$ = T$ & "DATABASE=" & Connect_String$ & ";"
> T$ = T$ & "UID=scott;PWD=tiger;"
>
> Set MyDB = OpenDatabase("", False, False, T$)
>
> HTH, david
 

-- 
--------------------------------------------------------------------------------------
Patrick Tan
Senior Systems Engineer,
Motorola. 
email: patrick_at_solarwind.sps.mot.com

Food for Thought (Month Dec'95):
"Don't be a farmer who keeps digging out the seeds to check if it's
growing".

--------------------------------------------------------------------------------------