ODBC trouble, how does servoy list Table fields

Classic Servoy
1

Hi,

I’ve an ODBC problem. I use a proprietary database called Divalto, that uses a proprietary ODBC driver named Harmony.

I suceeded to declare HARMONY as the datasource, and servoy’s dataprovider window shows all the table of Divalto.

BUT, when you click on a table, you can’t see its field.

So all that can be achieve is to get the Divaltyo tables listed, but you can’t do anything with them.

I suspect that servoy, to get the fields use a particular odbc syntax that Harmony doesn’t get.
Howewer excel works ok with that odbc driver.

Is there a way to see an errort log of what servoy tries do to and has problem with ?

Which are the sql instruction servoy uses to get the fields of a table ?

The vendor says its ODBC driver support all “Level 1” ODBC instructions, does servoy use some level 2 ones ?
And says it doesnt support “SQL cursors”

I’m pretty sure that I would be able to do raw queries, and that the ony thing that blocks me is the fact that the servoy GUI want sto display the fileds in the datasource window.

Is there a way to use the odbc tyables without having to declare it tyrhough the gui ?

2

ODBC needs a JDBC driver as well (if I am not mistaken).

As far as I know Servoy uses no special sql to avoid too much issues.

So, under normal circumstances this is a question of the driver.

Are you sure you use the latest drivers.

Maybe this link is helpful: http://java.sun.com/j2se/1.3/docs/guide … e.doc.html

3

Yes, I have the lastest sun jdbc driver, and right know i’m testing all the one of sun’s driver page.

No success so far

4

Vince,

Servoy uses standard jdbc calls to retrieve the tables and their columns.
Does connecting to this database using other java tools work?
You could try squirrel, for instance.

Rob

5

Okay this is an old thread, but I have a similar problem.
On the server I have a ODBC connection with an Access DB named OpenDis.
In Servoy I have a connection with sun.jdbc.odbc.JdbcOdbcDriver to OpenDis
Everything works fine, but it seems I have to make an ODBC-connection on every client.
Me no likey that. I assumed (maybe wrongly) that when I establish a connection on Servoy Server…that the clients would use that connection.

OpenDis is a scanningsoftware by the way…at it uses a Access db to store the pathnames of all scans.

Anyone has suggestion on how to implement this without having to make an ODBC connection on every client?

6

What I am not sure of, from what you write, is the db local or on the server.

If local the setup needs to be local, if on the server I think it is save to say that something goes wrong.

7

Something else, you say it is scanner software.
When the scanner connect direct instead of through Servoy you will certainly need a local driver.

8

IT2Be:
Something else, you say it is scanner software.
When the scanner connect direct instead of through Servoy you will certainly need a local driver.

Somehow the scanner-software doesn’t need a local driver…at least according to the system-manager of our customer.

9

Somehow the scanner-software doesn’t need a local driver…at least according to the system-manager of our customer.

Maybe it is built in.

So, your users scans something into the db on the server and you want to retrieve the data through servoy?

10

IT2Be:
So, your users scans something into the db on the server and you want to retrieve the data through servoy?

Yup…they only want to view the db