How to connect to a Sybase Database
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
21-06-19 04:49 PM
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
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
24-06-19 11:55 PM
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
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
31-03-21 10:08 AM
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
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
07-11-22 06:30 AM
------------------------------
Prasanna Sai Pothineni
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
07-11-22 07:03 AM
Develop Blue Prism process using Data - ODBC VBO which can be found in the digitalexchange.
------------------------------
Bohyon Hwang
Director
블루프리즘
Seoul
+82262033950
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
07-11-22 09:21 AM
------------------------------
Prasanna Sai Pothineni
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
08-11-22 01:53 AM
------------------------------
Bohyon Hwang
Director
블루프리즘
Seoul
+82262033950
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
12-12-22 06:26 AM
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
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
12-12-22 09:41 AM
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
------------------------------
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
12-12-22 03:00 PM
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
------------------------------
![](/skins/images/3CCE9DA4F28CA98E3CC8BF54ECC3AD71/responsive_peak/images/icon_anonymous_message.png)