Solved

configure windows xp to connect to sybase12 server

Posted on 2004-04-18
13
9,054 Views
Last Modified: 2007-12-19
I installed 'Sybase for Windows NT' on Windows XP.
What do I need to configure on my pc to be able to connect to sybase12 sqlserver?
This is what I have tried:

1) Control panel->Administrative Tools->Data Sources(ODBC)
2) Add User DSN
3) Select SQL Server
4) Information populated:
Name - CAT(database name)
Description - CAT(database name)
Server - syb12(sql server name)
5) Click Next
6) Toggle for selection ' With sql server authentication using a login id and password entered by the user. Click on 'Client Configuration' button -
7) At 'Add Network Library Configuration' window, populate this information:
Server alias - syb12
Server name - 100.4.30.50
Uncheck dynamically determine port (enter port number 4101, previously defaulted to 1422)
Check connect to sql server to obtain default settings for the additional configuration options
login  id - sa
password - password
8)Click next
9)Getting this error message:
Connection failed
SQLState:'01000'
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionRead(recv())
Connection f ailed:
SQLState:'08501'
SQL Server Error:11
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]General network error. Check your network documentation.

Is my configuration above correct:?
0
Comment
Question by:JamilahMS
  • 4
  • 3
  • 3
  • +1
13 Comments
 
LVL 15

Expert Comment

by:namasi_navaretnam
ID: 10858916
> 3) Select SQL Server

You need odbc driver for Sybase. Also You will need to install Sybase client software on your PC.

Regards-
0
 
LVL 13

Expert Comment

by:alpmoon
ID: 10864690
I suggest to test direct open client connection first. I am not sure whether you have to use ODBC or not. If you don't have to, just use Open Client connection.

Click start, then Sybase, then dsedit. In dsedit, you can add your server by using "server objects" and try your connection by using ping.

Good luck!
0
 

Author Comment

by:JamilahMS
ID: 10865350
Yes, already installed Sybase client.
Ping is ok.
Unable to connect using client isql.
Configure odbc as above but getting connection failure during configuration at step 7.
Is the way I configure odbc correct?
0
Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

 
LVL 15

Expert Comment

by:namasi_navaretnam
ID: 10865386
>Unable to connect using client isql.

what is the exact error message?

For odbc to work, connection using isql should work first.
0
 

Author Comment

by:JamilahMS
ID: 10865413
Ste4ps used:
1) Control panel->Administrative Tools->Data Sources(ODBC)
2) Add User DSN
3) Select SQL Server
4) Information populated:
Name - CAT(database name)
Description - CAT(database name)
Server - syb12(sql server name)
5) Click Next
6) Toggle for selection ' With sql server authentication using a login id and password entered by the user. Click on 'Client Configuration' button -
7) At 'Add Network Library Configuration' window, populate this information:
Server alias - syb12
Server name - 100.4.30.50
Uncheck dynamically determine port (enter port number 4101, previously defaulted to 1422)
Check connect to sql server to obtain default settings for the additional configuration options
login  id - sa
password - password
8)Click next
9)Getting this error message:
Connection failed
SQLState:'01000'
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionRead(recv())
Connection f ailed:
SQLState:'08501'
SQL Server Error:11
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]General network error. Check your network documentation.
0
 
LVL 13

Expert Comment

by:alpmoon
ID: 10865437
Did you try ping in dsedit?
0
 

Author Comment

by:JamilahMS
ID: 10865489
Sorry,  cant find dsedit function.
Start->Sybase->
I only have these options:
CT-Library Reference
SQLServer Manager
SQLEdit
SSM Help Reference
Sybping
Wisql32

I ping ok via Sybping
0
 
LVL 15

Accepted Solution

by:
namasi_navaretnam earned 125 total points
ID: 10865640
Try sybase odbc drivers.

DataDirect:
http://www.datadirect-technologies.com/download/downloadindex.asp

EasySoft:
http://www.easysoft.com/products/2204/trial.phtml

Looks like you are using odbc driver for MS SQL Server.
0
 
LVL 13

Expert Comment

by:alpmoon
ID: 10865648
I haven't used XP so far. Either Windows XP is different or there is something wrong with your Sybase Client installation. But you can also check and edit Sybase interfaces file,
%SYBASE%\ini\sql.ini

If the entry for your server in sql.ini looks OK, isql should be working. Have you tried wisql?

You can also try isql in Command Prompt:
isql -Usa -S<server_name> -P<password>

(Server name is the name in sql.ini, not ip address)
0
 
LVL 13

Expert Comment

by:alpmoon
ID: 10865804
Btw. have you checked the version of Open Client ('Sybase for Windows NT') you have installed. wisql was part of an old version (maybe system 10), you should have SQLAdvantage instead.
0
 
LVL 1

Expert Comment

by:gottathink2
ID: 10880269
It looks to me like you are using the wrong ODBC drivers to connect to the Sybase database. You appear to be using the "[ODBC SQL Server Driver]" which I think is for Microsoft SQL server not Sybase.

Is the Sybase database on another, separate computer then the one you have installed the ODBC drivers on?

The dsedit utility is normally installed with the Sybase client libraries on the client computer, it should be under "Sybase" on the Start > All Programs menu.

If your Sybase server uses a custom port then you will have to add the port ID in the properties using dsedit. I see you did something similar in step 7 of your list which seems to imply you are using the wrong ODBC drivers.
0

Featured Post

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

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

Having trouble getting your hands on Dynamics 365 Field Service or Project Service trial? Worry No More!!!
For months I had no idea how to 'discover' the IP address of the other end of a link (without asking someone who knows), and it drove me batty. Think about it. You can't use Cisco Discovery Protocol (CDP) because it's not implemented on the ASAs.…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
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…

786 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