How to connect to a Sybase Database

[FelipeSalgado]

Hi all,

I am working with a client that needs to insert and recieve data from a Sybase database with blueprism. How can I make this connection? Has someone done something similar?

I already tried to do it with a OLEDB action in blueprism but it has not worked.

Thanks,

Felipe Salgado
IT Consultant
Paradigma / Chile

------------------------------
Felipe Salgado
Consultor Senior
Paradigma
America/Santiago
------------------------------

[BohyonHwang]

I am not a Sybase engineer.
It's a long time ago when I worked as a db engineer.
I've just experienced oracle, informix and other sql-like servers.
So I'm just looking for resources together for help.
ODBC driver is a standard technology that connects products of different vendors,
but Connect String is different for each other.
ODBC VBO User Guide also says as follows.

"Refer to the vendors documentation for your specific ODBC driver for details about the makeup of their connection string."
So you need to refer to the right manual of the corresponding product.

How abount reviewing the following Sybase documentations.
https://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.sqlanywhere.12.0.1/dbadmin/connection-string-odbc.html

------------------------------
Bohyon Hwang
Director
블루프리즘
Seoul
+82262033950
------------------------------

[sastharpa]

Below Connection String for Sybase,  and both open connection & execute actions are working.
"DSN=IMAL_DBScript;Uid=username;Pwd=pass;"    where DSN name is the odbc connection name.

------------------------------
LAKSHMIGANESH Velayudham
------------------------------