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

Connection String to ".odb" base Database in VB

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


Joined: 04 Nov 2005
Posts: 2

PostPosted: Fri Nov 04, 2005 12:51 am    Post subject: Connection String to ".odb" base Database in VB Reply with quote

Hello everybody,
with Visual Basic .NET, I'm trying to connect to an ".odb" database, created with "OpenOffice Base", using a connectio string like this:

strStringConn = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source = C:\Test.odb;"

that is axactly the string that I use to connect to an Access database... but It doesen't work with OpenOffice Base!!

Is It possible to connect to a ".odb" database in the same manner as an Access DB? Can some one help me?

Tanks. Igor
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: Fri Nov 04, 2005 7:27 pm    Post subject: Reply with quote

At this time there is no ODBC or JDBC driver available for a Native Base database. I have to believe this will change before long.
Back to top
View user's profile Send private message Send e-mail Visit poster's website
igorbaldacci
Newbie
Newbie


Joined: 04 Nov 2005
Posts: 2

PostPosted: Sat Nov 05, 2005 12:09 am    Post subject: Reply with quote

I believe it too... Sad

Thnak you very much.. now I know that i must use an Access database for my applications... Confused
Back to top
View user's profile Send private message
pitonyak
Administrator
Administrator


Joined: 09 Mar 2004
Posts: 3655
Location: Columbus, Ohio, USA

PostPosted: Tue Nov 08, 2005 7:11 am    Post subject: Reply with quote

Either that, you acess OOo directly (not as nice I know).
_________________
--
Andrew Pitonyak
http://www.pitonyak.org/oo.php
Back to top
View user's profile Send private message Send e-mail Visit poster's website AIM Address
prophet665
General User
General User


Joined: 15 Nov 2005
Posts: 5

PostPosted: Tue Nov 15, 2005 12:16 pm    Post subject: Reply with quote

Holy cow! I just downloaded the new version of OpenOffice specifically to get the new Base application and it didn't ship with an ODBC driver!

This is going to SEVERLY limit the number of people willing to give OpenOffice a try.

Any idea when the driver will be available? I am trying to code a VB 5 application (yes, I know this is ancient, but the project is simple and VB 5 is what I have available without paying for anything else) and I just spent the last 1.5 hours looking for a code example. No wonder I couldn't find anything.

Mad

Christian
Back to top
View user's profile Send private message
Codejoy
Newbie
Newbie


Joined: 19 Nov 2005
Posts: 4

PostPosted: Mon Nov 21, 2005 1:23 pm    Post subject: Reply with quote

hmm now odbc driver, good to know. What about a jdbc driver though? I cannot seem to connect to the odb i built using java even Sad any help here?
Back to top
View user's profile Send private message AIM Address Yahoo Messenger MSN Messenger
pitonyak
Administrator
Administrator


Joined: 09 Mar 2004
Posts: 3655
Location: Columbus, Ohio, USA

PostPosted: Tue Nov 22, 2005 8:11 pm    Post subject: Reply with quote

I have lots of code examples, but they all assume that you will access a local DB from withiin Ooo, not externally.
_________________
--
Andrew Pitonyak
http://www.pitonyak.org/oo.php
Back to top
View user's profile Send private message Send e-mail Visit poster's website AIM Address
Codejoy
Newbie
Newbie


Joined: 19 Nov 2005
Posts: 4

PostPosted: Tue Nov 22, 2005 8:15 pm    Post subject: Reply with quote

when u say a local db from within ooo? thats not from say a java client accessing a odb file is it? thats what i need...dang.
Back to top
View user's profile Send private message AIM Address Yahoo Messenger MSN Messenger
Torolf
General User
General User


Joined: 11 Nov 2005
Posts: 41

PostPosted: Tue Nov 22, 2005 9:55 pm    Post subject: Reply with quote

I don't have examples per say, but if you access an ODB from Java or VB for that matter you will still have access to all of the objects (or interfaces) you have in OOBasic. You can issue statements, prepared statements, get result selts, record sets and the like.

At least that is the way I understand it. In fact the first examples I followed where from the Developers guide, written in java that I then converted to OObasic.

Torolf
Back to top
View user's profile Send private message
Codejoy
Newbie
Newbie


Joined: 19 Nov 2005
Posts: 4

PostPosted: Tue Nov 22, 2005 10:21 pm    Post subject: Reply with quote

Where is this developers guide? This might help...
Back to top
View user's profile Send private message AIM Address Yahoo Messenger MSN Messenger
Torolf
General User
General User


Joined: 11 Nov 2005
Posts: 41

PostPosted: Thu Nov 24, 2005 8:23 pm    Post subject: Reply with quote

You can get the developers guide from the OpenOffice web site. It is part of the SDK, and there is also an on-line version of it.
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