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

From: <iolo_at_my-dejanews.com>
Date: Tue, 28 Jul 1998 16:51:30 GMT
Message-ID: <6pkvii$55f$1@nnrp1.dejanews.com>

In article <6pkksj$5mg$1_at_taiwan.informatik.unirostock.de>, danilo.c.ramirez_at_nopspam.ucm.com (dan) wrote:
> We have VB 4.0 app on Win95 trying to communicate with Oracle 7.3 on Sun
> server. We have 16-bit ODBC installed on Win95 machine.
>
> However, we do not know what to put in option that asks for the SQL*Net
> command string. We have tried putting various pieces of info(from examples on
> the web and from our DB guy, i.e,. x:user/passs_at_our_server, p:our_server,
> x:our_server.spx, etc ) but nothing works.
>
> Any ideas?
>
> please respond to group or email to danilo.c####.ramirez_at_ucm.com
>
> remove #### to respond.
>
> Dan Ramriez
>
> ramdan_at_mailexcite.com
> Development Analyst
> Information Systems
> Commonwealth Edison
>
> The contents of this message express only the sender's opinion. This message
does not necessarily reflect the policy or views of my employer, Commonwealth Edison. All responsibility for the statements made in this Usenet posting resides solely and completely with the sender.
>

Hi,

on your client check the file tnsnames.ora which should sit in the

ORACLE_HOME\Network\Admin folder

It's content should look something like

Your_Oracle_Instance =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = Your_Oracle_Server)(PORT = 1522)) (CONNECT_DATA = (SID = Your_Oracle_Instance_Id)) )
Your_Oracle_Server needs to be references in the HOSTS or LMHOSTS file

or to give a concrete example

PARSIFAL_DD =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = PARSIFAL)(PORT = 1522))     (CONNECT_DATA = (SID = DD))
  )

then all you need to use is the name you declared in tnsnames.ora for example PARSIFAL_DD and provide your login and password

--
Oliver Willandsen
European Commission
http://europa.eu.int
All remarks are my own and do not necessarily refelct official European Commission 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 Tue Jul 28 1998 - 11:51:30 CDT