Using Database without ODBC
- MatthijsJongboer
- Posts: 200
- Joined: Thursday 11 November, 2010 - 14:12
Re: Using Database without ODBC
Hello Fabio,
Can you attach the file TestDB.db here?
Can you attach the file TestDB.db here?
Re: Using Database without ODBC
When I try to attach my db here returns this msg:
The extension db is not allowed
How can I do?
Thanks
Fabio
The extension db is not allowed
How can I do?
Thanks
Fabio
- MatthijsJongboer
- Posts: 200
- Joined: Thursday 11 November, 2010 - 14:12
Re: Using Database without ODBC
Try again. I've allowed the .db extension.
Re: Using Database without ODBC
Done!
Thanks
Thanks
- Attachments
-
- TestDB.db
- TestDB
- (5 KiB) Downloaded 351 times
- MatthijsJongboer
- Posts: 200
- Joined: Thursday 11 November, 2010 - 14:12
Re: Using Database without ODBC
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
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
Re: Using Database without ODBC
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
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
- MatthijsJongboer
- Posts: 200
- Joined: Thursday 11 November, 2010 - 14:12
Re: Using Database without ODBC
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).
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).
Re: Using Database without ODBC
I installed SQL Server and everything works very easily.
Thanks for your commitment!
Fabio
Thanks for your commitment!
Fabio