mORMot Open Source

ab

Administrator

From: France

Registered: 2010-06-21

Posts: 14,725

Website

SynDBODBC alive and working

That's it: ODBC is now officially supported within mORMot.

See http://synopse.info/forum/viewtopic.php?pid=4821#p4821

mpv

Member

From: Ukraine

Registered: 2012-03-24

Posts: 1,574

Website

Re: SynDBODBC alive and working

First of all - this is great news!

I test new ODBC unit with my MS SQL server 2008.
0) It's not clear for me to use DSN name in aServerName parameter - I think will be good to mark this moment in documentation (and text label in dbExplorer sample login window )
1) In my Windows7 64bit all I got exception "The specified DSN contains an architecture mismatch between the Driver and Application". Workaround is <a href="http://msdn.microsoft.com/en-us/library/windows/desktop/ms712362%28v=vs.85%29.aspx">here</a> (use odbcad32.exe to configure DSN). BUT - work only for user DSN (for system DSN the same problem - architecture mismatch).
2) Performance (tested on 12 threadSafe connection/50000 remote call via HTTP)

Small query result -  each query return 10 record:
OleDB: test duration  -        26 sec. 1860 query/sec
ODBC using SQLSRV32.dll:  30 sec. 1620 query/sec
ODBC using SQLNCLI.dll:     30 sec. 1620 query/sec
ODBC using SQLNCLI10.dll: 28 sec. 1760 query/sec

Big query result - each query return 2000 record (1000 execution):
OleDB: test duration  -         19.5 sec. 51 query/sec
ODBC using SQLSRV32.dll:   19.5 sec. 51 query/sec
ODBC using SQLNCLI10.dll:  20 sec. 50 query/sec

As we can see OleDB performance is better for small query ....

Hmmm.... Seems ODBC code is very raw. Many-many bugs. I test it carefully and write tickets.

Last edited by mpv (2012-08-13 07:18:02)