topic RE: How to connect to a Sybase Database in Product Forum

How to connect to a Sybase Database

FelipeSalgado — Fri, 21 Jun 2019 15:49:00 GMT

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
------------------------------

RE: How to connect to a Sybase Database

david.flores — Mon, 24 Jun 2019 22:55:00 GMT

Hello Felipe,

This issue is very rare since the Sybase DB is an uncommon DB and therefore we don't have much in the way of supporting this topic. However, there may be some others in our Community that might have some positive feedback for you and I will be looking forward to their comments and helpful tips

In the meantime, have you tried to confirm your OLEDB to Sybase connection before introducing Blue Prism? We know Blue Prism can interact with OLEDB, so if you can confirm your OLEDB to Sybase connection first, you might have better luck with your overall connection to Blue Prism after that connection is made.

Best of Luck and if I find more support on this, I will be sure to pass it along.

------------------------------
Regards,

David Flores
Sr. Product Consultant
Blue Prism
------------------------------

RE: How to connect to a Sybase Database

VaibhavArora — Wed, 31 Mar 2021 09:08:00 GMT

Hi @david.flores / @FelipeSalgado ,

Could you please help me in making connection with BP and SYBASE. How to make connection ?

@FelipeSalgado - Did you find any solution for this ?

------------------------------
Vaibhav Arora
Senior Process Optimisation developer
Fildelity
UTC
------------------------------

RE: How to connect to a Sybase Database

Prasanna_SaiPot — Mon, 07 Nov 2022 06:30:00 GMT

Hi @Felipe Salgado Please let us know if we have any solution for this?

------------------------------
Prasanna Sai Pothineni
------------------------------

RE: How to connect to a Sybase Database

BohyonHwang — Mon, 07 Nov 2022 07:03:00 GMT

Install Sybase ODBC driver on the Runtime Resources.
Develop Blue Prism process using Data - ODBC VBO which can be found in the digitalexchange.

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

RE: How to connect to a Sybase Database

Prasanna_SaiPot — Mon, 07 Nov 2022 09:21:00 GMT

Can you please help me to know where to get the Sybase ODBC driver?

------------------------------
Prasanna Sai Pothineni
------------------------------

RE: How to connect to a Sybase Database

BohyonHwang — Tue, 08 Nov 2022 01:53:00 GMT

Sybase is aquired by SAP, I heard. Probably, SAP homepage might give you some information about Sybase.

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

RE: How to connect to a Sybase Database

Prasanna_SaiPot — Mon, 12 Dec 2022 06:26:00 GMT

Hi Bohyon,

Thanks for your solution, i got the driver installed in the run time resource and while I am trying the connection to Sybase through Blueprism by using the below connection string: "database=" & [Database] & "; data source=" & [Server] & "; user id=" & [User] & "; password=""" & [Password] &""""&"; Connection Timeout=40", the below error is getting up: Data source name not found and no default driver specified.

Can you please help to find out where I am missing?

------------------------------
Prasanna Sai Pothineni
------------------------------

RE: How to connect to a Sybase Database

BohyonHwang — Mon, 12 Dec 2022 09:41:00 GMT

I'm not sure but the data source is not a server, I think.
Data source name must be added using the ODBC admin tool.
Why don't you review the following document.
Connect to an ODBC Data Source (SQL Server Import and Export Wizard) - SQL Server Integration Services (SSIS) | Microsoft Learn

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

RE: How to connect to a Sybase Database

Prasanna_SaiPot — Mon, 12 Dec 2022 15:00:00 GMT

Hi Bohyon,

Thanks for the info, using the above link, i tried to generate the connection string, but it is failing to establish the connection to Sybase database.

Can you please let me know how to connect over the call?

------------------------------
Prasanna Sai Pothineni
------------------------------

RE: How to connect to a Sybase Database

BohyonHwang — Tue, 13 Dec 2022 01:10:00 GMT

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
------------------------------

RE: How to connect to a Sybase Database

sastharpa — Mon, 08 May 2023 08:30:00 GMT

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
------------------------------