Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

VB5/ODBC Connect Strings

2 posts in Windows NT Last posting was on 1997-09-17 07:33:34.0Z
John Barrett Posted on 1997-09-16 15:39:54.0Z
From: "John Barrett" <jbarrett@ntis.com>
Subject: VB5/ODBC Connect Strings
Date: Tue, 16 Sep 1997 11:39:54 -0400
Lines: 15
X-Newsreader: Microsoft Outlook Express 4.71.1008.3
X-MimeOle: Produced By Microsoft MimeOLE Engine V4.71.1008.3
Message-ID: <PhVd1Yrw8GA.151@forums.powersoft.com>
Newsgroups: sybase.public.sqlserver.nt
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5527
Article PK: 1081605

I'm trying to set up an app that uses Sybase 11 via ODBC ov TCP/IP.
The key problem is that, while I can connect to teh datasource if I let
the ODBC driver pop any needed dialogs, if I try to do dbDriverNoPrompt
then I consistently get ODBC Call Failed errors. SybPing finds the Server
and SQL Central works with the current SQL.INI config.

What I need are examples of Connect Strings that will access a DSN
without ANY prompting for additional information. Everything should
be specified in the Connect String.

Any help or suggestions would be appreciated, and please respond
via EMAIL as I need a soloution to this problem ASAP !! Thanks !!


Tolga ULGEN Posted on 1997-09-17 07:33:34.0Z
Message-ID: <341F87CE.F565C2AF@info.com.tr>
Date: Wed, 17 Sep 1997 10:33:34 +0300
From: Tolga ULGEN <tulgen@info.com.tr>
Organization: InfoSybase
X-Mailer: Mozilla 4.01 [en] (WinNT; I)
MIME-Version: 1.0
To: John Barrett <jbarrett@ntis.com>
Subject: Re: VB5/ODBC Connect Strings
X-Priority: 3 (Normal)
References: <PhVd1Yrw8GA.151@forums.powersoft.com>
Content-Type: text/plain; charset=iso-8859-9
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 36
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5526
Article PK: 854782

There are several attributes of Sybase ODBC connection that you can
define by means of conn. string. these attributes are
DataSourceName (DSN) : a string value (i.e."Sybase System XI")
ServerName (SRVR) : Name of the server. The name must be defined in your
sql.ini (SYB_SERVER)
LogonID (UID) : case sensitive login id (sa).
Password (PWD) : case sensitive password.
Database (DB) : name of the db (pubs2)
Language (LANG) : must correspond a subdir of $SYBASE\locales
Charset (CS) : must correspond a subdir of $SYBASE\charsets
There are several other attributes, but I think if you supply the ones
above correctly, your connection will work. I think you have to supply
at least first 5 attributes.

John Barrett wrote:

> I'm trying to set up an app that uses Sybase 11 via ODBC ov TCP/IP.
> The key problem is that, while I can connect to teh datasource if I
> let
> the ODBC driver pop any needed dialogs, if I try to do
> dbDriverNoPrompt
> then I consistently get ODBC Call Failed errors. SybPing finds the
> Server
> and SQL Central works with the current SQL.INI config.
>
> What I need are examples of Connect Strings that will access a DSN
> without ANY prompting for additional information. Everything should
> be specified in the Connect String.
>
> Any help or suggestions would be appreciated, and please respond
> via EMAIL as I need a soloution to this problem ASAP !! Thanks !!