OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Connect to MS-SQL Server?

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base
View previous topic :: View next topic  
Author Message
Park
General User
General User


Joined: 25 Aug 2005
Posts: 18

PostPosted: Wed Sep 21, 2005 7:59 am    Post subject: Connect to MS-SQL Server? Reply with quote

I've set up MS-SQL Server 2000 on a Win2k Server machine. How can I connect from OOBase running on a Linux machine to a database on that system? The setup for an ODBC connection asks for a source on the local system. I've tried inputting various combination of the server / database name, but haven't had any luck. I've installed the FreeTDS package and am able to connect from a command line using tsql. But I'm not sure how to integrate FreeTDS into OOBase as a driver.
Back to top
View user's profile Send private message
DrewJensen
Super User
Super User


Joined: 06 Jul 2005
Posts: 2616
Location: Cumberland, MD

PostPosted: Wed Sep 21, 2005 8:08 am    Post subject: Reply with quote

Park,

Looking at the TDS site it seems that you might want to pursue using the JTDS driver instead, since the later is a JDBC implementation, and that is what OOBase would like to see.

Have a look at http://jtds.sourceforge.net/

Drew
_________________
Blog - http://baseanswers.spaces.live.com/
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Park
General User
General User


Joined: 25 Aug 2005
Posts: 18

PostPosted: Wed Sep 21, 2005 10:09 am    Post subject: one step closer Reply with quote

Thanks for the tip. I downloaded the JTDS driver and added it using the OO package manager. Following the URL directions at the website I set up the datasource URL and driver; java.sql.Driver. When I click on the Test Class button I get a "JDBC Driver loaded successfully", but then in the next step of the wizard, the Test Connection button gives a "Specified Driver Could Not Be Loaded!" error. So, I guess I need to do some more research.

This leads to another question; Which is the best way to add the driver package; the GUI interface or using unopkg from the command line? I tried both and ended up with two instances of jtds-1.1.jar in the listing. I tried one, then the other, then both, but they all give the same error.
Back to top
View user's profile Send private message
sgriffin
Newbie
Newbie


Joined: 28 Apr 2008
Posts: 1

PostPosted: Tue Apr 29, 2008 10:58 am    Post subject: Connecting to SQL Server using OOo Database Reply with quote

I realize that this is an old thread, but for future generations Very Happy

I am using OOo Database 2.3.0 and SQL Server 2000. This should work for similar set-ups.

Follow these steps to connect to sql server using jdbc jtds.

1. Open OOo Database and create a new database. Go to Tools>Options and select the Java tab. This should tell you the location of your JRE.

2. Obtain the most recent jtds java archive. Mine is jtds-1.2.2.jar. Copy this jar file into your JRE/lib/ext directory. Mine is located at /usr/lib/jvm/java-6-sun-1.6.0.03/jre/lib/ext, but yours may be different.

3. Click the "Class Path" button then on the "Class Path" form click on the "Add Archive" button. Navigate to the location of your jtds<version>.jar file and select it in the file list. Click "Open". Click the "OK" button until all of the open forms are closed.

4. Restart OOo Database.

5. On the Database Wizard, click the radio button entitled "Connect to an existing database", select the JDBC option in the pull down list and click "Next".

In the Datasource URL field type your connection string:

jtds:sqlserver://hostname:portnumber/databasename.

(example: jtds:sqlserver://intranetdb:1433/ourintranet)

In the JDBC driver class field type:

net.sourceforge.jtds.jdbc.Driver

Click "Test class". If you get a message that reads "The JDBC driver was loaded successfully" you are good to go. Click next.

6. Set up your authentication and click Test Connection. You should get "The connection was established successfully". Click "Next".

7. Configure the rest of your options on the final form and click "Finish" Save your database file. You can use this file to open your database connection to Sql Server in the future.

Good luck! Smile
Back to top
View user's profile Send private message
preserver3
Newbie
Newbie


Joined: 08 Oct 2008
Posts: 1

PostPosted: Wed Oct 08, 2008 10:48 am    Post subject: Continuing for future Generations Reply with quote

As an added note, you can drop the microsoft driver in the ./JRE/lib/ext above, add it with the classpath tool in ooBase, and then when you setup a connection, use a standard jdbc string (ex:jdbc:microsoft:sqlserver://servername:portnum;DatabaseName=dbname)
and
com.microsoft.jdbc.sqlserver.SQLServerDriver as the driver to load

And simply use the class 4 driver meant for this purpose. Its great for testing JBoss or Tomcat connection strings since they'd be identical.
Back to top
View user's profile Send private message
ottoshmidt1
Power User
Power User


Joined: 15 May 2009
Posts: 69
Location: Tbilisi, Georgia

PostPosted: Wed Nov 11, 2009 3:21 am    Post subject: Re: Continuing for future Generations Reply with quote

preserver3 wrote:
As an added note, you can drop the microsoft driver in the ./JRE/lib/ext above, add it with the classpath tool in ooBase, and then when you setup a connection, use a standard jdbc string .


Download Microsoft SQL server JDBC Driver from here:
http://msdn.microsoft.com/en-us/data/aa937724.aspx

and use - com.microsoft.sqlserver.jdbc.SQLServerDriver Driver to Load
and above - sqlserver://servername:portnum (without DatabaseName)

But I recommend JTDS as explained above... I had less problems with character sets with it.
_________________
[Solved] mark in title significantly facilitates the work of those who try to help. So please, be gentle and don't forget to insert it. Wink

IRC: /join #openoffice.org on irc.freenode.net
Back to top
View user's profile Send private message Send e-mail Yahoo Messenger MSN Messenger
seforsource
Newbie
Newbie


Joined: 24 Nov 2009
Posts: 3

PostPosted: Thu Dec 03, 2009 6:41 am    Post subject: Re: Continuing for future Generations Reply with quote

I tried first:
URL
jdbc(default):jtds:sqlserver://localhost:1433/myBase
Class JDBC
net.sourceforge.jtds.jdbc.Driver
it works!
I tried two:
URL
jdbc(default):sqlserver://localhost:1433;databaseName=myBase
Class JDBC
com.microsoft.sqlserver.jdbc.SQLServerDriver
it works!

But I can not edit the data! Not any! What do I do?Confused
p.s.: my English is poor!
Back to top
View user's profile Send private message
ottoshmidt1
Power User
Power User


Joined: 15 May 2009
Posts: 69
Location: Tbilisi, Georgia

PostPosted: Mon Dec 07, 2009 9:31 am    Post subject: Re: Continuing for future Generations Reply with quote

seforsource wrote:
I tried first:
URL
jdbc(default):jtds:sqlserver://localhost:1433/myBase
Class JDBC
net.sourceforge.jtds.jdbc.Driver
it works!
I tried two:
URL
jdbc(default):sqlserver://localhost:1433;databaseName=myBase
Class JDBC
com.microsoft.sqlserver.jdbc.SQLServerDriver
it works!

But I can not edit the data! Not any! What do I do?Confused
p.s.: my English is poor!


do you have insert privileges there?
_________________
[Solved] mark in title significantly facilitates the work of those who try to help. So please, be gentle and don't forget to insert it. Wink

IRC: /join #openoffice.org on irc.freenode.net
Back to top
View user's profile Send private message Send e-mail Yahoo Messenger MSN Messenger
seforsource
Newbie
Newbie


Joined: 24 Nov 2009
Posts: 3

PostPosted: Fri Dec 11, 2009 4:29 am    Post subject: Reply with quote

ottoshmidt1, i'm connect to base MSSQL Express under user sa!
I think that I incorrectly configured driver!
But I have not changed, I just installed it and everything!
Back to top
View user's profile Send private message
brianke
Newbie
Newbie


Joined: 14 Jun 2010
Posts: 1

PostPosted: Mon Jun 14, 2010 6:34 am    Post subject: Reply with quote

SOLVED: I failed to remove the out sqljdbc.jar from lib/ext.

I came across this thread and am trying to connect using the Microsoft driver (com.microsoft.sqlserver.jdbc.SQLServerDriver). I get a success message when I test the class but when I test the connection I get the following pop-up error message:

Java Runtime Environment (JRE) version 1.6 is not supported by this driver. use the sqljdbc4.jar class library, which provides support for JDBC 4.0.

The error message is pretty direct and I added the sqljdbc4.jar to my Java class path in OpenOffice and restarted. However, when I try to test the connection I get the same error message.

Is there an updated jar that I am not finding or something I am missing? I am running JRE v. 1.6.0_20

Thank you,
Brian Enderle
Back to top
View user's profile Send private message
JayBofMA
Newbie
Newbie


Joined: 30 Sep 2011
Posts: 1

PostPosted: Fri Sep 30, 2011 12:07 pm    Post subject: Performance not acceptable, try SQL Developer Reply with quote

I have tried this JTDS integration with LibreOffice 3.x Database and I am not impressed. The performance is terrible. Too much overhead of LiberOffice I suspect, despite 64bit on 8cores with 8GB.

The same JTDS can be used as a third-party driver in the free Oracle SQL Developer. The driver will add a SQL Server tab to connection property dialogs. JTDS performance is quite good in SQL Developer. Although you will loose some of the IDE features of the native Oracle drivers. (e.g. no code completion so database names and fields are not suggested while typing)
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group