You are not logged in.

Dear visitor, welcome to Jabaco - Community. If this is your first visit here, please read the Help. It explains in detail how this page works. To use all features of this page, you should consider registering. Please use the registration form, to register here or read more information about the registration process. If you are already registered, please login here.

ngking

Beginner

  • "ngking" is male
  • "ngking" started this thread

Posts: 1

Date of registration: Jul 3rd 2009

  • Send private message

1

Saturday, July 4th 2009, 12:13am

How to convert ADO Database objects to Jabaco

I am new to Jabaco, I write programs in VB using ADO database objects. What is the best way to convert them to a format that Jabaco can use?

I got a feeling that this will be a popular topic to discuss as many business applications use the ADO database objects. I searched for "ADO" but found no hits on the Community Forum or Wiki. So I guess this would be the first post on it.

I assume that I'll have to use some Java database connector instead, am I right? If so, which one, and how to do it with an MS-Access or MS-SQL Server database. I want my application to be scalable and be able to use databases like MySQL, PostgreSQL, Firebird, Oracle, etc as well later.

StefanSchnell

Trainee

  • "StefanSchnell" is male

Posts: 102

Date of registration: Mar 13th 2009

Location: Oberirsen - Germany

Occupation: Senior Software Engineer

Hobbies: Programming aund Photography

  • Send private message

2

Saturday, July 4th 2009, 8:43am

Hello ngking,
welcome at Jabaco.

I am not so familiar with ADO, but so far I know is ADO a COM object. In the COM list I found the modules msado15.dll (ADODB), msadomd.dll (ADOMD) and msadox.dll (ADOX). My suggestion: One way to realize a solution to use ADO with Jabaco is to use the Java-COM-Bridge (JaCoB). Here is a example for Word® and all links you need.

With JDBC you are right. For MS-SQL-Server you find a JDBC driver here and here is an older list with a lot of JDBC drivers. I do not know a JDBC driver for Access®, I use JDBC-ODBC-Bridge, you find an example here.

Hope it helps.

Cheers
Stefan
Visit my personal or commercial site
If you have questions or suggestions, write me an eMail or meet me here

Similar threads

Rate this thread
WoltLab Burning Board