1. Euphoria and ODBC
- Posted by HappyGene Oct 24, 2008
- 1067 views
Hi,
Has anyone attached to multiple db's via ODBC or a stable replacement? I will need to manipulate MS SQL Server and PostGres.
Thanks, Gene
2. Re: Euphoria and ODBC
- Posted by HappyGene Oct 24, 2008
- 1041 views
- Last edited Oct 25, 2008
I read back 10 pages on the forum and didn't see anything definitive. Whatever you've done with layered db access, I'd be glad to know about it.
Thanks, Gene
3. Re: Euphoria and ODBC
- Posted by m_sabal Oct 25, 2008
- 996 views
The nice thing about ODBC is it doesn't care what the underlying database is. I have a service program that runs 24/7 checking and comparing the data from two separate databases; so it has to maintain those two connections simultaneously all the time. Since you have to specify a connection for each query, as long as you keep them both open until your program is finished, it just works.
4. Re: Euphoria and ODBC
- Posted by HappyGene Oct 25, 2008
- 1014 views
...and you're calling an api to reach the driver or using a part of euphoria similar to ado or dao with vb?
5. Re: Euphoria and ODBC
- Posted by mattlewis (admin) Oct 25, 2008
- 991 views
...and you're calling an api to reach the driver or using a part of euphoria similar to ado or dao with vb?
If you're talking about my odbc library, then it's using the operating system ODBC API. FYI, you can, in theory, use ADO or DAO using EuCOM.
Matt
