Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
fabio
Starting Member
1 Post |
 Posted - 2002-07-29 : 05:59:19
|
| Hy guys,I have a strange problem:I have SQL Server 7 running on my pc and I cannot connect to a sybase (Ver 11.9) db from Query Analyzer, but I can from command prompt launching isql.exe.If I insert a wrong pwd in Query analyzer I receive a login error, but if the pwd is correct I receive a general network error, so the error is beyond authentication step.I can ping the server where Sybase db is and it pings me.I really have no idea!!Can anyone help me, please??Thanks, Fabio |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2002-07-29 : 07:14:00
|
| I don't think that will work. SQL Server has come a fair way since Sybase.There are tools that will work with both, have a look at DB Artisan from www.embarcadero.comDamian"I can't belive it's not butter"Edited by - Merkin on 07/29/2002 07:14:29 |
 |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2002-07-29 : 07:14:07
|
| I believe this is probably because isql uses DBLibrary to connect whereas Query Analyzer uses ODBC. Are you sure you should be able to use SQL7 Query Analyzer to connect to Sybase ? ( I appreciate that they were once the same product but that's not the case now which might be a reason why legacy tools like isql still work - try connecting with osql - if that doesn't work, Query Analyser won't work)HTHJasper Smith |
|
|
|
|
|
|
Unable to connect to Sybase from Query Analyzer