Connection with Act! Database

Classic Servoy
1

Hi,

Is it possible to connect Servoy with Act database?

Thanks in advance.

Regards,
Sunil

2

What kind of connections does Act allow to their database?

3

Hi,
From what I found out, ACT!Database supports OLEDB connection.

Any Idea how to connect OLEDB Provider?

Thanks.

Regards,
Sunil

4

Servoy by default connects to databases using JDBC.

A quick google gave me the following JDBC driver that allow to connect to OLEDB: http://www.jadozoom.com/en_jadoZoom.shtml

Haven’t tested it, but you could give that a try.

Would be nicer if ACT allowed direct DBc access though.

Paul

5

I have connected directly to Act! using Servoy, please contact me offline if you want more info. I know it may not be practical, but I would recommend to get all your data out of Act! and in to something else.

You don’t have to look too far to find out what Act is really like:

http://www.smarter.com/internet-utilities-communication-software/sage-act-2008/reviews/pr--ch-7--pi-931987.html

Just one of the first sites I found Googling Act! review. Get out of it while you can.
We have had massive problems with this product, contact me privately if you want more info.