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.

How do i do to make a odbc connection without go into panel control?

2 posts in Internet Developers Toolkit Last posting was on 2002-04-26 18:01:28.0Z
Walter Posted on 2002-04-26 12:33:07.0Z
Newsgroups: sybase.public.powerbuilder.inet-dev-toolkit
From: Walter
Date: Fri, 26 Apr 2002 08:33:07 -0400
Subject: How do i do to make a odbc connection without go into panel control?
Lines: 1
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Message-ID: <388_84C3437D0EE9F0820044F35785256BA7.0044F36C85256BA7@webforums>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub sybase.public.powerbuilder.inet-dev-toolkit:85
Article PK: 691193

How do i do to make a odbc connection without go into panel control?


Edward Muesch Posted on 2002-04-26 18:01:28.0Z
Newsgroups: sybase.public.powerbuilder.inet-dev-toolkit
From: "Edward Muesch" <emuesch@hotmail.com>
Subject: Re: How do i do to make a odbc connection without go into panel control?
Date: Fri, 26 Apr 2002 14:01:28 -0400
Lines: 39
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2615.200
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200
NNTP-Posting-Host: vzw-166-152-11-145.airbridge.net 166.152.11.145
Message-ID: <388_JtDPu2U7BHA.298@forums.sybase.com>
References: <388_84C3437D0EE9F0820044F35785256BA7.0044F36C85256BA7@webforums>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.powerbuilder.inet-dev-toolkit:84
Article PK: 691191

If you are referring to the ODBC prompt that occurs when an invalid userid
or password is specified then try:

SQLCA.dbParm =
"ConnectString='...',ConnectOption='SQL_DRIVER_CONNECT,SQL_DRIVER_NOPROMPT'"

But in this case then you will have to handle the error yourself and take
the appropriate action(s).

If you mean the control panel ODBC dialog-box to create the DSN then do a
search on http://groups.google.com for "powerbuilder DSNless connection".
You can connect through ODBC without a DSN setup on the client computer but
the syntax is different for each database.

Samples for SQLAnywhere 5:

// Connect to running server
DbParm=ConnectString='Driver={Sybase SQL Anywhere
5.0};UID=dba;PWD=sql;Databasename=idb;EngineName=isd10;start=D:\Program
Files\Sybase\SQL Anywhere 5.0\win32\dbclient.exe -x tcpip'

// Connect to local database
ConnectString='Driver={Sybase SQL Anywhere
5.0};DatabaseFile=c:\anydir\database.db;
Start=c:\windows\system\dbeng50.exe;UID=DBA;PWD=SQL'

Also, if you have any additional questions on this topic that don't involve
the Internet Development Toolkit directly, then you might want to try
posting to the powersoft.public.powerbuilder.connectivity newsgroup.

HTH

-EGM

<Walter> wrote in message
news:84C3437D0EE9F0820044F35785256BA7.0044F36C85256BA7@webforums...
> How do i do to make a odbc connection without go into panel control?