Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

SSMS connection to Sybase ASE

Tags:

ssms

sap-ase

Is there a way to connect to a Sybase (ASE) database instance using Sql Server Management Studio 2008? I tried using other tools to connect but they are very limited and would like to use SSMS.

like image 814
dirtyw0lf Avatar asked Nov 01 '12 18:11

dirtyw0lf


People also ask

How do I connect to a Sybase database in SQL Server Management Studio?

On the File menu, select Connect to Sybase. If you previously connected to Sybase, the command name will be Reconnect to Sybase. In the Provider box, select any of the installed providers on the machine to connect to Sybase server.

How do I connect to a Sybase server?

Use the Connect to Sybase dialog box to connect to the Sybase Adaptive Server Enterprise (ASE) instance that you want to migrate. To access this dialog box, on the File menu, select Connect to Sybase. If you have previously connected, the command is Reconnect to Sybase.

Can we connect to Sybase using SQL Developer?

Oracle SQL Developer 1.5 (1.5. 0.53. 38) supports browsing a selection of third party databases; Microsoft Access, Microsoft SQL Server, MySQL and Sybase. Before accessing these databases, you need to download and load the correct third party drivers.


2 Answers

You can use this tool:

SqlDbx

It's great.

like image 57
zluis0 Avatar answered Sep 20 '22 16:09

zluis0


As far as i know there is no way to use Microsoft's Server Management Studio. And if you are honest it doesnt make a lot sense either. why should sybase/sap design their servers to work with an application provided from a competitor.

personally i prefer to use isql as client software for sybase servers. if you wish to have a GUI may Sybase Central is an option for you.

like image 33
dom Avatar answered Sep 19 '22 16:09

dom