Re: ODBC problem, need help
From: Maggie Shapland <Maggie.Shapland_at_bristol.ac.uk>
Date: 1996/06/07
Message-ID: <DsMrH4.93v_at_uns.bris.ac.uk>#1/1
Date: 1996/06/07
Message-ID: <DsMrH4.93v_at_uns.bris.ac.uk>#1/1
ENRIQUE GOYRET <ENRIQUE.GOYRET_at_CITICORP.COM> wrote:
>I'm trying to use ODBC (Oracle 7.0 driver) to connect to Oracle
>7.0.16.6.5 in my Novell server. I use SQL*NET 1.1.1.0 and SQLPME 2.2.15.
>I defined the data source in Windows 3.11 with a connect string of
>X:MAESTROSRV. When I try a test connection I get message :
>
>[oracle][odbc oracle driver][oracle oci]ORA-03112: Host string syntax
>error.
>
you left out the database name (look at /etc/oratab or names of dbs files
if you dont know it- it could be 'sid' -for system identifier)
so connect string may be x:maestrosrv:sid
-- Maggie.Shapland_at_bristol.ac.uk Computing Service,University of Bristol,Tyndall Avenue, Bristol BS8 1UD Tel: 0117 9289000 Ext 3229 Fax: 0117 9291576 http://www.cse.bris.ac.uk/~ccmjsReceived on Fri Jun 07 1996 - 00:00:00 CEST