Unix to SQL Server connection

Question

Post reply

Unix to SQL Server connection

v03066

SSC Enthusiast

Points: 116
More actions
April 2, 2003 at 11:35 am

#76007

Am trying to access SQL Server 2k on W2k from a unix session using isql. Added theSQL server 2k host name and port number to interfaces file. No luck.
Any shortcuts ?
TIA
mO

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

Chris Hedgate One Orange Chip Points: 25041 More actions · Answer 1

What network libraries are the server listening to?

--

Chris Hedgate @ Apptus Technologies (http://www.apptus.se)

http://www.sql.nu

--
Chris Hedgate http://www.hedgate.net/
Contributor to the Best of SQL Server Central volumes
Articles: http://www.sqlservercentral.com/columnists/chedgate/

v03066 SSC Enthusiast Points: 116 More actions · Answer 2

v03066

SSC Enthusiast

Points: 116

April 3, 2003 at 8:25 am

#453044

using TCP/IP

Chris Hedgate One Orange Chip Points: 25041 More actions · Answer 3

Have you tried without host name, i.e. ip address directly?

--

Chris Hedgate @ Apptus Technologies (http://www.apptus.se)

http://www.sql.nu

--
Chris Hedgate http://www.hedgate.net/
Contributor to the Best of SQL Server Central volumes
Articles: http://www.sqlservercentral.com/columnists/chedgate/

solarobe SSC Enthusiast Points: 111 More actions · Answer 4

Sybase open client is incompatible with SQL Server 2000. They use differnt TDS (tabular data stream) protocols.

I have used a unix ODBC api and perl ODBC DBI with DBD::ODBC to access SQL2K from unix.

Edited by - solarobe on 04/04/2003 07:22:01 AM

v03066 SSC Enthusiast Points: 116 More actions · Answer 5

Where do i get unix ODBC ? We run sun solaris 8

TIA

Allen Cui-55137 SSC Guru Points: 51650 More actions · Answer 6

Are you tring to program to access SQL Server from Unix? Microsoft has a JDBC driver which you can install it into your Unix machine for Java application development environment.

Antares686 SSC Guru Points: 125444 More actions · Answer 7

Just keep in mind that the JDBC is still a work in progress and does act flaky, mostly slow.

JayDonoghue Valued Member Points: 72 More actions · Answer 8

I use a combination of freeTDS (http://www.freetds.org/) and perl w/ dbi:Sybase to connect to SQL2K from Solaris clients.

I have had no problems using TDS version 7.0 connecting to the server, though you can use an older version (4.2) if necessary. FreeTDS has decent documentation for setting up the connection.