Solved

configure windows xp to connect to sybase12 server

Posted on 2004-04-18
13
9,057 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
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

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

 
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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

Suggested Solutions

This article describes my battle tested process for setting up delegation. I use this process anywhere that I need to setup delegation. In the article I will show how it applies to Active Directory
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
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…

830 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