SQL Server 7 and Mac OS X
My first foray into the nasty world of consulting in awhile unfortunately involves Cold Fusion and MS SQL Server. (Thank god no ASP =) What would be the best way to connect to SQL Server from my iBook? I don't want to use Virtual PC, too slow. Anyhow I ended up grabbing a trial of SQLGrinder. It's not exactly what I want, but it's close enough. Microsoft has a JDBC driver for SQL Server 2000, but not for 7. A google search turned up jTDS. I put the jTDS driver into ~/Application Support/SQLGrinder and added the following parameters in the drivers preference tab of SQLGrinder:
Name: SQL Server
Base Class: net.sourceforge.jtds.jdbc.Driver
URL: jdbc:jtds:sqlserver
Enabled: check the check box
Things still didn't seem to be working so I opened up the connection preferences and checked the "Only Use JDBC 1.0 Features" box. Result: I can now send queries and browse the schema of a SQL Server 7 db on my iBook.
12:50:34 PM
