| Author |
Topic |
|
ekeneduru
Starting Member
6 Posts |
 Posted - 2008-08-15 : 06:45:04
|
| please can any body tell me how to connect to sybase database using sql server 2000 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-08-15 : 08:23:21
|
| Linked server?Do you have ODBC driver for sybase installed.? |
 |
|
|
elancaster
A very urgent SQL Yakette
1208 Posts |
|
|
ekeneduru
Starting Member
6 Posts |
Posted - 2008-08-15 : 08:30:04
|
| yes i have ODBC DRIVE |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-08-15 : 08:32:38
|
| Not ODBC Drive, its ODBC driver. Have you set up linked server before? |
|
|
|
ekeneduru
Starting Member
6 Posts |
Posted - 2008-08-15 : 08:43:55
|
| I HAVE SYBASE INSTALL IN MY PC,I CAN VIEW WITH SQL ADVANTAGE ON SYBASE BUT I WANT TO VIEW IT ON MICROSOFT SQL SERVER 2000 |
|
|
|
elancaster
A very urgent SQL Yakette
1208 Posts |
Posted - 2008-08-15 : 08:49:50
|
| WHY THE CAPS LOCK?read in books online about Linked Servers / openrowset / opendatasourcethen if you have any specific questions regarding the set up, come back and post themEm |
|
|
|
ekeneduru
Starting Member
6 Posts |
Posted - 2008-08-15 : 09:07:23
|
| how do i know if i have ODBC driver because when i was installing sybase i use custom installation and choose ODBC to install sybase. i know how to connect sql server 2000 to visual studio that to show u the knowlege i have on database.all i use is OLDB but i don't know about ODBC much. link served servers means connecting servers.can i use enterprize manager on Sql server to connect to sybase.thank for being there for me |
|
|
|
elancaster
A very urgent SQL Yakette
1208 Posts |
Posted - 2008-08-15 : 09:14:37
|
quote:
Originally posted by ekeneduru
how do i know if i have ODBC driver because when i was installing sybase i use custom installation and choose ODBC to install sybase. i know how to connect sql server 2000 to visual studio that to show u the knowlege i have on database.all i use is OLDB but i don't know about ODBC much. link served servers means connecting servers.can i use enterprize manager on Sql server to connect to sybase.thank for being there for me
yes...quote:
read in books online about Linked Servers / openrowset / opendatasource
Em |
|
|
|
ekeneduru
Starting Member
6 Posts |
Posted - 2008-08-15 : 09:32:37
|
| how |
|
|
|
elancaster
A very urgent SQL Yakette
1208 Posts |
Posted - 2008-08-15 : 09:38:30
|
| in books online (the SQL Server help shipped with the server install) look for those terms... linked server / openrowset / opendatasource. then if you get stuck implementing it post back here with a specific query.or maybe even try GOOGLE? this was the first result when i just searched....http://support.microsoft.com/kb/280102Em |
|
|
|
Van
Constraint Violating Yak Guru
462 Posts |
Posted - 2008-08-15 : 09:53:25
|
| I think he's wanting to connect and use Enterprise Manager with Sybase the same way we use it with SQL Server and see and administer Sybase with Enterprise Manager instead of SQL Advantage that came with Sybase. If that's possible, I'd like to hear about it too. A linked server would allow you to query the Sybase tables but can you link it into EM and browse Sybase tables via GUI and all? |
|
|
|
elancaster
A very urgent SQL Yakette
1208 Posts |
Posted - 2008-08-15 : 09:57:46
|
ah... maybe that is what OP means  from memory, i used to use a linked server with SQL 2000 to oracle and could browse the tables (under linked servers etc...) but no admin tasks etc of course, that's just crazy talk Em |
|
|
|
Van
Constraint Violating Yak Guru
462 Posts |
Posted - 2008-08-15 : 10:11:19
|
| Yea, I've never tried anything like that. Several years ago I had to administer a Sybase db for a few months and the Sybase software was much more difficult (for me) to use than EM so I can see why the OP would want to use EM if it's possible. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-08-15 : 11:04:29
|
| Setup linked server with ODBC (MSDASQL) for sybase and you can see tables and views in sybase. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-08-16 : 18:02:17
|
| >> I can see why the OP would want to use EM if it's possible.But can't manage sybase in sql em unfortunately, even with linked server. |
|
|
|
|
how to view sybase from sql server 2000