Jetzt gratis testen! http://freemail.web.de/home/landingpad/?mc=021130
yes, ADO is an object model that connects through ODBC. Via ADO, autocommit is turned off by default and each SQL statement has to be embedded in following code:
ADOConnObj.BeginTrans
ADOConnObj.Execute sqlstatement
ADOConnObj.CommitTrans
can you tell me what programming platform is best supported by MonetDB in order to avoid these problems and be able to write data quick to the database.
Can you as well tell me how many records per second can be written into and read from MonetDB (if everything is done correctly;))
regards
Von: monetdb-users@lists.sourceforge.net Gesendet: 26.1 0.06 10:41:04 An: monetdb-users@lists.sourceforge.net Betreff: Re: [MonetDB-users] writing to MonetDB via ADO On 26-10-2006 10:37:37 +0200, Branislav Djokovic wrote: > Thanks for the answer. I have tried to switch off autocommit within > ADO but it gives me an error message when i try to commit a command. > Can it be that it does not support it through ADO? I am not aware that we have an ADO driver. Does it work through the ODBC driver? If so, I would expect auto-commit flagging to work. How did you switch auto-commit off? Maybe the ODBC driver doesn't support it (yet). ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net /sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users |
|
| XXL-Speicher, PC-Virenschutz, Spartarife & mehr: Nur im WEB.DE Club! Jetzt gratis testen! http://freemail.web.de/home/landingpad/?mc=021130 |