?
Solved

db connection problem with sqladvantage, but not with isql

Posted on 2008-06-19
6
Medium Priority
?
1,101 Views
Last Modified: 2008-09-17
I'm trying to use another sql editor (besides C:\sqlany50\win32\isql.exe) to run queries.  With this isql, I connect perfectly (the db is in another server).
For some reason, when I try to connect with sqladvantage (or any other sql editor), I receive the following error.
I know the error has something to do with the configuration (a wrong path somewhere), but I don't know what it could be, or what I would need to look for.
The sqladv.exe I want to use is in "C:\SYBASE\BIN". There is another isql.exe in "C:\SYBASE\BIN" and that generates an exception error.

Here's the error that I get when I try to connect through "C:\SYBASE\BIN\sqladv.exe" :
 "ct_connect(): network packet layer: internal net library error: Net-Lib protocol driver call to connect two endpoints failed"

Any help is appreciated.
0
Comment
Question by:MyersA
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 13

Expert Comment

by:alpmoon
ID: 21826990
Sorry, but your quetion is really confusing. As much as I see you can connect to your database by using SQL Anywhere isql. So most probably it is a SQL Anywhere database, not ASE. As much as I know you can't use SQL Advantage to connect to a SQL Anywhere db. Actually if db version is 5, it is a really old product and they are not compatible.

In short you must clarify what database are you trying to connect. If it is a ASE db, your question is relevant. Otherwise you are trying to use incompible products.
0
 
LVL 2

Author Comment

by:MyersA
ID: 21830849
Sorry about that.

Our database is running in Sybase SQL Anywhere v5.5, and I'm using a very limited C:\sqlany50\win32\isql.exe to run all my scripts.

Basically, I would like to use another query editor, preferably free. I've downloaded two, but apparently they're only compatible with Sybase ASE since I get the above-mentioned error.

What would you recommend?


Thanks.
0
 
LVL 24

Accepted Solution

by:
Joe Woodhouse earned 152 total points
ID: 21837912
SQL Anywhere, even one as old as that, should still have shipped with a free GUI version of isql called dbisql. Although it's been a while since I used 5.x so maybe I'm thinking of later versions.

Basically your problem here is that SA is setup to expect ODBC connections whereas the other ASE client tools you're using are expecting a native Sybase Open Client layer to exist. I'm not sure you can even get in to SA 5.5 with Open Client.

But anything that's happy with ODBC should be fine for you. There aren't many free tools that I know of that fit the bill though.
0
 
LVL 1

Assisted Solution

by:jsteenkist
jsteenkist earned 148 total points
ID: 21874001
you should call sybase.bat (located in \sybase\ before starting anything else.
this will probably fix it.

gr.
jan.
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Learn how to use the free Acronis True Image app to easily transfer data between iPhones and Android phones.
We are witnesses that everyone is saying that our children shouldn't "play" with a technology because it is dangerous. This article is going to prove that they are wrong.
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Suggested Courses
Course of the Month13 days, 5 hours left to enroll

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question