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

From: <iolo_at_my-dejanews.com>
Date: Wed, 29 Jul 1998 10:06:50 GMT
Message-ID: <6pms7p$2n7$1@nnrp1.dejanews.com>

In article <35c0f70d.76138341_at_newshost.us.oracle.com>, marktoml_at_gdi.net (Mark Tomlinson) wrote:
> 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")
>

For this to work, INS32 needs to be set up in tnsnames.ora.

See my previous post on that

HTH --
Oliver Willandsen
European Commission
http://europa.eu.int
All remarks are my own and do not necessarily reflect official EC policy

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Wed Jul 29 1998 - 05:06:50 CDT