How to connect sql server 2000

Creating a macro - Writing a Script - Using the API (OpenOffice Basic, Python, BeanShell, JavaScript)
Post Reply
andnnl
Posts: 2
Joined: Thu Feb 05, 2009 4:06 am

How to connect sql server 2000

Post by andnnl »

How to connect sql server 2000?
OOo 2.3.X on Ms Windows W2k
andnnl
Posts: 2
Joined: Thu Feb 05, 2009 4:06 am

Re: How to connect sql server 2000

Post by andnnl »

How to connect sql server 2000
use jdbc
OOo 2.3.X on Ms Windows W2k
User avatar
r4zoli
Volunteer
Posts: 2882
Joined: Mon Nov 19, 2007 8:23 pm
Location: Budapest, Hungary

Re: How to connect sql server 2000

Post by r4zoli »

I never tried but it is same for all JDBC connections, it will guide you to right direction, not fully correct, I never tried.
Use MSSQL JDBC driver in same way as described in MySQL connection wiki page.
Download MSSQL driver,
add to the classpath, use

Code: Select all

com.microsoft.sqlserver.jdbc
as JDBC driver class.
I found it in MSDN documentation, may be need some change:

Code: Select all

jdbc:sqlserver://localhost:1433;databaseName=YourDatabase
AOO 4.0 and LibO 4 on Win 8
Hungarian forum co-admin
Post Reply