connecting a Mac to SQL Server 2008

Having trouble installing <oXygen/>? Got a bug to report? Post it all here.
rwentechaney
Posts: 1
Joined: Fri Sep 05, 2008 3:59 am

connecting a Mac to SQL Server 2008

Post by rwentechaney » Fri Sep 05, 2008 4:29 am

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!

sorin_ristache
Posts: 4144
Joined: Fri Mar 28, 2003 2:12 pm

Re: connecting a Mac to SQL Server 2008

Post by sorin_ristache » Fri Sep 05, 2008 12:40 pm

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

stefan
Posts: 45
Joined: Wed Jan 08, 2003 9:43 am
Contact:

Re: connecting a Mac to SQL Server 2008

Post by stefan » Wed Sep 17, 2008 12:10 pm

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.

Post Reply