Well, if it works in one place, try the other...
Went and tried the jTDS driver from http://jtds.sourceforge.net that I've been using to connect to SQL 7 from my Powerbook on the Windows box instead of the Microsoft driver, and sure enough - worked right away.
I'm now using this successfully to connect on my Mac to a remote SQL 7 server and on a Windows box to connect to a remote SQL 2000 box. Both Dev situations, so I don't know about how it works under load, but I think my client is going to test that. We'll see how it goes and I'll post back if I get any performance data.
Jason
On Jul 26, 2004, at 3:36 PM, Jason Pamental wrote:
Thanks John - I'll check it out. I have had luck with the JTDS driver on my laptop, but that was also with SQL 7, not 2000.
Jason
On Jul 26, 2004, at 3:29 PM, John McGowan wrote:
Jason,
We are currently running W5 on Linux connecting to MSSQL7 via JDBC. Part of what made it successfull was staying away from the MS drivers. We use JSQLConnect for our JDBC driver. Also, since the code we write still has to run on an ODBC server sometimes, we still use ODBC on the Dev studio when creating the taf and tcf code. Then right before we copy the files to the server that uses JDBC, we do a search and replace in the taf and tcf files for ODBC and replace with JDBC...
Works well.
Driver is located at... http://www.jnetdirect.com/
I know it's not what you were asking for, but thought I'd throw it out there for you anyway.
/John
Jason Pamental wrote:
I'm working on a client's migration to JDBC on Linux, but want to try using MS' JDBC driver for SQL Server 2000 from the Witango 5.5 Dev Studio. I'm not having luck getting the Dev Studio to connect - anyone have this working correctly on a Windows machine? If so, can you share what you have where in the setup screen?
Thanks,
Jason
______________________________________________________________________ __
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
-- ____________________________________________________________________
Jason Pamental, President [EMAIL PROTECTED]
Bathysphere Digital Media Services, Inc. http://bathyspheredms.com
____________________________________________________________________
Tel: 401.490.6830 Fax: 401.490.6831 ________________________________________
A North American Distributor for Witango (http://www.witango.us)
Rapid Web Application Development - XML Execution Engine
_______________________________________________________________________ _
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
-- ____________________________________________________________________
Jason Pamental, President [EMAIL PROTECTED]
Bathysphere Digital Media Services, Inc. http://bathyspheredms.com
____________________________________________________________________
Tel: 401.490.6830 Fax: 401.490.6831 ________________________________________
A North American Distributor for Witango (http://www.witango.us)
Rapid Web Application Development - XML Execution Engine
________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
