Re: [opendbx] Mailing list configuration
On Mon, Aug 3, 2009 at 6:46 PM, Norbert Sendetzky norb...@linuxnetworks.dewrote: On Mon August 3 2009 21:27:03 OpenDBX devel list wrote: Norbert: I don't know about sourceforge mailing list but I wonder if it is possible to configure it so that everybody can see the email and name of the person who sent an email. Right now I cannot see who is. I only see libopendbx-de...@lists.sourceforge.net. Sometimes this is useful for me when people of SqueakDBX ask in OpenDBX mailing list because I know his background. I've changed the setting back so the email of the sender should appear and also set the list to add a Reply-To: header. This should avoid the problem that pushing the reply button in the email client leads to replying only to the sender. Thanks Norbert for the quick answer and action! Norbert -- OpenPGP public key http://www.linuxnetworks.de/norbert.pubkey.asc -- Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july ___ libopendbx-devel mailing list libopendbx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX -- Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july___ libopendbx-devel mailing list libopendbx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX
Re: [opendbx] OpenDBX 1.4.2 release
On Sat, Aug 8, 2009 at 6:39 PM, Norbert Sendetzky norb...@linuxnetworks.dewrote: Hi Mariano Excellent news Norbert!!! I will try to make MySQL work with SqueakDBX As I expected I have to put #ifdef __CYGWIN__ to the original version of mysql.h in order to compile it. You shouldn't be forced to modify the mysql.h file any more with 1.4.2. In your case I think you've already modified it for 1.4.1 and if you reinstall the MySQL files, it should work now out of the box. That's exactly was happened and it was what I was trying to said in my previous email haha. Mariano Norbert -- OpenPGP public key http://www.linuxnetworks.de/norbert.pubkey.asc -- Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july ___ libopendbx-devel mailing list libopendbx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX -- Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july___ libopendbx-devel mailing list libopendbx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX
Re: [opendbx] Problem with Sqlite3 in 1.4.3
On Sat, Sep 19, 2009 at 10:33 AM, Norbert Sendetzky norb...@linuxnetworks.de wrote: Hi Mariano Norbert: I was trying to run all my tests in 1.4.3 for all backends and I found a problem with sqlite3. With 1.4.2 AND with the latest svn on trunk, it works perfect (it is weird that it works perfect in trunk). But, with 1.4.3 I have a segmentation fault when calling odbx_unbind(). I cannot enable log because the log was after this version I think. Do you have any idea of what can be ? There was an uninitialized variable which led to a segfault when you call odbx_unbind() directly after odbx_bind(). This is fixed in SVN rev 286. Thanks Norbert for your help. I did a svn co but I have the same problem. Are you sure you commit the changes? The weird thing is that this only happens with my (SqueakDBX) tests and openDBX tests work ok. Cheers, Mariano Norbert -- OpenPGP public key http://www.linuxnetworks.de/norbert.pubkey.asc -- Come build with us! The BlackBerryreg; Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9#45;12, 2009. Register now#33; http://p.sf.net/sfu/devconf ___ libopendbx-devel mailing list libopendbx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX -- Come build with us! The BlackBerryreg; Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9#45;12, 2009. Register now#33; http://p.sf.net/sfu/devconf___ libopendbx-devel mailing list libopendbx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX
Re: [opendbx] Trying to find MySQL random segmentation fault
Thanks Norbert: This is really excellent news. One of the most important ever :) I tried and works perfect. No segmentation fault. However, I found another problem. If I run ALL my tests several times, after running them like 5 o 6 times, I get the error Out of Memory when calling odbx_init(). In addition to this, in my Linux console I see the error: Can't initialize threads: error 11 Do you know what it is ? Can this be related to this last change? Best, Mariano On Sat, Sep 19, 2009 at 8:44 AM, Norbert Sendetzky norb...@linuxnetworks.de wrote: Hi Mariano Thanks!!! I did it. I attach the 6 connetions generated during my tests. The one with the problem was the opendbx-0x93d8390.dbg. However, that line of log seems the same as the rest. I've found the problem in mysql_odbx_finish(): If you removed the mysql_thread_end() and mysql_server_end() in mysql_odbx_finish() the segfault is gone. The problem is fixed in SVN rev 282. Thanks for your help Norbert -- OpenPGP public key http://www.linuxnetworks.de/norbert.pubkey.asc -- Come build with us! The BlackBerryreg; Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9#45;12, 2009. Register now#33; http://p.sf.net/sfu/devconf ___ libopendbx-devel mailing list libopendbx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX -- Come build with us! The BlackBerryreg; Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9#45;12, 2009. Register now#33; http://p.sf.net/sfu/devconf___ libopendbx-devel mailing list libopendbx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX
Re: [opendbx] Trying to find MySQL random segmentation fault
On Sun, Sep 20, 2009 at 9:53 AM, Norbert Sendetzky norb...@linuxnetworks.de wrote: Hi Mariano I has just test it but I had the same problem :( I tested latest from trunk. Please use branches/stable-1.4 instead of trunk because I don't committed this to trunk yet as I'm currently implementing something else on trunk. Excellent. I download, tested and worked perfect. Thank you so much. Norbert -- OpenPGP public key http://www.linuxnetworks.de/norbert.pubkey.asc -- Come build with us! The BlackBerryreg; Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9#45;12, 2009. Register now#33; http://p.sf.net/sfu/devconf ___ libopendbx-devel mailing list libopendbx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX -- Come build with us! The BlackBerryreg; Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9#45;12, 2009. Register now#33; http://p.sf.net/sfu/devconf___ libopendbx-devel mailing list libopendbx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX
[opendbx] New SqueakDBX release with 1.4.4 ?
Norbert: I need to do a new SqueakDBX release but I would love to have MySQL running on Windows and the fix with Sqlite3. Of course, not downloading things from SVN but from an OpenDBX release. Do you plan to do a 1.4.4 or whatever with this bug fixes ? Or you are agoing to wait for more bug reports ? Thanks, Mariano -- Come build with us! The BlackBerryreg; Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9#45;12, 2009. Register now#33; http://p.sf.net/sfu/devconf___ libopendbx-devel mailing list libopendbx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX
[opendbx] Question about OpenDBX tests [WAS]Re: [SqueakDBX] Connection not Valid problem
Norbert: I forward an email from someone trying to use SqueakDBX. He tried to run the openDBX tests in Linux and Mac and in both cases he had a problem. As you can see in his email, it says: WARNING: nonstandard use of \\ in a string literal LINE 1: SELECT * FROM odbxtest WHERE col = 'a\\''b' ^ HINT: Use the escape string syntax for backslashes, e.g., E'\\'. ideas? best, Mariano On Thu, Sep 24, 2009 at 3:06 PM, John Toohey j...@parspro.com wrote: - I've managed to build it on a VMWare VM running Ubunto, and using the --disable-utils switch, I've built it on OSX also. However on both systems when I run the test suite I see this :- `-- ./odbxtest -b pgsql -h localhost -p 5432 -d juliet -u postgres -w postgres ODBX_CAP_BASIC: 1 ODBX_CAP_LO: 0 ODBX_OPT_API_VERSION: 10200 ODBX_OPT_THREAD_SAFE: 1 ODBX_OPT_TLS: 1 ODBX_OPT_CONNECT_TIMEOUT: 1 (using) ODBX_OPT_MULTI_STATEMENTS: 1 (using) ODBX_OPT_PAGED_RESULTS: 0 ODBX_OPT_COMPRESS: 0 ODBX_CAP_BASIC: 1 ODBX_CAP_LO: 0 ODBX_OPT_API_VERSION: 10200 ODBX_OPT_THREAD_SAFE: 1 ODBX_OPT_TLS: 1 ODBX_OPT_CONNECT_TIMEOUT: 1 (using) ODBX_OPT_MULTI_STATEMENTS: 1 (using) ODBX_OPT_PAGED_RESULTS: 0 ODBX_OPT_COMPRESS: 0 WARNING: nonstandard use of \\ in a string literal LINE 1: SELECT * FROM odbxtest WHERE col = 'a\\''b' ^ HINT: Use the escape string syntax for backslashes, e.g., E'\\'. Error in odbx_result(): ERROR: relation odbxtest does not exist Error in odbx_result(): ERROR: relation odbxtest does not exist Not sure if this means there is a problem with the build (I downloaded to latest one) or a problem with the test suite. In order to continue and install GlorpDBX into my Pharo image, do I need to build a new image, as my current one already has Pharo-Glorp installed. I've never figured out how to uninstall packages in Smalltalk. On Thu, Sep 24, 2009 at 11:15, Mariano Martinez Peck marianop...@gmail.com wrote: On Thu, Sep 24, 2009 at 1:59 PM, John Toohey j...@parspro.com wrote: I'm currently trying to build openDBX on OSX. I've finally found the postgres client libs and include files, and I've run ./configure -with-backends=pgsql, but when I run make I get this error :- Excellent you are giving SqueakDBX at least a try. The real thing is this: The squeakDBX team is composed by 4 people. Only one has a Mac and he is very busy with his work. I have ALL databases working on Linux and Windows. And I have also prepared binaries for that because I can (dlls, .deb and .rpm). But I cannot do it with Mac because I don't have a mac and I don't know how binaries work on Mac. If you make it work, I would really love you help me generating the binaries so that I can update them to OpenDBX website. Which OpenDBX version are you trying to compile? You should try 1.4.3. Can you try configuring this way please ? ./configure --disable-utils --with-backends=pgsql If it works, I then explain you why that :) Making all in po g++ -DHAVE_CONFIG_H -I. -I.. -I../lib -DLOCALEDIR=\/usr/local/share/locale\ -DKEYWORDFILE=\/usr/local/share/opendbx/keywords\ -I/opt/local/include/postgresql83 -g -O2 -MT odbx_sql-argmap.o -MD -MP -MF .deps/odbx_sql-argmap.Tpo -c -o odbx_sql-argmap.o `test -f 'argmap.cpp' || echo './'`argmap.cpp mv -f .deps/odbx_sql-argmap.Tpo .deps/odbx_sql-argmap.Po g++ -DHAVE_CONFIG_H -I. -I.. -I../lib -DLOCALEDIR=\/usr/local/share/locale\ -DKEYWORDFILE=\/usr/local/share/opendbx/keywords\ -I/opt/local/include/postgresql83 -g -O2 -MT odbx_sql-commands.o -MD -MP -MF .deps/odbx_sql-commands.Tpo -c -o odbx_sql-commands.o `test -f 'commands.cpp' || echo './'`commands.cpp mv -f .deps/odbx_sql-commands.Tpo .deps/odbx_sql-commands.Po g++ -DHAVE_CONFIG_H -I. -I.. -I../lib -DLOCALEDIR=\/usr/local/share/locale\ -DKEYWORDFILE=\/usr/local/share/opendbx/keywords\ -I/opt/local/include/postgresql83 -g -O2 -MT odbx_sql-completion.o -MD -MP -MF .deps/odbx_sql-completion.Tpo -c -o odbx_sql-completion.o `test -f 'completion.cpp' || echo './'`completion.cpp mv -f .deps/odbx_sql-completion.Tpo .deps/odbx_sql-completion.Po g++ -DHAVE_CONFIG_H -I. -I.. -I../lib -DLOCALEDIR=\/usr/local/share/locale\ -DKEYWORDFILE=\/usr/local/share/opendbx/keywords\ -I/opt/local/include/postgresql83 -g -O2 -MT odbx_sql-odbx-sql.o -MD -MP -MF .deps/odbx_sql-odbx-sql.Tpo -c -o odbx_sql-odbx-sql.o `test -f 'odbx-sql.cpp' || echo './'`odbx-sql.cpp odbx-sql.cpp: In function 'int main(int, char**)': odbx-sql.cpp:228: error: invalid conversion from 'char* (*)(const char*, int)' to 'int (*)(const char*, int)' make[3]: *** [odbx_sql-odbx-sql.o] Error 1 make[2]: *** [all-recursive] Error 1 make[1]: *** [all-recursive] Error 1 make: *** [all] Error 2 Do you know of any pre-built binaries that will work on OSX? I don't know, but I would love to have them
Re: [opendbx] Question about OpenDBX tests [WAS]Re: [SqueakDBX] Connection not Valid problem
On Tue, Sep 29, 2009 at 3:37 PM, Norbert Sendetzky norb...@linuxnetworks.de wrote: Hi Mariano Excellent!!! Thanks Norbert for the quick answer. Can I add it here: http://www.linuxnetworks.de/doc/index.php/OpenDBX/Setup/Common_problems? Sure :-) Excellent. Done: http://www.linuxnetworks.de/doc/index.php/OpenDBX/Setup/Common_problems Norbert -- OpenPGP public key http://www.linuxnetworks.de/norbert.pubkey.asc -- Come build with us! The BlackBerryreg; Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9#45;12, 2009. Register now#33; http://p.sf.net/sfu/devconf ___ libopendbx-devel mailing list libopendbx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX -- Come build with us! The BlackBerryreg; Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9#45;12, 2009. Register now#33; http://p.sf.net/sfu/devconf___ libopendbx-devel mailing list libopendbx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX
Re: [opendbx] Wiki permissons
On Tue, Sep 29, 2009 at 3:56 PM, Norbert Sendetzky norb...@linuxnetworks.de wrote: Hi Mariano Actually I want to create a new section under 2. Setup OpenDBX for Mac, because there are some problems sometimes. For example, compiling odbx-sql (the same problem as windows). So I want to add a note saying to use the --disable-utils. I don't see the edit option in that page. Can you do it for me and then I put there my notes? Done. Thanks!!! In addition, I think than enable utils is something extra to OpenDBX. In my opinion would be better to have the minimal core of OpenDBX by default. And then, if you want to enable something, you explicitly do it. So, I would disable utils by default for OpenDBX. And we have problems in mac and windows with that and it is not even documented in OpenDBX webpage. I'm unsure about this. You have some valid points but documentation about the utilties problem is available all over - only for MacOS X there's no separate page as it is subsumed under Unix-like systems up to now. Yes, that's true. However, that's not my point. When I said it was not documented I was talking about odbx-sql, not the problem of utilities ;) My point is: IMHO it would be fantastic that OpenDBX compiles just the core (The kernel. The minimal you need to run OpenDBX) by default, despite the fact there are problems with utilities in certain OS. And then, for those who need utilities, you can enable them. Just the same as with the logging or putting all libraries in one library file. By the way, this was the error of the utilities in Mac OS: Making all in po g++ -DHAVE_CONFIG_H -I. -I.. -I../lib -DLOCALEDIR=\/usr/local/share/locale\ -DKEYWORDFILE=\/usr/local/share/opendbx/keywords\ -I/opt/local/include/postgresql83 -g -O2 -MT odbx_sql-argmap.o -MD -MP -MF .deps/odbx_sql-argmap.Tpo -c -o odbx_sql-argmap.o `test -f 'argmap.cpp' || echo './'`argmap.cpp mv -f .deps/odbx_sql-argmap.Tpo .deps/odbx_sql-argmap.Po g++ -DHAVE_CONFIG_H -I. -I.. -I../lib -DLOCALEDIR=\/usr/local/share/locale\ -DKEYWORDFILE=\/usr/local/share/opendbx/keywords\ -I/opt/local/include/postgresql83 -g -O2 -MT odbx_sql-commands.o -MD -MP -MF .deps/odbx_sql-commands.Tpo -c -o odbx_sql-commands.o `test -f 'commands.cpp' || echo './'`commands.cpp mv -f .deps/odbx_sql-commands.Tpo .deps/odbx_sql-commands.Po g++ -DHAVE_CONFIG_H -I. -I.. -I../lib -DLOCALEDIR=\/usr/local/share/locale\ -DKEYWORDFILE=\/usr/local/share/opendbx/keywords\ -I/opt/local/include/postgresql83 -g -O2 -MT odbx_sql-completion.o -MD -MP -MF .deps/odbx_sql-completion.Tpo -c -o odbx_sql-completion.o `test -f 'completion.cpp' || echo './'`completion.cpp mv -f .deps/odbx_sql-completion.Tpo .deps/odbx_sql-completion.Po g++ -DHAVE_CONFIG_H -I. -I.. -I../lib -DLOCALEDIR=\/usr/local/share/locale\ -DKEYWORDFILE=\/usr/local/share/opendbx/keywords\ -I/opt/local/include/postgresql83 -g -O2 -MT odbx_sql-odbx-sql.o -MD -MP -MF .deps/odbx_sql-odbx-sql.Tpo -c -o odbx_sql-odbx-sql.o `test -f 'odbx-sql.cpp' || echo './'`odbx-sql.cpp odbx-sql.cpp: In function 'int main(int, char**)': odbx-sql.cpp:228: error: invalid conversion from 'char* (*)(const char*, int)' to 'int (*)(const char*, int)' make[3]: *** [odbx_sql-odbx-sql.o] Error 1 make[2]: *** [all-recursive] Error 1 make[1]: *** [all-recursive] Error 1 make: *** [all] Error 2 when we disabled the utilities it compiles perfect. is this the same problem we have in Windows? cheers, Mariano Norbert -- OpenPGP public key http://www.linuxnetworks.de/norbert.pubkey.asc -- Come build with us! The BlackBerryreg; Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9#45;12, 2009. Register now#33; http://p.sf.net/sfu/devconf ___ libopendbx-devel mailing list libopendbx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX -- Come build with us! The BlackBerryreg; Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9#45;12, 2009. Register now#33; http://p.sf.net/sfu/devconf___ libopendbx-devel mailing list libopendbx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX
Re: [opendbx] Should MySQL 4.0.15. work with OpenDBX ?
2009/9/29 Herbert König herbertkoe...@gmx.net Hello Mariano Norbert, wouldn't the cheapest way be to just build a special case into SqueakDBX error handling that could be activated via some option? This, this can be perfectly done (I think). I also have thought in this solution. I will review the code and commit a version so that you can test it. The thing is that I don't know what happens if you open a connection with this error. What happens with all of the queries you do then ? will them work? It's a recoverable error after all. Same for OpenDBX, couldn't it just be an option? Me talking about something I know nothing about. And about supporting an extra built I'd say it's a pain that isn't worth it. (Talking about something I know). So it can either be a parameter in OpenDBX or it can be done in SqueakDBX. ok. As time permits I will try a port to see if I find more problems than the recoverable connection error. I will let you know. Thanks. Thanks Herbert MMP 2009/9/29 Mariano Martinez Peck marianop...@gmail.com MMP 2009/9/29 Norbert Sendetzky norb...@linuxnetworks.de MMP Hi Mariano, Herbert Ok. Now it is almost working. He is using the MySQL 5 client library to talk to a MySQL 4.0.15 server. I saw this: The problem now is that when he is trying to open the connection (odbx_bind) he gets a unknown system variable sql_mode. I looked in OpenDBX code and you don't have sql_mode in your source code. MMP It's in backends/mysql/mysql_basic.c, line 761 (trunk) MMP Wowmy total commander didn't find itweird :( MMP MMP Unfortunately, sql_mode is only supported since 4.1, so it's not possible to MMP connect to a MySQL 4.0 server using the standard OpenDBX source. The only way MMP to use the library would be to comment out the call to mysql_priv_setmode() in MMP line 197 and recompile but this would require to start the MySQL server in MMP ANSI mode (--sql-mode=ANSI) to get the same behaviour. MMP Thanks for the explanation Norbert. Now I am intrigued why MMP OpenDBX needs to set something in that variable. I mean, what MMP happens if you remove that call in line 197? MMP Herbert if you want, I can compile a new dll with the MMP changes Norbert said justto see if it works. Then you can decide MMP if you want to use SqueakDBX orthe native driver :( MMP For every new release of OpenDBX I can create a special MMP MySQL dll for4.0x MySQL compatibility. I have no problem at all MMP doing that. It isjust a couple of minutes. MMP Norbert: if this changes work, what do you think in MMP including to the website a MySQL-4.0x special dll for every new MMP release? MMP Best, MMP mariano MMP MMP Cheers, MMP Mariano MMP MMP Norbert MMP -- MMP OpenPGP public key MMP http://www.linuxnetworks.de/norbert.pubkey.asc Thanks, Herbertmailto:herbertkoe...@gmx.net -- Come build with us! The BlackBerryreg; Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9#45;12, 2009. Register now#33; http://p.sf.net/sfu/devconf___ libopendbx-devel mailing list libopendbx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX
Re: [opendbx] Newbie questions about error handling
Sorry, but I think the best thing is that I tell you my current problem: I don't remember C++ (I just programmed only once a couple of years ago) but in several object oriented languages, there is the concept of error handling using exceptions. And of course, this is the case of Smalltalk. I hope you know what exceptions are so that you can understand what I need. The thing is that from my code (SqueakDBX) or even from the user of SqueakDBX I would like to do a certain action depending on the error I got. But right now, I have no way to identify uniquely an error. The only thing I can do is to obtain a -1 and then the description. But I don't want to depend on that to identify a particular error type. Because if tomorrow the description changeSo, what I would love is to uniquely identify an error in ALL of the OpenDBX library. Something like this: Error code |Error number |Description NO_MEMORY |0 |There is no memory left LIBRARY_OPEN | 1 | OpenDBX could load the library backend . | | So, it doesn't matter which handle I have, I know every time I get a NO_MEMORY it means that ... So, with this, I can have decisions in my code and decide what to do in different error situations. Do you understand this problem? do you think OpenDBX can do something like this in a future release? does this make sense for you ? Cheers, Mariano On Tue, Sep 29, 2009 at 6:57 PM, Mariano Martinez Peck marianop...@gmail.com wrote: Norbert: I have a question. Although I am almost sure about the answer ;) The question is: when I have an error with OpenDBX I can then call odbx_error() to obtain the description. The thing is, is that error number unique? I mean, if I have an error number -3 with the description XXX every time I get a -3 the description will be XXX? or...perhaps after certain function invocation -3 can mean XXX and with other function it can mean YYY ? Thanks Mariano -- Come build with us! The BlackBerryreg; Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9#45;12, 2009. Register now#33; http://p.sf.net/sfu/devconf___ libopendbx-devel mailing list libopendbx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX
Re: [opendbx] Newbie questions about error handling
On Wed, Sep 30, 2009 at 4:13 AM, Norbert Sendetzky norb...@linuxnetworks.de wrote: On Tue September 29 2009 23:57:06 Mariano Martinez Peck wrote: The question is: when I have an error with OpenDBX I can then call odbx_error() to obtain the description. The thing is, is that error number unique? I mean, if I have an error number -3 with the description XXX every time I get a -3 the description will be XXX? or...perhaps after certain function invocation -3 can mean XXX and with other function it can mean YYY ? The error codes of the library are unique so -3 always means XXX but the errors of the backends aren't. ok. Those errors of the library are those which are in enum odbxerr ? Sorry Norbert for my ignorance, but how can I now each element of the enum what value is ? For example, -1 is ODBX_ERR_BACKEND ? where can I see that ? When I got -1 the description I get is the description of the error of the backend isn't it ? In any other case, the error I get is the description associated with the enum dbxerr which is in static const char* odbx_errmsg[] ??? I am right ??? This means that -1 always means something else depending on the called function, the state of the connection and the used backend. Norbert -- OpenPGP public key http://www.linuxnetworks.de/norbert.pubkey.asc -- Come build with us! The BlackBerryreg; Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9#45;12, 2009. Register now#33; http://p.sf.net/sfu/devconf ___ libopendbx-devel mailing list libopendbx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX -- Come build with us! The BlackBerryreg; Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9#45;12, 2009. Register now#33; http://p.sf.net/sfu/devconf___ libopendbx-devel mailing list libopendbx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX
Re: [opendbx] Should MySQL 4.0.15. work with OpenDBX ?
2009/9/30 Norbert Sendetzky norb...@linuxnetworks.de Hi Mariano, Herbert wouldn't the cheapest way be to just build a special case into SqueakDBX error handling that could be activated via some option? This, this can be perfectly done (I think). I also have thought in this solution. I will review the code and commit a version so that you can test it. Please don't handle this case specially in SqueakDBX as it changes the behaviour of the whole backend and this should only be done by the application programmer who knows what he's doing. There's an option (ODBX_OPT_MODE) which the application programmer can use to set the MySQL mode. We could change this slightly so when setting it to an empty string, the sql_mode isn't set at all. this sounds a better solution :) However, instead of an empty string I would like to declare something like NO_SQL_MODE or something like that but with much more description. What do you think ? The thing is that I don't know what happens if you open a connection with this error. What happens with all of the queries you do then ? will them work? It won't work as the odbx_bind() function has to clean up the connection and close it. ok. Norbert -- OpenPGP public key http://www.linuxnetworks.de/norbert.pubkey.asc -- Come build with us! The BlackBerryreg; Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9#45;12, 2009. Register now#33; http://p.sf.net/sfu/devconf___ libopendbx-devel mailing list libopendbx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX
[opendbx] the bugtracker is down
http://bugs.linuxnetworks.de/index.php?project=3 Down...or something similar hahaha. Cheers, Mariano -- Come build with us! The BlackBerryreg; Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9#45;12, 2009. Register now#33; http://p.sf.net/sfu/devconf___ libopendbx-devel mailing list libopendbx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX
Re: [opendbx] Newbie questions about error handling
On Thu, Oct 1, 2009 at 2:31 PM, Norbert Sendetzky norb...@linuxnetworks.dewrote: Hi Mariano Why you think that is a bad idea? Don't you need (sometimes) to distinguish between one error and others? for example, don't you need to do or not to do something depending on the error you received ? Ok, you can have the error number as an instance variable and then use a switch or if but...I don't know. Sure, I do. Usually, the same kind of exception is thrown for an error of the same class and I see OpenDBX errors as one class of errors. The other way round I would have 15 types of exceptions which is too much in my opinion. Ok. I was thinking the same for SqueakDBX. It's a matter of design :) But yes, 15 types (classes) is too much. But being able to handling different exception from my point of view Object Oriented (in my opinion) is better than asking the number an do a lot of ifs or switch. But, as you said, 15 is too much... Norbert -- OpenPGP public key http://www.linuxnetworks.de/norbert.pubkey.asc -- Come build with us! The BlackBerryreg; Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9#45;12, 2009. Register now#33; http://p.sf.net/sfu/devconf ___ libopendbx-devel mailing list libopendbx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX -- Come build with us! The BlackBerryreg; Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9#45;12, 2009. Register now#33; http://p.sf.net/sfu/devconf___ libopendbx-devel mailing list libopendbx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX
[opendbx] I will be near Germany :)
Norbert: I am enrolling to do a PhD at Lille, France. I got a grant and I will do this 3 year doctorate. It has to do with smalltalk, mobile and robotics and I am very exited with this. I must be being there at the end of Novembre...So, I will be near Germany :) for at least 3 years. Maybe we can meet and do an (first one?) OpenDBX sprint hahah. And you show me the good german beer ;) Best, Mariano -- Come build with us! The BlackBerry(R) Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9 - 12, 2009. Register now! http://p.sf.net/sfu/devconference___ libopendbx-devel mailing list libopendbx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX
Re: [opendbx] ODBC configuration in windows
On Thu, Oct 15, 2009 at 5:03 PM, Norbert Sendetzky norb...@linuxnetworks.de
wrote:
Hi Mariano
No. I ALWAYS have the error option type out of range (translated from
spanish to english). The problem seems to be:
-2719: Option type out of range
ODBC Error. A function was called with an invalid value for the argument
fOption (e.g. the functions SQLSetConnectOption() or SQLTransact()).
The problem is odbc_odbx_bind, where you do:
gen-err = SQLSetConnectAttr( gen-conn, SQL_DEFAULT_TXN_ISOLATION,
(SQLPOINTER) SQL_TXN_READ_COMMITTED, SQL_IS_UINTEGER );
if( !SQL_SUCCEEDED( gen-err ) )
{
return -ODBX_ERR_BACKEND;
}
I've tested myself and got the same error with MinGW odbc.dll. The problem
is
that it doesn't seem to support the read commited isolation level.
Furthermore, it doesn't seem to support another option as well. I have to
do
some investigations to see how we can work around this.
Thanks god. I tought I was getting (more) crazy :(
Altoguht maybe this is not a OpenDBX bug, I opened a ticket:
http://bugs.linuxnetworks.de/index.php?do=detailsid=24
Thanks for your excellent debugging :-)
You are welcome :) I miss the smalltalk debugger hahahahah
Norbert
--
OpenPGP public key
http://www.linuxnetworks.de/norbert.pubkey.asc
--
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
___
libopendbx-devel mailing list
libopendbx-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/libopendbx-devel
http://www.linuxnetworks.de/doc/index.php/OpenDBX
--
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference___
libopendbx-devel mailing list
libopendbx-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/libopendbx-devel
http://www.linuxnetworks.de/doc/index.php/OpenDBX
Re: [opendbx] ODBC configuration in windows
On Thu, Oct 15, 2009 at 5:03 PM, Norbert Sendetzky norb...@linuxnetworks.de
wrote:
Hi Mariano
No. I ALWAYS have the error option type out of range (translated from
spanish to english). The problem seems to be:
-2719: Option type out of range
ODBC Error. A function was called with an invalid value for the argument
fOption (e.g. the functions SQLSetConnectOption() or SQLTransact()).
The problem is odbc_odbx_bind, where you do:
gen-err = SQLSetConnectAttr( gen-conn, SQL_DEFAULT_TXN_ISOLATION,
(SQLPOINTER) SQL_TXN_READ_COMMITTED, SQL_IS_UINTEGER );
if( !SQL_SUCCEEDED( gen-err ) )
{
return -ODBX_ERR_BACKEND;
}
I've tested myself and got the same error with MinGW odbc.dll.
I don't think it is a MinGW odbc.dll problem. I tested in a clean PC without
MinGW (just the opendbx dlls) and same results. I just tried to connect to a
SQL Server database using the odbc driver that comes with Windows, and I got
the same results.
The problem is
that it doesn't seem to support the read commited isolation level.
Furthermore, it doesn't seem to support another option as well. I have to
do
some investigations to see how we can work around this.
Thanks for your excellent debugging :-)
Norbert
--
OpenPGP public key
http://www.linuxnetworks.de/norbert.pubkey.asc
--
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
___
libopendbx-devel mailing list
libopendbx-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/libopendbx-devel
http://www.linuxnetworks.de/doc/index.php/OpenDBX
--
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference___
libopendbx-devel mailing list
libopendbx-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/libopendbx-devel
http://www.linuxnetworks.de/doc/index.php/OpenDBX
Re: [opendbx] ODBC configuration in windows
The same happens with the ODBC driver for Excel. There is a guy who want to
use SqueakDBX to do selects from an Excel. If you take a clean pc, you
create a ODBC datasource for excel, with a certain .xls and then you try
OpenDBX, you will have the same problem.
Maybe a hack (I don't know if this is a solution) would be to try to set
those options and if there is an error with a particular option, it is
ignored hahaha. Moreover, maybe there is a way to as if the particular
option is supported or not. In that case, we can ask first before trying to
set a value.
Cheers,
Mariano
On Fri, Oct 16, 2009 at 9:57 AM, Mariano Martinez Peck
marianop...@gmail.com wrote:
On Thu, Oct 15, 2009 at 5:03 PM, Norbert Sendetzky
norb...@linuxnetworks.de wrote:
Hi Mariano
No. I ALWAYS have the error option type out of range (translated from
spanish to english). The problem seems to be:
-2719: Option type out of range
ODBC Error. A function was called with an invalid value for the argument
fOption (e.g. the functions SQLSetConnectOption() or SQLTransact()).
The problem is odbc_odbx_bind, where you do:
gen-err = SQLSetConnectAttr( gen-conn, SQL_DEFAULT_TXN_ISOLATION,
(SQLPOINTER) SQL_TXN_READ_COMMITTED, SQL_IS_UINTEGER );
if( !SQL_SUCCEEDED( gen-err ) )
{
return -ODBX_ERR_BACKEND;
}
I've tested myself and got the same error with MinGW odbc.dll.
I don't think it is a MinGW odbc.dll problem. I tested in a clean PC
without MinGW (just the opendbx dlls) and same results. I just tried to
connect to a SQL Server database using the odbc driver that comes with
Windows, and I got the same results.
The problem is
that it doesn't seem to support the read commited isolation level.
Furthermore, it doesn't seem to support another option as well. I have to
do
some investigations to see how we can work around this.
Thanks for your excellent debugging :-)
Norbert
--
OpenPGP public key
http://www.linuxnetworks.de/norbert.pubkey.asc
--
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
___
libopendbx-devel mailing list
libopendbx-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/libopendbx-devel
http://www.linuxnetworks.de/doc/index.php/OpenDBX
--
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference___
libopendbx-devel mailing list
libopendbx-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/libopendbx-devel
http://www.linuxnetworks.de/doc/index.php/OpenDBX
Re: [opendbx] MS SQL VS ODBC in Windows
On Sat, Dec 5, 2009 at 11:54 AM, Norbert Sendetzky norb...@linuxnetworks.de wrote: Hi Mariano Hi Norbert: I think I am quite confused. In this link http://www.linuxnetworks.de/doc/index.php/OpenDBX/Setup/Windows/Building_wi th_MinGW you can read: * MS SQL Server * *The mssql backend is primarily intended for Unix environments where a native client library is not available for the MS SQL Server and FreeTDS library provides the only alternative. On Windows platforms, the native client is an ODBC driver so it's better to use the odbc backend http://www.linuxnetworks.de/doc/index.php/OpenDBX/Setup/Windows/Bui lding_with_MinGW#ODBC .* Is this corret? If true, can you explain it a bit more to me? Yes, that's correct. Microsoft doesn't provide a nativ driver for SQL Server like MySQL, Oracle, etc. does. Instead, the official driver for SQL Server from Microsoft is a ODBC driver. Sure, it's possible to use the mssql backend and the FreeTDS library (not official), but the intended way (from Microsoft) is to use ODBC and the ODBC SQL Server driver (from Microsoft) on Windows platforms. Ahh okok. Now I get it. Now, despite what Microsoft says, which driver do you think is better to use in Linux and Windows ? Cheers ps: I am already in France :) Norbert -- OpenPGP public key http://www.linuxnetworks.de/norbert.pubkey.asc -- Join us December 9, 2009 for the Red Hat Virtual Experience, a free event focused on virtualization and cloud computing. Attend in-depth sessions from your desk. Your couch. Anywhere. http://p.sf.net/sfu/redhat-sfdev2dev ___ libopendbx-devel mailing list libopendbx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX -- Join us December 9, 2009 for the Red Hat Virtual Experience, a free event focused on virtualization and cloud computing. Attend in-depth sessions from your desk. Your couch. Anywhere. http://p.sf.net/sfu/redhat-sfdev2dev___ libopendbx-devel mailing list libopendbx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX
Re: [opendbx] OpenDBX 1.5.0 released
Excellent news Norbert!!! I am quite busy right now but ASAP I will compile this new version for all backends in Linux and Windows and run my tests :) And of course, I will ask you then a few things about the new features. Thank you very much. Mariano On Mon, Dec 14, 2009 at 11:18 PM, Norbert Sendetzky norb...@linuxnetworks.de wrote: Dear OpenDBX users I'm pleased to announce the start of a new development branch whose version 1.5.0 will be the first release. The package name was changed to libopendbx to ease creation of distribution packages. It also supports symbol versioning and versioned support files which makes it fully compatible to Debian policy. New features like a function for testing if a field value is NULL as well as a new error code for calling odbx_query() without fetching the results first are implemented. Some internal functions and regression tests has been improved and the library contains logging facilities for debug output. The ODBC backend does now work on Windows and minor bugs were fixed in the mssql and the oracle backends as well as in the library. http://linuxnetworks.de/opendbx/download/libopendbx-1.5.0.tar.gz More features are already on the todo list. Norbert -- OpenPGP public key http://www.linuxnetworks.de/norbert.pubkey.asc -- Return on Information: Google Enterprise Search pays you back Get the facts. http://p.sf.net/sfu/google-dev2dev ___ libopendbx-devel mailing list libopendbx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX -- Return on Information: Google Enterprise Search pays you back Get the facts. http://p.sf.net/sfu/google-dev2dev ___ libopendbx-devel mailing list libopendbx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX
Re: [opendbx] 1.5.0 windows dlls and results
On Sun, Dec 20, 2009 at 12:58 AM, Mariano Martinez Peck marianop...@gmail.com wrote: On Thu, Dec 17, 2009 at 9:41 PM, Norbert Sendetzky norb...@linuxnetworks.de wrote: Hi Mariano Hi Norbert. I just wanted to let you know that I compile all backends in Linux and Windows and all my tests are green. Even ODBC in windows is working :) I have a little problem, but I will ask then. I also generated dlls for windows. I attach a zip with them. If you manage it to also create the backends for firebird and sybase so we have a full package, I will upload your Windows DLLs :-) you make me work ;) Ok...I installed both for my first time in my life :) For sybase, there is another thread. Would be excellent if you can test that dll regardless my problem. At least to see if the dlls i generate work ok. I could successfully compile and install Firebird...even more, of my 95 squeakdbx unit tests, I have only 10 failing but I think it is nothing important and it is fixable :) ok100% green tests for Firebird in windows :) Just a question...is it ok to begin a transaction in firebird like this: SET TRANSACTION READ WRITE ? I tried with BEGIN TRANSACTION, START TRANSACTION, TRANSACTION START, etcbut no one worked. Cheers, Mariano So, good nows!!! This was only tested in Windows. I will test it in Linux when I have more time. I attach here all windows dlls. cheers, Mariano Norbert -- OpenPGP public key http://www.linuxnetworks.de/norbert.pubkey.asc -- This SF.Net email is sponsored by the Verizon Developer Community Take advantage of Verizon's best-in-class app development support A streamlined, 14 day to market process makes app distribution fast and easy Join now and get one step closer to millions of Verizon customers http://p.sf.net/sfu/verizon-dev2dev ___ libopendbx-devel mailing list libopendbx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX -- This SF.Net email is sponsored by the Verizon Developer Community Take advantage of Verizon's best-in-class app development support A streamlined, 14 day to market process makes app distribution fast and easy Join now and get one step closer to millions of Verizon customers http://p.sf.net/sfu/verizon-dev2dev ___ libopendbx-devel mailing list libopendbx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX
Re: [opendbx] 1.5.0 windows dlls and results
On Sun, Dec 20, 2009 at 9:05 PM, Norbert Sendetzky norb...@linuxnetworks.de wrote: Hi Mariano ok100% green tests for Firebird in windows :) Cool thing! :-) Just a question...is it ok to begin a transaction in firebird like this: SET TRANSACTION READ WRITE ? I tried with BEGIN TRANSACTION, START TRANSACTION, TRANSACTION START, etcbut no one worked. Sure, it's the Firebird variant for starting transactions. Ok, perfect. If you give the Ok with sybase we can upload the dlls to the site :) cheers, Mariano Norbert -- OpenPGP public key http://www.linuxnetworks.de/norbert.pubkey.asc -- This SF.Net email is sponsored by the Verizon Developer Community Take advantage of Verizon's best-in-class app development support A streamlined, 14 day to market process makes app distribution fast and easy Join now and get one step closer to millions of Verizon customers http://p.sf.net/sfu/verizon-dev2dev ___ libopendbx-devel mailing list libopendbx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX -- This SF.Net email is sponsored by the Verizon Developer Community Take advantage of Verizon's best-in-class app development support A streamlined, 14 day to market process makes app distribution fast and easy Join now and get one step closer to millions of Verizon customers http://p.sf.net/sfu/verizon-dev2dev ___ libopendbx-devel mailing list libopendbx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX
[opendbx] More quesions with Firebird
Hi Norbert: I have more questions about Firebird but I think it is better to put them here so that not confuse threads. 1) Which FIrebird version work with OpenDBX ? Class, Super or both ? 2) Suppose I compile OpenDBX libraries using one of them, should that dll work with the other version ? 3) I have already installed Firebird in my windows but I don't remember if i was classic or super. Do you know how I can know that ? Thanks and have a happy Christmas. Mariano -- This SF.Net email is sponsored by the Verizon Developer Community Take advantage of Verizon's best-in-class app development support A streamlined, 14 day to market process makes app distribution fast and easy Join now and get one step closer to millions of Verizon customers http://p.sf.net/sfu/verizon-dev2dev ___ libopendbx-devel mailing list libopendbx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX
[opendbx] Stupid question about Logging
Norbert: Hi! I will probably ask something very stupid hahaha. When I open a connecion with OpenDBX in my smalltalk world I see the connection handle as numbers, something like 156156272 for example. I guess that's the address pointer to what you put in handle int odbx_init( odbx_t** handle, const char* backend, const char* host, const char* port ) But...when you create the logs files, I see something like this: opendbx-0x9a47c38.dbgSo, what's that 0x9a47c38 How can I map the number I have (156156272) to the name of the debug file (opendbx-0x9a47c38.dbg ) ? I thought it was something related with hexadecimal, but I think it is not that. Thanks, Mariano -- This SF.Net email is sponsored by the Verizon Developer Community Take advantage of Verizon's best-in-class app development support A streamlined, 14 day to market process makes app distribution fast and easy Join now and get one step closer to millions of Verizon customers http://p.sf.net/sfu/verizon-dev2dev ___ libopendbx-devel mailing list libopendbx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX
Re: [opendbx] More quesions with Firebird
On Thu, Dec 24, 2009 at 4:10 PM, Norbert Sendetzky norb...@linuxnetworks.de wrote: Hi Mariano 1) Which FIrebird version work with OpenDBX ? Class, Super or both ? I use the super server for testing but the classic one should work the same way because they only differ how things are handled internally (threads vs. processes). lpthread instead of fork ? ahahaha I remember something abou my C course at University hahaha. 2) Suppose I compile OpenDBX libraries using one of them, should that dll work with the other version ? Yes, the client library is the same. excellent :) 3) I have already installed Firebird in my windows but I don't remember if i was classic or super. Do you know how I can know that ? Sorry, I don't know. Perhaps it's shown in the Windows start menu or when connecting with the isql utility. ok, doesn' matter. Thanks and have a happy Christmas. Thank you very much, I wish you a wonderful Christmas. Are you still in France? Yes, I am in Douai, near Lille. My first Christmas with cold and snow haha. In Argentina we have 30 or more for this days :) I want to go to Hamburg but in April more or less. Cheers, Mariano Norbert -- OpenPGP public key http://www.linuxnetworks.de/norbert.pubkey.asc -- This SF.Net email is sponsored by the Verizon Developer Community Take advantage of Verizon's best-in-class app development support A streamlined, 14 day to market process makes app distribution fast and easy Join now and get one step closer to millions of Verizon customers http://p.sf.net/sfu/verizon-dev2dev ___ libopendbx-devel mailing list libopendbx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX -- This SF.Net email is sponsored by the Verizon Developer Community Take advantage of Verizon's best-in-class app development support A streamlined, 14 day to market process makes app distribution fast and easy Join now and get one step closer to millions of Verizon customers http://p.sf.net/sfu/verizon-dev2dev ___ libopendbx-devel mailing list libopendbx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX
Re: [opendbx] Problem wih Firebird in Linux
On Thu, Dec 24, 2009 at 5:08 PM, Norbert Sendetzky norb...@linuxnetworks.de wrote: Hi Mariano When it tries to finish the first resultset, I have this error: *** glibc detected *** /home/ubuntu/squeak/pharo-vm-0.15.2f-linux/squeak: free(): invalid next size (fast): 0x09b95f28 *** Hmm, this is hard to debug and I can see nothing in the code up to now that may cause this. Could you please try to compile OpenDBX with --enable- singlelib to get a single binary and attach gdb to your Squeak process? Maybe we get more information from the debugger. Ok, I will try and let you know. It would be also interesting if the value of ((XSQLDA*) result-generic)-sqln is the same in firebird_odbx_result() and firebird_odbx_result_finish() and what's going on in odbx_result() when malloc()ing the buffers for the columns (var[i].sqldata). I am not sure if I understood you correctly. Would you mind sending me the printf put in the correct places so that I can compile and see the values? Thank you very much! Mariano Norbert -- OpenPGP public key http://www.linuxnetworks.de/norbert.pubkey.asc -- This SF.Net email is sponsored by the Verizon Developer Community Take advantage of Verizon's best-in-class app development support A streamlined, 14 day to market process makes app distribution fast and easy Join now and get one step closer to millions of Verizon customers http://p.sf.net/sfu/verizon-dev2dev ___ libopendbx-devel mailing list libopendbx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX -- This SF.Net email is sponsored by the Verizon Developer Community Take advantage of Verizon's best-in-class app development support A streamlined, 14 day to market process makes app distribution fast and easy Join now and get one step closer to millions of Verizon customers http://p.sf.net/sfu/verizon-dev2dev ___ libopendbx-devel mailing list libopendbx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX
Re: [opendbx] Problem with Sybase on Windows
Norbert: I installed gdb in MinGW and did the following test: juan...@juanjoe-nb /c/mariano/openDBX/libopendbx-1.5.0/test $ gdb odbxtest.exe GNU gdb (GDB) 7.0 Copyright (C) 2009 Free Software Foundation, Inc. License GPLv3+: GNU GPL version 3 or later http://gnu.org/licenses/gpl.html This is free software: you are free to change and redistribute it. There is NO WARRANTY, to the extent permitted by law. Type show copying and show warranty for details. This GDB was configured as mingw32. For bug reporting instructions, please see: http://www.gnu.org/software/gdb/bugs/... Reading symbols from c:\mariano\openDBX\libopendbx-1.5.0\test/odbxtest.exe...done. (gdb) set args -b sybase -h localhost -p 5000 -d Sybase -u sa -w (gdb) run Starting program: c:\mariano\openDBX\libopendbx-1.5.0\test/odbxtest.exe -b sybase -h localhost -p 5000 -d Sybase -u sa -w [New Thread 3624.0x504] [New Thread 3624.0xad0] Program received signal SIGSEGV, Segmentation fault. 0x6ae41ee2 in sybase_odbx_init (handle=0x3d4510, host=0x3d2d08 localhost, port=0x3d2d17 5000) at sybase_basic.c:81 81 if( cs_config( aux-ctx, CS_SET, CS_USERDATA, (CS_VOID*) aux, sizeof( void* ), NULL ) != CS_SUCCEED ) (gdb) bt #0 0x6ae41ee2 in sybase_odbx_init (handle=0x3d4510, host=0x3d2d08 localhost, port=0x3d2d17 5000) at sybase_basic.c:81 #1 0x00402e9b in odbx_init (handle=0x22ff30, backend=0x3d2cfc sybase, host=0x3d2d08 localhost, port=0x3d2d17 5000) at odbx.c:91 #2 0x00401fd5 in main (argc=13, argv=0x3d4570) at odbx-regression.c:146 As you can read there it is failing in sybase_basic.c:81 which has this line: if( cs_config( aux-ctx, CS_SET, CS_USERDATA, (CS_VOID*) aux, sizeof( void* ), NULL ) != CS_SUCCEED ) If you want, let me know what parameters or what can I print so that it helps. Kind regards, Mariano On Sat, Dec 19, 2009 at 10:31 PM, Mariano Martinez Peck marianop...@gmail.com wrote: On Sat, Dec 19, 2009 at 9:12 PM, Norbert Sendetzky norb...@linuxnetworks.de wrote: Hi Mariano However, it does not work. When I try to run the tests I get a segmentation fault. I display nothing in MinGW but the Windows windows saying there was an error in the mode¡ule libsybasebackend-1.dll I am also sure I have this in $path: ;C:\Sybase\ASE-15_0\dll; You need C:\Sybase\OCS-15_0\dll in your path for the libraries. What an idiot I am. I went to check my $path exactly for that. When I saw I had C:\Sybase\ASE-15_0\dll; I thought it was C:\Sybase\OCS-15_0\dll Anyway, I put it in Path, reset windowsbut same problem :( I even configured and compiled again just in case.. kind regards, mariano Norbert -- OpenPGP public key http://www.linuxnetworks.de/norbert.pubkey.asc -- This SF.Net email is sponsored by the Verizon Developer Community Take advantage of Verizon's best-in-class app development support A streamlined, 14 day to market process makes app distribution fast and easy Join now and get one step closer to millions of Verizon customers http://p.sf.net/sfu/verizon-dev2dev ___ libopendbx-devel mailing list libopendbx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX -- This SF.Net email is sponsored by the Verizon Developer Community Take advantage of Verizon's best-in-class app development support A streamlined, 14 day to market process makes app distribution fast and easy Join now and get one step closer to millions of Verizon customers http://p.sf.net/sfu/verizon-dev2dev ___ libopendbx-devel mailing list libopendbx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX
Re: [opendbx] Problem with Sybase on Windows
maybe I should print all the parameters I send to the function cs_config but I am not sure how to do that as I don't know the data type of those variables. thanks mariano On Sat, Dec 26, 2009 at 12:01 AM, Mariano Martinez Peck marianop...@gmail.com wrote: On Fri, Dec 25, 2009 at 11:02 PM, Norbert Sendetzky norb...@linuxnetworks.de wrote: Hi Mariano Program received signal SIGSEGV, Segmentation fault. 0x6ae41ee2 in sybase_odbx_init (handle=0x3d4510, host=0x3d2d08 localhost, port=0x3d2d17 5000) at sybase_basic.c:81 81 if( cs_config( aux-ctx, CS_SET, CS_USERDATA, (CS_VOID*) aux, sizeof( void* ), NULL ) != CS_SUCCEED ) I've committed a small fix to the stable branch (rev 316) available at https://libopendbx.svn.sourceforge.net/svnroot/libopendbx/branches/stable-1.4 It changes void* to CS_VOID* which might be a problem. Could you test if the problem is gone in this revision? Norbert: I have tried with that and I have also segmentation fault. Look this output: juan...@juanjoe-nb /c/mariano/openDBX/stable-1.4/test $ gdb odbxtest.exe GNU gdb (GDB) 7.0 Copyright (C) 2009 Free Software Foundation, Inc. License GPLv3+: GNU GPL version 3 or later http://gnu.org/licenses/gpl.html This is free software: you are free to change and redistribute it. There is NO WARRANTY, to the extent permitted by law. Type show copying and show warranty for details. This GDB was configured as mingw32. For bug reporting instructions, please see: http://www.gnu.org/software/gdb/bugs/... Reading symbols from c:\mariano\openDBX\stable-1.4\test/odbxtest.exe...done. (gdb) set args -v -b sybase -h localhost -p 5000 -d Sybase -u sa -w (gdb) run Starting program: c:\mariano\openDBX\stable-1.4\test/odbxtest.exe -v -b sybase -h localhost -p 5000 -d Sybase -w sa -p w [New Thread 2572.0xccc] [New Thread 2572.0x990] [New Thread 2572.0x518] Program received signal SIGSEGV, Segmentation fault. 0x6ae41e72 in sybase_odbx_init (handle=0x3d2448, host=0x3d4e6a localhost, port=0x3d4e97 \033[D\033[D\033[\033[D\033[D\033[D\033[D\033[u\033[C\033[C\033[C\033[C\033[Cw\033[C\033[C\033[C\033[C) at sybase_basic.c:78 78 if( cs_config( aux-ctx, CS_SET, CS_USERDATA, (CS_VOID*) aux, sizeof( CS_VOID* ), NULL ) != CS_SUCCEED ) (gdb) bt #0 0x6ae41e72 in sybase_odbx_init (handle=0x3d2448, host=0x3d4e6a localhost, port=0x3d4e97 \033[D\033[D\033[\033[D\033[D\033[D\033[D\033[u\033[C\033[C\033[C\033[C\033[Cw\033[C\033[C\033[C\033[C) at sybase_basic.c:78 #1 0x00402999 in odbx_init (handle=0x22ff48, backend=0x3d4e5e sybase, host=0x3d4e6a localhost, port=0x3d4e97 \033[D\033[D\033[\033[D\033[D\033[D\033[D\033[u\033[C\033[C\033[C\033[C\033[Cw\033[C\033[C\033[C\033[C) at odbx.c:79 #2 0x00401f8a in main (argc=14, argv=0x3d2478) at odbx-regression.c:141 (gdb) Do you see something ? Anyway, thanks for trying to fix it. Cheers, Mariano Norbert -- OpenPGP public key http://www.linuxnetworks.de/norbert.pubkey.asc -- This SF.Net email is sponsored by the Verizon Developer Community Take advantage of Verizon's best-in-class app development support A streamlined, 14 day to market process makes app distribution fast and easy Join now and get one step closer to millions of Verizon customers http://p.sf.net/sfu/verizon-dev2dev ___ libopendbx-devel mailing list libopendbx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX -- This SF.Net email is sponsored by the Verizon Developer Community Take advantage of Verizon's best-in-class app development support A streamlined, 14 day to market process makes app distribution fast and easy Join now and get one step closer to millions of Verizon customers http://p.sf.net/sfu/verizon-dev2dev ___ libopendbx-devel mailing list libopendbx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX
[opendbx] About large objects
Hi Norbert! How are you ? Here with 7 cm of snow :) While in Argentina is doing like 40º hahahah I have a question regarding large objects. I know that some client libraries support large objects using the same functions used for normal datatypes and that there are others that use special functions. For the last one, we have the special opendbx large functions. Now, what I would like to know is: 1) This depends just in the backend or also in the OS ? Is it possible that for a particular client library they behave different in different OS like the asynchronous queries for example ? or is it the same for all OS ? 2) I need to know for all the backends, which ones use normal functions and which ones the special functions 3) how do you know the answer to 2) ? Can I get it invoking some function, like odbx_get_option() for example ? 4) Suppose I have a row with a CLOB field of 1Gb (to say something)I would like to prevent to load such field in my Smalltalk image as it will probably crash everything. Is there a way to limit this, I mean, to put a maximum ? is there a way to ask the size before loading ? this depends on the way large objects are managed (normal or special functions) ? Thanks! Mariano -- SOLARIS 10 is the OS for Data Centers - provides features such as DTrace, Predictive Self Healing and Award Winning ZFS. Get Solaris 10 NOW http://p.sf.net/sfu/solaris-dev2dev___ libopendbx-devel mailing list libopendbx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX
Re: [opendbx] About large objects
On Fri, Feb 12, 2010 at 8:10 AM, Norbert Sendetzky norb...@linuxnetworks.de wrote: Hi Mariano Hi Norbert! How are you ? Here with 7 cm of snow :) Nice. Is that already more than you would like to have? ;-) Fortunately, not yet ;) 4) Suppose I have a row with a CLOB field of 1Gb (to say something)I would like to prevent to load such field in my Smalltalk image as it will probably crash everything. Is there a way to limit this, I mean, to put a maximum ? is there a way to ask the size before loading ? this depends on the way large objects are managed (normal or special functions) ? You can only limit the retrieved size in the freetds based backends (mssql, sybase). All others don't provide this functionality. Okbut can I do it from OpenDBX ? if true, how ? If the backend supports the odbx_lo_* functions, you can retrieve the the content of the large object in chunks. Providing a function to retrieve the size fails because Oracle has implemented its own semantic (returns number of characters instead of number of bytes). Ok, perfect. Thanks for the answers. Mariano -- SOLARIS 10 is the OS for Data Centers - provides features such as DTrace, Predictive Self Healing and Award Winning ZFS. Get Solaris 10 NOW http://p.sf.net/sfu/solaris-dev2dev___ libopendbx-devel mailing list libopendbx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX
[opendbx] Problem with BLOB in Sqlite3
Hi Norbert. I have a problem with BLOBs in Sqlite3.
I am creating a table like this:
CREATE TABLE test_large_columns (
large_clob CLOB,
large_blobBLOB)
Then, I do an insert like this:
INSERT INTO test_large_columns (large_clob, large_blob)
VALUES (large_clob_data, large_blob_data)
Both, the creation and the insert work ok. The problem is the query.
Actually, the problem is that if I call odbx_column_type() for the column
called large_blob which is the BLOB, I get that the type is *16r20 (32 in
decimal), which is the code of the CLOB, NOT THE BLOB. *
**
*Do you know where can the problem ? I should receive 16r2F (47).*
**
*I checked in *static int sqlite3_odbx_column_type() but this seems to be
ok:
case SQLITE_BLOB:
return ODBX_TYPE_BLOB;
**
**
Maybe the problem is that I am inserting it as a varchar. I mean, I use the
to insert it. In Sqlite varchar is managed like CLOB, which is the type
that is answering me. If this is the case, do you know how can I then insert
a row putting binary data in a BLOB ?
**
*I also checked in the *odbx-regression.h where you define
static struct odbxstmt sqlite3_multi[] = {
And you are not creating a column to test the BLOB, however, in
http://www.linuxnetworks.de/doc/index.php/OpenDBX/DBMS_Datatypes#Large_object_types
it seems to be supported. So, maybe we can add it there too.
Thanks!
Mariano
--
SOLARIS 10 is the OS for Data Centers - provides features such as DTrace,
Predictive Self Healing and Award Winning ZFS. Get Solaris 10 NOW
http://p.sf.net/sfu/solaris-dev2dev___
libopendbx-devel mailing list
libopendbx-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/libopendbx-devel
http://www.linuxnetworks.de/doc/index.php/OpenDBX
Re: [opendbx] About large objects
2) I need to know for all the backends, which ones use normal functions and which ones the special functions Firebird provides odbx_lo_* capabilites and Oracle could but I didn't get it to work without segfault. All other backends use the regular functions to manage large texts or blobs. So, with Oracle there is no way to use large objects through OpenDBX by the moment because the only way is using the special functions and you are having segmentation fault with them ? Or I can also use normal functions for large objects in Oracle ? If there is no way, shouldn't we need to change this: http://www.linuxnetworks.de/doc/index.php/OpenDBX/DBMS_Datatypes#Large_object_types Thanks for the clarification. Mariano -- SOLARIS 10 is the OS for Data Centers - provides features such as DTrace, Predictive Self Healing and Award Winning ZFS. Get Solaris 10 NOW http://p.sf.net/sfu/solaris-dev2dev___ libopendbx-devel mailing list libopendbx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX
Re: [opendbx] Making utils disable by default
On Fri, Mar 26, 2010 at 2:21 PM, Norbert Sendetzky norb...@linuxnetworks.de wrote: Hi Mariano Hi Norbert. We found several persons that had problems compiling OpenDBX due to not finding some libraries like readline and so on. I though it was only Windows, but it happens also in Linux. Most of the time, we even don't need the utils. So...my question is, what about letting utils disable by default and if you want it to compile it with --enable-utils ? I've changed this for the utils and tests in the current trunk it it will be part of the next development release. Both must be explicitely enabled in the future. Excellent, we are in sync ;) Thanks! Mariano Norbert -- OpenPGP public key http://www.linuxnetworks.de/norbert.pubkey.asc -- Download Intel#174; Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev ___ libopendbx-devel mailing list libopendbx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX -- Download Intel#174; Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev___ libopendbx-devel mailing list libopendbx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX
Re: [opendbx] Transactions opened
On Sat, Mar 27, 2010 at 5:24 PM, Norbert Sendetzky norb...@linuxnetworks.de wrote: Hi Mariano - I open a connection (odbx_init and odbx_bind) - send a query which starts the transaction. This query depends on the database, but suppose something like START TRANSACTION; - insert something - close the connection (odbx_finish and odbx_unbind). Here I didn't do any commit or rollback. Now, my question is, do the database client library finalize (rollback for example) all the opened transactions to the database done with that connection I am finalizing ? or do I explicitly rollback them ? What happen with the insert of this scenario ? Do this depends on the database client library ? Yes, the database server (!) rolls back the transaction if the connection is closed or lost. The inserted record isn't committed to the storage. The firebird backend is a little bit different, as it needs to explicitly roll back open transactions. ok...thanks. I was quite sure about thatbut not totally sure for Firebird, thus my question :) Do you think it is a good practice to explicitly rollback all opened transactions when closing a connection ? No, not in Squeak as you don't know anything about the open transactions. In the case of firebird, leave that to the firebird backend. So...the firebird backend (opendbx) takes care about that ? i don't have to worry about that ? correct? Thanks! Mariano Norbert -- OpenPGP public key http://www.linuxnetworks.de/norbert.pubkey.asc -- Download Intel#174; Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev ___ libopendbx-devel mailing list libopendbx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX -- Download Intel#174; Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev___ libopendbx-devel mailing list libopendbx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX
Re: [opendbx] Problem wih Firebird in Linux
On Sat, Mar 27, 2010 at 5:09 PM, Norbert Sendetzky norb...@linuxnetworks.de wrote: Hi Mariano The thing is that I run my suite tests and I have the problem again :( Please make a svn update again, build the library and run the test/odbxplusthreads program, please? That's the test I would like to see if it's working: test/odbxplusthreads -b firebird -h host -p 3050 -d db -u user -w password -v -r 100 I guess you meant odbxplustest instead of odbxplusthreads I run that, and my pc is flying since half an our :) hahaaha it is doing a sound like a Ferrari hahahaha Soit is running since half an hour...running the tests (I can see the text scrolling). No crash and seems no error. Now, I don't understand why my suite fail :( Cheers Mariano Norbert -- OpenPGP public key http://www.linuxnetworks.de/norbert.pubkey.asc -- Download Intel#174; Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev ___ libopendbx-devel mailing list libopendbx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX -- Download Intel#174; Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev___ libopendbx-devel mailing list libopendbx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX
Re: [opendbx] Problem wih Firebird in Linux
hahahahaha it was not a good idea to enable debug mode on such tests and even more running on top of a virtualbox image running all databases at the same time hahahaha but is cool to see a mac giving all it can :) On Sat, Mar 27, 2010 at 5:53 PM, Mariano Martinez Peck marianop...@gmail.com wrote: On Sat, Mar 27, 2010 at 5:09 PM, Norbert Sendetzky norb...@linuxnetworks.de wrote: Hi Mariano The thing is that I run my suite tests and I have the problem again :( Please make a svn update again, build the library and run the test/odbxplusthreads program, please? That's the test I would like to see if it's working: test/odbxplusthreads -b firebird -h host -p 3050 -d db -u user -w password -v -r 100 I guess you meant odbxplustest instead of odbxplusthreads I run that, and my pc is flying since half an our :) hahaaha it is doing a sound like a Ferrari hahahaha Soit is running since half an hour...running the tests (I can see the text scrolling). No crash and seems no error. Now, I don't understand why my suite fail :( Cheers Mariano Norbert -- OpenPGP public key http://www.linuxnetworks.de/norbert.pubkey.asc -- Download Intel#174; Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev ___ libopendbx-devel mailing list libopendbx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX -- Download Intel#174; Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev___ libopendbx-devel mailing list libopendbx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX
Re: [opendbx] Problem wih Firebird in Linux
On Sat, Mar 27, 2010 at 6:57 PM, Norbert Sendetzky norb...@linuxnetworks.de wrote: Hi Mariano test/odbxplusthreads -b firebird -h host -p 3050 -d db -u user -w password -v -r 100 I guess you meant odbxplustest instead of odbxplusthreads No, it's odbxplusthreads, the new test application. I don't have that file ubu...@ubuntu-desktop:~/opendbx/trunk/test$ ls -la total 568 drwxr-xr-x 5 ubuntu ubuntu 4096 2010-03-27 22:02 . drwxr-xr-x 11 ubuntu ubuntu 4096 2010-03-27 22:41 .. drwxr-xr-x 2 ubuntu ubuntu 4096 2010-03-27 17:52 .deps -rw-r--r-- 1 ubuntu ubuntu 18473 2010-03-27 21:25 Makefile -rw-r--r-- 1 ubuntu ubuntu812 2010-03-27 16:33 Makefile.am -rw-r--r-- 1 ubuntu ubuntu 20126 2010-03-27 16:33 Makefile.in -rw-r--r-- 1 ubuntu ubuntu 8519 2009-12-26 00:02 odbxplus-regression.cpp -rwxr-xr-x 1 ubuntu ubuntu 367274 2010-03-27 17:52 odbxplustest -rw-r--r-- 1 ubuntu ubuntu 6978 2010-03-27 21:13 odbxplus-threads.cpp -rw-r--r-- 1 ubuntu ubuntu 13512 2010-03-27 16:33 odbx-regression.c -rw-r--r-- 1 ubuntu ubuntu 26102 2010-03-27 16:33 odbx-regression.h -rwxr-xr-x 1 ubuntu ubuntu 70796 2010-03-27 17:52 odbxtest -rwxr-xr-x 1 ubuntu ubuntu 3367 2009-12-26 00:02 odbxtest.sh -rw-r--r-- 1 ubuntu ubuntu 1094 2009-12-26 00:02 odbxtest.site.template drwxr-xr-x 3 ubuntu ubuntu 4096 2009-12-26 00:02 ref drwxr-xr-x 6 ubuntu ubuntu 4096 2010-03-27 21:14 .svn ubu...@ubuntu-desktop:~/opendbx/trunk/test$ svn info Path: . URL: https://libopendbx.svn.sourceforge.net/svnroot/libopendbx/trunk/test Repository Root: https://libopendbx.svn.sourceforge.net/svnroot/libopendbx Repository UUID: 0912c25c-d03d-0410-aa93-f7ecdc94f862 Revision: 330 Node Kind: directory Schedule: normal Last Changed Author: nose Last Changed Rev: 330 Last Changed Date: 2010-03-27 21:07:42 +0100 (Sat, 27 Mar 2010) Norbert -- OpenPGP public key http://www.linuxnetworks.de/norbert.pubkey.asc -- Download Intel#174; Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev ___ libopendbx-devel mailing list libopendbx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX -- Download Intel#174; Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev___ libopendbx-devel mailing list libopendbx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX
Re: [opendbx] Ubuntu 9.10 Installation problem in configure step
On Tue, Apr 20, 2010 at 10:28 PM, Hannes Hirzel hannes.hir...@gmail.comwrote: I want to install OpenDBX on Ubuntu 9.10 (Karmic) I am following the installation instructions on http://www.linuxnetworks.de/doc/index.php/OpenDBX/Setup/Manual_builds ./configure gives as result checking for doxygen... no Warning: docbook man page converter not found - skip generating man pages Warning: doxygen not found - skip generating man pages checking readline/readline.h usability... no checking readline/readline.h presence... no checking for readline/readline.h... no configure: error: libreadline header (readline.h) not found In Ubuntu 9.10 there is no directory /usr/include/mysql Where do I get these header files from? Maybe there are more header files missing? This is a common problem. Look: http://www.linuxnetworks.de/doc/index.php/OpenDBX/Setup/Common_problems Just add: --disable-utils Example: ./configure --disable-utils --with-backends=firebird However, it is already fixed in the trunk...utilities will be disable by default...so in a future you won't need that. Chher Thank you for the answer in advance Hannes -- ___ libopendbx-devel mailing list libopendbx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX -- ___ libopendbx-devel mailing list libopendbx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX
Re: [opendbx] Ubuntu 9.10 Installation problem in configure step
On Wed, Apr 21, 2010 at 2:27 PM, Norbert Sendetzky norb...@linuxnetworks.de wrote: On Wed April 21 2010 17:37:07 Hannes Hirzel wrote: I tried to use the binary package. I went for http://download.opensuse.org/repositories/home:/nsendetzky:/OpenDBX/xUbuntu _9.10/i386/libopendbx1-mysql_1.4.5-1_i386.deb It gave me the attached error message. This is why I am working on the manual installation. There's a dependency between backends (e.g. libopendbx1-mysql) and and the library (libopendbx1) itself. You need to install the library before you can install the MySQL driver. On the command line you can install them both in one step: sudo dpkg -i libopendbx1_1.4.5-1_i386.deb libopendbx1-mysql_1.4.5-1_i386.deb Several people had the same problem (including myself)...it deserves a FAQ entry... no time now to do it by myself.. cheers mariano Norbert -- OpenPGP public key http://www.linuxnetworks.de/norbert.pubkey.asc -- ___ libopendbx-devel mailing list libopendbx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX -- ___ libopendbx-devel mailing list libopendbx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX
Re: [opendbx] Ubuntu 9.10 Installation problem in configure step
sudo dpkg -i libopendbx1_1.4.5-1_i386.deb libopendbx1-mysql_1.4.5-1_i386.deb A very simple solution if you happen to know it (saves a few hours of time). I updated the wiki page http://www.linuxnetworks.de/doc/index.php/OpenDBX/Setup/Unix-like/Binary_packages#Ubuntu Thank you all for your time and patience Excellent! Thanks a lot. Mariano Hannes -- ___ libopendbx-devel mailing list libopendbx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX -- ___ libopendbx-devel mailing list libopendbx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX
Re: [opendbx] Ubuntu 9.10 Installation problem in configure step
On Fri, Apr 23, 2010 at 2:39 PM, Hannes Hirzel hannes.hir...@gmail.comwrote: Having a comprehensive step by step guide how to install OpenDBX in Ubuntu (plus SqueakDBX but that is on another list) would be great for me. Don't you think this is enough? http://www.squeakdbx.org/Compiling%20and%20installing%20OpenDBX http://www.squeakdbx.org/Compiling%20for%20different%20backends/Common%20steps%20and%20problems http://www.squeakdbx.org/Compiling%20for%20different%20backends/Different%20backends%20under%20Ubuntu I think I got OpenDBX installed but I am not sure as it does not work in SqueakDBX. There are tests for OpenDBX and tests for SqueakDBX. If OpenDBX tests work, then OpenDBX is working. If OpenDBX tests work, but SqueakDBX don't, then, SqueakDBX is not working. You can read about how to run the OpenDBX tests in the links I already sent you. How to run SqueakDBX tests, you can read it here: http://www.squeakdbx.org/Tests I do not know where the error is. Me neither. If you don't try to give me the max info available, I won't be able to help you. However currently I do not have time to pursue this. I will give it another try in about three weeks time with a fresh Ubuntu 10.04 installation in a virtual machine. Thank you all for your help so far. You are welcome. I think all the process is well documented. And if it is not, please let us know. Cheers Mariano On 4/23/10, Alacner alac...@gmail.com wrote: i really like build with source, and i build the document to chm file, if who want it, send mail to me, alacner#gmail.com 2010/4/21 Hannes Hirzel hannes.hir...@gmail.com: I want to install OpenDBX on Ubuntu 9.10 (Karmic) I am following the installation instructions on http://www.linuxnetworks.de/doc/index.php/OpenDBX/Setup/Manual_builds ./configure gives as result checking for doxygen... no Warning: docbook man page converter not found - skip generating man pages Warning: doxygen not found - skip generating man pages checking readline/readline.h usability... no checking readline/readline.h presence... no checking for readline/readline.h... no configure: error: libreadline header (readline.h) not found In Ubuntu 9.10 there is no directory /usr/include/mysql Where do I get these header files from? Maybe there are more header files missing? Thank you for the answer in advance Hannes -- ___ libopendbx-devel mailing list libopendbx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX -- ___ libopendbx-devel mailing list libopendbx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX -- ___ libopendbx-devel mailing list libopendbx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX -- ___ libopendbx-devel mailing list libopendbx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX
[opendbx] Running tests information in webpage
Norbert: I thought it was documented in the website how to run the OpenDBX test...but I didn't find it. If it is not there, can we add it ? I am not sure where. In addition, now we have to document also that in version xxx, tests have to be explicitly enable in configure. Cheers Mariano -- ___ libopendbx-devel mailing list libopendbx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX
Re: [opendbx] Running tests information in webpage
On Sat, May 8, 2010 at 10:34 PM, Norbert Sendetzky norb...@linuxnetworks.de wrote: Hi Mariano Norbert: I thought it was documented in the website how to run the OpenDBX test...but I didn't find it. I've added some documentation for the test application: http://www.linuxnetworks.de/doc/index.php/OpenDBX/Test_application This is great Norbert! Thank you very much. Sorry I didn't do it by myself but these times I have very few time for SqueakDBX/OpenDBX :( Cheers Mariano Norbert -- OpenPGP public key http://www.linuxnetworks.de/norbert.pubkey.asc -- ___ libopendbx-devel mailing list libopendbx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX -- ___ libopendbx-devel mailing list libopendbx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX
Re: [opendbx] [Pharo-project] OpenDBX for dbase files
2010/6/11 Facundo Vozzi facundo...@gmail.com Hi at all, can I used openDBX for read dbase (.dbf) files or I need try with xbase ? Hi Facundo. Sounds Spanish name (or even Argentinian!!! ;) ) I don't know if it is possible. I even don't know that dbase is (I had to googled it) what is xbase also? I cc'ed openDBX mailing list and maybe Norbert can help you. Cheers Mariano regards, Facu ___ Pharo-project mailing list pharo-proj...@lists.gforge.inria.fr http://lists.gforge.inria.fr/cgi-bin/mailman/listinfo/pharo-project -- ThinkGeek and WIRED's GeekDad team up for the Ultimate GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the lucky parental unit. See the prize list and enter to win: http://p.sf.net/sfu/thinkgeek-promo___ libopendbx-devel mailing list libopendbx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX
Re: [opendbx] Windows binaries etc.
On Tue, Jun 22, 2010 at 7:40 AM, Norbert Sendetzky norb...@linuxnetworks.de wrote: Hi Mark I've been developing an interface using Windows 1.4.4 binaries. So far this has worked well using Firebird and mySQL on Windows. I will be testing with SQLite 3 shortly. I am confused with MS SQLServer implementation. I can't find a backend for this (in 1.4.4) even though it is mentioned in various documentation along with TDS (what is TDS?). I thought I'd test ODBC backend, but ran into a lot of problems. Then I read through the change logs for 1.4.5 where you mention that many changes had been made to the ODBC backend to solve various problems. 1. Will you make OpenDBX 1.4.5 Windows binaries available? 2. Can you tell me what is required to interface to MS SQLServer? The mssql backend is only used on Linux systems in combination with the FreeTDS library. On Windows systems, the official way to interface a MS SQL Server is using the ODBC driver. The Windows binaries are contributed by Mariano and not created by myself. Currently, he seems to be very busy, so no Windows binaries for 1.4.5 were built up to now and I don't know if he will do so in the future. Yes, I am busy but I allocated some time to build Windows dlls for 1.4.5 :) I am in the process now. I will send an email woth them when they are ready. Let me know when 1.5 is out so that I can do the same. Cheers Mariano Norbert -- OpenPGP public key http://www.linuxnetworks.de/norbert.pubkey.asc -- ThinkGeek and WIRED's GeekDad team up for the Ultimate GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the lucky parental unit. See the prize list and enter to win: http://p.sf.net/sfu/thinkgeek-promo ___ libopendbx-devel mailing list libopendbx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX -- ThinkGeek and WIRED's GeekDad team up for the Ultimate GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the lucky parental unit. See the prize list and enter to win: http://p.sf.net/sfu/thinkgeek-promo___ libopendbx-devel mailing list libopendbx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX
Re: [opendbx] cannot compile sqlite3 in Mac OS
On Sat, Jul 3, 2010 at 8:46 PM, Norbert Sendetzky norb...@linuxnetworks.dewrote: Hi Mariano odbx_sql-odbx-sql.o `test -f 'odbx-sql.cpp' || echo './'`odbx-sql.cpp odbx-sql.cpp: In function 'int main(int, char**)': odbx-sql.cpp:228: error: invalid conversion from 'char* (*)(const char*, int)' to 'int (*)(const char*, int)' make[3]: *** [odbx_sql-odbx-sql.o] Error 1 make[2]: *** [all-recursive] Error 1 make[1]: *** [all-recursive] Error 1 make: *** [all] Error 2 I remember that Esteban noted the same problem but he had no time to debug further into this issue. ahh I didn't know. I will ask him. It seems that the readline library seems to be different on MacOS and other Unix-like systems. Could you please tell me, what libreadline version is installed on your system? I have no idea how to know that. Any help? Thanks Mariano Thanks Norbert -- OpenPGP public key http://www.linuxnetworks.de/norbert.pubkey.asc -- This SF.net email is sponsored by Sprint What will you do first with EVO, the first 4G phone? Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first ___ libopendbx-devel mailing list libopendbx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX -- This SF.net email is sponsored by Sprint What will you do first with EVO, the first 4G phone? Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first___ libopendbx-devel mailing list libopendbx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX
Re: [opendbx] cannot compile sqlite3 in Mac OS
Hi Norbert. I tried with the --disable-utils and got another problem. I attach make output. BTW, how did you came to do conclusion it was a libreadline problem? thanks mariano On Sat, Jul 3, 2010 at 9:22 PM, Mariano Martinez Peck marianop...@gmail.com wrote: On Sat, Jul 3, 2010 at 8:46 PM, Norbert Sendetzky norb...@linuxnetworks.de wrote: Hi Mariano odbx_sql-odbx-sql.o `test -f 'odbx-sql.cpp' || echo './'`odbx-sql.cpp odbx-sql.cpp: In function 'int main(int, char**)': odbx-sql.cpp:228: error: invalid conversion from 'char* (*)(const char*, int)' to 'int (*)(const char*, int)' make[3]: *** [odbx_sql-odbx-sql.o] Error 1 make[2]: *** [all-recursive] Error 1 make[1]: *** [all-recursive] Error 1 make: *** [all] Error 2 I remember that Esteban noted the same problem but he had no time to debug further into this issue. ahh I didn't know. I will ask him. It seems that the readline library seems to be different on MacOS and other Unix-like systems. Could you please tell me, what libreadline version is installed on your system? I have no idea how to know that. Any help? Thanks Mariano Thanks Norbert -- OpenPGP public key http://www.linuxnetworks.de/norbert.pubkey.asc -- This SF.net email is sponsored by Sprint What will you do first with EVO, the first 4G phone? Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first ___ libopendbx-devel mailing list libopendbx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX -- This SF.net email is sponsored by Sprint What will you do first with EVO, the first 4G phone? Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first___ libopendbx-devel mailing list libopendbx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX
Re: [opendbx] cannot compile sqlite3 in Mac OS
here I attach, sorry On Sat, Jul 3, 2010 at 10:39 PM, Mariano Martinez Peck marianop...@gmail.com wrote: Hi Norbert. I tried with the --disable-utils and got another problem. I attach make output. BTW, how did you came to do conclusion it was a libreadline problem? thanks mariano On Sat, Jul 3, 2010 at 9:22 PM, Mariano Martinez Peck marianop...@gmail.com wrote: On Sat, Jul 3, 2010 at 8:46 PM, Norbert Sendetzky norb...@linuxnetworks.de wrote: Hi Mariano odbx_sql-odbx-sql.o `test -f 'odbx-sql.cpp' || echo './'`odbx-sql.cpp odbx-sql.cpp: In function 'int main(int, char**)': odbx-sql.cpp:228: error: invalid conversion from 'char* (*)(const char*, int)' to 'int (*)(const char*, int)' make[3]: *** [odbx_sql-odbx-sql.o] Error 1 make[2]: *** [all-recursive] Error 1 make[1]: *** [all-recursive] Error 1 make: *** [all] Error 2 I remember that Esteban noted the same problem but he had no time to debug further into this issue. ahh I didn't know. I will ask him. It seems that the readline library seems to be different on MacOS and other Unix-like systems. Could you please tell me, what libreadline version is installed on your system? I have no idea how to know that. Any help? Thanks Mariano Thanks Norbert -- OpenPGP public key http://www.linuxnetworks.de/norbert.pubkey.asc -- This SF.net email is sponsored by Sprint What will you do first with EVO, the first 4G phone? Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first ___ libopendbx-devel mailing list libopendbx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX makeSqliteDis.rtf Description: RTF file -- This SF.net email is sponsored by Sprint What will you do first with EVO, the first 4G phone? Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first___ libopendbx-devel mailing list libopendbx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX
Re: [opendbx] Building on Solaris
On Fri, Jul 30, 2010 at 10:56 AM, Ihsan Dogan ih...@dogan.ch wrote: Hello, Yes, this works. Okit seems you have a problem with odbx-sql. This is a command line tool to use with OpenDBX to talk do databases. It is not part of OpenDBX core, just an optional tool. That's why I think it should be disable by default and compile it on demand. In addition, it uses some libs like readline that has problems in others OS. See http://www.linuxnetworks.de/doc/index.php/OpenDBX/Setup/Common_problems and this http://www.linuxnetworks.de/doc/index.php/OpenDBX/Setup/Manual_builds#Without_utilities cheers mariano Ihsan On 07/30/10 09:45, Mariano Martinez Peck wrote: Hi. Just to see if it works, can you add to ./configure this: --disable-utils cheers mariano On Fri, Jul 30, 2010 at 9:10 AM, Ihsan Dogan ih...@dogan.ch mailto:ih...@dogan.ch wrote: Hello, I'm trying to build OpenDBX on Solaris 10 and I'm running into this issue: /bin/bash ../libtool --tag=CXX --mode=link /opt/csw/gcc4/bin/g++ -mtune=i686 -O2 -pipe -m32 -march=i386 -L/opt/csw/gcc4/lib/. -m32 -march=i386 -L/opt/csw/instantclient_10_2 -L/opt/csw/lib -o odbx-sql odbx_sql-argmap.o odbx_sql-commands.o odbx_sql-completion.o odbx_sql-odbx-sql.o ../lib/.libs/libopendbx.so ../lib/.libs/libopendbxplus.so -lreadline -lncurses libtool: link: /opt/csw/gcc4/bin/g++ -mtune=i686 -O2 -pipe -m32 -march=i386 -m32 -march=i386 -o odbx-sql odbx_sql-argmap.o odbx_sql-commands.o odbx_sql-completion.o odbx_sql-odbx-sql.o ../lib/.libs/libopendbx.so ../lib/.libs/libopendbxplus.so -L/opt/csw/gcc4/lib/. -L/opt/csw/instantclient_10_2 -L/opt/csw/lib -lreadline -lncurses Undefined first referenced symbol in file libintl_gettext odbx_sql-commands.o (symbol belongs to implicit dependency /opt/csw/lib/libintl.so.8) libintl_textdomain odbx_sql-odbx-sql.o (symbol belongs to implicit dependency /opt/csw/lib/libintl.so.8) libintl_bindtextdomain odbx_sql-odbx-sql.o (symbol belongs to implicit dependency /opt/csw/lib/libintl.so.8) ld: fatal: Symbol referencing errors. No output written to odbx-sql Solaris 10 x86, using GCC. Ihsan -- ih...@dogan.ch mailto:ih...@dogan.ch http://blog.dogan.ch/ -- The Palm PDK Hot Apps Program offers developers who use the Plug-In Development Kit to bring their C/C++ apps to Palm for a share of $1 Million in cash or HP Products. Visit us here for more details: http://p.sf.net/sfu/dev2dev-palm ___ libopendbx-devel mailing list libopendbx-devel@lists.sourceforge.net mailto:libopendbx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX -- The Palm PDK Hot Apps Program offers developers who use the Plug-In Development Kit to bring their C/C++ apps to Palm for a share of $1 Million in cash or HP Products. Visit us here for more details: http://p.sf.net/sfu/dev2dev-palm ___ libopendbx-devel mailing list libopendbx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX -- ih...@dogan.ch http://blog.dogan.ch/ -- The Palm PDK Hot Apps Program offers developers who use the Plug-In Development Kit to bring their C/C++ apps to Palm for a share of $1 Million in cash or HP Products. Visit us here for more details: http://p.sf.net/sfu/dev2dev-palm ___ libopendbx-devel mailing list libopendbx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX -- The Palm PDK Hot Apps Program offers developers who use the Plug-In Development Kit to bring their C/C++ apps to Palm for a share of $1 Million in cash or HP Products. Visit us here for more details: http://p.sf.net/sfu/dev2dev-palm___ libopendbx-devel mailing list libopendbx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX
[opendbx] how to use SqueakDBX with Oracle in Mac OS [WAS] Fwd: Problem with Oracle in Mac OS
For those who needs to run SqueakDBX or OpenDBX with Oracle in Mac OS. Here
is what Colin had to do in order to make it work.
Cheers
Mariano
-- Forwarded message --
From: Colin Doherty colin.dohe...@gmail.com
Date: Thu, Aug 19, 2010 at 12:10 PM
Subject: Re: Problem with Oracle in Mac OS
To: Mariano Martinez Peck marianop...@gmail.com
Hi Mariano,
This is what I did if you want to add it to the documentation:
Platform: OSX 10.6.4 with Squeak 4.1, Oracle Instant Client for OSX 10.2
Installed SqueakDBX using Monticello.
Installed Oracle Instant Client (downloaded base, sqlplus and sdk packages)
to here: /usr/local/instantclient10_2
Created a subdirectory in /usr/local/instantclient10_2 called tns,
containing tnsnames.ora file.
Added the following environment settings to .bash_profile for compilation of
libopendbx-1.5.0:
DYLD_LIBRARY_PATH=/usr/local/instantclient10_2
ORACLE_HOME=/usr/local/instantclient10_2
TNS_ADMIN=/usr/local/instantclient10_2/tns
Compiled libopendbx-1.5.0 using these flags:
CFLAGS=-m32 CPPFLAGS=-m32 -I/usr/local/instantclient10_2/sdk/include
LDFLAGS=-arch i386 -L/usr/local/instantclient10_2 ./configure
--disable-utils --with-backends=oracle
make
make install
To get SqueakDBX/Oracle to work when Squeak is launched as an OSX
application need to create the following launch configuration file
/etc/launchd.conf, containing:
setenv DYLD_LIBRARY_PATH /usr/local/instantclient10_2
setenv ORACLE_HOME /usr/local/instantclient10_2
setenv TNS_ADMIN /usr/local/instantclient10_2/tns
Need to reboot for launchd.conf to take effect.
You also need to add these environment settings to your .bash_profile in
order to run squeak with SqueakDBX/Oracle from command line:
DYLD_LIBRARY_PATH=/usr/local/lib:/usr/local/instantclient10_2
ORACLE_HOME=/usr/local/instantclient10_2
TNS_ADMIN=/usr/local/instantclient10_2/tns
Cheers
Colin
On Thu, Aug 19, 2010 at 8:36 AM, Mariano Martinez Peck
marianop...@gmail.com wrote:
On Thu, Aug 19, 2010 at 2:48 AM, Colin Doherty colin.dohe...@gmail.comwrote:
Hi,
I've got it working. The problem turned out to be that environment that
launched applications in OSX was very minimal and wasn't including all the
required paths. You have to add the DYLD_LIBRARY_PATH to the Oracle
libraries for the systems /etc/launchd.conf file and it then works, no
memory errors etc.
Great news! I had a similar problem with DYLD_LIBRARY_PATH and oracle but
in Linux. See this link
http://www.squeakdbx.org/Oracle
In http://www.squeakdbx.org/Different%20backends%20under%20Mac
you see there is no entry for Oracle ;)
Soif you want to give us a hand and help with the documentation, please
let me know. I can create you a user or to send me text.
thanks
mariano
Thanks for all your help previously.
Cheers
Colin
On Wed, Aug 18, 2010 at 6:25 PM, Mariano Martinez Peck
marianop...@gmail.com wrote:
On Wed, Aug 18, 2010 at 7:21 PM, Colin Doherty
colin.dohe...@gmail.comwrote:
That's quite possible given my limited C skills. This is what I did,
just added switch statement and declared error variable:
Don't worry. I am C limited also...Norbert is the expert here ;)
sb4 error;
if( ( conn-errcode = OCIEnvCreate( env, OCI_THREADED, NULL, NULL,
NULL, NULL, 0, NULL ) ) != OCI_SUCCESS )
{
switch( conn-errcode )
{
case OCI_SUCCESS:
snprintf( conn-errmsg, OCI_ERROR_MAXMSG_SIZE,
Success );
break;
case OCI_SUCCESS_WITH_INFO:
snprintf( conn-errmsg, OCI_ERROR_MAXMSG_SIZE,
Success with info );
break;
case OCI_NEED_DATA:
snprintf( conn-errmsg, OCI_ERROR_MAXMSG_SIZE,
Need data );
break;
case OCI_NO_DATA:
snprintf( conn-errmsg, OCI_ERROR_MAXMSG_SIZE,
No data );
break;
case OCI_ERROR:
OCIErrorGet( (dvoid*) conn-err, 1, NULL,
error, (text*) conn-errmsg, OCI_ERROR_MAXMSG_SIZE, OCI_HTYPE_ERROR
);
break;
case OCI_INVALID_HANDLE:
snprintf( conn-errmsg, OCI_ERROR_MAXMSG_SIZE,
Invalid handle );
break;
case OCI_STILL_EXECUTING:
snprintf( conn-errmsg, OCI_ERROR_MAXMSG_SIZE,
Still executing );
break;
case OCI_CONTINUE:
snprintf( conn-errmsg, OCI_ERROR_MAXMSG_SIZE,
Continue );
break;
default:
snprintf( conn-errmsg, OCI_ERROR_MAXMSG_SIZE,
Unknown error );
break;
}
printf(2-hndl-cleanup);
printf(ODBX_ERR_NOMEM1 error: %d \n, conn-errcode);
oracle_odbx_error(handle);
oracle_priv_handle_cleanup( handle );
return -ODBX_ERR_NOMEM
Re: [opendbx] Building errors opendbx 1.4.5
Hi Miguel, what happens if you try with 1.5.0 ?? As far as I can see in 1.4.5, odbxlib.cat the end there is a big if: #ifdef HAVE_WINDOWS_H #include windows.h #endif static int _odbx_lib_register( struct odbx_t* handle, const char* library ) -.. #else #error Building shared libraries requires capabilities to load libraries dynamically #endif I have no idea.Norbert will probably help you. Cheers Mariano On Fri, Mar 18, 2011 at 12:10 PM, Miguel Sanchez mikey.sanc...@gmail.comwrote: Hi All, I'm trying to make opendbx-1.4.5 under MingW on Win XP SP3. I get the following error on make . (Despite this error I can see it has built ./backends/mssql/.libs/libmssqlbackend-1.dll). I presume what is not being built is libopendbx? . . . libtool: compile: gcc -std=gnu99 -DHAVE_CONFIG_H -I. -I.. -DLIBVERSION=10405 -D LOCALEDIR=\/usr/local/share/locale\ -DLIBPATH=\/usr/local/lib/opendbx\ -DLIB PREFIX=\lib\ -DLIBSUFFIX=\-1.dll\ -Ic:/mingw/msys/1.0/local/include -g -O2 - MT libopendbx_la-odbxlib.lo -MD -MP -MF .deps/libopendbx_la-odbxlib.Tpo -c odbxl ib.c -DDLL_EXPORT -DPIC -o .libs/libopendbx_la-odbxlib.o odbxlib.c:259:2: error: #error Building shared libraries requires capabilities to load libraries dynamically make[2]: *** [libopendbx_la-odbxlib.lo] Error 1 make[2]: Leaving directory `/opendbx/lib' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/opendbx' make: *** [all] Error 2 My configuration was as follows. $ CPPFLAGS=-Ic:/mingw/msys/1.0/local/include LDFLAGS=-Lc:/mingw/msys/1.0/loc al/lib configure --disable-utils --with-backends=mssql Best Regards, Miguel -- Colocation vs. Managed Hosting A question and answer guide to determining the best fit for your organization - today and in the future. http://p.sf.net/sfu/internap-sfd2d ___ libopendbx-devel mailing list libopendbx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX -- Colocation vs. Managed Hosting A question and answer guide to determining the best fit for your organization - today and in the future. http://p.sf.net/sfu/internap-sfd2d___ libopendbx-devel mailing list libopendbx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX
Re: [opendbx] Future plans
On Mon, Mar 21, 2011 at 1:17 AM, Benoit St-Jean bstj...@yahoo.com wrote: Hello everyone, Are there any plans to support DB/2 in the near future ? Yes. At least it is written here: http://www.linuxnetworks.de/doc/index.php/OpenDBX/Future Nevertheless, I wouldn't expect too much. I am not sure Norbert has time enough. The good thing is that OpenDBX has a good design and even being C it is easy to extend :) If you see you have all the OpenDBX core in the files that are in /lib and then, for each backend there is a BACKEND_basic.c in /backends. So it is a matter of writing a db2.basic.c where you map the openDBX functions to DB2 client library functions. Ok...all that is just my thought and been a C newbie. So probably it is much more complicated than that hehehhe Cheers Mariano Thank you. - Benoit St-Jean Yahoo! Messenger: bstjean A standpoint is an intellectual horizon of radius zero. (Albert Einstein) -- Colocation vs. Managed Hosting A question and answer guide to determining the best fit for your organization - today and in the future. http://p.sf.net/sfu/internap-sfd2d ___ libopendbx-devel mailing list libopendbx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX -- Colocation vs. Managed Hosting A question and answer guide to determining the best fit for your organization - today and in the future. http://p.sf.net/sfu/internap-sfd2d___ libopendbx-devel mailing list libopendbx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX
Re: [opendbx] Building errors opendbx 1.4.5
On Mon, Mar 21, 2011 at 12:27 PM, Miguel Sanchez mikey.sanc...@gmail.comwrote: Hi Mariano, On Norberts suggestion I'm cutting over to try with the DBXObcPlatform but I'm still getting a fatal error on odbx_bind. I was wondering, if I'm using DBXOdbcPlatform won't I need to give it a DSN rather than a host name? yes. Checl #createConnection for DBXMsSQLFacility or DBXOdbcMSSQLFacility or DBXOdbcPostgreFacility Are there any special instructions for configuring DBXConnectionSettings on an ODBC connection? No, just using the TDS name in host. Check those #createConnection as example. Regards, Miguel On 18 March 2011 21:55, Mariano Martinez Peck marianop...@gmail.com wrote: Hi Miguel, what happens if you try with 1.5.0 ?? As far as I can see in 1.4.5, odbxlib.cat the end there is a big if: #ifdef HAVE_WINDOWS_H #include windows.h #endif static int _odbx_lib_register( struct odbx_t* handle, const char* library ) -.. #else #error Building shared libraries requires capabilities to load libraries dynamically #endif I have no idea.Norbert will probably help you. Cheers Mariano On Fri, Mar 18, 2011 at 12:10 PM, Miguel Sanchez mikey.sanc...@gmail.com wrote: Hi All, I'm trying to make opendbx-1.4.5 under MingW on Win XP SP3. I get the following error on make . (Despite this error I can see it has built ./backends/mssql/.libs/libmssqlbackend-1.dll). I presume what is not being built is libopendbx? . . . libtool: compile: gcc -std=gnu99 -DHAVE_CONFIG_H -I. -I.. -DLIBVERSION=10405 -D LOCALEDIR=\/usr/local/share/locale\ -DLIBPATH=\/usr/local/lib/opendbx\ -DLIB PREFIX=\lib\ -DLIBSUFFIX=\-1.dll\ -Ic:/mingw/msys/1.0/local/include -g -O2 - MT libopendbx_la-odbxlib.lo -MD -MP -MF .deps/libopendbx_la-odbxlib.Tpo -c odbxl ib.c -DDLL_EXPORT -DPIC -o .libs/libopendbx_la-odbxlib.o odbxlib.c:259:2: error: #error Building shared libraries requires capabilities to load libraries dynamically make[2]: *** [libopendbx_la-odbxlib.lo] Error 1 make[2]: Leaving directory `/opendbx/lib' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/opendbx' make: *** [all] Error 2 My configuration was as follows. $ CPPFLAGS=-Ic:/mingw/msys/1.0/local/include LDFLAGS=-Lc:/mingw/msys/1.0/loc al/lib configure --disable-utils --with-backends=mssql Best Regards, Miguel -- Colocation vs. Managed Hosting A question and answer guide to determining the best fit for your organization - today and in the future. http://p.sf.net/sfu/internap-sfd2d ___ libopendbx-devel mailing list libopendbx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX -- Colocation vs. Managed Hosting A question and answer guide to determining the best fit for your organization - today and in the future. http://p.sf.net/sfu/internap-sfd2d ___ libopendbx-devel mailing list libopendbx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX -- Colocation vs. Managed Hosting A question and answer guide to determining the best fit for your organization - today and in the future. http://p.sf.net/sfu/internap-sfd2d ___ libopendbx-devel mailing list libopendbx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX -- Colocation vs. Managed Hosting A question and answer guide to determining the best fit for your organization - today and in the future. http://p.sf.net/sfu/internap-sfd2d___ libopendbx-devel mailing list libopendbx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX
Re: [opendbx] Mssql connection failed
On Thu, May 12, 2011 at 10:24 PM, Alain_Rastoul alr@free.fr wrote: Hi Mariano, Thanks for the pointers, I'll have a look at those links and tests. I think there are lot of developpers using windows and MS technology and that it would be nice to document a litle bit more this configuration specifically - I remember several posts on squeaks mailing lists about sql server connection with squeak - prehaps having precompiled binaries would help a lot too - Your docs on the build are nice, but not all developpers feel comfortable with that boring stuff. Hi Alain. There are binaries. This is explained in: http://www.squeakdbx.org/Compiling%20and%20installing%20OpenDBX and it links to: http://www.linuxnetworks.de/doc/index.php/OpenDBX/Setup/Unix-like http://www.linuxnetworks.de/doc/index.php/OpenDBX/Setup/Windows Cheers Mariano Regards Alain Mariano Martinez Peck marianop...@gmail.com a écrit dans le message de news: BANLkTi=5CM-AXxt=dybhbhqt8uh-5sm...@mail.gmail.com... On Thu, May 12, 2011 at 1:21 PM, Alain rastoul alr@free.fr wrote: Hi, I finally got openDbx working with FreeTDS and ODBC, I don't know what went wrong last night, I suppose my computer got tired ;) This is great ! Well, these are great news!!! :) Please, if there is something we can improve in the documentation of the website, let us know. However, I found - a much better performance with ODBC backend (DBXOdbcPlatform) in the test I did than with Freetds (DBXMSSQLPlatform) (run the test below, changing DBXOdbcPlatform to DBXMSSQLPlatform). With the ODBC backend the test ran about 2 times faster tha Did you see the benchmarks we have ? Check the classes DBXBigBenchmarks, DBXTinyBenchmarks and DBXMultipleForksBenchmarks. And this link: http://www.squeakdbx.org/Benchmarks nt MSSQL-freetds backend (needs explorations here) - perhaps a problem with TinyInt datatype ? (not very important) Probably related to: http://www.squeakdbx.org/Mappings%20from%20String%20to%20specific%20squeak%20types%20in%20selects#Whathappenifyouareretrievingarowthathasanotsupportedfield http://www.linuxnetworks.de/doc/index.php/OpenDBX/DBMS_Datatypes Cheers The test below consist read the column definitions of syscolumns and does not need any other database than master. Set myhost, myport, mydb, myuser and mypassword as appropriate. If you uncomment c.xprec, you will have the TinyInt error 500 timesRepeat: [ | conn connectionSettings result sql | sql := 'select c.name, c.id, s.name , c.length --, c.xprec --, c.xscale, c.xtype from master..sysobjects as o inner join master..syscolumns as c on o.id = c.id inner join master..systypes as s on c.xtype = s.xtype where o.name = ''syscolumns'''. connectionSettings := DBXConnectionSettings host: 'myhost' port: '1884' database: 'mydb' userName: 'myuser' userPassword: 'mypassword'. [ conn := DBXConnection platform: DBXOdbcPlatform new settings: connectionSettings. conn connect. conn open. result := conn execute: sql. result rowsDo: [ :r | 1 to: result columnCount do: [:c| | v | v := r rawValueAt: c.]]. ] ensure: [ conn close ]]. Cheers, Alain -- Alain_rastoul -- Achieve unprecedented app performance and reliability What every C/C++ and Fortran developer should know. Learn how Intel has extended the reach of its next-generation tools to help boost performance applications - inlcuding clusters. http://p.sf.net/sfu/intel-dev2devmay ___ libopendbx-devel mailing list libopendbx-devel-5nwgofrqmnerv+lv9mx5uipxlwaov...@public.gmane.org https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX -- Mariano http://marianopeck.wordpress.com -- -- Achieve unprecedented app performance and reliability What every C/C++ and Fortran developer should know. Learn how Intel has extended the reach of its next-generation tools to help boost performance applications - inlcuding clusters. http://p.sf.net/sfu/intel-dev2devmay -- -- Achieve unprecedented app performance and reliability What every C/C++ and Fortran developer should know. Learn how Intel has extended the reach of its next-generation tools to help boost performance applications - inlcuding clusters. http://p.sf.net
Re: [opendbx] slow insert with sqlite
On Tue, Jul 5, 2011 at 11:11 PM, Alain Rastoul alr@free.fr wrote: Hi Norbert, Yes they are problems with multi threading and sqlite, my question was about the opendbx implementation and/or the opendbx interface in Pharo. In Pharo there is only one vm thread, yes but I thought that may be opendbx or the opendbx interface was doing the call in another thread and the vm thread was waiting for completion? yes, exactly. But only if the backend and database client library support that. Are they documents about the opendbx architecture and or the opendbx interface in Pharo (couldn't find on the web site). Check the links I've sent you and the emails I have forwarded to squeakdbx mailing list. After you have read Hernik mails I can point you to the code if you want ;) Thank you for your answer Regards Alain Norbert Sendetzky norb...@linuxnetworks.de a écrit dans le message de news:4e137b24.7010...@linuxnetworks.de... Hi Alain I've done a small program in Pharo 1.3 with glorp+opendbx that insert 1000 rows in a customer table in a sqlite db. The 1000 insert takes 140 sec (very slow), but the Pharo profiler says that it spend 95% of the time waiting for input. I can't speak for the Pharo implementation but SQLite is known for being problematic when at least two threads trying to write to the same database file. Norbert -- All of the data generated in your IT infrastructure is seriously valuable. Why? It contains a definitive record of application performance, security threats, fraudulent activity, and more. Splunk takes this data and makes sense of it. IT sense. And common sense. http://p.sf.net/sfu/splunk-d2d-c2 -- All of the data generated in your IT infrastructure is seriously valuable. Why? It contains a definitive record of application performance, security threats, fraudulent activity, and more. Splunk takes this data and makes sense of it. IT sense. And common sense. http://p.sf.net/sfu/splunk-d2d-c2 ___ libopendbx-devel mailing list libopendbx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX -- Mariano http://marianopeck.wordpress.com -- All of the data generated in your IT infrastructure is seriously valuable. Why? It contains a definitive record of application performance, security threats, fraudulent activity, and more. Splunk takes this data and makes sense of it. IT sense. And common sense. http://p.sf.net/sfu/splunk-d2d-c2___ libopendbx-devel mailing list libopendbx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX
Re: [opendbx] Problems compiling opendbx on windows with latest MinGW and msys
Guille I think that a possible solution can be to create the variable $PATH and add it to C:\MinGW\lib\ or to whereever you have the lib folder of mingw. In your $PATH I can see you don't put :/mingw/lib Guille $PATH .:/usr/local/bin:/mingw/bin:/bin:/usr/local/bin:/usr/bin:/c/WINDOWS/system32:/c/WINDOWS:/c/WINDOWS/System32/Wbem:/c/Archivos de programa/QuickTime/QTSystem/:/c/WINDOWS/system32/WindowsPowerShell/v1.0:/c/Archivos de programa/Microsoft SQL Server/90/Tools/binn/:/mingw/bin/ But I do: $ echo $PATH .:/usr/local/bin:/mingw/bin:/bin:/c/oraclexe/app/oracle/product/10.2.0/server/bin:/c/Sybase/OCS-15_0/dll:/c/Sybase/ASE-15_0/jobscheduler/bin:/c/Sybase/ASE-15_0/dll:/c/Sybase/ASE-15_0/bin:/c/Sybase/DBISQL/bin:/c/Sybase/DataAccess/ADONET/dll:/c/Sybase/DataAccess/ODBC/dll:/c/Sybase/DataAccess/OLEDB/dll:/c/Sybase/UAF-2_5/bin:/c/Sybase/OCS-15_0/lib3p:/c/Sybase/OCS-15_0/dll:/c/Sybase/OCS-15_0/bin:/c/SQLServer:/c/mariano/oracle/instantclient_11_1/:/mingw/bin: /mingw/lib:/lib/:/usr/bin:/c/WINDOWS/system32:/c/WINDOWS:/c/WINDOWS/System32/Wbem:/c/Archivos de programa/TortoiseSVN/bin:/c/PostgreSQL/8.3/bin/:/c/Archivos de programa/Microsoft SQL Server/90/Tools/binn/:/c/XEClient/bin:/c/MySQL/bin:/c/Archivos de programa/CMake 2.8/bin:/c/Archivos de programa/Git/cmd:/c/Archivos de programa/Git/bin:/c/Archivos de programa/Cincom/ObjectStudio/dllw32:./dllw32 In addition, maybe we can do something like --disable-nls during ./configure ? tell me if helped On Sat, Jul 9, 2011 at 10:41 PM, Guillermo Polito guillermopol...@gmail.com wrote: Yeap. I'm now trying to use Cygwin instead. I'll tell you if I can succeed :). Thanks! On Sat, Jul 9, 2011 at 5:39 PM, Norbert Sendetzky norb...@linuxnetworks.de wrote: Hi Guille Do you think it's a problem with my minGW instalation? I've also installed the package in http://gnuwin32.sourceforge.net/packages/gettext.htm to see if it makes some difference. Yes, I think so. Did you used the documentation as reference? http://linuxnetworks.de/doc/index.php/OpenDBX/Setup/Windows/Building_with_MinGW Norbert -- All of the data generated in your IT infrastructure is seriously valuable. Why? It contains a definitive record of application performance, security threats, fraudulent activity, and more. Splunk takes this data and makes sense of it. IT sense. And common sense. http://p.sf.net/sfu/splunk-d2d-c2 ___ libopendbx-devel mailing list libopendbx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX -- All of the data generated in your IT infrastructure is seriously valuable. Why? It contains a definitive record of application performance, security threats, fraudulent activity, and more. Splunk takes this data and makes sense of it. IT sense. And common sense. http://p.sf.net/sfu/splunk-d2d-c2 ___ libopendbx-devel mailing list libopendbx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX -- Mariano http://marianopeck.wordpress.com -- All of the data generated in your IT infrastructure is seriously valuable. Why? It contains a definitive record of application performance, security threats, fraudulent activity, and more. Splunk takes this data and makes sense of it. IT sense. And common sense. http://p.sf.net/sfu/splunk-d2d-c2___ libopendbx-devel mailing list libopendbx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX
Re: [opendbx] [Pharo-users] DBXTypeNotSupoorted with Glorp
On Mon, Aug 15, 2011 at 9:59 PM, Alain Rastoul alr@free.fr wrote: ** Hi, I finally found that when called in C with the same api calls that those made by opendbx, sqlite correctly returns datatype of columns when fetching rows, the problem is clearly that the data type is stored in SQueakDBX column description for the resultset the first time it fetches the first row. For sqlite, squeakdbx should call the sqlite api to retrieve column datatype for each row and each colum while fetching data. Hi Alain. I am reading this: http://www.linuxnetworks.de/doc/index.php/OpenDBX/C_API/odbx_column_type From SqueakDBX, we send odbx_column_type ONCE PER RESULTSET. You can see this in #processNextResultSet:querySettings: that for every resultset it sends #processResultWithRows:resultHandle:querySettings: Now should we send odbx_column_type and friends ONCE PER RAW? As far as I can see, in other databases we don't need to do that. But maybe we are wrong and you are right. Norbert? Anyway, if you want to give it a try to Sqlite, what about overwrite #moveNext: in SqlitePlatform and do something to set the new type for every raw. From what I can see, if the type depends on each raw and it should be asked for every raw, then a design change is needed so that we can move the description from the REsultSet to the Raw :) But it may have implications I don't know. Perhaps squeakDbx could get only true object values (are rawValues really needed) ?. Well, it depends on the user needs. Now, a key point is what GLORP should use. Or perhaps another solution would be to call the sqlite api if the stored datatype is UNKNOWN in column description ... (only for sqlite, but sounds like a bad trick) sounds like a hask, but if it works it is at least a valid workaround. I am perplexed ... Any idea is welcome Cheers Alain Mariano Martinez Peck marianop...@gmail.com a écrit dans le message de news: CAA+-=mw69g-mp3fqutj9vvhajrop9ezdv5z0zkv9junyzet...@mail.gmail.com ... On Sat, Aug 13, 2011 at 12:06 AM, Alain Rastoul alr@free.fr wrote: ** It doen't work. Howerver googling for opendbx msg00483, I found http://www.mail-archive.com/libopendbx-devel-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org/msg00483.htmlhttp://www.mail-archive.com/libopendbx-devel-5NWGOfrQmnetEtDZOKyKiw@public.gmane.orgrge.net/msg00483.html yes, that one :) it seems to be the problem of the issue 10, and I think the same problem I have.. yes Sorry, I cannot do more :( Strange that it doesn't work with MSSQL too.. Mariano Martinez Peck marianop...@gmail.com a écrit dans le message de news: CAA+-=mW4rwrLMhMAzsLhQ5zEWZBG_Jg=BF2dKu3wsxw0=io=i...@mail.gmail.com... On Fri, Aug 12, 2011 at 11:14 PM, Alain Rastoul alr@free.fr wrote: ** I used the following script (about 2 months ago I think ) in Pharo 1.3 SqueakDBX Gofer new squeaksource: 'MetacelloRepository'; package: 'ConfigurationOfSqueakDBX'; load. ConfigurationOfSqueakDBX project latestVersion load. GLORP Gofer new squeaksource: 'MetacelloRepository'; package: 'ConfigurationOfGlorpDBX'; load. ConfigurationOfGlorpDBX project latestVersion load. Yes, you are using SqueakDBX ;) you will move soon to DBXTalk :) II use DBXTestCase for my test with the code I send in my email (is it ok for you?), but I will have alook at DBXQueryTest too. No problem to put it in the test suite - it makes me remember that I still didn't send my license agreement to Stephane but I will do it asap... I hate papers ;-) in our case we don't need that ;) http://www.mail-archive.com/libopendbx-devel-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org/msg00483.html The link is broken http://www.mail-archive.com/libopendbx-devel-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org/msg00483.html this one works? -- Mariano http://marianopeck.wordpress.com -- Mariano http://marianopeck.wordpress.com -- Mariano http://marianopeck.wordpress.com -- uberSVN's rich system and user administration capabilities and model configuration take the hassle out of deploying and managing Subversion and the tools developers use with it. Learn more about uberSVN and get a free download at: http://p.sf.net/sfu/wandisco-dev2dev ___ libopendbx-devel mailing list libopendbx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX
Re: [opendbx] [Pharo-users] DBXTypeNotSupoorted with Glorp
And here: http://www.linuxnetworks.de/doc/index.php/OpenDBX/C_API/Usage
I can read:
Processing results
After fetching a row, all values of this row are available for further
processing, as well as their name, length and type - but the name and the
type of a column won't change. Also the number of columns returned by
odbx_column_counthttp://www.linuxnetworks.de/doc/index.php/OpenDBX/API/odbx_column_count()
is fixed for the whole result.
int i;
for( i = 0; i odbx_column_count( result ); i++ )
{
fprintf( stdout, Name: %s\n, odbx_column_name( result, i ) );
fprintf( stdout, Type: %d\n, odbx_column_type( result, i ) );
fprintf( stdout, Length: %d\n, odbx_field_length( result, i ) );
fprintf( stdout, Value: %s\n, odbx_field_value( result, i ) );
}
Besides
odbx_column_typehttp://www.linuxnetworks.de/doc/index.php/OpenDBX/API/odbx_column_type()
these functions don't return error codes. Instead, they return zero (
odbx_field_lengthhttp://www.linuxnetworks.de/doc/index.php/OpenDBX/API/odbx_field_length())
or NULL
(odbx_column_namehttp://www.linuxnetworks.de/doc/index.php/OpenDBX/API/odbx_column_name()
and
odbx_field_lengthhttp://www.linuxnetworks.de/doc/index.php/OpenDBX/API/odbx_field_length()),
but you shouldn't check for those because these values are also valid return
values.
All numbers are returned as strings from the database regardless if they are
integers or floats. If you want to do arithmetic operations, you have to
convert them to their machine dependent binary representation first.
On Mon, Aug 15, 2011 at 11:11 PM, Mariano Martinez Peck
marianop...@gmail.com wrote:
On Mon, Aug 15, 2011 at 9:59 PM, Alain Rastoul alr@free.fr wrote:
**
Hi,
I finally found that when called in C with the same api calls that those
made by opendbx, sqlite correctly returns datatype of columns when fetching
rows, the problem is clearly that the data type is stored in SQueakDBX
column description for the resultset the first time it fetches the first
row.
For sqlite, squeakdbx should call the sqlite api to retrieve column
datatype for each row and each colum while fetching data.
Hi Alain. I am reading this:
http://www.linuxnetworks.de/doc/index.php/OpenDBX/C_API/odbx_column_type
From SqueakDBX, we send odbx_column_type ONCE PER RESULTSET.
You can see this in #processNextResultSet:querySettings: that for every
resultset it sends #processResultWithRows:resultHandle:querySettings:
Now should we send odbx_column_type and friends ONCE PER RAW? As far as
I can see, in other databases we don't need to do that. But maybe we are
wrong and you are right.
Norbert?
Anyway, if you want to give it a try to Sqlite, what about overwrite
#moveNext: in SqlitePlatform and do something to set the new type for every
raw.
From what I can see, if the type depends on each raw and it should be asked
for every raw, then a design change is needed so that we can move the
description from the REsultSet to the Raw :)
But it may have implications I don't know. Perhaps squeakDbx could get
only true object values (are rawValues really needed) ?.
Well, it depends on the user needs. Now, a key point is what GLORP should
use.
Or perhaps another solution would be to call the sqlite api if the
stored datatype is UNKNOWN in column description ... (only for sqlite,
but sounds like a bad trick)
sounds like a hask, but if it works it is at least a valid workaround.
I am perplexed ...
Any idea is welcome
Cheers
Alain
Mariano Martinez Peck marianop...@gmail.com a écrit dans le message
de news:
CAA+-=mw69g-mp3fqutj9vvhajrop9ezdv5z0zkv9junyzet...@mail.gmail.com...
On Sat, Aug 13, 2011 at 12:06 AM, Alain Rastoul alr@free.fr wrote:
**
It doen't work.
Howerver googling for opendbx msg00483, I found
http://www.mail-archive.com/libopendbx-devel-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org/msg00483.htmlhttp://www.mail-archive.com/libopendbx-devel-5NWGOfrQmnetEtDZOKyKiw@public.gmane.orgrge.net/msg00483.html
yes, that one :)
it seems to be the problem of the issue 10, and I think the same
problem I have..
yes
Sorry, I cannot do more :(
Strange that it doesn't work with MSSQL too..
Mariano Martinez Peck marianop...@gmail.com a écrit dans le message
de news:
CAA+-=mW4rwrLMhMAzsLhQ5zEWZBG_Jg=BF2dKu3wsxw0=io=i...@mail.gmail.com...
On Fri, Aug 12, 2011 at 11:14 PM, Alain Rastoul alr@free.fr wrote:
**
I used the following script (about 2 months ago I think ) in Pharo 1.3
SqueakDBX
Gofer new squeaksource: 'MetacelloRepository';
package: 'ConfigurationOfSqueakDBX';
load.
ConfigurationOfSqueakDBX project latestVersion load.
GLORP
Gofer new squeaksource: 'MetacelloRepository';
package: 'ConfigurationOfGlorpDBX';
load.
ConfigurationOfGlorpDBX project latestVersion load.
Yes, you are using SqueakDBX ;) you will move soon to DBXTalk :)
II use DBXTestCase for my test with the code I send in my email (is
it ok
Re: [opendbx] [Pharo-users] DBXTypeNotSupoorted with Glorp
On Tue, Aug 16, 2011 at 10:24 AM, Norbert Sendetzky norb...@linuxnetworks.de wrote: Hi Alain, Mariano Yes, that is what is expected, but in the case of SQLite, the column type changes to SQLITE_NULL for nulls and that is a problem in squeakdbx now. I think column datatype should not be stored in the resultset in the case of sqlite. Other databases don't behave this way (as far as I can remember), so, overriding moveNext for sqlite would probably be fine. SQLite introduces a new data type SQLITE_NULL and unfortunately, the column type changes if NULL values occur - independent of what the real data type of the column is. In all other database libraries, this isn't the case. Thanks Norbert. So, in summary our (SqueakDBX) usage of OpenDBX is correct. Nevertheless, we could adapt the backend for Sqlite in SqueakDBX so that fixes this problem. Norbert -- uberSVN's rich system and user administration capabilities and model configuration take the hassle out of deploying and managing Subversion and the tools developers use with it. Learn more about uberSVN and get a free download at: http://p.sf.net/sfu/wandisco-dev2dev ___ libopendbx-devel mailing list libopendbx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX -- Mariano http://marianopeck.wordpress.com -- uberSVN's rich system and user administration capabilities and model configuration take the hassle out of deploying and managing Subversion and the tools developers use with it. Learn more about uberSVN and get a free download at: http://p.sf.net/sfu/wandisco-dev2dev ___ libopendbx-devel mailing list libopendbx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX
Re: [opendbx] Problems compiling opendbx on windows with latestMinGW and msys
On Mon, Aug 15, 2011 at 12:18 PM, Alain Rastoul alr@free.fr wrote: ** Hi, Just to let you know that I finally solved this problem adding LDFLAGS = -lintl to the sqlite3 backend makefile of opendbx I think a better way to do this would be to add it somwhere in the configure script. Norbert, do you think this should be added to OpenDBX makefiles? Thanks Cheers Alain Alain Rastoul alr.dev-ganu6spq...@public.gmane.org alr@free.fr a écrit dans le message de news: j285sb$mf0$1...@dough.gmane.org... Hi Guillermo Did you solve your compiling problem undefined reference to libintl_dgettext ? I have the same problem trying to build the sqlite3 backend. TIA Alain Guillermo Polito guillermopol...@gmail.com a écrit dans le message de news: CAOBmb50Te7k=xanvfynofmpn-r1ih0qs+u7s9xlpaui4x+fwea-rq2myubu...@public.gmane.orgail.comCAOBmb50Te7k=xanvfynofmpn-r1ih0qs+u7s9xlpaui4x+f...@mail.gmail.com ... Ok, I tried all that without success :S. But, I tried for the second time to use the compiled dlls from the site-I dunno why the first time did not work-, pasting them into Windows\system32, and it worked, so I'm freezing the open dbx building for now. Thanks for all your help, and sorry for the spam :). Guille On Mon, Jul 11, 2011 at 7:42 AM, Mariano Martinez Peck marianop...@gmail.com wrote: Guille I think that a possible solution can be to create the variable $PATH and add it to C:\MinGW\lib\ or to whereever you have the lib folder of mingw. In your $PATH I can see you don't put :/mingw/lib Guille $PATH .:/usr/local/bin:/mingw/bin:/bin:/usr/local/bin:/usr/bin:/c/WINDOWS/system32:/c/WINDOWS:/c/WINDOWS/System32/Wbem:/c/Archivos de programa/QuickTime/QTSystem/:/c/WINDOWS/system32/WindowsPowerShell/v1.0:/c/Archivos de programa/Microsoft SQL Server/90/Tools/binn/:/mingw/bin/ But I do: $ echo $PATH .:/usr/local/bin:/mingw/bin:/bin:/c/oraclexe/app/oracle/product/10.2.0/server/bin:/c/Sybase/OCS-15_0/dll:/c/Sybase/ASE-15_0/jobscheduler/bin:/c/Sybase/ASE-15_0/dll:/c/Sybase/ASE-15_0/bin:/c/Sybase/DBISQL/bin:/c/Sybase/DataAccess/ADONET/dll:/c/Sybase/DataAccess/ODBC/dll:/c/Sybase/DataAccess/OLEDB/dll:/c/Sybase/UAF-2_5/bin:/c/Sybase/OCS-15_0/lib3p:/c/Sybase/OCS-15_0/dll:/c/Sybase/OCS-15_0/bin:/c/SQLServer:/c/mariano/oracle/instantclient_11_1/:/mingw/bin: /mingw/lib:/lib/:/usr/bin:/c/WINDOWS/system32:/c/WINDOWS:/c/WINDOWS/System32/Wbem:/c/Archivos de programa/TortoiseSVN/bin:/c/PostgreSQL/8.3/bin/:/c/Archivos de programa/Microsoft SQL Server/90/Tools/binn/:/c/XEClient/bin:/c/MySQL/bin:/c/Archivos de programa/CMake 2.8/bin:/c/Archivos de programa/Git/cmd:/c/Archivos de programa/Git/bin:/c/Archivos de programa/Cincom/ObjectStudio/dllw32:./dllw32 In addition, maybe we can do something like --disable-nls during ./configure ? tell me if helped On Sat, Jul 9, 2011 at 10:41 PM, Guillermo Polito guillermopol...@gmail.com wrote: Yeap. I'm now trying to use Cygwin instead. I'll tell you if I can succeed :). Thanks! On Sat, Jul 9, 2011 at 5:39 PM, Norbert Sendetzky norb...@linuxnetworks.de wrote: Hi Guille Do you think it's a problem with my minGW instalation? I've also installed the package in http://gnuwin32.sourceforge.net/packages/gettext.htmto see if it makes some difference. Yes, I think so. Did you used the documentation as reference? http://linuxnetworks.de/doc/index.php/OpenDBX/Setup/Windows/Building_with_MinGW Norbert -- All of the data generated in your IT infrastructure is seriously valuable. Why? It contains a definitive record of application performance, security threats, fraudulent activity, and more. Splunk takes this data and makes sense of it. IT sense. And common sense. http://p.sf.net/sfu/splunk-d2d-c2 ___ libopendbx-devel mailing list libopendbx-devel-5nwgofrqmnerv+lv9mx5uipxlwaov...@public.gmane.org https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX -- All of the data generated in your IT infrastructure is seriously valuable. Why? It contains a definitive record of application performance, security threats, fraudulent activity, and more. Splunk takes this data and makes sense of it. IT sense. And common sense. http://p.sf.net/sfu/splunk-d2d-c2 ___ libopendbx-devel mailing list libopendbx-devel-5nwgofrqmnerv+lv9mx5uipxlwaov...@public.gmane.org https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX -- Mariano http://marianopeck.wordpress.com -- All of the data generated in your IT infrastructure is seriously valuable. Why? It contains
Re: [opendbx] OpenDBX in 64 bits
OK, Thanks Norbert. On Wed, Oct 2, 2013 at 12:29 PM, Norbert Sendetzky norb...@linuxnetworks.de wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Mariano Do you know if OpenDBX is working OK with 64 bits? If true, then I guess it also depends on the backend library to know if there is a 64 bits version of if it could be compiled and works with such architecture, right? I haven't tried it yet, but there should be no obstacles in the OpenDBX library itself. Yes, the backend must be a 64 bit version too so it will work. Norbert -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.11 (GNU/Linux) Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/ iQIcBAEBAgAGBQJSTDvnAAoJEA3e3tWv2uU+f3UQALbR2PkznEWbcHZjWwHbWolR sJVA6rIJrAkMtfBGYL3n0fFV19rabK4pqhBHxVnR/CP/2qhE2hrj2fpwk42gAWlI RYyyTWltMaSwSAHSttIbd2/mAW8nsQAdIMhyLTjJ8U5lzaQOyiOeD83EutmyYeRv BUN9s7k9npD4QXgMnGhEtkxO5DuhElNpkNqmCB1v+e5tPOaQNS2i+C/pJGjzc74n 6CljSAyniHLYfJzAzrBZQlgsP/pDV54zWTMswN4P2QBGrf60XW2KsiHMXV4Mhrkg MvemyiocvHM3rXF10U2U+U5i98j3wcdL9qzjVpAhfBLQyhZpWxvBTMuHbl40w1D0 gcWvQYCXDyJGx6Fem1um0byGx/7dTdsRDD3K1j/cBD1jjPseYubBmh/OzTSHYDkk LahXRafjf6cZo49+tv1kDfH2vABNreTOEwYJT/HvAz2UU4amR4jNNy20oYAQz1BX dwnvvdoxYmZeIfOwMn+sgCcBc/wETn8f7wNuA0O7TL3RxxRmcjlLbzoRJ0r3SEQD lswBpc2X5M2gLMRnBUbgIms6drvRW61prFOZ0im01ov6dnpSnUj6Gq8gBEGhAhyv JOwAEjtGwP12vb9MvOv7NR60+cKApB//G4BqwvNh6DHeQm9gu62mhNsQFSqK9eLT B4iRZLfqiUM3G8dhvB9S =P/0C -END PGP SIGNATURE- -- October Webinars: Code for Performance Free Intel webinars can help you accelerate application performance. Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from the latest Intel processors and coprocessors. See abstracts and register http://pubads.g.doubleclick.net/gampad/clk?id=60134791iu=/4140/ostg.clktrk ___ libopendbx-devel mailing list libopendbx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX -- Mariano http://marianopeck.wordpress.com -- October Webinars: Code for Performance Free Intel webinars can help you accelerate application performance. Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from the latest Intel processors and coprocessors. See abstracts and register http://pubads.g.doubleclick.net/gampad/clk?id=60134791iu=/4140/ostg.clktrk___ libopendbx-devel mailing list libopendbx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX
Re: [opendbx] ODBC Connection String
I don't remember. Maybe here is some help: http://forum.world.st/Coming-here-from-the-Pharo-mailing-list-td4641683.html ? Maybe Norbert (OpenDBX author) knows. Did you try specifying all the DBXConnectionSettings with the database, username and password? Best, On Sun, May 4, 2014 at 7:36 PM, Jose Sebastian Calvo fxgall...@gmail.comwrote: Hi, I've read that the preferred method in windows to use MSSQLServer is trough odbc. In Dolphin Smalltalk I can use a connection string to do a dns less connection so there is no need to define an specific DNS in the windows dns manager. e.g. 'UID=my_uid;PWD=my_pwd;DATADABE=my_database' Is there a way to do the same with DBXTalk? Regards Sebastian Calvo -- You received this message because you are subscribed to the Google Groups DBXTalk group. To unsubscribe from this group and stop receiving emails from it, send an email to dbxtalk+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout. -- Mariano http://marianopeck.wordpress.com -- Is your legacy SCM system holding you back? Join Perforce May 7 to find out: #149; 3 signs your SCM is hindering your productivity #149; Requirements for releasing software faster #149; Expert tips and advice for migrating your SCM now http://p.sf.net/sfu/perforce___ libopendbx-devel mailing list libopendbx-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libopendbx-devel http://www.linuxnetworks.de/doc/index.php/OpenDBX
