Page 1 of 1
connecting a Mac to SQL Server 2008
Posted: Fri Sep 05, 2008 4:29 am
by rwentechaney
Using a newer MacBook.
Leopard 10.5.4
Java 1.5.0_13
oXygen XML Editor (Enterprise Edition 9.3, build 2008081313)
Trying to connect to an SQL Server (2008).
I downloaded sqljdbc4.jar to add as a new data source driver (per instructions in manual).
When I try to add it, I receive an error message: "Invalid input: Driver class."
Any help is appreciated.
Thank you!
Re: connecting a Mac to SQL Server 2008
Posted: Fri Sep 05, 2008 12:40 pm
by sorin_ristache
Hello,
We will check if there is any problem with accessing SQL Server 2008 from Oxygen. We had no problems working from Oxygen on an SQL Server 2005 database. Normally you should connect to SQL Server 2008 without problems from Oxygen if you use the correct JDBC driver and you follow
the instructions for configuring the database connection.
Regards,
Sorin
Re: connecting a Mac to SQL Server 2008
Posted: Wed Sep 17, 2008 12:10 pm
by stefan
You should be able to connect to SQL Server 2008 from a Mac OS environment if you download the "Microsoft SQL Server 2005 JDBC Driver 1.2" available from the following link:
http://www.microsoft.com/downloads/deta ... laylang=en extract the archive and use the sqljdbc_1.2\enu\sqljdbc.jar file to configure the SQL Server datasource from Oxygen-> Preferences -> Data Sources.
The above driver works with any 1.4 or later JVM.
I suspect that you tried to use the "Microsoft SQL Server JDBC Driver 2.0 Community Technology Preview (July 2008)" available to download from the link:
http://www.microsoft.com/downloads/deta ... laylang=en
This new driver is compiled with Java 1.6 so if you like to use it you must run Oxygen with a Java 1.6 or later JVM.