Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

PowerBuilder 7.0 connecting to Sybase SQL Anywhere Server v5.x

1 view
Skip to first unread message

Alex Castillo

unread,
Sep 13, 2005, 12:30:34 PM9/13/05
to
Hi...

When using Powerbuilder 7 to connect to Sybase SQL Anywhere Server v5.x, if
the user name and/or
password is invalid, an ODBC configuration dialogue window appears. What
parameter do I include in my connect string to prevent the ODBC window from
showing?

I found someone was using SQL_DRIVER_CONNECT,SQL_DRIVER_NOPROMPT in order to
do so, but is not working on my Sybase SQL Anywhere Server v5.x

Anyone has an idea I can use?

Thank you..!

Alex


Chris Keating (iAnywhere Solutions)

unread,
Sep 13, 2005, 4:07:41 PM9/13/05
to
That should work with SA5. Can you post your exact code?


"Alex Castillo" <klmAlexC...@HotMail.Com> wrote in message
news:4326fe94$1@forums-2-dub...

Alex Castillo

unread,
Sep 13, 2005, 5:03:27 PM9/13/05
to
This is the code I'm using now:

SQLCA.DBMS="ODBC"
SQLCA.DBParm="ConnectString='Agent=client;AutoStop=yes;DSN=MyDSN;ENG=MyServe
r;Start=c:\sqlany50\win32\dbclient.exe -x TCPIP{Host=192.168.1.5}
KGASQL;DBN=MyDataBaseName;UID=dba;PWD=secret'"
CONNECT USING SQLCA;

I've tried to add the SQL_DRIVER_CONNECT,SQL_DRIVER_NOPROMPT in different
points of the SQLCA.DBParm parameter unsuccesfully...

Where and how should I place them?

"Chris Keating (iAnywhere Solutions)" <Spam_NoTha...@iAnywhere.com>
wrote in message news:4327318d$1@forums-1-dub...

Chris Keating (iAnywhere Solutions)

unread,
Sep 13, 2005, 8:03:43 PM9/13/05
to
Here is an example:

SQLCA.DBMS = "ODBC"
SQLCA.AutoCommit = False
SQLCA.DBParm = "ConnectString='DSN=ASA 9.0
Sample;UID=dba;PWD=sql',ConnectOption='SQL_DRIVER_CONNECT,SQL_DRIVER_NOPROMPT'"

"Alex Castillo" <klmAlexC...@HotMail.Com> wrote in message

news:43273e9f@forums-1-dub...

Alex Castillo

unread,
Sep 14, 2005, 8:46:29 AM9/14/05
to
Great..!

There are any other ConnectOptions? Where are they documented?

Thank you for your help..!

Alex

"Chris Keating (iAnywhere Solutions)" <Spam_NoTha...@iAnywhere.com>

wrote in message news:432768df$1@forums-1-dub...

0 new messages