[ubuntu] ODBC

[Mario Splivalo]

On Thu, 2005-12-15 at 13:01 -0500, 'Forum Post wrote:
> Anyone had any luck using the M$ SQL Server JDBC drivers on a Ubuntu
> Linux box to connect OOo to MSSQL? I have downloaded the drivers from
> the M$ site and tried to point Base to them with no luck - something
> causes OOo to Blue Screen and just die with an error message.
> 
> Had no problems using the M$ JDBC stuff to connect OOo on a Windows box
> to M$ SQL Server.
> 
> What gives? :confused:
> 
> Using Breezy as the client
> Standard OOo 2.0
> M$ JDBC SP 3
> M$ SQL Server 2000
> 
> 
> -- 
> Ubuntu Warrior
> 

I use DbVisualiser, and for connecting to MSSQL i use MSSQLjdbc drivers.
Or something like that. I actually have no idea where I got them, I
think DBVisualiser home page pointed me out for them. The ones I got are
open/free. Here are the md5sums of the files:

[buntor] [~/DbVisualizer-4.3.4/lib] > md5sum ms*
a454d9ff82723a3656004666a281e841  msbase.jar
93bd2063760377a1a96336658d7abedc  mssqlserver.jar
106e08ffba37c92288c02eca54553cca  msutil.jar
[buntor] [~/DbVisualizer-4.3.4/lib] >

I could send you those if you're unable to find them. DbVisualiser works
excellent with those. Haven't tried OO, because my MSSQL machine is at
work.

You may run into jtds drives, but those didn't seem to work for me.

	Mike