Using Database without ODBC

All topics on the Atoms in any Enterprise Dynamics Library.
User avatar
MatthijsJongboer
Posts: 200
Joined: Thursday 11 November, 2010 - 14:12

Re: Using Database without ODBC

Post by MatthijsJongboer »

Hello Fabio,
Can you attach the file TestDB.db here?
LAC-Bursi
Posts: 41
Joined: Friday 09 November, 2012 - 10:37

Re: Using Database without ODBC

Post by LAC-Bursi »

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

How can I do?

Thanks
Fabio
User avatar
MatthijsJongboer
Posts: 200
Joined: Thursday 11 November, 2010 - 14:12

Re: Using Database without ODBC

Post by MatthijsJongboer »

Try again. I've allowed the .db extension.
LAC-Bursi
Posts: 41
Joined: Friday 09 November, 2012 - 10:37

Re: Using Database without ODBC

Post by LAC-Bursi »

Done!

Thanks
Attachments
TestDB.db
TestDB
(5 KiB) Downloaded 340 times
User avatar
MatthijsJongboer
Posts: 200
Joined: Thursday 11 November, 2010 - 14:12

Re: Using Database without ODBC

Post by MatthijsJongboer »

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
LAC-Bursi
Posts: 41
Joined: Friday 09 November, 2012 - 10:37

Re: Using Database without ODBC

Post by LAC-Bursi »

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
User avatar
MatthijsJongboer
Posts: 200
Joined: Thursday 11 November, 2010 - 14:12

Re: Using Database without ODBC

Post by MatthijsJongboer »

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).
LAC-Bursi
Posts: 41
Joined: Friday 09 November, 2012 - 10:37

Re: Using Database without ODBC

Post by LAC-Bursi »

I installed SQL Server and everything works very easily.

Thanks for your commitment!
Fabio
Post Reply