Re: myodbc driver araise full table scan
Hello. Please, provide more information about your software and oprating system. Include versions of MySQL and MyODBC. See: http://dev.mysql.com/doc/mysql/en/bug-reports.html http://dev.mysql.com/doc/mysql/en/myodbc-bug-report.html chenwei [EMAIL PROTECTED] wrote: i use myodbc to connect to a big table, to my surprise, myodbc araise full table scan and crash. could anybody help me with that? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: myodbc on mandrake
Hello. If you can't find rpms with this driver, you may install it manually. At first you should install unixODBC or iODBC. Then install MyODBC using binary tarball. See: http://dev.mysql.com/doc/mysql/en/myodbc-unix-tarball-installation.html Put the correct information in configuration files. See: http://dev.mysql.com/doc/mysql/en/dsn-on-unix.html symbulos partners [EMAIL PROTECTED] wrote: Dear friends, I cannot locat the odbc driver for mysql in mandrake. Does anyone have an idea about the whereabouts of the thing? thanks in advance -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MyODBC 3.5.9 and MySQL 4.1.8
Have a look at: http://dev.mysql.com/doc/mysql/en/Old_client.html Marc. -Message d'origine- De : nikos [mailto:[EMAIL PROTECTED] Envoyé : mercredi 5 janvier 2005 10:09 À : mysql@lists.mysql.com Objet : MyODBC 3.5.9 and MySQL 4.1.8 Hello list and happy new year. Recently I've install mysql 4.1 on win 2000 with IIS 5 and works perfect. My problem is that when i'm trying to make a connection with myodbc (latest release) as localhost I got the following message: Client does not support authentication protocol requestet by server. Consider upgrading mysql client. MyODBC whorks fine because I 've allready make connection throw lan on a Linux RH-9 with apache and mysql 4.0.22 Any suggestions? Thanky you -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MyODBC 3.5.9 and MySQL 4.1.8
You could also leave the password blank if you don't want to force MySQL to revert to the old password encryption on start-up. This should be fine if your server is in the DMZ and you control all the processes that have access to the server. Unfortunately, 4.2.x breaks backward compatibility with ODBC and many other old clients, including major open source PHP projects. --- Mechain Marc [EMAIL PROTECTED] wrote: Have a look at: http://dev.mysql.com/doc/mysql/en/Old_client.html Marc. -Message d'origine- De : nikos [mailto:[EMAIL PROTECTED] Envoyé : mercredi 5 janvier 2005 10:09 À : mysql@lists.mysql.com Objet : MyODBC 3.5.9 and MySQL 4.1.8 Hello list and happy new year. Recently I've install mysql 4.1 on win 2000 with IIS 5 and works perfect. My problem is that when i'm trying to make a connection with myodbc (latest release) as localhost I got the following message: Client does not support authentication protocol requestet by server. Consider upgrading mysql client. MyODBC whorks fine because I 've allready make connection throw lan on a Linux RH-9 with apache and mysql 4.0.22 Any suggestions? Thanky you -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ Do you Yahoo!? The all-new My Yahoo! - Get yours free! http://my.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MyODBC 3.5.9 and MySQL 4.1.8
Try MyODBC 3.51.10. It supports 4.1 auth. Here is a link to a mirror that has it: http://mysql.netvisao.pt/downloads/connector/odbc/3.51.html --- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -Original Message- From: nikos Sent: Wednesday, January 05, 2005 3:09 AM To: mysql@lists.mysql.com Subject: MyODBC 3.5.9 and MySQL 4.1.8 Hello list and happy new year. Recently I've install mysql 4.1 on win 2000 with IIS 5 and works perfect. My problem is that when i'm trying to make a connection with myodbc (latest release) as localhost I got the following message: Client does not support authentication protocol requestet by server. Consider upgrading mysql client. MyODBC whorks fine because I 've allready make connection throw lan on a Linux RH-9 with apache and mysql 4.0.22 Any suggestions? Thanky you -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MyODBC 3.5.9 and MySQL 4.1.8
Tom, this is awesome! It must have been fresh out of dev because I downloaded 3.51.09 a couple of days ago. I just downloaded it and it works fine with 4.1 authentication. Thanks! --- Tom Crimmins [EMAIL PROTECTED] wrote: Try MyODBC 3.51.10. It supports 4.1 auth. Here is a link to a mirror that has it: http://mysql.netvisao.pt/downloads/connector/odbc/3.51.html --- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -Original Message- From: nikos Sent: Wednesday, January 05, 2005 3:09 AM To: mysql@lists.mysql.com Subject: MyODBC 3.5.9 and MySQL 4.1.8 Hello list and happy new year. Recently I've install mysql 4.1 on win 2000 with IIS 5 and works perfect. My problem is that when i'm trying to make a connection with myodbc (latest release) as localhost I got the following message: Client does not support authentication protocol requestet by server. Consider upgrading mysql client. MyODBC whorks fine because I 've allready make connection throw lan on a Linux RH-9 with apache and mysql 4.0.22 Any suggestions? Thanky you -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ Do you Yahoo!? Meet the all-new My Yahoo! - Try it today! http://my.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MyODBC 3.5.9 and MySQL 4.1.8
I Agree I did downloaded from dev.x MyODBC 3.5.10-x86-win-32bit.exe and it works with MySQL 4xx Thanks Love and regards Prasad - Original Message - From: Homam S.A. [EMAIL PROTECTED] To: Tom Crimmins [EMAIL PROTECTED]; nikos [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Sent: Thursday, January 06, 2005 12:43 AM Subject: RE: MyODBC 3.5.9 and MySQL 4.1.8 Tom, this is awesome! It must have been fresh out of dev because I downloaded 3.51.09 a couple of days ago. I just downloaded it and it works fine with 4.1 authentication. Thanks! --- Tom Crimmins [EMAIL PROTECTED] wrote: Try MyODBC 3.51.10. It supports 4.1 auth. Here is a link to a mirror that has it: http://mysql.netvisao.pt/downloads/connector/odbc/3.51.html --- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -Original Message- From: nikos Sent: Wednesday, January 05, 2005 3:09 AM To: mysql@lists.mysql.com Subject: MyODBC 3.5.9 and MySQL 4.1.8 Hello list and happy new year. Recently I've install mysql 4.1 on win 2000 with IIS 5 and works perfect. My problem is that when i'm trying to make a connection with myodbc (latest release) as localhost I got the following message: Client does not support authentication protocol requestet by server. Consider upgrading mysql client. MyODBC whorks fine because I 've allready make connection throw lan on a Linux RH-9 with apache and mysql 4.0.22 Any suggestions? Thanky you -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ Do you Yahoo!? Meet the all-new My Yahoo! - Try it today! http://my.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MyODBC 3.51.10
You need to set the OLD_PASSWORDS variable in the [MYSQLD] section of the my.ini file. Set-variable = old_passwords=1 It's not the ODBC, but your version of MySQL. 4.0.x uses 1 variant of password hashing, 4.1.x uses a more secure one that will be covered in MyODBC 3.53 (coming soon...). J.R. -Original Message- From: Erich Beyrent [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 04, 2005 2:53 PM To: mysql@lists.mysql.com Subject: MyODBC 3.51.10 I somehow managed to download and install MyODBC 3.51.10 on my XP box, and it connects with no problems to my database server running version 4.1.7. However, it seems that MySQL is only allowing downloads for 3.51.9, and when I installed it on my Server 2003 and attempted to connect, I get the following error: Client does not support authentication protocol requested by server; consider upgrading MySQL client I can only assume it's because of the older driver? Best regards, Erich Beyrent Systems Administrator Information Technology Services Plymouth State University (603) 535-2948 [EMAIL PROTECTED] Si vis pacem para bellum -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MyODBC 3.51.10
You need to set the OLD_PASSWORDS variable in the [MYSQLD] section of the my.ini file. Set-variable = old_passwords=1 It's not the ODBC, but your version of MySQL. 4.0.x uses 1 variant of password hashing, 4.1.x uses a more secure one that will be covered in MyODBC 3.53 (coming soon...). J.R. I did read that in the manual, but I was confused as to why I get the error on one pc and not the other. I am also somewhat confused as to why I have 3.51.10 on one pc, but cannot find it anymore for my other. Did it get pulled from the website? -Erich- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MyODBC 3.51.10
4.1 auth is not supported until MyODBC 3.51.10. I don't know why the win binaries are not on the download page anymore, though the source is there. Here is a mirror with the windows binaries. http://mysql.netvisao.pt/Downloads/MyODBC3/MyODBC-3.51.10-x86-win-32bit.exe --- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -Original Message- From: Erich Beyrent Sent: Tuesday, January 04, 2005 2:53 PM To: 'J.R. Bullington';Subject: RE: MyODBC 3.51.10 You need to set the OLD_PASSWORDS variable in the [MYSQLD] section of the my.ini file. Set-variable = old_passwords=1 It's not the ODBC, but your version of MySQL. 4.0.x uses 1 variant of password hashing, 4.1.x uses a more secure one that will be covered in MyODBC 3.53 (coming soon...). J.R. I did read that in the manual, but I was confused as to why I get the error on one pc and not the other. I am also somewhat confused as to why I have 3.51.10 on one pc, but cannot find it anymore for my other. Did it get pulled from the website? -Erich- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: myODBC connect problems
Annie, Try opening a telnet session from your Win2K box to your Linux box using port 3306. If your MySQL server is there, you will see the version number of your server embedded in some other data. You can either close the connection or wait for it to time out. IF you got your version number, your MySQL server will be visible to your ODBC driver on that port. You can use this telnet trick to ping your MySQL servers on other ports (like 22) as one way to verify that they are bound to the ports they are supposed to be listening on. One other interesting thing about myODBCD 3.51 I discovered is that I had to declare an initial database in order to connect. If you are using the MySQL client you can defer USE-ing a database until after you connect but I couldn't get my drivers to connect without declaring a database in the data source. HTH, Shawn Green Database Administrator Unimin Corporation - Spruce Pine Annie Law [EMAIL PROTECTED]To: [EMAIL PROTECTED] .ca cc: Fax to: 06/08/2004 02:16 Subject: myODBC connect problems PM Hi, I would appreciate help on the following. I have installed myODBC 3.51 on my Windows 2000 computer. I am trying to connect mysql database on a linux server. I configured the ODBC data source adminstrator from the administrative tools. After trying to add a new data source and entering all of the appropriate fields I get the error Lost connection to MySQL server during query The error shows up immediately. The only change I made was to change the port to 22. I use port 22 when I try to make a putty connection or WinSCP. I have no problems connecting to the server when using this method. I also don't have any problems connecting to the database after connecting with putty or using mysqlcc. I tried to used the default method of using port of 3306 and I get an error as well Can't connect to MySQL server on ... I am not sure what the problem is? thanks very much. - Post your free ad now! Yahoo! Canada Personals -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MyODBC and Windows XP
Jos Angel Blanco Linares wrote: Hi, everybody I have in my office two pc machines. One of them is a Pentium III with Windows 98 second edition and MyODBC 3.51.06; the other is a Pentium 4 with Windows XP and MyODBC 2.50.39. The MySQL database is running on a linux server, and via MyODBC I connect to the MySQL server to run my Visual FoxPro desk applications. The problem is: the Pentium III machine loads faster the remote tables than the Pentium IV; or better said: the Pentium IV pc loads very very slow the remote tables. I've tried with the two version of MyODBC, and I've got the same result. What can it be? TIA Have you got ODBC tracing ( or logging or whatever ) turned on on the Pentium 4? It's in your ODBC configuration thing. Under Win 2000 it's in Control Panel == Admin Tools == ODBC. There should be a 'tracing' tab. Don't know where it is under XP. -- signature Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MyODBC and Windows XP
At 19:14 18/3/2004, José Angel Blanco Linares wrote: Hi, Hi, everybody I have in my office two pc machines. One of them is a Pentium III with Windows 98 second edition and MyODBC 3.51.06; the other is a Pentium 4 with Windows XP and MyODBC 2.50.39. The MySQL database is running on a linux server, and via MyODBC I connect to the MySQL server to run my Visual FoxPro desk applications. The problem is: the Pentium III machine loads faster the remote tables than the Pentium IV; or better said: the Pentium IV pc loads very very slow the remote tables. I've tried with the two version of MyODBC, and I've got the same result. What can it be? Great chance is to be the SP 1 on XP, that makes MyODBC loss performance when calling setlocal. In this case the work around is to set on XP the MyODBC flag: don't use setlocale. Regards, For technical support contracts, visit https://order.mysql.com/ Are you MySQL certified?, http://www.mysql.com/certification/ Miguel Angel Solórzano [EMAIL PROTECTED] São Paulo - Brazil -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MyODBC Help
I'm copying this to the list (hope you don't mind). You'll find you get quicker and better responses when all the experts on the list see your question. Plus, someone else may have a similar question and benefit from the answers you get. I've never seen this problem myself, but it looks like a configure error. I'd bet that if you look in your Makefile, you'll see a -L/yes/lib instead of -L/path/to/lib for some library. Perhaps you told configure --with-some-lib rather than --with-some-lib=/path/to/lib? I'd suggest you `make distclean` then try configure/make again. Assuming you get the same error, you could post your configure command and see if anyone can spot what you need to change. Michael Morgan, Andrew R. wrote: Mr. Stassen, Not trying to take advantage of your help this morning, but I wanted to know if you knew the answer to this problem now too. I'm trying to install MyODBC and now I get this error upon 'make': ../libtool[1296]: yes/lib: not found libtool: link: cannot determine absolute directory name of `yes/lib' make[2]: *** [libmyodbc3.la] Error 1 make[2]: Leaving directory `/virtual/MyODBC-3.51.06/driver' make[1]: *** [all] Error 2 make[1]: Leaving directory `/virtual/MyODBC-3.51.06/driver' make: *** [all-recursive] Error 1 Any ideas? Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MyODBC and MySQL 4.1
I know how to grant privileges but the problem is with the password type of mysql 4.1.0 After granting privileges using GRANT (in 4.1.0), I can only login using the mysql client. But I can't use the same username and password for logging in. Nor MyODBC will succeed. But c:\mysql\bin\mysql.exe will login without any problem. I think it's a compatibility issue. Thanks Emery - Original Message - From: abaid al-mutairy To: Director General: NEFACOMP Sent: Saturday, November 29, 2003 08:30 Subject: Re: MyODBC and MySQL 4.1 To create a new user use the Grant command from the mysql command prompt: Mysql GRANT ALL PRIVILEGES ON *.* TO user1@'%' - IDENTIFIED BY 'some_pass' WITH GRANT OPTIONGRANT ALL PRIVILEGES this will allow the user1 with the some_pass to access the database Director General: NEFACOMP [EMAIL PROTECTED] wrote: Hi groups, does anyone know of a way to use myODBC and connect to MySQL 4.1 using its new passwords? When I create a password using PASSWORD( ), I can only login using the MySQL client (the one that comes with MySQL). But if I create the password using OLD_PASSWORD( ), I can login from both my applications and the MySQL client!!! Curious!! The server says: ERROR 1249: Client does not support authentication protocol requested by server. Consider upgrading MySQL client. I received this error when I used - MySQL Front 2.5 - MySQL Control Center 0.9.2 - My Application developped in VB using MyODBC 3.51 to connect I have not yet tried PHP. I searched the archives but found only one people who faced the same problem but I didn't see any message saying that he got a solution. Or simply, is it possible to tell MySQL daemon to use OLD_PASSWORD when encrypting passwords? Any advice? Thanks, __ NZEYIMANA Emery Fabrice NEFA Computing Services, Inc. P.O. Box 5078 Kigali Office Phone: +250-51 11 06 Office Fax: +250-50 15 19 Mobile: +250-08517768 Email: [EMAIL PROTECTED] http://www.nefacomp.net/ -- Do you Yahoo!? Free Pop-Up Blocker - Get it now
Re: MyODBC and MySQL 4.1
I have found the issue. It is talked about at the URL http://www.mysql.com/doc/en/Password_hashing.html The question now is When Will MyODBC support that new hashing? Thanks Emery - Original Message - From: Director General: NEFACOMP [EMAIL PROTECTED] To: abaid al-mutairy [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Saturday, November 29, 2003 13:43 Subject: Re: MyODBC and MySQL 4.1 I know how to grant privileges but the problem is with the password type of mysql 4.1.0 After granting privileges using GRANT (in 4.1.0), I can only login using the mysql client. But I can't use the same username and password for logging in. Nor MyODBC will succeed. But c:\mysql\bin\mysql.exe will login without any problem. I think it's a compatibility issue. Thanks Emery - Original Message - From: abaid al-mutairy To: Director General: NEFACOMP Sent: Saturday, November 29, 2003 08:30 Subject: Re: MyODBC and MySQL 4.1 To create a new user use the Grant command from the mysql command prompt: Mysql GRANT ALL PRIVILEGES ON *.* TO user1@'%' - IDENTIFIED BY 'some_pass' WITH GRANT OPTIONGRANT ALL PRIVILEGES this will allow the user1 with the some_pass to access the database Director General: NEFACOMP [EMAIL PROTECTED] wrote: Hi groups, does anyone know of a way to use myODBC and connect to MySQL 4.1 using its new passwords? When I create a password using PASSWORD( ), I can only login using the MySQL client (the one that comes with MySQL). But if I create the password using OLD_PASSWORD( ), I can login from both my applications and the MySQL client!!! Curious!! The server says: ERROR 1249: Client does not support authentication protocol requested by server. Consider upgrading MySQL client. I received this error when I used - MySQL Front 2.5 - MySQL Control Center 0.9.2 - My Application developped in VB using MyODBC 3.51 to connect I have not yet tried PHP. I searched the archives but found only one people who faced the same problem but I didn't see any message saying that he got a solution. Or simply, is it possible to tell MySQL daemon to use OLD_PASSWORD when encrypting passwords? Any advice? Thanks, __ NZEYIMANA Emery Fabrice NEFA Computing Services, Inc. P.O. Box 5078 Kigali Office Phone: +250-51 11 06 Office Fax: +250-50 15 19 Mobile: +250-08517768 Email: [EMAIL PROTECTED] http://www.nefacomp.net/ -- Do you Yahoo!? Free Pop-Up Blocker - Get it now -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MyODBC and MySQL 4.1
Hi! On Nov 27, Director General: NEFACOMP wrote: Hi groups, does anyone know of a way to use myODBC and connect to MySQL 4.1 using its new passwords? When I create a password using PASSWORD( ), I can only login using the MySQL client (the one that comes with MySQL). But if I create the password using OLD_PASSWORD( ), I can login from both my applications and the MySQL client!!! Curious!! The server says: ERROR 1249: Client does not support authentication protocol requested by server. Consider upgrading MySQL client. I received this error when I used - MySQL Front 2.5 - MySQL Control Center 0.9.2 - My Application developped in VB using MyODBC 3.51 to connect I have not yet tried PHP. I searched the archives but found only one people who faced the same problem but I didn't see any message saying that he got a solution. Or simply, is it possible to tell MySQL daemon to use OLD_PASSWORD when encrypting passwords? yes. --old-passwords switch. Regards, Sergei -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MyODBC 3.51 + Windows Server 2000 = Memory Leak
We're running MyODBC 3.51 on Windows 2000 Ssrver with IIS5 and ColdFusion 5 applications and don't see any memory leaks. In a very hight traffic application, you'll want to keep connections open as long as possible anyway. There's also a MyODBC list that you might try. - Original Message - From: Jon Drukman [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, August 23, 2003 1:26 PM Subject: MyODBC 3.51 + Windows Server 2000 = Memory Leak We have a very high traffic mysql app running in ASP on Windows 2000. It connects to a Linux mysql server (4.0.12) via ADODB and MyODBC. It's leaking memory like crazy. We've implemented connection pooling and long timeouts on connections so as to minimize the number of connects closes, but that is only a band-aid on the problem. Does anyone know how to get MyODBC to run on Windows without leaking memory on open/close? Thanks for any help. -jsd- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MyODBC 3.51 for MySQL 4.1
At 9:54 +0100 6/17/03, [EMAIL PROTECTED] wrote: I am using MySQL 4.1 alpha for windows for new development. Is MyODBC 3.51.06 supposed to work for MySQL 4.1 alpha? I get message [MySQL][ODBC 3.51 Driver]Client does not support authentication protocol requested by server. Consider upgrading MySQL client. Any clue about when MyODBC 3.52 will be released? The MyOLEDB version I am using is 3.0 many thanks, rajendra The authentication protocol and password hashing has changed in 4.1. When you install MySQL 4.1, you should run the server with the --old-passwords option to tell it not to create new-style password hashes. After starting the server this way, you should also change the passwords of any accounts that you created while the server was running without --old-passwords. Otherwise, older clients will not be able to use those accounts. You can recognize which accounts have new-style password hashes by looking in the user table of the mysql database. 16-byte values in the Password column use old hashing, longer values use new hashing. http://www.mysql.com/doc/en/What-to-do-from-4.0.html -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: MyODBC: SQLBindParameter mix DATA_AT_EXEC with direct bound param eters
Hi! thanks for your response. I found my mistake, you pointed me to the right direction. Although I provide different pcbLength buffers for the parameters, I did not initialize the second one. ODBC documentation says, that it will be ignored on integer columns if its not SQL_NULL_DATA. But I should initialize it at least with 0. ;) Next time I post to the appropriate list (myodbc) ;) Frank -Original Message- From: Venu [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 11, 2003 11:03 PM To: Naumann, Frank Cc: '[EMAIL PROTECTED]' Subject: Re: MyODBC: SQLBindParameter mix DATA_AT_EXEC with direct bound param eters On Mon, 2003-03-10 at 09:40, Naumann, Frank wrote: Hi all, Hi !! I found a problem (bug?) when updating a blob column via MyODBC. The statement i run is like that: UPDATE blob_table SET blob_col = ? where id = ? when i do NOT bind the restriction as input parameter, but write it directly in the string, it works perfectly. but when i want to bind the restriction directly, the following happens: 1. I bind the blob_col with SQL_LEN_DATA_AT_EXEC(length) as indikator (SQLBindParameter returns SQL_SUCCESS) 2. I bind the id restriction directly to a program variable (SQLBindParameter returns SQL_SUCCESS) 3. I call SQLExecute, it returns SQL_NEED_DATA as expected. 4. I call SQLParamData to access the blob_col, it returns also SQL_NEED_DATA as expected. 5. I call several times SQLPutData to fill the blob_col, each returns with SQL_SUCCESS 6. I call SQLParamData to indicate that the blob_col is populated with data completely and would expect SQL_SUCCESS. I just tested it, and it returns SQL_SUCCESS unless if you have more parameters data to be supplied during the run-time. Possible reason could be, you might have specified the same pcbLength buffer to all parameters in SQLBindParameter. Here is a simple snippet from the test suite for the similar case: .. .. rc = SQLPrepare(hstmt,update t_putdata set c2= ? where c1 = ?,SQL_NTS); mystmt(hstmt,rc); rc = SQLBindParameter(hstmt,1,SQL_PARAM_INPUT,SQL_C_CHAR, SQL_LONGVARCHAR,0,0, (SQLPOINTER)1,0,pcbLength); rc = SQLBindParameter(hstmt,2,SQL_PARAM_INPUT,SQL_C_LONG, SQL_INTEGER,0,0,c1,0,NULL); pcbLength = SQL_LEN_DATA_AT_EXEC(0); c1 = 10; rc = SQLExecute(hstmt); myassert(rc == SQL_NEED_DATA); rc = SQLParamData(hstmt, token); myassert(rc == SQL_NEED_DATA); strcpy(data,mysql ab); rc = SQLPutData(hstmt,data,6); mystmt(hstmt,rc); strcpy(data,- the open source database company); rc = SQLPutData(hstmt,data,strlen(data)); mystmt(hstmt,rc); rc = SQLParamData(hstmt, token); mystmt(hstmt,rc); SQLFreeStmt(hstmt, SQL_RESET_PARAMS); SQLFreeStmt(hstmt, SQL_CLOSE); .. .. The data updated is: data: mysql - the open source database company(40) Thanks -- Regards, Venu For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ Palo Alto, CA-94306, USA ___/ www.mysql.com Join MySQL Users Conference and Expo: http://www.mysql.com/events/uc2003/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MyODBC: SQLBindParameter mix DATA_AT_EXEC with direct boundparam eters
On Mon, 2003-03-10 at 09:40, Naumann, Frank wrote: Hi all, Hi !! I found a problem (bug?) when updating a blob column via MyODBC. The statement i run is like that: UPDATE blob_table SET blob_col = ? where id = ? when i do NOT bind the restriction as input parameter, but write it directly in the string, it works perfectly. but when i want to bind the restriction directly, the following happens: 1. I bind the blob_col with SQL_LEN_DATA_AT_EXEC(length) as indikator (SQLBindParameter returns SQL_SUCCESS) 2. I bind the id restriction directly to a program variable (SQLBindParameter returns SQL_SUCCESS) 3. I call SQLExecute, it returns SQL_NEED_DATA as expected. 4. I call SQLParamData to access the blob_col, it returns also SQL_NEED_DATA as expected. 5. I call several times SQLPutData to fill the blob_col, each returns with SQL_SUCCESS 6. I call SQLParamData to indicate that the blob_col is populated with data completely and would expect SQL_SUCCESS. I just tested it, and it returns SQL_SUCCESS unless if you have more parameters data to be supplied during the run-time. Possible reason could be, you might have specified the same pcbLength buffer to all parameters in SQLBindParameter. Here is a simple snippet from the test suite for the similar case: .. .. rc = SQLPrepare(hstmt,update t_putdata set c2= ? where c1 = ?,SQL_NTS); mystmt(hstmt,rc); rc = SQLBindParameter(hstmt,1,SQL_PARAM_INPUT,SQL_C_CHAR, SQL_LONGVARCHAR,0,0, (SQLPOINTER)1,0,pcbLength); rc = SQLBindParameter(hstmt,2,SQL_PARAM_INPUT,SQL_C_LONG, SQL_INTEGER,0,0,c1,0,NULL); pcbLength = SQL_LEN_DATA_AT_EXEC(0); c1 = 10; rc = SQLExecute(hstmt); myassert(rc == SQL_NEED_DATA); rc = SQLParamData(hstmt, token); myassert(rc == SQL_NEED_DATA); strcpy(data,mysql ab); rc = SQLPutData(hstmt,data,6); mystmt(hstmt,rc); strcpy(data,- the open source database company); rc = SQLPutData(hstmt,data,strlen(data)); mystmt(hstmt,rc); rc = SQLParamData(hstmt, token); mystmt(hstmt,rc); SQLFreeStmt(hstmt, SQL_RESET_PARAMS); SQLFreeStmt(hstmt, SQL_CLOSE); .. .. The data updated is: data: mysql - the open source database company(40) Thanks -- Regards, Venu For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ Palo Alto, CA-94306, USA ___/ www.mysql.com Join MySQL Users Conference and Expo: http://www.mysql.com/events/uc2003/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MyODBC 3.51 - Memory allocation error with BLOBs
On Sun, 2003-03-02 at 21:19, Aaron O'Neil wrote: How-To-Repeat: I suspect there is a bug in the ODBC driver in relation to blobs. I'm now using 3.51.06, but was having this same problem on 3.51.05. I'm using Visual C++ and their CRecordset wrapper for the ODBC calls. I'm using the positioned updates. As long as I keep the binary data I'm trying to transfer under the default buffer size (8192) it works fine. I'm guessing it is a default buffer size from looking at the debug text. Here is the output info from setting a binary field that works, the data for the binary field is 6933, less than the 8192. Thanks for the clear report. I just tested this, and noticed that this is happening only with the debug version of the driver and not with the release version, and thats why it wasn't even caught with the regression test suite before the releases. Did you tested this with the release version of the driver ? If yes, what was the outcome. I will investigate and fix why 'my_realloc' is crashing if using the debug version of the MySQL client libraries. Thanks SQLSetPos | enter: irow: 1 fOption: SQL_UPDATE Lock: 0 | init_dynamic_string | | _mymalloc | | | enter: Size: 1024 | | | exit: ptr: 11ae198 | | _mymalloc | init_dynamic_string | find_used_table | | _mymalloc | | | enter: Size: 8 | | | exit: ptr: 10238a8 | | _mymalloc | find_used_table | dynstr_realloc | dynstr_realloc | dynstr_realloc | dynstr_realloc | extend_buffer | | enter: current_length: 0 length: 6934 buffer_length: 8192 | extend_buffer | info: param: 0x12eddc ctype: -2 SqlType: -4 data: 0x1412c58 length: 6933 actual_len: 6933 pos_in_query: 00FCF764 | info: param: 0x12eddc ctype: 1 SqlType: 4 data: 0xfced54 length: 1 actual_len: 1 pos_in_query: 00FCF764 That above works just fine. Here is what happens whenever I try to set binary data 8192: SQLSetPos | enter: irow: 1 fOption: SQL_UPDATE Lock: 0 | init_dynamic_string | | _mymalloc | | | enter: Size: 1024 | | | exit: ptr: 11ae198 | | _mymalloc | init_dynamic_string | find_used_table | | _mymalloc | | | enter: Size: 8 | | | exit: ptr: 1023808 | | _mymalloc | find_used_table | dynstr_realloc | dynstr_realloc | dynstr_realloc | dynstr_realloc | extend_buffer | | enter: current_length: 0 length: 11016 buffer_length: 8192 | | _myrealloc | | | _mymalloc | | | | enter: Size: 16384 | | | | exit: ptr: 11ae5f0 | | | _mymalloc | | | _myfree | | | | enter: ptr: f37d58 | | | _myfree | | _myrealloc | extend_buffer | info: param: 0x12eddc ctype: -2 SqlType: -4 data: 0x1412d30 length: 11015 actual_len: 11015 pos_in_query: 00FCF764 | extend_buffer | | enter: current_length: 2582681 length: 11527 buffer_length: 8192 | | _myrealloc | | | safe: Reallocating unallocated data at line 145, 'execute.c' | | _myrealloc | extend_buffer | copy_error | | error: code :4001, state: S1001, err :(null) | | exit : SQL_ERROR This happens every time I try to store more than 8192 bytes. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Regards, Venu For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ Palo Alto, CA-94306, USA ___/ www.mysql.com Join MySQL Users Conference and Expo: http://www.mysql.com/events/uc2003/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: myODBC, if left alone, can lock up an Access table
-Original Message- From: Steve Quezadas [mailto:[EMAIL PROTECTED]] I notice that sometimes when I establish a connection with myODBC with Microsoft Access, and send it occasional sql statements it works fine at first. But if you let it sit for, say, 30 minutes and comes back, the Access table locks up. I am not sure if this is a problem with myODBC (which I would report to this mailling list) or a problem with Access itself (thus I would have to report it to the Access newsgroup). Anyways, this problem is kinda annoying because the only way I can get out of it is if I force-quit Access. I haven't seen this problem. The only time I've had to force-quit Access was if I changed a table definition or restarted MySQL while Access was open -- this tends to put it in an infinite loop. (Great error handling, Microsoft!) Maybe someone can help you out more of you provide more details of your setup? MySQL, MyODBC, and Access versions, operating system of the clients, etc. Linked tables, or direct access via VBA? Anything else unusual? FWIW, we're using Windows NT 4.0, Access 2000, and MyODBC 2.50.39. We're using linked tables. We haven't had any problems that weren't covered by the MyODBC FAQ. I highly recommend following their recommendation of adding a TIMESTAMP column to each table, it fixed the flakiness we were having with disappearing records and locked tables. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MyODBC with text files
I think you need the ODBC driver for plain text files to do so. It is generally installed in Win32, but I do not know about Linux. As to use MyODBC for that, I do not think it will work. HTH JFernando ** sql ** -Original Message- From: Nikola Pentchev (ESA) [mailto:[EMAIL PROTECTED]] Sent: December 20, 2002 02:11 To: '[EMAIL PROTECTED]' Subject: MyODBC with text files Hello, I am writing this e-mail just to ask about the following: I plan to implement some data storage in flat ASCII files. I want to work with SQL in order to automate requests from/to the files. Can I use MyODBC in order to work against flat files? If yes, what do I need to install (can I just install MyODBC and use the C API)? I am working on Solaris 8 Thanks Nikola Pentchev Lead Designer Ericsson South Africa (Pty) Ltd Tel: +27 11 844 2254 Fax: +27 11 844 2279 Mobile: +27 83 222 6063 ECN: 820 2254 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MyODBC with iODBC on Mac OSX 10.2 Jaguar
Tarin wrote: Has anyone had any success in building the MySQL ODBC 3.51 Driver (formerly MyODBC) against iODBC on Mac OSX 10.2 Jaguar? Specifically, I would like to use the MySQL ODBC 3.51.04 Driver built using the iODBC Unix libraries, rather than the iODBC frameworks available on OSX through OpenLink. Has anyone had any success in building this target? One of my main problems is that one of the prerequisites of building MyODBC is that MySQL's libmysqlclient library must be installed as a shared library, but the binary distribution of MySQL for 10.2 does not include a shared version, only a static one. I cannot seem to get any success building a shared version of this library from the source distribution of MySQL on OSX 10.2. If anyone has any ideas, advice or comments, I'd really appreciate it. Thanks! Hi !! What type of errors are you getting while building the driver as well as building mysql shared libraries. I built on HP 10 and 11 without any problems along with mysql shared ones. From next release onwards, I will also include the client shared libraries for download along with the driver. In case if you need client shared libs for HP 10/11, please let me know, I can provide you the link to download. Did you had any chance to test with the MyODBC 3.51.04 HP 10 binaries from the main download site ? Thanks. Tarin Haig. PS: Please forgive me if any of this doesn't make sense - I'm very new to the world of MySQL. -- Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ Palo Alto, CA-94306 ___/ www.mysql.com USA - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: myodbc prolbems between linux windows
I found the following statement in my mysql.server script, and I changed it back to default... (the howto at tldp.org had me put this in, and I had forgotten about it) $bindir/safe_mysqld --datadir=$datadir --pid-file=$pid_file --bind-address= 127.0.0.1 $bindir/safe_mysqld --datadir=$datadir --pid-file=$pid_file now when I try to connect I get the following error message when I an initially trying to connect to the table;Lost connect to MySQL server during query linux box is 192.168.0.1 and my win2k box is 192.168.0.2 and 192.168.0.3. this is the permissions that I have granted. Host Db User 192.168.0.ntsmaster mysql (all privileges selected) - Original Message - From: John Jacques To: Jeff Bluemel Sent: Saturday, October 05, 2002 6:26 PM Subject: Re: myodbc prolbems between linux windows Ha, I don't recall either, but I used it all the time when I ran a linux server. I think it is nets, or netstat, or netstats then there are options like netstat -u or -n and such. man netstat I think it is netstat. Jeff Bluemel wrote: John - let me ask a stupid quesiton - I cannot remember the command to pull that up. I thought it was net stats, but that command is not recognized on my linux box... Jeff - Original Message - From: John Jacques [EMAIL PROTECTED] To: Jeff Bluemel [EMAIL PROTECTED] Sent: Friday, October 04, 2002 4:50 PM Subject: Re: myodbc prolbems between linux windows do you mean 192.168.1.0? What is the IP address of the Linux box? Is the Linux box listening for connections and on the same port # that Windows is trying to connect to? It's on an internal network, so what is the IP of the linux box and do you have that AND the port # in the ODBC connection information? So, the 1st step is to check the net stats on the linux box and verify that it is listening on that port and you are using the correct IP address to connect to. John Jeff Bluemel wrote: I had gotten some feedback on this, but I still do not have enough information on this to resolve it. the initial thoughts comments I got from people the believed it was a connectivity problem. this is on an internal network. the linux box has shared drives I use all day everyday with no problems, telnet between the 2, ftp, web applications. there is no firewall or restrictions between the 2 computers, and I can connect to mysql on the localhost (which is the linux box). I am using the myodbc driver. I am completely stuck on this, and I cannot figure out how to resolve this. I have mysql on a linux box (IP 192.168.0.1), and I've got a windows 2000 box that I am trying to connect to with with odbc. I am getting the following error message [MySQL AB][MyODBC] ERROR : Can't connect to MySQL server on 192.168.0.1 (10061) Jeff Bluemel Jeff Bluemel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MyODBC Error
Nitesh, Tuesday, July 16, 2002, 3:46:39 AM, you wrote: ND I have my MySql 3.23 running, I installed MyODBC in my Win98 PC and created a DSN for MySql. ND When I use MS Access to connect to MySql I get an Error saying Host 192.168.1.103 is not allowed to connect to this MySql Server. ND I also tried connecting using telnet 192.168.1.109 3306 I get the same error. You don't have permissions to connect from host 192.168.1.103. Take a look at: http://www.mysql.com/doc/G/R/GRANT.html http://www.mysql.com/doc/P/r/Privileges.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MyODBC Error
Look at the GRANT documentation to see how mysql authenticates using host and user. -Original Message- From: Nitesh Divecha [mailto:[EMAIL PROTECTED]] Sent: Monday, July 15, 2002 5:47 PM To: [EMAIL PROTECTED] Subject: MyODBC Error Sensitivity: Confidential Hello All, I have my MySql 3.23 running, I installed MyODBC in my Win98 PC and created a DSN for MySql. When I use MS Access to connect to MySql I get an Error saying Host 192.168.1.103 is not allowed to connect to this MySql Server. I also tried connecting using telnet 192.168.1.109 3306 I get the same error. Please help, thanking you in advance. Regards Nitesh - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MyODBC DSN Configuration Dialog Hidden
Hi , -Original Message- From: mySQL list [mailto:[EMAIL PROTECTED]] Sent: Friday, June 07, 2002 2:35 AM To: [EMAIL PROTECTED] Subject: MyODBC DSN Configuration Dialog Hidden Hi, I have a vb application which connects to mysql via ado/myodbc 3.51.03. In it, users can choose to connect to databases on different machines. I construct a connection string from the hostname, database etc. So far so good. The problem I have only occurs (as far as I can tell) on Windows XP, not Windows 2000: If I try and connect to a host where mysql is not running, the driver pops up an error message box, saying [MySQL][ODBC 3.51 Driver] Can't connect to MySQL server on 'hostname' (10061), then after clicking ok, the DSN Configuration Dialog is opened, but hidden behind the application window. In contrast, on Windows 2000, no error message box or dsn dialog appears at all (which I prefer). You can disable the re-connect prompt in ado by using DriverNoPrompt option from your conn.open method. You can also disable the prompt during the failed connection from the DSN using the option 'Don't prompt on connect'. And as far as hidden dialog, am not sure how does that come in to picture as we use XP and 2000 for all internal testing. Can you cross check whether the dialog is really active by using 'alt-tab' ? Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MyODBC DSN Configuration Dialog Hidden
Hi Venu, The problem I have only occurs (as far as I can tell) on Windows XP, not Windows 2000: If I try and connect to a host where mysql is not running, the driver pops up an error message box, saying [MySQL][ODBC 3.51 Driver] Can't connect to MySQL server on 'hostname' (10061), then after clicking ok, the DSN Configuration Dialog is opened, but hidden behind the application window. In contrast, on Windows 2000, no error message box or dsn dialog appears at all (which I prefer). You can disable the re-connect prompt in ado by using DriverNoPrompt option from your conn.open method. I can't find any option to use DriverNoPrompt in ADO, only DAO, unless you mean in the OPTION= part of the connection string. Originally I had OPTION=35, I've tried OPTION=51 (adding 16 which should disable any prompts), but its just the same. You can also disable the prompt during the failed connection from the DSN using the option 'Don't prompt on connect'. And as far as hidden dialog, am not sure how does that come in to picture as we use XP and 2000 for all internal testing. Can you cross check whether the dialog is really active by using 'alt-tab' ? Yes it is there - alt-tab brings it to the front (and the Don't prompt on connect checkbox is set when I use OPTION=51). Regards, Ian Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: [MyODBC]Access denied for user: 'ODBC@localhost'
ok, rebooting didn't fix it, reinstalling myodbc didn't fix it, creating a user ODBC@localhost fixed it. all off a sudden i need a user named ODBC@localhost, and last i checked, i'm the only one here that knows anything about how to use mysql here at the office. so what might have been changed that would cause this. MyODBC has the correct username/password for the databases it uses. MS Access can open the ODBC databases without any problems (before i created the ODBC@localhost) its only the web server that seems to need the user. (ColdFusion PHP) and how do i change it back to not need the odbc@localhost user anymore (again)? and it turns out (just to mislead me even more...) Mozilla 1.0 running on linux isn't working correctly with phpmyadmin using cookie auth. (don't know if its just me, or just mozilla...) after login in, it shows me 2 frames, both with login screens. On Thursday 06 June 2002 8:39, you wrote: Error Occurred While Processing Request Error Diagnostic Information ODBC Error Code = S1000 (General error) [TCX][MyODBC]Access denied for user: 'ODBC@localhost' (Using password: NO) The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (3:1) to (4:39). Date/Time: 06/06/02 06:34:43 Browser: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.0.0) Gecko/20020529 it was working fine yesterday... what is probably the problem? also i can't use phpMyAdmin anymore from the same machine. i can use the command line mysql just fine though. its running off of a win2k machine - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- To one large turkey add one gallon of vermouth and a demijohn of Angostura bitters. Shake. -- F. Scott Fitzgerald, recipe for turkey cocktail. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: [MyODBC]Access denied for user: 'ODBC@localhost'
Ray, Thursday, June 06, 2002, 4:39:11 PM, you wrote: R Error Occurred While Processing Request R Error Diagnostic Information R ODBC Error Code = S1000 (General error) R [TCX][MyODBC]Access denied for user: 'ODBC@localhost' (Using password: NO) R The error occurred while processing an element with a general identifier of R (CFQUERY), occupying document position (3:1) to (4:39). R Date/Time: 06/06/02 06:34:43 R Browser: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.0.0) Gecko/20020529 R it was working fine yesterday... what is probably the problem? R also i can't use phpMyAdmin anymore from the same machine. i can use the R command line mysql just fine though. If you can connect with command line client but connection fails with phpMyAdmin and MyODBC it's probably wrong connection parameters. Please, check you DSN. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: [MyODBC]Access denied for user: 'ODBC@localhost'
in the DSN settings, each datasource has a different username and password. and looking over the DSNs, none of them should be using the username ODBC@localhost. On Thursday 06 June 2002 9:18, you wrote: Ray, Thursday, June 06, 2002, 4:39:11 PM, you wrote: R Error Occurred While Processing Request R Error Diagnostic Information R ODBC Error Code = S1000 (General error) R [TCX][MyODBC]Access denied for user: 'ODBC@localhost' (Using password: NO) R The error occurred while processing an element with a general identifier of R (CFQUERY), occupying document position (3:1) to (4:39). R Date/Time: 06/06/02 06:34:43 R Browser: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.0.0) Gecko/20020529 R it was working fine yesterday... what is probably the problem? R also i can't use phpMyAdmin anymore from the same machine. i can use the R command line mysql just fine though. If you can connect with command line client but connection fails with phpMyAdmin and MyODBC it's probably wrong connection parameters. Please, check you DSN. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MyODBC connection to Linux MySQL
yvon, Monday, May 27, 2002, 11:33:42 PM, you wrote: yd I tried to connect to a mysql database running on a yd linux server using an odbc connection in windows 98. I yd get the following message: yd [TCX][MyODBC]Host x.x.x.x is not allowed to connect to yd this MySQL server yd (#1130)[Microsoft][ODBC Driver Manager] Connection not yd open (#0) yd The username specified in the data source name is root yd and I can ping the server where MySQLis running. yd What did I do wrong or did not do at all on client or yd server side? Your root user has a problem with privileges. 'root' doesn't have privilege to connect from the host. You should allow user to connect from your host. Check it: http://www.mysql.com/doc/A/c/Access_denied.html yd Plase help me. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MyODBC Question
Hi, -Original Message- From: David M. Peak [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 30, 2002 12:35 PM To: [EMAIL PROTECTED] Subject: MyODBC Question I have a question about MyODBC and the results of SQLGetTypeInfo from a table with a column of type TEXT. The results show that the column is of type VARCHAR with a length of 255. Is there a way to show the true datatype? The MySQL that I'm running is 3.23.36. That is supposed to be for the fix for invalid mapping of SET and enum types from other vendors while migrating (MSSQL, ACCESS, DTS and all conversion tools), else the behaviour is not expected. One magic here is that, if you set this to CHAR(..) then the Access 97 works, and if it is VARCHAR(..) then All other ACCESS (98, 2000, XP) works, but 97 fails. We are trying to fix this issue in next versions to have a common procedure by allowing TEXT type to accept field size. Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MyODBC Question
So what is the best way to store information in a MySQL database through MyODBC that is of a character type that is greater that 255 chars? BLOB? - Original Message - From: Venu [EMAIL PROTECTED] To: 'David M. Peak' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, April 30, 2002 2:17 PM Subject: RE: MyODBC Question Hi, -Original Message- From: David M. Peak [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 30, 2002 12:35 PM To: [EMAIL PROTECTED] Subject: MyODBC Question I have a question about MyODBC and the results of SQLGetTypeInfo from a table with a column of type TEXT. The results show that the column is of type VARCHAR with a length of 255. Is there a way to show the true datatype? The MySQL that I'm running is 3.23.36. That is supposed to be for the fix for invalid mapping of SET and enum types from other vendors while migrating (MSSQL, ACCESS, DTS and all conversion tools), else the behaviour is not expected. One magic here is that, if you set this to CHAR(..) then the Access 97 works, and if it is VARCHAR(..) then All other ACCESS (98, 2000, XP) works, but 97 fails. We are trying to fix this issue in next versions to have a common procedure by allowing TEXT type to accept field size. Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MyODBC Question
Hi, -Original Message- From: David M. Peak [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 30, 2002 2:44 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: MyODBC Question So what is the best way to store information in a MySQL database through MyODBC that is of a character type that is greater that 255 chars? BLOB? You can always make use of TEXT, MEDIUM TEXT, LONG VARCHAR, .. and similarly for BLOBs. Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MyODBC Question
I don't mean to beat a dead horse here, but when the backend checks the length of the datatype for the columns to prepare the statment, the TEXT column comes back as length of 255 so my 1,500 char string gets cut off. Is there a datatype that the MyODBC driver will return as character data greater than 255? - Original Message - From: Venu [EMAIL PROTECTED] To: 'David M. Peak' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, April 30, 2002 2:45 PM Subject: RE: MyODBC Question Hi, -Original Message- From: David M. Peak [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 30, 2002 2:44 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: MyODBC Question So what is the best way to store information in a MySQL database through MyODBC that is of a character type that is greater that 255 chars? BLOB? You can always make use of TEXT, MEDIUM TEXT, LONG VARCHAR, .. and similarly for BLOBs. Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MyODBC Question
Hi, Please call SQLGetTypeInfo with SQL_LONGVARCHAR, then you get the results what is expected. Here is the output snippet: SQLGetTypeInfo: In: StatementHandle = 0x003A1960, DataType = SQL_LONGVARCHAR=-1 Return: SQL_SUCCESS=0 Get Data All: .. long varchar, -1, 16777215, text, -1, 65535, mediumtext, -1, 16777215, 3 rows fetched from 19 columns. SQLGetTypeInfo: In: StatementHandle = 0x003A1960, DataType = SQL_LONGVARBINARY=-4 Return: SQL_SUCCESS=0 Get Data All: .. long varbinary, -4, 16777215, blob, -4, 65535, longblob, -4, 2147483647, tinyblob, -4, 255, mediumblob, -4, 16777215 5 rows fetched from 19 columns. Ok, also, you said you got TEXT max size as 255 in the prepares, do you have any log on that ? Because the driver won't return the length as 255. The mapping in SQLGetTypeInfo is intended for SET and ENUM not for direct TEXT, so it won't affect what you are describing. You can see that the TEXT deals separatly in the same SQL_GET_TYPE_INFO_values which returns the max length as 65535. Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.com -Original Message- From: David M. Peak [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 30, 2002 2:59 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: MyODBC Question I don't mean to beat a dead horse here, but when the backend checks the length of the datatype for the columns to prepare the statment, the TEXT column comes back as length of 255 so my 1,500 char string gets cut off. Is there a datatype that the MyODBC driver will return as character data greater than 255? - Original Message - From: Venu [EMAIL PROTECTED] To: 'David M. Peak' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, April 30, 2002 2:45 PM Subject: RE: MyODBC Question Hi, -Original Message- From: David M. Peak [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 30, 2002 2:44 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: MyODBC Question So what is the best way to store information in a MySQL database through MyODBC that is of a character type that is greater that 255 chars? BLOB? You can always make use of TEXT, MEDIUM TEXT, LONG VARCHAR, .. and similarly for BLOBs. Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MyODBC multiple connection
I am writing web page using VB script ASP, and cannot work with MyODBC 2.5 of MySQL but can work with 3.5.1 the previous problem is : I made a page using ASP MyODBC, it is working then I try multiple connection, the second trial to open the page failed with a disastrous error do anyone know why? thanks Borus - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MyODBC arrrgghh!
The mysql.user table requires an entry corresponding to user@IP/hostname corresponding to the XPwkst w/ODBC. -Original Message- From: Andrew Hazen [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 18, 2002 11:02 AM To: [EMAIL PROTECTED] Subject: MyODBC arrrgghh! Alright, I'm feeling pretty clueless on this one. I've downloaded and installed MyODBC. I am trying to go from my local WinXP to my database on a unix/apache webserver. (I want to use CodeCharge to build a site). I have asked my ISP to grant remote access and he says he has. I can access from a phpMyAdmin on one webserver to a db on the other webserver fine. But when I try to access with ODBC, using the same username/password it's no go. mysql;mysql; Andrew Hazen, O.C.P. E-Commerce Developer Jatech Solutions Inc. www.jatech.ca Specializing in OSCOMMERCE applications and PHP/MySQL programming. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MyODBC arrrgghh!
Here's the basics for MySQL database access (seven lines total:
use mysql;
create database myDB;
insert into db values ('myHOST.myDOMAIN.com', 'myDB', 'myUSER',
'Y','Y','Y','Y','N','N','N','N','N','N');
insert into user values ('localhost','myUSER', Password ('myPASSWD'), 'Y',
'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y');
insert into user values ('myHOST.myDOMAIN.com', 'myUSER', Password
('myPASSWD'), 'Y', 'Y', 'Y', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N',
'N', 'N');
insert into user values ('myIP', 'myUSER', Password ('myPASSWD'), 'Y', 'Y',
'Y', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N');
quit
-Original Message-
From: Land, Christopher [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 18, 2002 11:26 AM
To: Andrew Hazen; [EMAIL PROTECTED]
Subject: RE: MyODBC arrrgghh!
The mysql.user table requires an entry corresponding to user@IP/hostname
corresponding to the XPwkst w/ODBC.
-Original Message-
From: Andrew Hazen [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 18, 2002 11:02 AM
To: [EMAIL PROTECTED]
Subject: MyODBC arrrgghh!
Alright, I'm feeling pretty clueless on this one.
I've downloaded and installed MyODBC.
I am trying to go from my local WinXP to my database on a unix/apache
webserver. (I want to use CodeCharge to build a site).
I have asked my ISP to grant remote access and he says he has. I can
access from a phpMyAdmin on one webserver to a db on the other webserver
fine. But when I try to access with ODBC, using the same
username/password it's no go.
mysql;mysql;
Andrew Hazen, O.C.P.
E-Commerce Developer
Jatech Solutions Inc.
www.jatech.ca
Specializing in OSCOMMERCE applications and PHP/MySQL programming.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MyODBC arrrgghh!
Your workstation is 192.168.1.101:
insert into user values ('192.168.1.101', 'myUSER', Password
('myPASSWD'), 'Y', 'Y', 'Y', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N',
'N', 'N');
Allow class C network access with:
insert into user values ('192.168.1.%', 'netUSER', Password
('netPASSWD'), 'Y', 'Y', 'Y', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N',
'N', 'N');
OR
insert into user values ('%.indominion.com', 'hostUSER', Password
('hostPASSWD'), 'Y', 'Y', 'Y', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N',
'N', 'N');
C:~
-Original Message-
From: Land, Christopher [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 18, 2002 12:01 PM
To: [EMAIL PROTECTED]
Subject: RE: MyODBC arrrgghh!
Here's the basics for MySQL database access (seven lines total:
use mysql;
create database myDB;
insert into db values ('myHOST.myDOMAIN.com', 'myDB', 'myUSER',
'Y','Y','Y','Y','N','N','N','N','N','N');
insert into user values ('localhost','myUSER', Password ('myPASSWD'), 'Y',
'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y');
insert into user values ('myHOST.myDOMAIN.com', 'myUSER', Password
('myPASSWD'), 'Y', 'Y', 'Y', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N',
'N', 'N');
insert into user values ('myIP', 'myUSER', Password ('myPASSWD'), 'Y', 'Y',
'Y', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N');
quit
-Original Message-
From: Land, Christopher [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 18, 2002 11:26 AM
To: Andrew Hazen; [EMAIL PROTECTED]
Subject: RE: MyODBC arrrgghh!
The mysql.user table requires an entry corresponding to user@IP/hostname
corresponding to the XPwkst w/ODBC.
-Original Message-
From: Andrew Hazen [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 18, 2002 11:02 AM
To: [EMAIL PROTECTED]
Subject: MyODBC arrrgghh!
Alright, I'm feeling pretty clueless on this one.
I've downloaded and installed MyODBC.
I am trying to go from my local WinXP to my database on a unix/apache
webserver. (I want to use CodeCharge to build a site).
I have asked my ISP to grant remote access and he says he has. I can
access from a phpMyAdmin on one webserver to a db on the other webserver
fine. But when I try to access with ODBC, using the same
username/password it's no go.
mysql;mysql;
Andrew Hazen, O.C.P.
E-Commerce Developer
Jatech Solutions Inc.
www.jatech.ca
Specializing in OSCOMMERCE applications and PHP/MySQL programming.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MyODBC arrrgghh!
Well go figure. Seems like our firewall is blocking things. Guess I'll
have to run local for development.
Thanks for your help.
Andrew Hazen
-Original Message-
From: Land, Christopher [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 18, 2002 3:12 PM
To: [EMAIL PROTECTED]
Subject: RE: MyODBC arrrgghh!
Your workstation is 192.168.1.101:
insert into user values ('192.168.1.101', 'myUSER', Password
('myPASSWD'), 'Y', 'Y', 'Y', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', 'N',
'N',
'N', 'N');
Allow class C network access with:
insert into user values ('192.168.1.%', 'netUSER', Password
('netPASSWD'), 'Y', 'Y', 'Y', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', 'N',
'N',
'N', 'N');
OR
insert into user values ('%.indominion.com', 'hostUSER', Password
('hostPASSWD'), 'Y', 'Y', 'Y', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', 'N',
'N',
'N', 'N');
C:~
-Original Message-
From: Land, Christopher [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 18, 2002 12:01 PM
To: [EMAIL PROTECTED]
Subject: RE: MyODBC arrrgghh!
Here's the basics for MySQL database access (seven lines total:
use mysql;
create database myDB;
insert into db values ('myHOST.myDOMAIN.com', 'myDB', 'myUSER',
'Y','Y','Y','Y','N','N','N','N','N','N');
insert into user values ('localhost','myUSER', Password ('myPASSWD'),
'Y',
'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y');
insert into user values ('myHOST.myDOMAIN.com', 'myUSER', Password
('myPASSWD'), 'Y', 'Y', 'Y', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', 'N',
'N',
'N', 'N');
insert into user values ('myIP', 'myUSER', Password ('myPASSWD'), 'Y',
'Y',
'Y', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N');
quit
-Original Message-
From: Land, Christopher [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 18, 2002 11:26 AM
To: Andrew Hazen; [EMAIL PROTECTED]
Subject: RE: MyODBC arrrgghh!
The mysql.user table requires an entry corresponding to user@IP/hostname
corresponding to the XPwkst w/ODBC.
-Original Message-
From: Andrew Hazen [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 18, 2002 11:02 AM
To: [EMAIL PROTECTED]
Subject: MyODBC arrrgghh!
Alright, I'm feeling pretty clueless on this one.
I've downloaded and installed MyODBC.
I am trying to go from my local WinXP to my database on a unix/apache
webserver. (I want to use CodeCharge to build a site).
I have asked my ISP to grant remote access and he says he has. I can
access from a phpMyAdmin on one webserver to a db on the other webserver
fine. But when I try to access with ODBC, using the same
username/password it's no go.
mysql;mysql;
Andrew Hazen, O.C.P.
E-Commerce Developer
Jatech Solutions Inc.
www.jatech.ca
Specializing in OSCOMMERCE applications and PHP/MySQL programming.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MyODBC
Sounds like a user permission problem. Make sure you're allowed to connect from that ip. ( You can check in the 'user' table in the 'mysql' db. ) -- sh On Wed, 2002-04-17 at 09:34, Jim Bahr wrote: Hi Gang, Im trying to set my remote xp pc to connect to my server databases using MS Access. I have loaded and configured Myodbc21.50.39 (win95) and my DNS but get the following error message when I try to connect in Access. [TXC][MyODBC] Host'hxxx-xxx-xxx.ip, Alltel.net is not allowed to connect to this MySQL server (#1130). The x above = my dsl ip address. Any idea what I need to do next? Am I getting close? Jim - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: myODBC
Andrew, Wednesday, April 10, 2002, 7:26:01 PM, you wrote: AH I'm trying to use the old MS Visio Modeler with mysql. I have AH downloaded and installed the myODBC driver and set up a DNS. But I keep AH getting this connection error: AH Can't connect to MySQL server on 'www.jsicorp.com'(10060) AH I set the username and password the same as what works with phpMyAdmin. Is your MySQL server running? Check it using telnet. Look at: http://www.mysql.com/doc/C/a/Can_not_connect_to_server.html You can find description of error there, it may help you. AH Any thoughts? -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MyODBC and .NET (C#)
I just got it to work in VB.NET. I played with the connection string. In fact, I took everything out except the DSN. Here is the code (VB.net). For the most part it is exactly like VB6 except no SET commands and no default properties. Try making your connection string minimal in C#. Dim c As New ADODB.Connection() Dim r As New ADODB.Recordset() c.Open(DSN=SchoolStuff) r = c.Execute(SELECT * FROM classtitles) While Not r.EOF MsgBox(r.Fields(classtitle).Value) r.MoveNext() End While r.Close() r = Nothing c.Close() c = Nothing At 06:01 PM 3/11/2002 -0800, you wrote: Hi All, I'm having problems connecting to MySQL with C# via MyODBC 3.51.02; the DSN I created is called 'MySQL1'. The error I am receiving is: The 'MySQL1' provider is not registered on the local machine. This is what my connection string looks like: string strConn = Provider=MySQL1;DNS=MySQL1; Has anyone faced similar issues? Any advice? Thanks in advance, Jes __ Do You Yahoo!? Try FREE Yahoo! Mail - the world's greatest free email! http://mail.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MyODBC for Core Business, followup...
To all: This is in response to a request for more information. I thought others may find it useful. Thanks so much for your reply. It's good news to hear that someone is relying on MyODBC for an important purpose, much of the usage I've seen seemed rather small. Like I said, we have had not problems with it, other than the problems that Access is causing because of its non-standard implementation of ODBC. I will make note of the fact, however, that we *did* have some issues with the driver, but those were fixed, and those bugs are now no longer a problem. Again, I think when it came right down to it, it was Access issues, and not really MyODBC issues. If you don't mind, I'd like to ask just a few more questions... Not at all. I'll do my best. - Can you describe what your application does a bit? I'm also interested in why you chose the Access/MyODBC route. My reasoning is a desire to PHP on the Web side of things, and certainly the easse and cost of running a MySQL server... The application primarily provides for entry, editing, and procession (through various states) of student government legislation. It also keeps track of who is in what postion, when they were placed and removed, and why. We also plan to implement a module that prints agendas and minutes. We chose Access/ODBC for a few reasons. 1) We were rewriting an existing application, and while it *was* a total rewrite, and went from using a local Access database to using a MySQL server, we wanted to keep the interface and behavior as similar as possible. 2) We wanted more control over format of reports. As much as I hate to admit it, Access does have strong (and pretty easy) report design and generation. This especially comes in handy when printing out official documents. Also, I didn't want to design reports by hand, as I would have had to do in Perl (formating issues, etc). 3) When wanting to update fields on the fly, e.g. change the values available in another field based on a drop down box, it can be very cumbersome to convert that to the web. Either you have to use Javascript and pull a new page every time, or make it a multistep process. It is much easier, from a design viewpoint, to use the instant response of a local GUI. We will, however, have an online module pretty soon here to search and view existing legislation, which was why we moved it to a MySQL back-end in the first place. - Any details on the 'gotcha' issues with Access you mentioned you've been through is certainly appreciated. Some you may have heard, others you may not. 1) Make sure every table has a unique ID field (auto increment works just fine) and a TIMESTAMP field. Access will use those on updates to make sure nothing has changed since it pulled in the record for edit, and to make sure it's only affecting one record. 2) On your connect options (either the FLAGS in connect parameters, or in ODBC setup) make sure you select Don't optimize column width and Return matching rows. Using both of these would make for FLAGS=3 in your connect statement 3) On direct connections, for some reason, using rst.addnew, adding values, and rst.update, then repeating that will repeat the value of the first rst.addnew. I'm quite sure it's an access bug. I have an MDB file with a test case if you are interested. 4) If you don't use the Don't optimize option above, updates using recordssets may end up with truncated data if the new data is longer than the old data. 5) Inserts on direct connections (and an empty table) using recordsets (not a direct INSERT query) fail, and insert blank records. Again, I have a test case for that. - I'm assuming your Access application is all with linked ODBC tables... what type of load does it receive and how is performance (vs. a more typical SQL Server setup if you happen to know)? We use a hybrid linked/direct connection set up. Partially for Gotchas 3, 4 and 5 above. But also for speed. We use some pretty hairy joins in our program. Some as large as 4 or 5 tables. When Access processes that, it breaks it down into 3 or 4 queries (for computability, I'm sure) and sends those. This makes it very slow. In one case, when I pull in a history, it could take 2 or 3 seconds (literally). When I optimized the query, and sent it over the direct connection, it could pull in histories as fast as I could click the mouse. We also use the hybrid setup because reports can't use direct connections. This does, of course, make for a rather dicey situation, since we need to do inserts and updates (sometimes with recordsets) on attached tables. Which means those tables need to be connected with the proper username/permissions. Which means we have the slightly ugly hack of attaching/unattaching the tables everytime someone logs in or out. It's not pretty, but it works. Our next time around for this application is going to be in VB (using
Re: MyODBC or some other C based API for speed?
Wilbur, Saturday, March 02, 2002, 12:23:08 AM, you wrote: WS I'm doing development directly in C. WS So which API is recommended..? MYSQL C API Look at: http://www.mysql.com/doc/C/C/C.html WS Wilbur -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MyODBC or some other C based API for speed?
I'm doing development directly in C. So which API is recommended..? Wilbur Magic phrase... sql Putting A Human Face On Technology ;-) Literally! http://www.TheFaceOf.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MyODBC or some other C based API for speed?
At 02:17 AM 3/1/02 +0100, you wrote: Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: sql,query If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: I'm working on indexing words in web pages, and I'm finding a significant issue with the performance of MyODBC, even when I resort to using batch mode inserts.. I'm currently using the older version of MyODBC, and basically I'm looking to determine if anyone is aware of a faster API? Is the newer version faster? How about a non-ODBC API? Wilbur Putting A Human Face On Technology ;-) Literally! http://www.TheFaceOf.com Putting A Human Face On Technology ;-) Literally! http://www.TheFaceOf.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MyODBC 3.51 build for Mac OSX
Hi, -Original Message- From: Brian Reed [mailto:[EMAIL PROTECTED]] Sent: Saturday, February 23, 2002 9:52 AM To: [EMAIL PROTECTED] Subject: MyODBC 3.51 build for Mac OSX Sorry, Im new here and Im sure this has been discussed ad naseum, but does anyone have information on where to get an installer for the Mac OSX version of the MyODBC drivers? The latest build I could find on the web is 2.5. The 3.51 Mac build is not available for downloads. Possibly will add from 3.51.02 versions onwards. The alternative is to download the source and build the driver yourself. Here is a mail which describes how to build 3.51 driver on Mac. http://lists.mysql.com/cgi-ez/ezmlm-cgi?5:mss:4816:200202:kikmibdplecdpppfcd jm Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MyODBC Blocking Table for DROP request ?
Hi, -Original Message- From: Fabrice Schleifer [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 20, 2002 11:31 PM To: [EMAIL PROTECTED] Subject: MyODBC Blocking Table for DROP request ? Hello everybody, here is a strange thing that creates me nightmares ... How-To-Repeat: Stage 1 . Using a my SQL GUI : Create a simple Table ... create table FAKE (bidon integer) Everything works fine ... Stage 2. Using a C compiler and MyODBC3.51 Driver (actually I use Borland as C Compiler) cut Everything successes in this code , always SQL Success is returned ( note: I removed the lines that use the result set of SQLColumns.. because of no interest ..) Stage 3. Using the GUY , try to erase the table ... DROP table FAKE Message : Error on delete of '.\LemoineDB\fake.MYI' (Errcode: 13) (I think this is an permission problem) I am almost sure I habe all the permissionss : I cannot succeed in deleting the table until I stop the server and restart it . Once the server is restarted I can drop the table using the command above with no problem . Other test I did : If I comment out the SQLColumns API , everything works fines from stage 1 to 3 . Fix: I have to restart the server to drop the tables ..(that not a fix ) :--))) See also information below and joined the MyODBC.log I created running the code . Please , give me a quick answer even if no quick solution . I could able to reproduce the bug, and will fix it for the next release versions by finding the exact cause (possibly some where we are not closing the opened session while using the mysql_list_fields()). The immediate work around is to execute FLUSH TABLES before you try to drop it, that way you can eliminate the server shutdown. And, thanks for the good functionality bug. Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MyODBC leaking handles...
Hi again, Sorry for being a pain here, but; If I select any other ODBC source (of about 10 that I have) including SQL Server, access, Informix, etc... it doesn't leak. Shouldn't it leak there as well then? It is only with MyODBC driver it happens. Comments? / Jens -Original Message- From: Venu [mailto:[EMAIL PROTECTED]] Sent: den 3 januari 2002 18:38 To: Jens Collin Cc: [EMAIL PROTECTED] Subject: RE: MyODBC leaking handles... Hi, -Original Message- From: Jens Collin [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 02, 2002 11:44 PM To: '[EMAIL PROTECTED]' Cc: [EMAIL PROTECTED] Subject: RE: MyODBC leaking handles... Hi again, From what I can see, when the driver is unloaded (I guess when my application is shut down) it releases all handles again. But the init shouldn't take 800.000 handles over time right? :) There was a leak in the server and some part of driver in 2.50.39 w.r.t. loading and unloading. The server side got the fixes from 4.0.1 or 3.23.48 versions, and driver will have from 2.50.40 or 3.51.01 onwards. The 3.51 driver will be released shortly. Keep tuned to [EMAIL PROTECTED] for the release announcement. Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.com -Original Message- From: Venu [mailto:[EMAIL PROTECTED]] Sent: den 19 december 2001 20:01 To: Jens Collin; [EMAIL PROTECTED] Subject: RE: MyODBC leaking handles... Hi, -Original Message- From: Jens Collin [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 19, 2001 3:05 AM To: '[EMAIL PROTECTED]'; [EMAIL PROTECTED] Subject: RE: MyODBC leaking handles... Hi again, Some more information; OS: Windows 2000 Professional, SP2a + all patches mySQL 3.32.46 (windows version) myODBC 2.50.37 I open then database, do a select, close the recordset and finally close the database. This results in 2 handles increase. (Notised in windows task manager) If I loop this test, the handles counter just goes through the roof. over 800.000 handles over one night! I have done the exact same test with MS SQL Server 7.0 and 2000, no missing handles. This works for oracle's drivers as well. I guess that a trace can be useful? However, I should upload it to your FTP right? (If I read the manual right :)) I'll be happy to assist you with any data needed, just let me know what to send. Thanks for the feedback. I will look into it immediately. When I tested with PURIFY, I couldn't find any leaks. Let me do a cross check again. Another small note, might be useful. There are some open resources allocated for the driver during the initialization, and will be freed only upon termination or unloading of driver from memory. So, does this happen even after terminating the application in the proper sequence of calls ? No need of any trace right now, if needed I will ask you. Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.com -Original Message- From: Venu [mailto:[EMAIL PROTECTED]] Sent: den 18 december 2001 19:38 To: Jens Collin; [EMAIL PROTECTED] Subject: RE: MyODBC leaking handles... Hi, -Original Message- From: Jens Collin [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 18, 2001 4:22 AM To: '[EMAIL PROTECTED]' Subject: MyODBC leaking handles... Hi all, This is my first post in this forum. I've tried to find something in the documentation but failed. I cannot find out why the ODBC driver is leaking 1 handle for each request that I do! It doesn't matter if I close it or whatever I do. Anyone that knows what to do? Any hints or tips? Recently we found the leaks in the initialization towards UNIX, and fixed them from driver and server, but we didn't find any thing from Windows (The Unix fixes will be there for 2.50.40 and 3.51.01) Windows 2000 Professional MySQL 3.23 MyODBC 2.50.39 Can you be more specific on this, please ? If you can send the leaks statistics, it will be a great help. Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.com Regards, ___ Jens A. Collin Envox Technical System Developer Envox Group Söder Mälarstrand 43
RE: MyODBC leaking handles...
Hi Venu, Any news regarding this issue? / Jens -- Hi again Venu, I'm attaching a small program. One of our developers have been in contact with you before so I guess that you recognize this program :-) Source is attached also wich I assume is self explanatory for you guys. The program can easily recreate the situation that we are experiencing. Please have a look at it, or at least test it. It will be obvious. We have been in contact with you before, as I just said, and if you need my support contract info, please don't hesitate to ask me by email or phone. Let me know. Regards, ___ Jens A. Collin Envox Technical System Developer Envox Group Söder Mälarstrand 43 118 25 Stockholm Sweden Office: +46 (0)8 56 256 000 Fax : +46 (0)8 56 256 050 [EMAIL PROTECTED] http://www.envox.com ___ -Original Message- From: Venu [mailto:[EMAIL PROTECTED]] Sent: den 4 februari 2002 21:21 To: Jens Collin Cc: [EMAIL PROTECTED] Subject: RE: MyODBC leaking handles... Hi, -Original Message- From: Jens Collin [mailto:[EMAIL PROTECTED]] Sent: Monday, February 04, 2002 5:42 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: RE: MyODBC leaking handles... Hi again Venu, I tried the latest one. I'm sorry to say that the error persists... Still leaking handles at terrible speeds. One handle for each select even if we close the set. You mentioned something regarding a new version of the server engine as well... Is this going to be released soon? Does this affect this issue? Perhaps this fix just works with ODBC server of later versions and not only the ODBC one. Hmmm, am sorry. Actually the 8k leak fix(charset and initialization) was there in .47 version of server and 3.51.01, together should be able to work out. If it happens with the above configure, could you please able to trace back the call sequence of leaks ? Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MyODBC BDE invalid configuration error (BDE Error 12550)
Hi, -Original Message- From: Guido Sohne [mailto:[EMAIL PROTECTED]] Sent: Friday, February 08, 2002 6:54 AM To: [EMAIL PROTECTED] Subject: MyODBC BDE invalid configuration error (BDE Error 12550) We're running a MySQL 3.23.47 server on Windows 98, and when trying to connect to BDE version 3.0 (bundled with Borland C++ Builder 1) using MyODBC version 3.51 we get something like Invalid configuration parameter: Alias: database_alias BDE Error 12550 [0x31][0x6] I've searched the list archives and realize that some people have occasionally come across this problem but haven't found a solution or an indication of what the problem is ... Is it possible for you to trace MS ODBC DM calls and send that log ? That enables the clear picture of what is happening. I tried to download the eval copy of Borland C++ Builder to give a try, but it is ~140 MB, so waiting for your log. If it doesn't help, then I will go ahead and give a try by downloading. Borland,s web site says of BDE Error 12550 12550 Invalid configuration parameter. One possible cause for the error: ODBC ALIASES. When creating and/or using a BDE alias that is using an ODBC DSN make sure that the ALIAS parameter ODBC DSN is set to the DSN that you wish to use and that has been created using ODBC Manager. Available ODBC DSN's can be chosen from the parameter's drop-down edit using the BDE Administrator. Another possible cause: Using ISAPI app and ODBC against NT web server. ODBC DSN on NT machine should be set to system instead of user. Did you tried with the 'system dsn' or 'file dsn' ? And whats the outcome ? For more information on different types of DSNs, refer to http://www.mysql.com/products/myodbc/faq.html#DSN_Types Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MyODBC leaking handles...
Hi Venu, Any news regarding this issue? / Jens -- Hi again Venu, I'm attaching a small program. One of our developers have been in contact with you before so I guess that you recognize this program :-) Source is attached also wich I assume is self explanatory for you guys. The program can easily recreate the situation that we are experiencing. Please have a look at it, or at least test it. It will be obvious. We have been in contact with you before, as I just said, and if you need my support contract info, please don't hesitate to ask me by email or phone. Let me know. Regards, ___ Jens A. Collin Envox Technical System Developer Envox Group Söder Mälarstrand 43 118 25 Stockholm Sweden Office: +46 (0)8 56 256 000 Fax : +46 (0)8 56 256 050 [EMAIL PROTECTED] http://www.envox.com ___ -Original Message- From: Venu [mailto:[EMAIL PROTECTED]] Sent: den 4 februari 2002 21:21 To: Jens Collin Cc: [EMAIL PROTECTED] Subject: RE: MyODBC leaking handles... Hi, -Original Message- From: Jens Collin [mailto:[EMAIL PROTECTED]] Sent: Monday, February 04, 2002 5:42 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: RE: MyODBC leaking handles... Hi again Venu, I tried the latest one. I'm sorry to say that the error persists... Still leaking handles at terrible speeds. One handle for each select even if we close the set. You mentioned something regarding a new version of the server engine as well... Is this going to be released soon? Does this affect this issue? Perhaps this fix just works with ODBC server of later versions and not only the ODBC one. Hmmm, am sorry. Actually the 8k leak fix(charset and initialization) was there in .47 version of server and 3.51.01, together should be able to work out. If it happens with the above configure, could you please able to trace back the call sequence of leaks ? Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MyODBC leaking handles...
Hi again Venu, I tried the latest one. I'm sorry to say that the error persists... Still leaking handles at terrible speeds. One handle for each select even if we close the set. You mentioned something regarding a new version of the server engine as well... Is this going to be released soon? Does this affect this issue? Perhaps this fix just works with ODBC server of later versions and not only the ODBC one. Regards, ___ Jens A. Collin Envox Technical System Developer Envox Group Söder Mälarstrand 43 118 25 Stockholm Sweden Office: +46 (0)8 56 256 000 Fax : +46 (0)8 56 256 050 [EMAIL PROTECTED] http://www.envox.com ___ -Original Message- From: Venu [mailto:[EMAIL PROTECTED]] Sent: den 3 januari 2002 18:38 To: Jens Collin Cc: [EMAIL PROTECTED] Subject: RE: MyODBC leaking handles... Hi, -Original Message- From: Jens Collin [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 02, 2002 11:44 PM To: '[EMAIL PROTECTED]' Cc: [EMAIL PROTECTED] Subject: RE: MyODBC leaking handles... Hi again, From what I can see, when the driver is unloaded (I guess when my application is shut down) it releases all handles again. But the init shouldn't take 800.000 handles over time right? :) There was a leak in the server and some part of driver in 2.50.39 w.r.t. loading and unloading. The server side got the fixes from 4.0.1 or 3.23.48 versions, and driver will have from 2.50.40 or 3.51.01 onwards. The 3.51 driver will be released shortly. Keep tuned to [EMAIL PROTECTED] for the release announcement. Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.com -Original Message- From: Venu [mailto:[EMAIL PROTECTED]] Sent: den 19 december 2001 20:01 To: Jens Collin; [EMAIL PROTECTED] Subject: RE: MyODBC leaking handles... Hi, -Original Message- From: Jens Collin [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 19, 2001 3:05 AM To: '[EMAIL PROTECTED]'; [EMAIL PROTECTED] Subject: RE: MyODBC leaking handles... Hi again, Some more information; OS: Windows 2000 Professional, SP2a + all patches mySQL 3.32.46 (windows version) myODBC 2.50.37 I open then database, do a select, close the recordset and finally close the database. This results in 2 handles increase. (Notised in windows task manager) If I loop this test, the handles counter just goes through the roof. over 800.000 handles over one night! I have done the exact same test with MS SQL Server 7.0 and 2000, no missing handles. This works for oracle's drivers as well. I guess that a trace can be useful? However, I should upload it to your FTP right? (If I read the manual right :)) I'll be happy to assist you with any data needed, just let me know what to send. Thanks for the feedback. I will look into it immediately. When I tested with PURIFY, I couldn't find any leaks. Let me do a cross check again. Another small note, might be useful. There are some open resources allocated for the driver during the initialization, and will be freed only upon termination or unloading of driver from memory. So, does this happen even after terminating the application in the proper sequence of calls ? No need of any trace right now, if needed I will ask you. Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.com -Original Message- From: Venu [mailto:[EMAIL PROTECTED]] Sent: den 18 december 2001 19:38 To: Jens Collin; [EMAIL PROTECTED] Subject: RE: MyODBC leaking handles... Hi, -Original Message- From: Jens Collin [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 18, 2001 4:22 AM To: '[EMAIL PROTECTED]' Subject: MyODBC leaking handles... Hi all, This is my first post in this forum. I've tried to find something in the documentation but failed. I cannot find out why the ODBC driver is leaking 1 handle for each request that I do! It doesn't matter if I close it or whatever I do. Anyone that knows what to do? Any hints or tips? Recently we found the leaks in the initialization towards UNIX, and fixed them from driver and server, but we didn't find any thing from Windows (The Unix fixes will be there for 2.50.40 and 3.51.01) Windows 2000 Professional MySQL 3.23 MyODBC 2.50.39 Can you be more specific on this, please ? If you can send the leaks statistics, it will be a great help. Regards, Venu
RE: MyODBC leaking handles...
Hi, -Original Message- From: Jens Collin [mailto:[EMAIL PROTECTED]] Sent: Monday, February 04, 2002 5:42 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: RE: MyODBC leaking handles... Hi again Venu, I tried the latest one. I'm sorry to say that the error persists... Still leaking handles at terrible speeds. One handle for each select even if we close the set. You mentioned something regarding a new version of the server engine as well... Is this going to be released soon? Does this affect this issue? Perhaps this fix just works with ODBC server of later versions and not only the ODBC one. Hmmm, am sorry. Actually the 8k leak fix(charset and initialization) was there in .47 version of server and 3.51.01, together should be able to work out. If it happens with the above configure, could you please able to trace back the call sequence of leaks ? Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MyODBC
Hi Venu, I am unable to use MyODBC with .NET. What options do you recommend setting in DSN? I used Return matching rows, and Change BIGINT to INT, but no luck, error message. The Test connection works ok, but when I use the wizard to configure the data source in .NET, it throws an error, unable to use this connection or something. D'Arcy - Original Message - From: Venu [EMAIL PROTECTED] To: Mike Nelson [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Saturday, January 26, 2002 2:15 PM Subject: RE: MyODBC Hi, -Original Message- From: Mike Nelson [mailto:[EMAIL PROTECTED]] Sent: Friday, January 25, 2002 11:43 PM To: [EMAIL PROTECTED] Subject: MyODBC Any plans to upgrade the MyODBC driver to support .NET? I downloaded a copy of MySQL and tested it with a .NET app and received an error that this version of ODBC wasn't supported. Just wondering if this is on the development horizon. You should be able to work with .NET through MyODBC with out many problems. I tried with ODBC.NET, ADO.NET through MyODBC and could able to do the basic stuff without any problems. If you need a ODBC compliant of 3.x or more, we will be releasing a new MyODBC 3.51 Driver shortly, which should fit for most of the requirements. Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MyODBC
D'Arcy Rittich writes: Hi Venu, I am unable to use MyODBC with .NET. What options do you recommend setting in DSN? I used Return matching rows, and Change BIGINT to INT, but no luck, error message. The Test connection works ok, but when I use the wizard to configure the data source in .NET, it throws an error, unable to use this connection or something. D'Arcy Hi! Currently, Using .NET, one can access to MySQL through its native ODBC Drivers using the following .NET Framework SDK: - ADO.NET - ASP.NET and - ODBC.NET This can be accomplished using either Visual Basic, Visual C++ and C# as the programming language. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MyODBC
Hi,
when I use the wizard to configure the data source in .NET, it throws an
error, unable to
use this connection or something.
What is this **configure the data source in .NET** ? Can you please elaborate
?
FYI : I used the following compilation options:
csc /t:exe /out:mycon.exe mycon.cs
/r:System.dll
/r:System.Data.dll
/r:C:\WINNT\Microsoft.NET\Framework\v1.0.2914\System.Data.Odbc.dll
And here is the simple C# sample using ODBC.NET (though its not perfect
sample)
to makeuse of BIGINTs fetch with MyODBC 3.51 driver.
/**
* @sample: mycon.cs
* @purpose : Demo sample for ODBC.NET using MyODBC or MyODBC 3.51
* @author: Venu, [EMAIL PROTECTED]
*
* (C) Copyright MySQL AB, 1995-2002
*
**/
using Console = System.Console;
using System.Data.Odbc;
namespace myodbc3
{
class mycon
{
static void Main(string[] args)
{
try
{
//Connection string for MyODBC
/*string MyConString = DRIVER={MySQL}; +
SERVER=localhost; +
DATABASE=test; +
UID=venu; +
PASSWORD=venu; +
OPTION=3;
*/
//Connection string for MyODBC 3.51
string MyConString = DRIVER={MySQL ODBC 3.51 Driver}; +
SERVER=localhost; +
DATABASE=test; +
UID=venu; +
PASSWORD=venu; +
OPTION=35; // Dynamic cursor support
OdbcConnection MyConnection = new OdbcConnection(MyConString);
MyConnection.Open();
Console.WriteLine(\n !!! success, connected successfully !!!\n);
//Connection
Console.WriteLine(Connection Information:);
Console.WriteLine(\tConnection String: +
MyConnection.ConnectionString);
Console.WriteLine(\tConnection Timeout: +
MyConnection.ConnectionTimeout);
Console.WriteLine(\tDatabase: + MyConnection.Database);
Console.WriteLine(\tDataSource: + MyConnection.DataSource);
Console.WriteLine(\tDriver: + MyConnection.Driver);
Console.WriteLine(\tServerVersion: + MyConnection.ServerVersion);
//Create a sample table
OdbcCommand MyCommand = new OdbcCommand(DROP TABLE IF EXISTS
my_odbc_net,MyConnection);
MyCommand.ExecuteNonQuery();
MyCommand.CommandText = CREATE TABLE my_odbc_net(id int, name
varchar(20), idb bigint);
MyCommand.ExecuteNonQuery();
//Insert
MyCommand.CommandText = INSERT INTO my_odbc_net VALUES(10,'venu',
300);
Console.WriteLine(INSERT, Total rows affected: +
MyCommand.ExecuteNonQuery());;
//Insert
MyCommand.CommandText = INSERT INTO my_odbc_net
VALUES(20,'mysql',400);
Console.WriteLine(INSERT, Total rows affected: +
MyCommand.ExecuteNonQuery());
//Insert
MyCommand.CommandText = INSERT INTO my_odbc_net
VALUES(20,'mysql',500);
Console.WriteLine(INSERT, Total rows affected: +
MyCommand.ExecuteNonQuery());
//Update
MyCommand.CommandText = UPDATE my_odbc_net SET id=999 WHERE id=20;
Console.WriteLine(Update, Total rows affected: +
MyCommand.ExecuteNonQuery());
//COUNT(*)
MyCommand.CommandText = SELECT COUNT(*) as TRows FROM my_odbc_net;
Console.WriteLine(Total Rows: + MyCommand.ExecuteScalar());
//Fetch
MyCommand.CommandText = SELECT * FROM my_odbc_net;
OdbcDataReader MyDataReader;
MyDataReader = MyCommand.ExecuteReader();
while (MyDataReader.Read())
{
if(string.Compare(MyConnection.Driver,myodbc3.dll) == 0) {
Console.WriteLine(Data: + MyDataReader.GetInt32(0) + +
MyDataReader.GetString(1) + +
MyDataReader.GetInt64(2)); //Supported
only by MyODBC 3.51
}
else {
Console.WriteLine(Data: + MyDataReader.GetInt32(0) + +
MyDataReader.GetString(1) + +
MyDataReader.GetInt32(2)); //BIGINTs
not supported by MyODBC
}
}
//Close all resources
MyDataReader.Close();
MyConnection.Close();
}
catch (OdbcException MyOdbcException)
{
Console.WriteLine(Error + \n +
NATIVE: + MyOdbcException.Errors[0].NativeError.ToString() + \n
+
SQLSTATE: + MyOdbcException.Errors[0].SQLState + \n +
MESSAGE: + MyOdbcException.Errors[0].Message );
}
}
}
}
Regards, Venu
--
For technical support contracts, go to https://order.mysql.com
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED]
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer
/_/ /_/\_, /___/\___\_\___/ California, USA
___/ www.mysql.com
Re: MyODBC
Mike Nelson writes: Any plans to upgrade the MyODBC driver to support .NET? I downloaded a copy of MySQL and tested it with a .NET app and received an error that this version of ODBC wasn't supported. Just wondering if this is on the development horizon. Hi! We are in the planning stage on entire .NET issue, so no info will be available until some hard decisions are made. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MyODBC
Hi, -Original Message- From: Mike Nelson [mailto:[EMAIL PROTECTED]] Sent: Friday, January 25, 2002 11:43 PM To: [EMAIL PROTECTED] Subject: MyODBC Any plans to upgrade the MyODBC driver to support .NET? I downloaded a copy of MySQL and tested it with a .NET app and received an error that this version of ODBC wasn't supported. Just wondering if this is on the development horizon. You should be able to work with .NET through MyODBC with out many problems. I tried with ODBC.NET, ADO.NET through MyODBC and could able to do the basic stuff without any problems. If you need a ODBC compliant of 3.x or more, we will be releasing a new MyODBC 3.51 Driver shortly, which should fit for most of the requirements. Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MyODBC problem: Show Processlist
Hi, Hallo, Im writing an Visual Basic 6 application, using MDAC 2.1 and MySql ODBC 2.50.38. In some part of this application I like to know the processes that are running on MySql. I'm using SHOW PROCESSLIST expecting a recordset back like in SHOW STATUS. I'm getting an runtime-error -2147467259 (80004005), Function sequence error when I try to go to the first record (.MoveFirst). This works ok with SHOW STATUS. I traced the ODBC calls and enclosed the files. You can see that the SHOW STATUS leaves no error in the trace file. The SHOW PROCESSLIST however does. I hope you can give me an advice. Thanks in advance. Frans Streur -=*-=*-=*-=*-=*-=*-=*-=*-=*-=*-=*-=*-=*-=*-=*-=*-=* Frans Streur - 's-Hertogenbosch - The Netherlands EMail [EMAIL PROTECTED] -=*-=*-=*-=*-=*-=*-=*-=*-=*-=*-=*-=*-=*-=*-=*-=*-=* Errors Tracefile: SHOW PROCESSLIST VB6 120-534 EXIT SQLNumResultCols with return code -1 (SQL_ERROR) HSTMT 031F17E0 SWORD * 0x0012E908 DIAG [S1010] [Microsoft][ODBC Driver Manager] Function sequence error (0) What is its previous call ? Is it SQLPrepare or SQLExecDirect ? Note that, if it is SQLPrepare, then please upgrade your driver to .39 version to have a fix for this. Other wise, please send me the complete trace, but before that try with .39 version of the driver. NOTE: The error is returned by the DM, not by the driver, so we need to have a trace to understand what is happening from the application, and my guess is something to do with app calling sequence. Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MyODBC leaking handles...
Venu, I really look forward to the update. Thanks for following up! Regards, ___ Jens A. Collin Envox Technical System Developer Envox Group Söder Mälarstrand 43 118 25 Stockholm Sweden Office: +46 (0)8 56 256 000 Fax : +46 (0)8 56 256 050 [EMAIL PROTECTED] http://www.envox.com ___ -Original Message- From: Venu [mailto:[EMAIL PROTECTED]] Sent: den 3 januari 2002 18:38 To: Jens Collin Cc: [EMAIL PROTECTED] Subject: RE: MyODBC leaking handles... Hi, -Original Message- From: Jens Collin [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 02, 2002 11:44 PM To: '[EMAIL PROTECTED]' Cc: [EMAIL PROTECTED] Subject: RE: MyODBC leaking handles... Hi again, From what I can see, when the driver is unloaded (I guess when my application is shut down) it releases all handles again. But the init shouldn't take 800.000 handles over time right? :) There was a leak in the server and some part of driver in 2.50.39 w.r.t. loading and unloading. The server side got the fixes from 4.0.1 or 3.23.48 versions, and driver will have from 2.50.40 or 3.51.01 onwards. The 3.51 driver will be released shortly. Keep tuned to [EMAIL PROTECTED] for the release announcement. Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.com -Original Message- From: Venu [mailto:[EMAIL PROTECTED]] Sent: den 19 december 2001 20:01 To: Jens Collin; [EMAIL PROTECTED] Subject: RE: MyODBC leaking handles... Hi, -Original Message- From: Jens Collin [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 19, 2001 3:05 AM To: '[EMAIL PROTECTED]'; [EMAIL PROTECTED] Subject: RE: MyODBC leaking handles... Hi again, Some more information; OS: Windows 2000 Professional, SP2a + all patches mySQL 3.32.46 (windows version) myODBC 2.50.37 I open then database, do a select, close the recordset and finally close the database. This results in 2 handles increase. (Notised in windows task manager) If I loop this test, the handles counter just goes through the roof. over 800.000 handles over one night! I have done the exact same test with MS SQL Server 7.0 and 2000, no missing handles. This works for oracle's drivers as well. I guess that a trace can be useful? However, I should upload it to your FTP right? (If I read the manual right :)) I'll be happy to assist you with any data needed, just let me know what to send. Thanks for the feedback. I will look into it immediately. When I tested with PURIFY, I couldn't find any leaks. Let me do a cross check again. Another small note, might be useful. There are some open resources allocated for the driver during the initialization, and will be freed only upon termination or unloading of driver from memory. So, does this happen even after terminating the application in the proper sequence of calls ? No need of any trace right now, if needed I will ask you. Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.com -Original Message- From: Venu [mailto:[EMAIL PROTECTED]] Sent: den 18 december 2001 19:38 To: Jens Collin; [EMAIL PROTECTED] Subject: RE: MyODBC leaking handles... Hi, -Original Message- From: Jens Collin [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 18, 2001 4:22 AM To: '[EMAIL PROTECTED]' Subject: MyODBC leaking handles... Hi all, This is my first post in this forum. I've tried to find something in the documentation but failed. I cannot find out why the ODBC driver is leaking 1 handle for each request that I do! It doesn't matter if I close it or whatever I do. Anyone that knows what to do? Any hints or tips? Recently we found the leaks in the initialization towards UNIX, and fixed them from driver and server, but we didn't find any thing from Windows (The Unix fixes will be there for 2.50.40 and 3.51.01) Windows 2000 Professional MySQL 3.23 MyODBC 2.50.39 Can you be more specific on this, please ? If you can send the leaks statistics, it will be a great help. Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.com Regards, ___ Jens
RE: MyODBC leaking handles...
Hi, -Original Message- From: Jens Collin [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 02, 2002 11:44 PM To: '[EMAIL PROTECTED]' Cc: [EMAIL PROTECTED] Subject: RE: MyODBC leaking handles... Hi again, From what I can see, when the driver is unloaded (I guess when my application is shut down) it releases all handles again. But the init shouldn't take 800.000 handles over time right? :) There was a leak in the server and some part of driver in 2.50.39 w.r.t. loading and unloading. The server side got the fixes from 4.0.1 or 3.23.48 versions, and driver will have from 2.50.40 or 3.51.01 onwards. The 3.51 driver will be released shortly. Keep tuned to [EMAIL PROTECTED] for the release announcement. Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.com -Original Message- From: Venu [mailto:[EMAIL PROTECTED]] Sent: den 19 december 2001 20:01 To: Jens Collin; [EMAIL PROTECTED] Subject: RE: MyODBC leaking handles... Hi, -Original Message- From: Jens Collin [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 19, 2001 3:05 AM To: '[EMAIL PROTECTED]'; [EMAIL PROTECTED] Subject: RE: MyODBC leaking handles... Hi again, Some more information; OS: Windows 2000 Professional, SP2a + all patches mySQL 3.32.46 (windows version) myODBC 2.50.37 I open then database, do a select, close the recordset and finally close the database. This results in 2 handles increase. (Notised in windows task manager) If I loop this test, the handles counter just goes through the roof. over 800.000 handles over one night! I have done the exact same test with MS SQL Server 7.0 and 2000, no missing handles. This works for oracle's drivers as well. I guess that a trace can be useful? However, I should upload it to your FTP right? (If I read the manual right :)) I'll be happy to assist you with any data needed, just let me know what to send. Thanks for the feedback. I will look into it immediately. When I tested with PURIFY, I couldn't find any leaks. Let me do a cross check again. Another small note, might be useful. There are some open resources allocated for the driver during the initialization, and will be freed only upon termination or unloading of driver from memory. So, does this happen even after terminating the application in the proper sequence of calls ? No need of any trace right now, if needed I will ask you. Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.com -Original Message- From: Venu [mailto:[EMAIL PROTECTED]] Sent: den 18 december 2001 19:38 To: Jens Collin; [EMAIL PROTECTED] Subject: RE: MyODBC leaking handles... Hi, -Original Message- From: Jens Collin [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 18, 2001 4:22 AM To: '[EMAIL PROTECTED]' Subject: MyODBC leaking handles... Hi all, This is my first post in this forum. I've tried to find something in the documentation but failed. I cannot find out why the ODBC driver is leaking 1 handle for each request that I do! It doesn't matter if I close it or whatever I do. Anyone that knows what to do? Any hints or tips? Recently we found the leaks in the initialization towards UNIX, and fixed them from driver and server, but we didn't find any thing from Windows (The Unix fixes will be there for 2.50.40 and 3.51.01) Windows 2000 Professional MySQL 3.23 MyODBC 2.50.39 Can you be more specific on this, please ? If you can send the leaks statistics, it will be a great help. Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.com Regards, ___ Jens A. Collin Envox Technical System Developer Envox Group Söder Mälarstrand 43 118 25 Stockholm Sweden Office: +46 (0)8 56 256 000 Fax : +46 (0)8 56 256 050 [EMAIL PROTECTED] http://www.envox.com ___ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail
RE: MyODBC leaking handles...
Hi again, From what I can see, when the driver is unloaded (I guess when my application is shut down) it releases all handles again. But the init shouldn't take 800.000 handles over time right? :) / Jens -Original Message- From: Venu [mailto:[EMAIL PROTECTED]] Sent: den 19 december 2001 20:01 To: Jens Collin; [EMAIL PROTECTED] Subject: RE: MyODBC leaking handles... Hi, -Original Message- From: Jens Collin [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 19, 2001 3:05 AM To: '[EMAIL PROTECTED]'; [EMAIL PROTECTED] Subject: RE: MyODBC leaking handles... Hi again, Some more information; OS: Windows 2000 Professional, SP2a + all patches mySQL 3.32.46 (windows version) myODBC 2.50.37 I open then database, do a select, close the recordset and finally close the database. This results in 2 handles increase. (Notised in windows task manager) If I loop this test, the handles counter just goes through the roof. over 800.000 handles over one night! I have done the exact same test with MS SQL Server 7.0 and 2000, no missing handles. This works for oracle's drivers as well. I guess that a trace can be useful? However, I should upload it to your FTP right? (If I read the manual right :)) I'll be happy to assist you with any data needed, just let me know what to send. Thanks for the feedback. I will look into it immediately. When I tested with PURIFY, I couldn't find any leaks. Let me do a cross check again. Another small note, might be useful. There are some open resources allocated for the driver during the initialization, and will be freed only upon termination or unloading of driver from memory. So, does this happen even after terminating the application in the proper sequence of calls ? No need of any trace right now, if needed I will ask you. Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.com -Original Message- From: Venu [mailto:[EMAIL PROTECTED]] Sent: den 18 december 2001 19:38 To: Jens Collin; [EMAIL PROTECTED] Subject: RE: MyODBC leaking handles... Hi, -Original Message- From: Jens Collin [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 18, 2001 4:22 AM To: '[EMAIL PROTECTED]' Subject: MyODBC leaking handles... Hi all, This is my first post in this forum. I've tried to find something in the documentation but failed. I cannot find out why the ODBC driver is leaking 1 handle for each request that I do! It doesn't matter if I close it or whatever I do. Anyone that knows what to do? Any hints or tips? Recently we found the leaks in the initialization towards UNIX, and fixed them from driver and server, but we didn't find any thing from Windows (The Unix fixes will be there for 2.50.40 and 3.51.01) Windows 2000 Professional MySQL 3.23 MyODBC 2.50.39 Can you be more specific on this, please ? If you can send the leaks statistics, it will be a great help. Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.com Regards, ___ Jens A. Collin Envox Technical System Developer Envox Group Söder Mälarstrand 43 118 25 Stockholm Sweden Office: +46 (0)8 56 256 000 Fax : +46 (0)8 56 256 050 [EMAIL PROTECTED] http://www.envox.com ___ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MyODBC leaking handles...
Hi, Well, if I close my application, windows grabs hold of the handles again... If that is what you mean? I use it with an applications generator for telecom mostly so I have no idea how the inner works is done. I could find out for you if you want to, since I'm working at that company :) We want to be able to give MySQL as an option to our partners instead of always suggesting MS SQL server or oracle. The more the merrier :) What I know is that the DBstuff is started in its own thread and when all DB interaction is done, the thread is killed. The handles are still attached to the platform. When the platform is killed by exiting or force-exit, the handles are returned. Perhaps we can change something in our application? But from what our developers have told me, they are using ODBC 1.0 straight up with no short-cuts Let me know if you need anything! / Jens -Original Message- From: Venu [mailto:[EMAIL PROTECTED]] Sent: den 19 december 2001 20:01 To: Jens Collin; [EMAIL PROTECTED] Subject: RE: MyODBC leaking handles... Hi, -Original Message- From: Jens Collin [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 19, 2001 3:05 AM To: '[EMAIL PROTECTED]'; [EMAIL PROTECTED] Subject: RE: MyODBC leaking handles... Hi again, Some more information; OS: Windows 2000 Professional, SP2a + all patches mySQL 3.32.46 (windows version) myODBC 2.50.37 I open then database, do a select, close the recordset and finally close the database. This results in 2 handles increase. (Notised in windows task manager) If I loop this test, the handles counter just goes through the roof. over 800.000 handles over one night! I have done the exact same test with MS SQL Server 7.0 and 2000, no missing handles. This works for oracle's drivers as well. I guess that a trace can be useful? However, I should upload it to your FTP right? (If I read the manual right :)) I'll be happy to assist you with any data needed, just let me know what to send. Thanks for the feedback. I will look into it immediately. When I tested with PURIFY, I couldn't find any leaks. Let me do a cross check again. Another small note, might be useful. There are some open resources allocated for the driver during the initialization, and will be freed only upon termination or unloading of driver from memory. So, does this happen even after terminating the application in the proper sequence of calls ? No need of any trace right now, if needed I will ask you. Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.com -Original Message- From: Venu [mailto:[EMAIL PROTECTED]] Sent: den 18 december 2001 19:38 To: Jens Collin; [EMAIL PROTECTED] Subject: RE: MyODBC leaking handles... Hi, -Original Message- From: Jens Collin [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 18, 2001 4:22 AM To: '[EMAIL PROTECTED]' Subject: MyODBC leaking handles... Hi all, This is my first post in this forum. I've tried to find something in the documentation but failed. I cannot find out why the ODBC driver is leaking 1 handle for each request that I do! It doesn't matter if I close it or whatever I do. Anyone that knows what to do? Any hints or tips? Recently we found the leaks in the initialization towards UNIX, and fixed them from driver and server, but we didn't find any thing from Windows (The Unix fixes will be there for 2.50.40 and 3.51.01) Windows 2000 Professional MySQL 3.23 MyODBC 2.50.39 Can you be more specific on this, please ? If you can send the leaks statistics, it will be a great help. Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.com Regards, ___ Jens A. Collin Envox Technical System Developer Envox Group Söder Mälarstrand 43 118 25 Stockholm Sweden Office: +46 (0)8 56 256 000 Fax : +46 (0)8 56 256 050 [EMAIL PROTECTED] http://www.envox.com ___ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php
RE: MyODBC availability
Hi! Venu == Venu [EMAIL PROTECTED] writes: Venu Hi Kevin, -Original Message- From: Kevin Donnelly [mailto:[EMAIL PROTECTED]] Sent: Monday, December 17, 2001 12:47 PM To: [EMAIL PROTECTED] Subject: MyODBC availability Does anyone know why it is that the MyODBC authors prefer not to allow that to be distributed in the unixODBC package, or with distros (eg the SuSE CDs don't contain it)? Venu Peter will answer this, why MyODBC is not included in Venu unixODBC distribution :) Venu Peter, any comments .. ? From our side, the only reason is that the unixODBC people has not wanted/asked us about this. The MySQL GPL license allows them to do this, even without asking us. Regards, Monty - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MyODBC leaking handles...
Hi again, Some more information; OS: Windows 2000 Professional, SP2a + all patches mySQL 3.32.46 (windows version) myODBC 2.50.37 I open then database, do a select, close the recordset and finally close the database. This results in 2 handles increase. (Notised in windows task manager) If I loop this test, the handles counter just goes through the roof. over 800.000 handles over one night! I have done the exact same test with MS SQL Server 7.0 and 2000, no missing handles. This works for oracle's drivers as well. I guess that a trace can be useful? However, I should upload it to your FTP right? (If I read the manual right :)) I'll be happy to assist you with any data needed, just let me know what to send. / Jens -Original Message- From: Venu [mailto:[EMAIL PROTECTED]] Sent: den 18 december 2001 19:38 To: Jens Collin; [EMAIL PROTECTED] Subject: RE: MyODBC leaking handles... Hi, -Original Message- From: Jens Collin [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 18, 2001 4:22 AM To: '[EMAIL PROTECTED]' Subject: MyODBC leaking handles... Hi all, This is my first post in this forum. I've tried to find something in the documentation but failed. I cannot find out why the ODBC driver is leaking 1 handle for each request that I do! It doesn't matter if I close it or whatever I do. Anyone that knows what to do? Any hints or tips? Recently we found the leaks in the initialization towards UNIX, and fixed them from driver and server, but we didn't find any thing from Windows (The Unix fixes will be there for 2.50.40 and 3.51.01) Windows 2000 Professional MySQL 3.23 MyODBC 2.50.39 Can you be more specific on this, please ? If you can send the leaks statistics, it will be a great help. Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.com Regards, ___ Jens A. Collin Envox Technical System Developer Envox Group Söder Mälarstrand 43 118 25 Stockholm Sweden Office: +46 (0)8 56 256 000 Fax : +46 (0)8 56 256 050 [EMAIL PROTECTED] http://www.envox.com ___ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MyODBC leaking handles...
Hi, -Original Message- From: Jens Collin [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 19, 2001 3:05 AM To: '[EMAIL PROTECTED]'; [EMAIL PROTECTED] Subject: RE: MyODBC leaking handles... Hi again, Some more information; OS: Windows 2000 Professional, SP2a + all patches mySQL 3.32.46 (windows version) myODBC 2.50.37 I open then database, do a select, close the recordset and finally close the database. This results in 2 handles increase. (Notised in windows task manager) If I loop this test, the handles counter just goes through the roof. over 800.000 handles over one night! I have done the exact same test with MS SQL Server 7.0 and 2000, no missing handles. This works for oracle's drivers as well. I guess that a trace can be useful? However, I should upload it to your FTP right? (If I read the manual right :)) I'll be happy to assist you with any data needed, just let me know what to send. Thanks for the feedback. I will look into it immediately. When I tested with PURIFY, I couldn't find any leaks. Let me do a cross check again. Another small note, might be useful. There are some open resources allocated for the driver during the initialization, and will be freed only upon termination or unloading of driver from memory. So, does this happen even after terminating the application in the proper sequence of calls ? No need of any trace right now, if needed I will ask you. Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.com -Original Message- From: Venu [mailto:[EMAIL PROTECTED]] Sent: den 18 december 2001 19:38 To: Jens Collin; [EMAIL PROTECTED] Subject: RE: MyODBC leaking handles... Hi, -Original Message- From: Jens Collin [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 18, 2001 4:22 AM To: '[EMAIL PROTECTED]' Subject: MyODBC leaking handles... Hi all, This is my first post in this forum. I've tried to find something in the documentation but failed. I cannot find out why the ODBC driver is leaking 1 handle for each request that I do! It doesn't matter if I close it or whatever I do. Anyone that knows what to do? Any hints or tips? Recently we found the leaks in the initialization towards UNIX, and fixed them from driver and server, but we didn't find any thing from Windows (The Unix fixes will be there for 2.50.40 and 3.51.01) Windows 2000 Professional MySQL 3.23 MyODBC 2.50.39 Can you be more specific on this, please ? If you can send the leaks statistics, it will be a great help. Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.com Regards, ___ Jens A. Collin Envox Technical System Developer Envox Group Söder Mälarstrand 43 118 25 Stockholm Sweden Office: +46 (0)8 56 256 000 Fax : +46 (0)8 56 256 050 [EMAIL PROTECTED] http://www.envox.com ___ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MyODBC leaking handles...
Hi, -Original Message- From: Jens Collin [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 18, 2001 4:22 AM To: '[EMAIL PROTECTED]' Subject: MyODBC leaking handles... Hi all, This is my first post in this forum. I've tried to find something in the documentation but failed. I cannot find out why the ODBC driver is leaking 1 handle for each request that I do! It doesn't matter if I close it or whatever I do. Anyone that knows what to do? Any hints or tips? Recently we found the leaks in the initialization towards UNIX, and fixed them from driver and server, but we didn't find any thing from Windows (The Unix fixes will be there for 2.50.40 and 3.51.01) Windows 2000 Professional MySQL 3.23 MyODBC 2.50.39 Can you be more specific on this, please ? If you can send the leaks statistics, it will be a great help. Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.com Regards, ___ Jens A. Collin Envox Technical System Developer Envox Group Söder Mälarstrand 43 118 25 Stockholm Sweden Office: +46 (0)8 56 256 000 Fax : +46 (0)8 56 256 050 [EMAIL PROTECTED] http://www.envox.com ___ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MyODBC availability
Hi Kevin, -Original Message- From: Kevin Donnelly [mailto:[EMAIL PROTECTED]] Sent: Monday, December 17, 2001 12:47 PM To: [EMAIL PROTECTED] Subject: MyODBC availability Does anyone know why it is that the MyODBC authors prefer not to allow that to be distributed in the unixODBC package, or with distros (eg the SuSE CDs don't contain it)? Peter will answer this, why MyODBC is not included in unixODBC distribution :) Peter, any comments .. ? Is it a licensing issue, something to do with the ODBC spec, or just plain don't want to do that, so there (which, I hasten to add, is perfectly acceptable)? No such, as long as it is GPL distribution. Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MyODBC availability
Venu [EMAIL PROTECTED] writes: No such, as long as it is GPL distribution. Actually, it's Public Domain, not GPL. It's included in Red Hat Linux 7.2. -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MyODBC availability
Does anyone know why it is that the MyODBC authors prefer not to allow that to be distributed in the unixODBC package, or with distros (eg the SuSE CDs don't contain it)? Peter will answer this, why MyODBC is not included in unixODBC distribution :) Peter, any comments .. ? Is it a licensing issue, something to do with the ODBC spec, or just plain don't want to do that, so there (which, I hasten to add, is perfectly acceptable)? No such, as long as it is GPL distribution. I had it in unixODBC originally but I gather someone asked Nick to remove it. Mind you; I just built the OSX version of MyODBC by copying all the MyODBC source (just *.h and *.c) into the unixODBC source tree. However; I only checked the make (actually qmake project file) into unixODBC cvs. It was really important, when unixODBC first started, to have some drivers in the unixODBC source tree but it less important now. What is REALLY important is to encourage Linux, UNIX, and OSX people to put unixODBC itself into O/S distros as a standard thing. Then allow drivers to be added with the assumption that the O/S has some form of ODBC sub-system. It's not as of there is some kind of overhead of having it on a system and not being used (no processes and 1 meg on disk for the core stuff). The upside is significant. Peter - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MyODBC Problem with SQL2000 - MySQL Data Transformation
Hi, -Original Message- From: Jack A. Fobel [mailto:[EMAIL PROTECTED]] Sent: Saturday, December 01, 2001 3:22 PM To: MySQL List Subject: MyODBC Problem with SQL2000 - MySQL Data Transformation Hi Folks, I'm having a problem when I try to populate a MySQL database using DTS in SQL2000. The data types on the SQL2k table are varchar, as well as the types in MySQL. I am receiving a 'Data Overflow' error for each column that it tries to update. I've tried numerous ways of population, each failing with this error code. I'm beginning to think it is the MyODBC driver. I connect to SQL2k with OLD DB and use MyODBC to connect to MySQL. Have any of you tried doing this yet? Just curious that maybe you have run into this before. Last week only I spent some time on this issue, as the DTS from MS is not mapping the varchar columns properly to MySQL when using MyODBC, and in some cases it maps varchar to set :) I will trace down the problem this week, and I will update you on that. Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MyODBC: DSN Creation
Hi Kevin, -Original Message- From: Kevin Smith [mailto:[EMAIL PROTECTED]] Sent: Monday, November 26, 2001 9:25 AM To: [EMAIL PROTECTED] Subject: MyODBC: DSN Creation Hi All, I need to setup MyODBC DSN's for MySQL access. Does anyone know how to build a simple installer that will create User/System DSN's from a file? ie. like the odbc.inf file included with the MyODBC installer? Can odbcconf.exe be used to install a DSN? If so, what are the parameters used to create a DSN, can you give me a good example. Many thanks, You can make use of 'myodbc.rsp' file that comes with the binary distribution, which configures MyODBC and the sample DSN using odbcconf.exe. The simple command for this is odbcconf /f myodbc.rsp Here is the myodbc.rsp that is included in the distribution for 2.50.40 version. INSTALLDRIVER MySQL Driver|Driver=myodbc.dll|Setup=myodbc.dll|| CONFIGDRIVER MySQL Driver APILevel=2 CONFIGDRIVER MySQL Driver ConnectFunctions=YYN CONFIGDRIVER MySQL Driver DriverODBCVer=2.50.40 CONFIGDRIVER MySQL Driver FileUsage=0 CONFIGDRIVER MySQL Driver FileExtns=*.txt CONFIGDRIVER MySQL Driver SQLLevel=1 CONFIGDRIVER MySQL Driver CPTimeout=60 CONFIGDSN MySQL Driver DSN=sample-MySQL;Description=MySQL ODBC Driver;SERVER=database_server;User=odbc;DB=test;Port=3306|| Regards, venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MyODBC question
Valentin Kulikov wrote: while:I have set 'myname' as a user name. Somebody (MyODBC? Windows2000?) added a suffix '@mydialup-provider.com' to my db user name. Or maybe a problem is in something else and a diagnostic is incorrect? Unless you connect to MySQL via a unix socket, the hostname of the client box will always be added to the connection string. That is for security and I believe MySQL does it. You (or your admin) needs to add an entry into the user or db table for your dial-up host. --Bill - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MyODBC properties window / VB data environment / ADODB
Hi ! )-Original Message- )From: Mikko Lampinen [mailto:[EMAIL PROTECTED]] )Sent: Tuesday, September 18, 2001 12:33 PM )To: [EMAIL PROTECTED] )Subject: MyODBC properties window / VB data environment / ADODB ) ) )Hi, ) )I'm using Data environment (Visual Basic) and MyOdbc to make a )connection to )Mysql database. Every time my program establishes a connection using Data )environment, the MyOdbc property window pops up. This dialog does )not appear )if connection is established using ADODB. ) )So, firstly, is there any way to prevent MyOdbc property window )appearing if )data environment is used? Ok, fixed in the 2.50.39 MyODBC release. Please tuned to announces or myodbc list for the release announcement of this version later today or tomorrow from Monty. ) )Secondly, is it recommended to use ADODB with MyOdbc/MySql at all? Yes. Do you have any to say NO ? )There have been few warnings concerning ADODB and (sleeping) threads in some news )groups. As for as I know, we are clearing all issues that pops up from mailto:[EMAIL PROTECTED] or mailto:[EMAIL PROTECTED]. There are some known issues that are mainly due to version mismatch b/w the 2.x driver and 3.x ODBC DM, and in that majority of them are MS ODBC DM related. If you take a look at Microsoft knowledge base or news groups, you find the reason, why certain things are not working with ADO/DAO/RDO through the ODBC 2.x compliant drivers. For this reason only, we are developing a new MyODBC3 driver which is based on ODBC 3.51 specifications, and we might have a BETA-1 release of this driver this month end. If there is anything stalled from 2.50 MyODBC driver, please send a detailed mail to mailto:[EMAIL PROTECTED] (or if you have a support contract, send it to mailto:[EMAIL PROTECTED] ), which includes: 1. Version of the MyODBC driver and the server 2. Problem description 3. ODBC trace by ODBC DM and MyODBC 4. Reproducible sample. So that we can look forward for the solution. Regards, venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu mailto:[EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MyODBC, DBUG and multi-threaded clients
Hi Monty, Michael Widenius wrote: Hi! Sinisa == Sinisa Milivojevic [EMAIL PROTECTED] writes: Sinisa Peter Duffy writes: Hi Sinisa, My problems are within the mysqlclient and MyODBC libraries, both used directly by the application (and therefore all on the client side of the socket.) Both the mysqlclient and MyODBC libraries do (or in my case did) contain calls to the DBUG functions. Obviously, given the fact that the libraries are being called directly by the application, the amount of multi-threading done by the application is most emphatically relevant. cut Just a note about this; I have now updated the section 'How to Make a Thread-safe Client' with more information regarding this. This should be available on our web site shortly. Thanks - I'll look out for this. Regards, Peter - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MyODBC, DBUG and multi-threaded clients
Hi Monty, Michael Widenius wrote: Hi! I have a small comment to this. Note that you will get crashes in the DBUG package if you call any MySQL function inside a thread that hasn't called mysql_init() or mysql_connect(). If you want to use MySQL functions in threads that doesn't call the above functions, you need to call my_thread_init() at the start of the thread and my_thread_end() before the thread ends. If you think that the DBUG functions are the ones that is causing problems, you can always recompile MySQL without --with-debug, in which the DBUG macros will not generate any code. Regards, Monty Thanks very much for this: I will check the application for these calls. Regards, Peter - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MyODBC, DBUG and multi-threaded clients
Hi! Sinisa == Sinisa Milivojevic [EMAIL PROTECTED] writes: Sinisa Peter Duffy writes: Hi Sinisa, My problems are within the mysqlclient and MyODBC libraries, both used directly by the application (and therefore all on the client side of the socket.) Both the mysqlclient and MyODBC libraries do (or in my case did) contain calls to the DBUG functions. Obviously, given the fact that the libraries are being called directly by the application, the amount of multi-threading done by the application is most emphatically relevant. cut Just a note about this; I have now updated the section 'How to Make a Thread-safe Client' with more information regarding this. This should be available on our web site shortly. Regards, Monty - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MyODBC, DBUG and multi-threaded clients
Hi! I have a small comment to this. Sinisa == Sinisa Milivojevic [EMAIL PROTECTED] writes: cut I have no interest in any other clients except possibly to investigate whether or not they produced anything like the same behaviour that I am observing with my own application. My only key objective is to fix my application, which, to repeat again, is coredumping during calls to DBUG functions within the mysqlclient and MyODBC libraries. Regards, Peter Sinisa Exactly what I mean. There are several multithreaded clients out there Sinisa all using libmysqlclient and some MyODBC and none of them experience Sinisa the problems you describe. Note that you will get crashes in the DBUG package if you call any MySQL function inside a thread that hasn't called mysql_init() or mysql_connect(). If you want to use MySQL functions in threads that doesn't call the above functions, you need to call my_thread_init() at the start of the thread and my_thread_end() before the thread ends. If you think that the DBUG functions are the ones that is causing problems, you can always recompile MySQL without --with-debug, in which the DBUG macros will not generate any code. Regards, Monty - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MyODBC, DBUG and multi-threaded clients
Peter Duffy writes: Hi Sinisa, My problems are within the mysqlclient and MyODBC libraries, both used directly by the application (and therefore all on the client side of the socket.) Both the mysqlclient and MyODBC libraries do (or in my case did) contain calls to the DBUG functions. Obviously, given the fact that the libraries are being called directly by the application, the amount of multi-threading done by the application is most emphatically relevant. First of all DBUG_* are not functions but macros and very simple macros for that fact. And if there was a bug in any of those macros, it would have surfaced in our server or in any of our multi-threaded client, like mysqlmanager. I have no interest in any other clients except possibly to investigate whether or not they produced anything like the same behaviour that I am observing with my own application. My only key objective is to fix my application, which, to repeat again, is coredumping during calls to DBUG functions within the mysqlclient and MyODBC libraries. Regards, Peter Exactly what I mean. There are several multithreaded clients out there all using libmysqlclient and some MyODBC and none of them experience the problems you describe. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MyODBC, DBUG and multi-threaded clients
Peter Duffy writes: Hi Sinisa, Do you know of any which are specifically accessed by multi-threaded client applications via ODBC? (If so, I'd really like to know, so that I can try to get hold of copies of the client applications to test in my own environment.) As you very well know, it is completely irrelevant what kind of multi-threaded program it is. Those function perform the same regardless if programs listents to the socket or write to the socket. DBUG functions have got nothing to do with that. There are many such programs utilizing DBUG functions, like mysqlmanagers in tool directory of 4.0. Then several GUI clients. Practically dozens of them. Some of those GUI clients utilizing ODBC. Do some research on your side. I'm sorry about your experiences with mpatrol. As I've said, I find it superb: it has already been of enormous assistance in fixing memory leaks, and in the current situation it gave me information that I could not have gained otherwise. Also, I've always found the author of mpatrol to be highly responsive and helpful. I have not used dmalloc. Best regards, Peter Oh, I had no problems by authors of either mpatrol and dmalloc. I just got reply that my problems lie beyond scopes of their programs and that they will do it one day when they have time, which is OK. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MyODBC, DBUG and multi-threaded clients
Hi Sinisa, Sinisa Milivojevic wrote: Peter Duffy writes: Hi Sinisa, Do you know of any which are specifically accessed by multi-threaded client applications via ODBC? (If so, I'd really like to know, so that I can try to get hold of copies of the client applications to test in my own environment.) As you very well know, it is completely irrelevant what kind of multi-threaded program it is. Those function perform the same regardless if programs listents to the socket or write to the socket. DBUG functions have got nothing to do with that. My problems are within the mysqlclient and MyODBC libraries, both used directly by the application (and therefore all on the client side of the socket.) Both the mysqlclient and MyODBC libraries do (or in my case did) contain calls to the DBUG functions. Obviously, given the fact that the libraries are being called directly by the application, the amount of multi-threading done by the application is most emphatically relevant. There are many such programs utilizing DBUG functions, like mysqlmanagers in tool directory of 4.0. Then several GUI clients. Practically dozens of them. Some of those GUI clients utilizing ODBC. Do some research on your side. I have no interest in any other clients except possibly to investigate whether or not they produced anything like the same behaviour that I am observing with my own application. My only key objective is to fix my application, which, to repeat again, is coredumping during calls to DBUG functions within the mysqlclient and MyODBC libraries. Regards, Peter - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MyODBC, DBUG and multi-threaded clients
Peter Duffy writes: Versions: Linux: Redhat 6.2, kernel 2.2.16-3 (using Terje Malmedal's coredump patch from http://www.movement.uklinux.net - there are a number of patches addressing the threaded coredump issue, but this one was specific for my kernel and it sure as hell did the business 8)) OpenLDAP: originally 2.0.7, then 2.0.11. mysql: 3.23.38 MyODBC: 2.50.33 libiodbc: 3.0.5 mpatrol: 1.4.5 (http://www.cbmamiga.demon.co.uk/mpatrol) Hi! As an example, mysql server is a multi-threaded program and when compile --with-debug it uses DBUG function. There are literally thousands and thousands of locations where mysql server built for debugging is running, without a single problem being caused by those routines. Furthermore, these routines have not been changed for years and have been thoroughly checked with Purify and Pure Coverage which are much better tools then mpatrol. I have my own reservations regarding mpatrol and dmalloc. None of them, for example, worked with my C++ programs. They just crashed/ refused to work. I have tried latest versions and wrote to the authors. That was more then one year ago. It is possible that meanwhile this situation has been fixed. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MyODBC, DBUG and multi-threaded clients
Hi Sinisa, Sinisa Milivojevic wrote: As an example, mysql server is a multi-threaded program and when compile --with-debug it uses DBUG function. I know. As I said, one of my main problems is that MyODBC does not have a --without-debug option. There are literally thousands and thousands of locations where mysql server built for debugging is running, without a single problem being caused by those routines. Do you know of any which are specifically accessed by multi-threaded client applications via ODBC? (If so, I'd really like to know, so that I can try to get hold of copies of the client applications to test in my own environment.) Furthermore, these routines have not been changed for years and have been thoroughly checked with Purify and Pure Coverage which are much better tools then mpatrol. I don't doubt that the routines have been thoroughly checked. However, I am talking about specific problems and specific observations in my own work. The application coredumped; the backtraces (persistently) pointed me at the DBUG_ calls in MyODBC; I commented-out the calls; the situation vastly improved. If you could suggest an alternative explanation and approach, I'd be happy to hear it. I have my own reservations regarding mpatrol and dmalloc. None of them, for example, worked with my C++ programs. They just crashed/ refused to work. I have tried latest versions and wrote to the authors. That was more then one year ago. It is possible that meanwhile this situation has been fixed. I'm sorry about your experiences with mpatrol. As I've said, I find it superb: it has already been of enormous assistance in fixing memory leaks, and in the current situation it gave me information that I could not have gained otherwise. Also, I've always found the author of mpatrol to be highly responsive and helpful. I have not used dmalloc. Best regards, Peter - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MyODBC between MySQL-Server (Linux) and Linux-Client
Hi !! )-Original Message- )From: [EMAIL PROTECTED] )[mailto:[EMAIL PROTECTED]]On Behalf Of Peter Harvey )Sent: Saturday, September 01, 2001 8:13 AM )To: [EMAIL PROTECTED] )Subject: Re: MyODBC between MySQL-Server (Linux) and Linux-Client ) ) ) ) root@workstation3:/home/manuel isql -v MySQLtest dbuser ) [unixODBC][TCX][MyODBC]Can't connect to local MySQL server through socket ) '/var/lib/mysql/mysql.sock' (2) ) [ISQL]ERROR: Could not SQLConnect ) root@workstation3:/home/manuel ) ) It seems to try to connect to a local mysql-server, wich doesn't exist? ) ) My /etc/odbc.ini on the other Linux client (same as on the server): ) ) )How did you add the odbc.ini entry... using ODBCConfig? I am )thinking that you may )have dropped it into the wrong place using a text editor... but )then again... it does )not quite sound like it. Hmmm The default location for the system ini is )/usr/local/lib/etc/odbc.ini or something like that. Using )ODBCConfig (or odbcinst) is )a good way to ensure that you modify the correct ini file. ) Also, check what is the $ODBCINI value and make sure it is really pointing to the expected odbc.ini. If not export ODBCINI to your odbc.ini file path and try. Some times better to include filename also in to the path like export ODBCINI=/usr/etc/odbc.ini Regards Venu -- For technical support contracts, go to https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Venu mailto:[EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ Woodside, California USA ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MyODBC between MySQL-Server (Linux) and Linux-Client
root@workstation3:/home/manuel isql -v MySQLtest dbuser [unixODBC][TCX][MyODBC]Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) [ISQL]ERROR: Could not SQLConnect root@workstation3:/home/manuel It seems to try to connect to a local mysql-server, wich doesn't exist? My /etc/odbc.ini on the other Linux client (same as on the server): How did you add the odbc.ini entry... using ODBCConfig? I am thinking that you may have dropped it into the wrong place using a text editor... but then again... it does not quite sound like it. Hmmm The default location for the system ini is /usr/local/lib/etc/odbc.ini or something like that. Using ODBCConfig (or odbcinst) is a good way to ensure that you modify the correct ini file. Peter -- +--- | Data Architect | your data; how you want it | http://www.codebydesign.com +--- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: myODBC?
Hi, maybe I didn't phrase my question correctly. I'm using a SGI machine running Irix and going to be using a mySQL db on a Linux box behind a firewall. Since I will set up a tunnel with ssh2 to forward port 3306, it will appear to the Irix system that the db exists locally. Now here is what I'm confused about: Do I 1) install both iODBC and myODBC on the Irix system? or 2) install iODBC on the Irix one and myODBC on that Linux machine where the mySQL db physically located? Thanks! Wen -Original Message- From: Venu [mailto:[EMAIL PROTECTED]] Sent: Friday, August 24, 2001 9:33 AM To: Werner Stürenburg; Wen Tien Cc: [EMAIL PROTECTED] Subject: RE: myODBC? Hi !!! )-Original Message- )From: Werner Stürenburg [mailto:[EMAIL PROTECTED]] )Sent: Friday, August 24, 2001 5:59 AM )To: Wen Tien )Cc: [EMAIL PROTECTED] )Subject: Re: myODBC? ) ) )In my understanding, myODBC is a middleware for programs which )don't know how to deal directly with mySQL. So if you use perl or )php, you won't ever use ODBC, as this only slows things down, )obviously. ODBC is kind of a workaround in my understanding. ) )Please correct me, if I'm wrong. ) )Wen Tien schrieb am Freitag, 24. August 2001, 14:39:55: ) ) Hi, ) I am a newbie that has a question about what exactly is )myODBC (for Unix) ) doing. Is myODBC, 1) a wrapper over the mySQL database to )make it conform ) to the ODBC interface or 2) a plug-in driver that goes with a manager ) program to allow the access of mySQL db? I am using an Irix machine that ) tries to use a mySQL db on a Linux box (natively via port )forwarding) so I'm ) trying to decide where to install what... thanks. ) MyODBC is a ODBC Driver for MySQL. The current version is fully conformed to MS ODBC 2.x Specifications. So you can use the driver to access MySQL as per this specifications. Coming to the second one, yes, MyODBC works fine with all major driver managers such as MS ODBC DM, iODBC, unixODBC and Merant ODBC DM. Also it works in a stand alone mode too when you link the static library of the driver to your application. In this case no DSN issue will be coming. You can use DSN less connection, by specifying proper connection fields. The only drawback in this case (for any odbc driver ) is it can only talk to MySQL server, and it can't talk to any other, but its not the case when going through the manager. Regards Venu -- For technical support contracts, go to https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ Woodside, California USA ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: myODBC?
Hi !! )-Original Message- )From: Wen Tien [mailto:[EMAIL PROTECTED]] )Sent: Friday, August 24, 2001 1:58 PM )To: [EMAIL PROTECTED]; Werner Stürenburg )Cc: [EMAIL PROTECTED] )Subject: RE: myODBC? ) ) )Hi, maybe I didn't phrase my question correctly. I'm using a SGI machine )running Irix and going to be using a mySQL db on a Linux box behind a )firewall. Since I will set up a tunnel with ssh2 to forward port 3306, it )will appear to the Irix system that the db exists locally. Now )here is what )I'm confused about: Do I 1) install both iODBC and myODBC on the Irix )system? or 2) install iODBC on the Irix one and myODBC on that )Linux machine )where the mySQL db physically located? Thanks! ) You need to install both iODBC or unixODBC and MyODBC in the client side from which your ODBC application tries to access (Irix) the db from Linux m/c. Regards Venu -- For technical support contracts, go to https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ Woodside, California USA ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: myODBC?
Hi !!! )-Original Message- )From: Werner Stürenburg [mailto:[EMAIL PROTECTED]] )Sent: Friday, August 24, 2001 5:59 AM )To: Wen Tien )Cc: [EMAIL PROTECTED] )Subject: Re: myODBC? ) ) )In my understanding, myODBC is a middleware for programs which )don't know how to deal directly with mySQL. So if you use perl or )php, you won't ever use ODBC, as this only slows things down, )obviously. ODBC is kind of a workaround in my understanding. ) )Please correct me, if I'm wrong. ) )Wen Tien schrieb am Freitag, 24. August 2001, 14:39:55: ) ) Hi, ) I am a newbie that has a question about what exactly is )myODBC (for Unix) ) doing. Is myODBC, 1) a wrapper over the mySQL database to )make it conform ) to the ODBC interface or 2) a plug-in driver that goes with a manager ) program to allow the access of mySQL db? I am using an Irix machine that ) tries to use a mySQL db on a Linux box (natively via port )forwarding) so I'm ) trying to decide where to install what... thanks. ) MyODBC is a ODBC Driver for MySQL. The current version is fully conformed to MS ODBC 2.x Specifications. So you can use the driver to access MySQL as per this specifications. Coming to the second one, yes, MyODBC works fine with all major driver managers such as MS ODBC DM, iODBC, unixODBC and Merant ODBC DM. Also it works in a stand alone mode too when you link the static library of the driver to your application. In this case no DSN issue will be coming. You can use DSN less connection, by specifying proper connection fields. The only drawback in this case (for any odbc driver ) is it can only talk to MySQL server, and it can't talk to any other, but its not the case when going through the manager. Regards Venu -- For technical support contracts, go to https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ Woodside, California USA ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: myODBC?
In my understanding, myODBC is a middleware for programs which don't know how to deal directly with mySQL. So if you use perl or php, you won't ever use ODBC, as this only slows things down, obviously. ODBC is kind of a workaround in my understanding. Please correct me, if I'm wrong. Wen Tien schrieb am Freitag, 24. August 2001, 14:39:55: Hi, I am a newbie that has a question about what exactly is myODBC (for Unix) doing. Is myODBC, 1) a wrapper over the mySQL database to make it conform to the ODBC interface or 2) a plug-in driver that goes with a manager program to allow the access of mySQL db? I am using an Irix machine that tries to use a mySQL db on a Linux box (natively via port forwarding) so I'm trying to decide where to install what... thanks. Wen Tien - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Herzlich Werner -- MySQL in Deutschland: Anpassung, Unterstützung, Schulung für Sie __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Dr. Werner Stürenburg [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Consultant /_/ /_/\_, /___/\___\_\___/ Bielefeld, Germany ___/ www.mysql.com +49-5224-997-407 Fax -409 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MyODBC, MySQL, and a little bit of perl
On Sat, Aug 18, 2001 at 04:25:50PM -0700, John Meyer wrote:
Here's the error message that I am getting:
[911] [2] [0] [Microsoft][ODBC Driver Manager] Invalid string or buffer
length
And here is the code
my $sqlcommand = INSERT INTO
EMAILS(PERSONALITY_ID,EMAIL_HEADER,EMAIL_EMAIL,EMAIL_FROM,EMAIL_SUBJECT)
VALUES( . $personalid . ,\ . $headerlines . \,\ . $lines . \,\
^
+--- that's not right, is it?
How about something like this:
# sets up a var for sprintf.
my $sql_fmt = qq{insert into emails
( personality_id, email_header, email_email, email_from, email_subject )
values( %s, %s, %s, %s, %s )
};
my $sql = sprintf( $sql_fmt, $personalid, $headerlines, $lines, $from, $subject );
$emails-sql($sql);
--
Any technology distinguishable from magic is insufficiently advanced.
TopQuark Software Serv. Contract programmer, server bum.
[EMAIL PROTECTED]Give up Spammers; I use procmail.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MyOdbc to unix
Hi Venu, I want some sample codes for ODBC connection to MySQL. Where can I get it? R.Srivatsan [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MyOdbc to unix
SRIVATSAN RAGHURAMAN writes: Hi Venu, I want some sample codes for ODBC connection to MySQL. Where can I get it? R.Srivatsan [EMAIL PROTECTED] To connect from Unix or from Windows ?? -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MyOdbc to unix
Hi Sinisa, Sorry I should have mentioned this earlier. From Windows. R.Srivatsan [EMAIL PROTECTED] ___ Sinisa Milivojevic [EMAIL PROTECTED] Wrote--- SRIVATSAN RAGHURAMAN writes: Hi Venu, I want some sample codes for ODBC connection to MySQL. Where can I get it? R.Srivatsan [EMAIL PROTECTED] To connect from Unix or from Windows ?? -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MyOdbc to unix
Hi !
-Original Message-
From: SRIVATSAN RAGHURAMAN [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 07, 2001 6:13 PM
To: [EMAIL PROTECTED]
Subject: RE: MyOdbc to unix
Hi Sinisa,
Sorry I should have mentioned this earlier. From Windows.
R.Srivatsan
[EMAIL PROTECTED]
___
Sinisa Milivojevic [EMAIL PROTECTED] Wrote---
SRIVATSAN RAGHURAMAN writes:
Hi Venu,
I want some sample codes for ODBC connection to MySQL.
Where can I get it?
R.Srivatsan
[EMAIL PROTECTED]
To connect from Unix or from Windows ??
We are sorry to say this, at present there is no MyODBC samples available
for the public. We are in the plan of distributing some basic samples with
the next release version of the driver, shortly.
FYI, to establish a connection to MySQL through MyODBC, follow the following
instrcutions:
-- Download MyODBC driver from
http://www.mysql.com/downloads/api-myodbc.html
-- Follow the instructions from the online manual to install and configure
the DSN.
http://www.mysql.com/documentation/mysql/bychapter/manual_ODBC.html#ODBC
-- If you want to use it on Unix, configure the MyODBC with iODBC or
unixODBC. Please read the following archive which gives complete details in
setting up the MyODBC with iODBC/unixODBC:
http://lists.mysql.com/cgi-ez/ezmlm-cgi?5:mss:3657:200108:einnhiokafobjmjbmc
bm
-- Once DSN (lets say MyTest) as configured in ODBC.INI, write a simple
C-ODBC as given below and build it by linking through DM libraries. On NT,
use odbc32.lib.
Hope this helps you, let me know if you have any questions on this.
Regards
Venu
/* Common system headers */
#include windows.h /* for WINDOWS */
#include stdio.h
#include assert.h
/* MS SQL API headers */
#include sql.h
#include sqlext.h
/* PROTOTYPE */
void tmysql_error(RETCODE rc,HENV henv,HDBC hdbc,HSTMT hstmt);
void my_test(HDBC hdbc,HSTMT hstmt);
/* UTILITY MACROS */
#define MyEnvCHECK(henv,r) \
if ( ((r) != SQL_SUCCESS) ) \
tmysql_error(r, henv, NULL, NULL); \
assert( ((r) == SQL_SUCCESS) || ((r) == SQL_SUCCESS_WITH_INFO) )
#define MyConCHECK(hdbc,r) \
if ( ((r) != SQL_SUCCESS) ) \
tmysql_error(r, NULL, hdbc, NULL); \
assert( ((r) == SQL_SUCCESS) || ((r) == SQL_SUCCESS_WITH_INFO) )
#define MyStmtCHECK(hstmt,r) \
if ( ((r) != SQL_SUCCESS) ) \
tmysql_error(r, NULL, NULL, hstmt); \
assert( ((r) == SQL_SUCCESS) || ((r) == SQL_SUCCESS_WITH_INFO) )
void main()
{
HENV henv;
HDBC hdbc;
HSTMT hstmt;
RETCODE rc;
char *dsn= MyTest;
char *uid= username;
char *pwd= password;
/* ALLOCATE ENVIRONMENT HANDLE */
rc = SQLAllocEnv(henv);
MyEnvCHECK(henv,rc);
/* ALLOCATE CONNECTION HANDLE */
rc = SQLAllocConnect(henv, hdbc);
MyEnvCHECK(henv,rc);
/* CONNECT TO THE SERVER */
printf(connecting to '%s' with user name '%s'...\n,dsn,uid);
rc = SQLConnect(hdbc, dsn, SQL_NTS, uid, SQL_NTS, pwd, SQL_NTS);
MyConCHECK(hdbc,rc);
/* ALLOCATE STATEMENT HANDLE */
rc = SQLAllocStmt(hdbc, hstmt);
MyConCHECK(hdbc,rc);
/* CALL FUNCTION TO PERFORM BASIC SQL OPS */
my_test(hdbc, hstmt);
/* FREE ALL HANDLES and DISCONNECT FROM SERVER */
rc = SQLFreeStmt(hstmt, SQL_DROP);
MyStmtCHECK(hstmt,rc);
printf(disconnecting from server ...\n);
rc = SQLDisconnect(hdbc);
MyConCHECK(hdbc,rc);
rc = SQLFreeConnect(hdbc);
MyConCHECK(hdbc,rc);
rc = SQLFreeEnv(henv);
MyEnvCHECK(henv,rc);
} /* END OF MAIN */
/**
Simple function to do basic ops with MySQL
*/
void myodbc_test(HDBC hdbc,HSTMT hstmt)
{
RETCODE rc;
int nInData = 1;
int nOutData, nRowCount;
char szOutData[31]={0};
/* CREATE TABLE 'myodbc' */
SQLExecDirect(hstmt,drop table tmyodbc ,SQL_NTS);
rc = SQLExecDirect(hstmt,create table tmyodbc (col1 int, col2
varchar(30)),SQL_NTS);
MyStmtCHECK(hstmt,rc);
rc = SQLTransact(NULL,hdbc,SQL_COMMIT);
MyConCHECK(hdbc,rc);
rc = SQLFreeStmt(hstmt,SQL_CLOSE);
MyStmtCHECK(hstmt,rc);
/* DIRECT INSERT */
rc = SQLExecDirect(hstmt,insert into tmyodbc
values(10,'direct-insert'),SQL_NTS);
MyStmtCHECK(hstmt,rc);
/* PREPARE INSERT */
rc = SQLPrepare(hstmt,insert into tmyodbc
values(?,'PARAM_INSERT'),SQL_NTS);
MyStmtCHECK(hstmt,rc);
rc = SQLBindParameter(hstmt,1,SQL_PARAM_INPUT, SQL_C_LONG,SQL_INTEGER,
0,0,nIndata,0,NULL);
MyStmtCHECK(hstmt,rc);
for (nIndata=20 ; nIndata100; nIndata=index+10)
{
rc = SQLExecute(hstmt);
MyStmtCHECK(hstmt,rc);
}
rc = SQLTransact(NULL,hdbc,SQL_COMMIT);
MyConCHECK(hdbc,rc);
/* FREE THE PARAM BUFFERS */
rc = SQLFreeStmt(hstmt,SQL_RESET_PARAMS);
MyStmtCHECK(hstmt,rc);
rc = SQLFreeStmt(hstmt,SQL_CLOSE);
MyStmtCHECK(hstmt,rc
