Solved

db connection problem with sqladvantage, but not with isql

Posted on 2008-06-19
6
1,096 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
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 38 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 37 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

Suggested Solutions

Title # Comments Views Activity
truncation error - math operation 6 562
Visual Studio 2010 with SyBase 3 852
SQL Syntax 6 401
SyBase SQL DataTime Format 6 297
Facebook has became the #1 social media platform. People share many funny videos there, yet you don't know how to download them? Now you can download Videos from Facebook in just 3 simple steps.
Building a cohesive image for your brand is vital to making an impression on consumers. When the economy is tough, brands do better than unbranded  products. This can have a huge impact on your long-term profits, as the economy goes up and down.
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

685 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