Re: What SQL*Net command do we use for VB to Oracle

the only way to MAYBE get this working is to have the 16 bit SQL*Net configured and the connect string is simply the same as for 16 bit SQL*Plus. [hint: drop the SQL*Net v1 style of X:, P: etc..., just use the alias]. this is naturally done in the DSN configuration, VB doesn't need to refer to SQL*Net at all, simply the DSN information.

Code example:

Dim odb As Database
Set odb = OpenDatabase(ODBC, False, False, "ODBC;DSN=INS32;UID=SCOTT;PWD=TIGER") Received on Tue Jul 28 1998 - 11:08:57 CDT