how to connect a remote MS-SQL server?

[Jerry QU]

Hi All,

How to connect to a remote (Not at the same machine) MS-SQL 
database using JDBC-ODBC bridge?

looking for a simplesample code

TIA

Jerry Qu

Re: how to connect a remote MS-SQL server?

[Tim O'Neil]

At 10:52 AM 7/28/2001, you wrote:
Hi All,

How to connect to a remote (Not at the same machine) MS-SQL database using 
JDBC-ODBC bridge?

looking for a simple sample code

Do you have the ms-sql client on your client machine? If so
configure it for tcp/ip and then connect with the same jdbc
code you would use for any data source.

Re: how to connect a remote MS-SQL server?

[Jerry QU]

but, the client is on a linux machine...then How?

thanks

Jerry


  
- Original Message - 
From: Tim O'Neil [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, July 29, 2001 1:47 AM
Subject: Re: how to connect a remote MS-SQL server?


 At 10:52 AM 7/28/2001, you wrote:
 Hi All,
 
 How to connect to a remote (Not at the same machine) MS-SQL database using 
 JDBC-ODBC bridge?
 
 looking for a simple sample code
 
 Do you have the ms-sql client on your client machine? If so
 configure it for tcp/ip and then connect with the same jdbc
 code you would use for any data source.
 

Re: how to connect a remote MS-SQL server?

[Tim O'Neil]

At 10:59 AM 7/28/2001, you wrote:
but, the client is on a linux machine...then How?

I came up with this after simply entering mssql linux client
in google: http://www.freetds.org/, looks promising after a
glance.
Want more? Do the same.

Re: how to connect a remote MS-SQL server?

[Jim Seach]

If you're looking for a commercial solution, we've had
good results with the inet Opta 2000 jdbc driver for
SQL Server.  Licenses start  at $399.

see
http://www.inetsoftware.de/English/Produkte/OPTA/default.htm

Jim
--- Tim O'Neil [EMAIL PROTECTED] wrote:
 At 10:59 AM 7/28/2001, you wrote:
 but, the client is on a linux machine...then How?
 
 I came up with this after simply entering mssql
 linux client
 in google: http://www.freetds.org/, looks promising
 after a
 glance.
 Want more? Do the same.
 


__
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/