InControl Community

Hello Fabio,
Can you attach the file TestDB.db here?

When I try to attach my db here returns this msg:
The extension db is not allowed

How can I do?

Thanks
Fabio

Try again. I've allowed the .db extension.

Done!

Thanks

Hello Fabio,

Bad news. We were not able to get any results from the database into ED.
We activated the OLE DB Provider and did many tests without success.
Since the connection test is not testing anything, it's impossible to say where the problem is (and thus what the solution is).
Also, the extension of the database file seems to be irrelevant.
So, we're back to square one.

It's also hard to find any other Ole DB Provider. Are you bound to use this database format?
And what about the ADO vs. ODBC reasons?

Regards, Matthijs

My main goal is to get the fastest communication way with an huge database.

Now I have to work with free softwares, in the future I can buy software if it's more performant.

All feasible solutions are well accepted!

Let me know

Thanks
Fabio

For databases, I would say Access is the default selection in case of databases. When you data grows, I would start looking at MSSQL.
But it highly depends on how and where you want to use the data.
An alternative could be MySQL but for large databases, a paid option is always the best (even with free versions).

I installed SQL Server and everything works very easily.

Thanks for your commitment!
Fabio