Re: Sql*Net2 and Visual Basic

From: A little left of plumb <dwyche_at_giant.intranet.com>
Date: 1995/12/14
Message-ID: <1995Dec14.164721.14026_at_giant>#1/1


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
Received on Thu Dec 14 1995 - 00:00:00 CET

Original text of this message