Servoy Forum

by **Odysseus** » Mon Oct 06, 2003 5:02 pm

What file do i download from where to get openbase supported and I assume I installed it then in servoy/drivers/.

I downloaded OpnbaseJDBC.jar and placed it in drivers/ but Openbase doesn't show as a choice in the DB Servers :cry:

by **Jan Aleman** » Tue Oct 07, 2003 11:32 am

I assume what you are saying is that you don't see it in the Auto Setup Server list.

To use Openbase with Servoy follow the steps below:

1. Place OpenBase.jar in your drivers folder, make sure Servoy is closed
2. launch servoy and go to Application preferences, DB server tab
3. Click New
4. in the Driver pulldown choose: com.openbase.jdbc.ObDriver
5. fill in a servername of choice (this is the named connection within servoy, how you name it doesnt really matter)
6. fill in the username and password of the connection
7. in the URL field fill in the following:
jdbc:openbase://localhost:20223/dbname
replace localhost (if necessary) with ip or hostname of database server
replace dbname with the name of the database you want to connect to

When you press OK the connection will be tested.

We will add OpenBase to the Auto Setup Server pulldown as soon as possible

by **Bert** » Tue Oct 07, 2003 1:00 pm

Odysseus wrote:What file do i download from where to get openbase supported and I assume I installed it then in servoy/drivers/.

I downloaded OpnbaseJDBC.jar and placed it in drivers/ but Openbase doesn't show as a choice in the DB Servers

For what matter do you prefer OpenBase over FireBird (wich is already pre-installed)?

by **Odysseus** » Tue Oct 07, 2003 8:07 pm

I have a CRM soft based on OpenBase, that is not supported on Win. Since the openbase structure is totally open I want to try to make a Windows client. (while waiting for iAnywhere to be included as default database).

by **raymanj** » Mon Jan 19, 2004 10:10 am

Where do I download the OpenBase.jar or OpenBaseJDBC.jar file to install in the Servoy/drivers folder?

I would like to test out Servoy with OpenBase.

by **Jan Aleman** » Mon Jan 19, 2004 11:02 am

Click on downloads on the Openbase website. It's listed directly on the first page as: OpenBase JDBC2.0 Driver Client

by **raymanj** » Mon Jan 19, 2004 9:43 pm

Thank you

by **raymanj** » Sun Feb 13, 2005 9:46 pm

I am trying to test Servoy on an OpenBase backend. I am having trouble getting Servoy to connect to any database hosted by OpenBase.

I have downloaded their JDBC driver (OpenBaseJDBC.jar v3.0) from their website. In installed it in the drivers folder of Servoy. Launched up Servoy went to the DB Server area to add a database. When I clicked OK I always get the same error:

java.sql.SQLException: Can not connect to the openexec at 'localhost:20223'

Does anyone know what I am doing wrong?

OpenBase 8.0.4

Servoy Developer
Version R2 2.1.2-build 315
Java version 1.4.2-38 (Mac OS X)

by **raymanj** » Fri Feb 25, 2005 2:48 am

raymanj wrote:I am trying to test Servoy on an OpenBase backend. I am having trouble getting Servoy to connect to any database hosted by OpenBase.

I have downloaded their JDBC driver (OpenBaseJDBC.jar v3.0) from their website. In installed it in the drivers folder of Servoy. Launched up Servoy went to the DB Server area to add a database. When I clicked OK I always get the same error:

java.sql.SQLException: Can not connect to the openexec at 'localhost:20223'

Does anyone know what I am doing wrong?

OpenBase 8.0.4

Servoy Developer
Version R2 2.1.2-build 315
Java version 1.4.2-38 (Mac OS X)

I am still having trouble connecting to an OpenBase backend and Servoy. Could anyone give me some advice regarding this.

by **IT2Be** » Fri Feb 25, 2005 9:18 am

Is openbase running?
Is it running on your local/servoy server/developer machine?
Is the port the correct one?

by **raymanj** » Sat Feb 26, 2005 7:51 am

IT2BE wrote:Is openbase running?
Is it running on your local/servoy server/developer machine?
Is the port the correct one?

I am running the demo version of OpenBase on my Servoy developer machine.

I ran a port scan for lovcalhost and port 20223 was open

Openbase is running and I have a few databases running by it.

I always get the same error when trying to add a database connection in DBServers section. "No able to connect"

by **Jan Aleman** » Sat Feb 26, 2005 2:18 pm

do you have security setting set correctly? can you connect with other sql tools that use JDBC like aqua data studio?

by **raymanj** » Sat Feb 26, 2005 7:58 pm

jaleman wrote:do you have security setting set correctly? can you connect with other sql tools that use JDBC like aqua data studio?

Well it looks like I am having more trouble than I thought. I finally got Servoy to except a new database connection in the DBServer list, but one problem. The icon of the database listed in the DBServer list is lighter than the rest. Also when I go to create a new form the server connection is not listed in any of the Using Server lists.

I tried Aqua Data Studio and I am able to connect but I always get an error. "Connection Failed. Your login and password are not valid."

I checked users and logins. They were set to admin and no password. I even shabged them, to avail.

I ran another program that uses OpenBase for its database (DayLite) and it worked fine at accessing OpenBase.

My settings I used were:
URL: jdbc:openbase://localhost/Company
Driver: com.openbase.jdbc.ObDriver
Location: /Library/Java/Extensions/OpenBaseJDBC.jar

by **Jan Aleman** » Sun Feb 27, 2005 1:39 pm

Do you also get this behaviour after restarting Servoy?

by **raymanj** » Sun Feb 27, 2005 11:02 pm

jaleman wrote:Do you also get this behaviour after restarting Servoy?

Yes, even after a restart of Servoy.

Servoy Forum

Openbase driver

Openbase driver

Re: Openbase driver

Where get the drivers for OpenBase?

Who is online