does ado/myodbc not support blob data insert in vc6?
hi,all! ENV: mysql server 5.1, myodbc 5.1.5, vc 6.0, I use ado to operate mysql. I found it can't work to insert a blob data to mysql server. And it is no problem to get the blob data from mysql server. what's the matter? I used the source code of MSDN about AppendChunk and GetChunk Methods Example (VC++) http://msdn.microsoft.com/en-us/library/ms676103(VS.85).aspx The connection to mysql server was changed by following: _bstr_t strCnn(DRIVER={MySQL ODBC 5.1 Driver}; SERVER=localhost;DATABASE=test; USER=root; PASSWORD=111;OPTION=3;); -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
does ado/myodbc not support blob data insert in vc6?
hi,all! ENV: mysql server 5.1, myodbc 5.1.5, vc 6.0, I use ado to operate mysql. I found it can't work to insert a blob data to mysql server. And it is no problem to get the blob data from mysql server. what's the matter? I used the source code of MSDN about AppendChunk and GetChunk Methods Example (VC++) http://msdn.microsoft.com/en-us/library/ms676103(VS.85).aspx The connection to mysql server was changed by following: _bstr_t strCnn(DRIVER={MySQL ODBC 5.1 Driver}; SERVER=localhost;DATABASE=test; USER=root; PASSWORD=111;OPTION=3;); -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Problems with MyODBC 3.51.12 for MacOSX Panther
Hi all, I have downloaded and installed the myodbc3 driver for MacOSX onto my Panther machine (10.3.9). First surprise, the MySQL graphical installer doesn't seem to appear in the Applications folder, has it been dropped ? Secondly, although I have manage to configure ODBCAdministrator, the datasource is declared, and visible to the user, it is however inaccessible, and I get an error message when trying to connect. I have noticed that the readme says that an executable file should be installed in /usr/bin/ as myodbc3i, when I start this command as sudo from a terminal, I get the following error message : /usr/lib/libltdl.3.dylib (No such file or directory) and indeed the libtool library isn't installed. The README provided with the MyODBC dmg package states that you don't actually need anything else to get MyODBC working, not even the MySQL client libraries, so what gives with the libtool dependencies ? After trawling with Google, I found on a mysql list a suggestion that one should install the XCode development package provided by Apple, since that package provides the library in question. Here's the crunch, my disks with the Mac machines are tiny, thw whole point is to access data remotely and not have to store stuff locally, and that also means not having space to install a development environment on every machine. So what am I to do ? Is this problem not going to be fixed ? Is there no solution other than that (some solution !!) Thirdly, I notice that the installation hasn't provided a file called libmyodbc3S.dylib, which is traditionally the shared library to which function calls are made for setup of the connection to the mysql server. Has this been dropped too, or is the MacOSX package deficient ? The worst bit about all of this is that a binary package was previously available (3.51.9 or 10 I think), that had all of these things in it, but I don't seem to be able to find it anymore on the servers. Any help most gratefully taken. Alex -- Thurgood Alex [EMAIL PROTECTED] Cabinet Michel Richebourg -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: VIEW not working with myODBC in XP and Access 2003
This is an Access problem; you'll need to find folks who know access to fix it. Try: http://www.tek-tips.com/viewthread.cfm?qid=1146857page=1 ?? -Sheeri On 4/26/06, Daevid Vincent [EMAIL PROTECTED] wrote: I have a critical problem that I hope there is a simple solution for. I've just spent a couple days converting a very messy hack to populate a table using a much more elegant VIEW solution now. Everything is going great, except now the whole point of this VIEW is so that people using MS Access (or other ODBC) can use the VIEW. It doesn't work!?! I've followed all of this: http://dev.mysql.com/doc/refman/5.0/en/msaccess-setup.html I can import/link any other non-VIEW table. I've given FULL permissions to my ODBC user in mysql.mysql.user (and other appropriate) places just in case. Access pops up an error box that says Could not execute query; could not find linked table I'm using these versions: Windows XP http://dev.mysql.com/downloads/connector/odbc/3.51.html [EMAIL PROTECTED]:/lockdown# mysql --version mysql Ver 14.12 Distrib 5.0.15, for pc-linux-gnu (i686) using readline 4.3 -- 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]
VIEW not working with myODBC in XP and Access 2003
I have a critical problem that I hope there is a simple solution for. I've just spent a couple days converting a very messy hack to populate a table using a much more elegant VIEW solution now. Everything is going great, except now the whole point of this VIEW is so that people using MS Access (or other ODBC) can use the VIEW. It doesn't work!?! I've followed all of this: http://dev.mysql.com/doc/refman/5.0/en/msaccess-setup.html I can import/link any other non-VIEW table. I've given FULL permissions to my ODBC user in mysql.mysql.user (and other appropriate) places just in case. Access pops up an error box that says Could not execute query; could not find linked table I'm using these versions: Windows XP http://dev.mysql.com/downloads/connector/odbc/3.51.html [EMAIL PROTECTED]:/lockdown# mysql --version mysql Ver 14.12 Distrib 5.0.15, for pc-linux-gnu (i686) using readline 4.3 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
myodbc version 3.21.X
Hey list, I'm am currently looking for myODBC 3.21.X but can't seem to find a suited downloadsite. Does anyone know a link to this version? Thanks in advance, Reinhart Viane
Re: How can I keep character_set_client value after MyODBC auto reconnect?
I wouldn't hold your breath for any new 3.xx releases or updates. MySQL AB has moved through developing and releasing and almost retiring the 4.0.x and 4.1.x versions of its server line and is actively promoting v5.0.x while still working on v5.1.x. The 4.1.x version is being supported with patches (if the issue still affects that versions) but I cannot remember if 4.0 still is. No new features are planned for any versions lower than 5 that I am aware of. I think now might be a good time to upgrade your server. Shawn Green Database Administrator Unimin Corporation - Spruce Pine 古雷 [EMAIL PROTECTED] wrote on 01/10/2006 09:49:04 PM: Thanks a lot. I needs SET AUTOCOMMIT=0, SET NAMES utf8 and SET TRANSACTION ISOLATION LEVEL READ COMMITTED after a new connection. Further more, MyODBC3.51.10 reconnects automatically when connection lost but MyODBC3.51.12 doesn't. I think automatic reconnection is not bad when it can keep variables' value or can give me a chance to run more than one SQL statement to init my session. Another question: when will new verison of MyODBC3.5 be released? One of our application often disconnect and connect MySQL and then MyODBC often core dump. Best regards, gulei - Original Message - From: Dušan Pavlica [EMAIL PROTECTED] To: 古雷 [EMAIL PROTECTED]; MySQL List mysql@lists.mysql.com Sent: Tuesday, January 10, 2006 6:34 PM Subject: Re: How can I keep character_set_client value after MyODBC auto reconnect? Hi, did you try SET CHARACTER SET utf8 as Initial Statement under Connection Options of your MyODBC DSN? HTH, Dusan - Original Message - From: 古雷 [EMAIL PROTECTED] To: MySQL List mysql@lists.mysql.com Sent: Monday, January 09, 2006 10:19 AM Subject: How can I keep character_set_client value after MyODBC auto reconnect? Hello: I found that MyODBC use mysql_ping to check connection and reconnect. After reconnect by using mysql_ping character_set_client, character_set_connection and character_set_results go back to latin1. But I need them to be utf8. What can I do with MyODBC? Regards, gu lei 祝 事业有成,家庭和睦,身体健康,一切吉祥 古雷 --- 中企动力科技集团 技术事业发展部___技术架构部 \__企业IP通讯部 电话:010 58022278-302 地址:北京亦庄经济技术开发区北工大软件园 (地盛北街1号)A区3号楼 邮编:100176
Re: How can I keep character_set_client value after MyODBC auto reconnect?
Hi, Shawn Green Thanks for your reply. But I expect new version of MyODBC(one of mysql-connectors), not of mysqld. We now use mysql5.0. The newest version of MyODBC is 3.51.12. Regards, gulei - Original Message - From: [EMAIL PROTECTED] To: 古雷 [EMAIL PROTECTED] Cc: MySQL List mysql@lists.mysql.com; Dušan Pavlica [EMAIL PROTECTED] Sent: Wednesday, January 11, 2006 11:16 PM Subject: Re: How can I keep character_set_client value after MyODBC auto reconnect? I wouldn't hold your breath for any new 3.xx releases or updates. MySQL AB has moved through developing and releasing and almost retiring the 4.0.x and 4.1.x versions of its server line and is actively promoting v5.0.x while still working on v5.1.x. The 4.1.x version is being supported with patches (if the issue still affects that versions) but I cannot remember if 4.0 still is. No new features are planned for any versions lower than 5 that I am aware of. I think now might be a good time to upgrade your server. Shawn Green Database Administrator Unimin Corporation - Spruce Pine 古雷 [EMAIL PROTECTED] wrote on 01/10/2006 09:49:04 PM: Thanks a lot. I needs SET AUTOCOMMIT=0, SET NAMES utf8 and SET TRANSACTION ISOLATION LEVEL READ COMMITTED after a new connection. Further more, MyODBC3.51.10 reconnects automatically when connection lost but MyODBC3.51.12 doesn't. I think automatic reconnection is not bad when it can keep variables' value or can give me a chance to run more than one SQL statement to init my session. Another question: when will new verison of MyODBC3.5 be released? One of our application often disconnect and connect MySQL and then MyODBC often core dump. Best regards, gulei - Original Message - From: Dušan Pavlica [EMAIL PROTECTED] To: 古雷 [EMAIL PROTECTED]; MySQL List mysql@lists.mysql.com Sent: Tuesday, January 10, 2006 6:34 PM Subject: Re: How can I keep character_set_client value after MyODBC auto reconnect? Hi, did you try SET CHARACTER SET utf8 as Initial Statement under Connection Options of your MyODBC DSN? HTH, Dusan - Original Message - From: 古雷 [EMAIL PROTECTED] To: MySQL List mysql@lists.mysql.com Sent: Monday, January 09, 2006 10:19 AM Subject: How can I keep character_set_client value after MyODBC auto reconnect? Hello: I found that MyODBC use mysql_ping to check connection and reconnect. After reconnect by using mysql_ping character_set_client, character_set_connection and character_set_results go back to latin1. But I need them to be utf8. What can I do with MyODBC? Regards, gu lei 祝 事业有成,家庭和睦,身体健康,一切吉祥 古雷 --- 中企动力科技集团 技术事业发展部___技术架构部 \__企业IP通讯部 电话:010 58022278-302 地址:北京亦庄经济技术开发区北工大软件园 (地盛北街1号)A区3号楼 邮编:100176
Re: How can I keep character_set_client value after MyODBC auto reconnect?
Hi, did you try SET CHARACTER SET utf8 as Initial Statement under Connection Options of your MyODBC DSN? HTH, Dusan - Original Message - From: 古雷 [EMAIL PROTECTED] To: MySQL List mysql@lists.mysql.com Sent: Monday, January 09, 2006 10:19 AM Subject: How can I keep character_set_client value after MyODBC auto reconnect? Hello: I found that MyODBC use mysql_ping to check connection and reconnect. After reconnect by using mysql_ping character_set_client, character_set_connection and character_set_results go back to latin1. But I need them to be utf8. What can I do with MyODBC? Regards, gu lei 祝 事业有成,家庭和睦,身体健康,一切吉祥 古雷 --- 中企动力科技集团 技术事业发展部___技术架构部 \__企业IP通讯部 电话:010 58022278-302 地址:北京亦庄经济技术开发区北工大软件园 (地盛北街1号)A区3号楼 邮编:100176 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How can I keep character_set_client value after MyODBC auto reconnect?
Thanks a lot. I needs SET AUTOCOMMIT=0, SET NAMES utf8 and SET TRANSACTION ISOLATION LEVEL READ COMMITTED after a new connection. Further more, MyODBC3.51.10 reconnects automatically when connection lost but MyODBC3.51.12 doesn't. I think automatic reconnection is not bad when it can keep variables' value or can give me a chance to run more than one SQL statement to init my session. Another question: when will new verison of MyODBC3.5 be released? One of our application often disconnect and connect MySQL and then MyODBC often core dump. Best regards, gulei - Original Message - From: Dušan Pavlica [EMAIL PROTECTED] To: 古雷 [EMAIL PROTECTED]; MySQL List mysql@lists.mysql.com Sent: Tuesday, January 10, 2006 6:34 PM Subject: Re: How can I keep character_set_client value after MyODBC auto reconnect? Hi, did you try SET CHARACTER SET utf8 as Initial Statement under Connection Options of your MyODBC DSN? HTH, Dusan - Original Message - From: 古雷 [EMAIL PROTECTED] To: MySQL List mysql@lists.mysql.com Sent: Monday, January 09, 2006 10:19 AM Subject: How can I keep character_set_client value after MyODBC auto reconnect? Hello: I found that MyODBC use mysql_ping to check connection and reconnect. After reconnect by using mysql_ping character_set_client, character_set_connection and character_set_results go back to latin1. But I need them to be utf8. What can I do with MyODBC? Regards, gu lei 祝 事业有成,家庭和睦,身体健康,一切吉祥 古雷 --- 中企动力科技集团 技术事业发展部___技术架构部 \__企业IP通讯部 电话:010 58022278-302 地址:北京亦庄经济技术开发区北工大软件园 (地盛北街1号)A区3号楼 邮编:100176
How can I keep character_set_client value after MyODBC auto reconnect?
Hello: I found that MyODBC use mysql_ping to check connection and reconnect. After reconnect by using mysql_ping character_set_client, character_set_connection and character_set_results go back to latin1. But I need them to be utf8. What can I do with MyODBC? Regards, gu lei 祝 事业有成,家庭和睦,身体健康,一切吉祥 古雷 --- 中企动力科技集团 技术事业发展部___技术架构部 \__企业IP通讯部 电话:010 58022278-302 地址:北京亦庄经济技术开发区北工大软件园 (地盛北街1号)A区3号楼 邮编:100176
connect with myODBC to mysql through proxy
Hi all, I have a windows computer in my network which needs an odbc connection through proxy. the only thing is that i don't know how to do this on a windows machine. i have installed the myodbc driver and it works for connecting on a mysql server in my local network. but i have an isp address, the database name. connecting without proxy, that is directly, works fine; but i need to make a connection behind a proxy. Danny -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: connect with myODBC to mysql through proxy
Hello. Please could you describe more in details what kind of proxy you want to use and the network topology (firewalls, routers which perform NAT and so on). Danny Stolle wrote: Hi all, I have a windows computer in my network which needs an odbc connection through proxy. the only thing is that i don't know how to do this on a windows machine. i have installed the myodbc driver and it works for connecting on a mysql server in my local network. but i have an isp address, the database name. connecting without proxy, that is directly, works fine; but i need to make a connection behind a proxy. Danny -- 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: Access 2002 hangs with MyODBC 3.51.11
Dear sir Thank you for your answer. You help me much. I replace msjet40.dll with an oldest from ServicePackFiles/ and works fine -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 18, 2005 7:12 PM To: mysql@lists.mysql.com Subject: Fw: Access 2002 hangs with MyODBC 3.51.11 The attachment was stripped by the list manager: forwarded to list for general information Shawn - Forwarded by Shawn Green/Unimin on 10/18/2005 12:07 PM - Shawn Green/Unimin 10/18/2005 11:48 AM To nikos [EMAIL PROTECTED] cc mysql@lists.mysql.com Subject Re: Access 2002 hangs with MyODBC 3.51.11 nikos [EMAIL PROTECTED] wrote on 10/18/2005 10:58:51 AM: Hello list I recently update my Access 2002 with Office SP3 (Access 10.6501...) and all connections with MySQL through MyODBC 3.51.11 have problems I install the Access on a pc without updating and the driver works fine. This version of Access is 10.25... something. I download again MyODBC driver but I get the same problem: access still hangs up. In the event viewer there is the following problem: Faulting application msaccess.exe, version 10.0.6501.0, faulting module msjet40.dll, version 4.0.9025.0, fault address 0x000e9f60. Does any body know what's the problem? Thank you Nikos Microsoft distributed a security hotfix, updating MSJET40.DLL to version 4.0.9025.0, which broke every version of MyODBC I test with (I have gone back as far as 3.51.2). Actually, AFAIK, it may only break the process of creating linked tables from MS Access. All other functions may remain functional. However, that's primarily what my users need the library to do, so for me it's broken. Related MySQL bug reports: http://bugs.mysql.com/bug.php?id=9932 http://bugs.mysql.com/bug.php?id=11698 http://bugs.mysql.com/bug.php?id=12386 Workaround: On each affected user's machine, replace newer MSJET40.DLL with previous version (4.0.8618.0), attached. (attachment probably stripped during list distribution). This effectively undoes part of the security hotfix but restores the ability to create and repair table links from MS Access through MyODBC to MySQL. Due to Microsoft's file protection system (FPS), you have to replace the backup version first. The backup can be in an i386 folder, a DLLCACHE folder or in several other possible places (depending on the version of the OS and how FPS has been configured). After you make sure that MS Access is turned off, you can replace the main version in the SYSTEM32 folder. Check the version tab in the properties of each file after you make the copy to make sure your intended changes have taken effect. [attachment msjet40.dll deleted by Shawn Green/Unimin] Last I heard, MySQL was still working on a full fix for the problem. Shawn Green Database Administrator Unimin Corporation - Spruce Pine -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Access 2002 hangs with MyODBC 3.51.11
Hello list I recently update my Access 2002 with Office SP3 (Access 10.6501...) and all connections with MySQL through MyODBC 3.51.11 have problems I install the Access on a pc without updating and the driver works fine. This version of Access is 10.25... something. I download again MyODBC driver but I get the same problem: access still hangs up. In the event viewer there is the following problem: Faulting application msaccess.exe, version 10.0.6501.0, faulting module msjet40.dll, version 4.0.9025.0, fault address 0x000e9f60. Does any body know what's the problem? Thank you Nikos -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Fw: Access 2002 hangs with MyODBC 3.51.11
The attachment was stripped by the list manager: forwarded to list for general information Shawn - Forwarded by Shawn Green/Unimin on 10/18/2005 12:07 PM - Shawn Green/Unimin 10/18/2005 11:48 AM To nikos [EMAIL PROTECTED] cc mysql@lists.mysql.com Subject Re: Access 2002 hangs with MyODBC 3.51.11 nikos [EMAIL PROTECTED] wrote on 10/18/2005 10:58:51 AM: Hello list I recently update my Access 2002 with Office SP3 (Access 10.6501...) and all connections with MySQL through MyODBC 3.51.11 have problems I install the Access on a pc without updating and the driver works fine. This version of Access is 10.25... something. I download again MyODBC driver but I get the same problem: access still hangs up. In the event viewer there is the following problem: Faulting application msaccess.exe, version 10.0.6501.0, faulting module msjet40.dll, version 4.0.9025.0, fault address 0x000e9f60. Does any body know what's the problem? Thank you Nikos Microsoft distributed a security hotfix, updating MSJET40.DLL to version 4.0.9025.0, which broke every version of MyODBC I test with (I have gone back as far as 3.51.2). Actually, AFAIK, it may only break the process of creating linked tables from MS Access. All other functions may remain functional. However, that's primarily what my users need the library to do, so for me it's broken. Related MySQL bug reports: http://bugs.mysql.com/bug.php?id=9932 http://bugs.mysql.com/bug.php?id=11698 http://bugs.mysql.com/bug.php?id=12386 Workaround: On each affected user's machine, replace newer MSJET40.DLL with previous version (4.0.8618.0), attached. (attachment probably stripped during list distribution). This effectively undoes part of the security hotfix but restores the ability to create and repair table links from MS Access through MyODBC to MySQL. Due to Microsoft's file protection system (FPS), you have to replace the backup version first. The backup can be in an i386 folder, a DLLCACHE folder or in several other possible places (depending on the version of the OS and how FPS has been configured). After you make sure that MS Access is turned off, you can replace the main version in the SYSTEM32 folder. Check the version tab in the properties of each file after you make the copy to make sure your intended changes have taken effect. [attachment msjet40.dll deleted by Shawn Green/Unimin] Last I heard, MySQL was still working on a full fix for the problem. Shawn Green Database Administrator Unimin Corporation - Spruce Pine
Re: Access 2002 hangs with MyODBC 3.51.11
nikos wrote: Hello list I recently update my Access 2002 with Office SP3 (Access 10.6501...) and all connections with MySQL through MyODBC 3.51.11 have problems I install the Access on a pc without updating and the driver works fine. This version of Access is 10.25... something. I download again MyODBC driver but I get the same problem: access still hangs up. In the event viewer there is the following problem: Faulting application msaccess.exe, version 10.0.6501.0, faulting module msjet40.dll, version 4.0.9025.0, fault address 0x000e9f60. Does any body know what's the problem? Thank you Nikos I've got Access 2002 SP3 ( unfortunately ). I'm not getting these hangs though. Check that you're following http://dev.mysql.com/doc/refman/4.1/en/programs-known-to-work-with-myodbc.html to the letter. Also don't use MyODBC-3.51.11 - there are a lot of problems with this version. 3.51.06 worked well for me. Alternatively, you can track down 3.51.12 - there was a link posted to it in the MyODBC mailing list. It also works for me, but it's not actually released yet, so you might be better going with 3.51.06. -- 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]
Problem compiling MyODBC - looking for sql.h file
I posted this on the ODBC list, but there is not much traffic there and no one replied. Hopefully someone here has dealt with this. I am setting up ColdFusion to access a MySQL 4.1.x database. This required new MyODBC drivers to be installed on the system for ColdFusion. After a lot of trial and error, I got it figured out. I install mysql on the system (using --without-server), then install MyODBC. Then copy the libmyodbc3.so file to a directory under ColdFusion, and change ColdFusion's odbc.ini file to reference this new driver. I am now trying to do it on a second system, but am getting errors during the ./configure of MyODBC (3.5.11). This is my configure statement: ./configure --with-mysql-path=/usr/local/mysql \ --without-samples \ --disable-test \ --enable-thread-safe And this is the resulting output: ... ODBC DRIVER MANAGER CONFIGURATION - LIBRARIES AND HEADERS checking for isql... No checking for unixODBC version... Unknown checking sql.h usability... No checking sql.h presence... No checking for sql.h... no configure: error: Unable to find the unixODBC headers in '/usr/local//include' It's complaining about unixODBC headers, maybe specifically the sql.h file in the second to last line? But I don't have unixODBC installed on the FIRST system, the one that is working just fine. (ColdFusion has it's one built in ODBC manager, unixODBC is not necessary.) However there is a /usr/local/include/sql.h file on that system. I don't know how it got there. By looking inside the file it appears to be related to MyODBC 3.5.11. Just for kicks I copied this file to the second system, but got the same error when trying to run ./configure. Any ideas? -Ryan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problem compiling MyODBC - looking for sql.h file
Ryan Stille wrote: I posted this on the ODBC list, but there is not much traffic there and no one replied. Hopefully someone here has dealt with this. I am setting up ColdFusion to access a MySQL 4.1.x database. This required new MyODBC drivers to be installed on the system for ColdFusion. After a lot of trial and error, I got it figured out. I install mysql on the system (using --without-server), then install MyODBC. Then copy the libmyodbc3.so file to a directory under ColdFusion, and change ColdFusion's odbc.ini file to reference this new driver. I am now trying to do it on a second system, but am getting errors during the ./configure of MyODBC (3.5.11). This is my configure statement: ./configure --with-mysql-path=/usr/local/mysql \ --without-samples \ --disable-test \ --enable-thread-safe And this is the resulting output: ... ODBC DRIVER MANAGER CONFIGURATION - LIBRARIES AND HEADERS checking for isql... No checking for unixODBC version... Unknown checking sql.h usability... No checking sql.h presence... No checking for sql.h... no configure: error: Unable to find the unixODBC headers in '/usr/local//include' It's complaining about unixODBC headers, maybe specifically the sql.h file in the second to last line? But I don't have unixODBC installed on the FIRST system, the one that is working just fine. (ColdFusion has it's one built in ODBC manager, unixODBC is not necessary.) However there is a /usr/local/include/sql.h file on that system. I don't know how it got there. By looking inside the file it appears to be related to MyODBC 3.5.11. Just for kicks I copied this file to the second system, but got the same error when trying to run ./configure. Any ideas? -Ryan Ryan, It's part of unixODBC-devel walt -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Connecting using MyODBC
Hello. I'm not familiar with this subject, however, have you been at: http://dev.mysql.com/doc/mysql/en/howto-cf.html http://dev.mysql.com/doc/mysql/en/programs-known-to-work-with-myodbc.html http://dev.mysql.com/doc/mysql/en/myodbc-tested-applications.html http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_17262 Ryan Stille [EMAIL PROTECTED] wrote: I am trying to connect to MySQL from within ColdFusion on a linux box. ColdFusion (version 5) came with a Merant driver, but it is too old to support transactions. I've downloaded libmyodbc_mysql.so (MyODBC 2.5) and also libmyodbc3.so (MyODBC 3.5) and could not get either of these to work. But I'm not sure if I'm using them correctly. Basically all I've done is copy these files to my machine and change this line in ColdFusion's odbc.ini file: Old: Driver=3D/opt/coldfusion/lib/CFmysql15.so New: Driver=3D/opt/coldfusion/lib/libmyodbc_mysql.so Does this sound like I'm using them correctly? Most of the documentation I find about MyODBC talks about installing an odbc manager, I believe ColdFusion already has one built in, since the odbc.ini file already exists and is used. When I use ODBC 3.5 my server just hangs. When I use the 2.5 driver I get this error: ODBC Error Code =3D IM003 (Specified driver could not be loaded) Thanks for any help. -Ryan -- 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]
Connecting using MyODBC
I am trying to connect to MySQL from within ColdFusion on a linux box. ColdFusion (version 5) came with a Merant driver, but it is too old to support transactions. I've downloaded libmyodbc_mysql.so (MyODBC 2.5) and also libmyodbc3.so (MyODBC 3.5) and could not get either of these to work. But I'm not sure if I'm using them correctly. Basically all I've done is copy these files to my machine and change this line in ColdFusion's odbc.ini file: Old: Driver=/opt/coldfusion/lib/CFmysql15.so New: Driver=/opt/coldfusion/lib/libmyodbc_mysql.so Does this sound like I'm using them correctly? Most of the documentation I find about MyODBC talks about installing an odbc manager, I believe ColdFusion already has one built in, since the odbc.ini file already exists and is used. When I use ODBC 3.5 my server just hangs. When I use the 2.5 driver I get this error: ODBC Error Code = IM003 (Specified driver could not be loaded) Thanks for any help. -Ryan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
return result set in SPs and using MyODBC
hi all, how can we have a select satement in an SP?(i want to return a result set from the SP). i want to migrate from SQL Server to MySQL and i don't know what to do with these SPs. it can be done in MySQL client, but it gives the error:procedure foo can't return a result set in the given context MySQL in the application. can i set a cursor out put parameter and return it?(just like Oracle) or it has another solution? and another question: is MyODBC 3.51 tested with MySQL 5.x? can we call an SP from Delphi via MyODBC? (i tried to do so (using ADO an a data provider for OLEDB) but i think somewhere in passing the call statement it had put {} around call sp() statement so that mysql returned an error about the syntax.) Thanks in advane Chagh - Start your day with Yahoo! - make it your home page
Re: return result set in SPs and using MyODBC
Hello. Information from this thread might be helpful: http://lists.mysql.com/mysql/187580 Shaghayegh Sahebie [EMAIL PROTECTED] wrote: [-- text/plain, encoding 8bit, charset: iso-8859-1, 18 lines --] hi all, how can we have a select satement in an SP?(i want to return a result set from the SP). i want to migrate from SQL Server to MySQL and i don't know what to do with these SPs. it can be done in MySQL client, but it gives the error:procedure foo can't return a result set in the given context MySQL in the application. can i set a cursor out put parameter and return it?(just like Oracle) or it has another solution? and another question: is MyODBC 3.51 tested with MySQL 5.x? can we call an SP from Delphi via MyODBC? (i tried to do so (using ADO an a data provider for OLEDB) but i think somewhere in passing the call statement it had put {} around call sp() statement so that mysql returned an error about the syntax.) Thanks in advane Chagh - Start your day with Yahoo! - make it your home page -- 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]
myodbc driver araise full table scan
mysql,您好! 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? 致 礼! chenwei [EMAIL PROTECTED] 2005-08-08
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: Problem with datetime values and MyODBC driver
Thanks Dwi for the tip, but unfortunately this solution is possible only in applications which connect only to MySQL and I am already using it in those applications but now I need to connect to MySQL or to MS Access (or to other DB engine) with one query using only different connection string (and different ODBC drivers). And thus I must set query parameters to their correct data types and ODBC driver should do the conversions. And that is what is not working. I will probably fill a bug report and will see. Dusan - Original Message - From: Dwi Putra L To: Dušan Pavlica Sent: Friday, August 05, 2005 6:34 AM Subject: Re: Problem with datetime values and MyODBC driver Dušan Pavlica wrote: Hello, I'm working in C++ Builder 6.0 and I'm trying to create application which could connect through ADO components to different databases using ODBC drivers. If I create TADOQuery object which has datetime parametr and I fill this parametr with valid datetime value then I can see in MYSQL's query log that only date portion is used. But if I use same query object to connect to MS Access then data in MS Access are OK. Win XP, MyODBC 3.51.11, MySQL 4.1.9 Does anybody have any idea how to solve this problem? Thanks in advance Dusan Pavlica I use delphi 7 and I have same problem with you MySQL save and search datetime data as string. My solution is to change datetime data into string with format : 2005-08-05 (year-month-day) -- var str_year, str_month, str_day, str_date : string; year, month, day : word; DecodeDate(Now,year,month,day); str_year := inttostr(year); str_month := inttostr(month); if Length(str_month) 2 then str_month := '0' + str_month; str_day := inttostr(day); if Length(str_day) 2 then str_day := '0' + str_day; str_date := str_year + '-' + str_month + '-' + str_day; --- The same thing when I want to conduct a query, which using date as parameters. I change certain date into string. _dwi.
Re: Problem with datetime values and MyODBC driver
Hello. I was unable to find similar bug in bugs database, but there were several problems with datetime. Some of them were solved by choosing different versions of software. Check if your problem exists on MySQL 4.1.13. Maybe ODBC tracing help you to localize the problem. If you have a reproducible test case you can report a bug. Du$an Pavlica [EMAIL PROTECTED] wrote: Hello, I'm working in C++ Builder 6.0 and I'm trying to create application which could connect through ADO components to different databases using ODBC drivers. If I create TADOQuery object which has datetime parametr and I fill this parametr with valid datetime value then I can see in MYSQL's query log that only date portion is used. But if I use same query object to connect to MS Access then data in MS Access are OK. Win XP, MyODBC 3.51.11, MySQL 4.1.9 Does anybody have any idea how to solve this problem? Thanks in advance Dusan Pavlica -- 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]
Problem with datetime values and MyODBC driver
Hello, I'm working in C++ Builder 6.0 and I'm trying to create application which could connect through ADO components to different databases using ODBC drivers. If I create TADOQuery object which has datetime parametr and I fill this parametr with valid datetime value then I can see in MYSQL's query log that only date portion is used. But if I use same query object to connect to MS Access then data in MS Access are OK. Win XP, MyODBC 3.51.11, MySQL 4.1.9 Does anybody have any idea how to solve this problem? Thanks in advance Dusan Pavlica
myodbc cygwin
Dear All, I tried several times to install myodbc 3.51.11 in cygwin (newest, recently updated version) without any success. ./configure works perfect, including the optional packages unixodbc and mysql which I have already installed without any problems. Make fails and make configure too. The error in make is: execute.c:721 : error: conflicting types for `sqlputdata` make [2] leaving directory ... Many thanks for help, Jan ___ Dr. Jan Bartholdy Freiheitsweg 64 16515 Oranienburg OT Friedrichsthal phone +49 3301 808129 fax +49 3301 808130 cellphone +49 172 3945713 email [EMAIL PROTECTED] + Virus checked by G DATA AntiVirusKit Version: AVK 15.0.5457 from 13.06.2005 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Any limit for MyODBC connections?
Hi, Is there any database login restriction for myODBC? meaning there is any upper limit of number of connections? Please help me in this. Thanks, Narasimha Confidentiality Notice The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain confidential or privileged information. If you are not the intended recipient, please notify the sender at Wipro or [EMAIL PROTECTED] immediately and destroy all copies of this message and any attachments.
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]
myodbc on mandrake
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 -- symbulos partners -.- symbulos - ethical services for your organisation http://www.symbulos.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
myodbc, mysql 5.0.0-alpha
I'm having trouble compiling myodbc-3.51.11 against mysql 5.0.0 - something about int2str has too many arguments - should I be using a newer version of myodbc (I couldn't find one), or is it not supported yet for mysql 5.0.0, or ...? Running debian / linux 2.6.9-2-k7. Frederik -- http://ofb.net/~frederik/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Does MyODBC support SQLDescribeParam ?
Hello: I need SQLDescribeParam to get parameters' type information. But with MyODBC3.51 and MYSQL 4.1.10max I got wrong type and wrong number of parameters. Does MyODBC support SQLDescribeParam ? When will MyODBC support SQLDescribeParam ? Thanks. Regards, Gu Lei -- inline: cover.jpg-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MyODBC SQLDescribeCol can't get ColumnSize of any String types column
Hello: MyODBC3.51 MYSQL4.1.10-max MyODBC SQLDescribeCol can't get ColumnSize of any String types column. SQLDescribeCol can get ColumnSize of numeric column. Why ? Regards, Gu Lei -- inline: cover.jpg-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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
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]
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]
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: Help using SSL from VB client, using MyODBC
Hello. I'm not a VB expert, but some notes about methods of establishing such connections can be found at: http://dev.mysql.com/doc/mysql/en/Windows_and_SSH.html http://dev.mysql.com/doc/mysql/en/mysql_ssl_set.html William Blair Wagner [EMAIL PROTECTED] wrote: I'm kind of new to the SSL scene. I've read all I can find on MySQL.org about setting up and using SSL. I'm on MySLQ 4.20 and have built mysql after configuring with --use-vio and --use-openssl. HAVE_OPENSSL = YES. I can handle setting up the user talbe and GRANTS to require SSL for users and connections. What I don't know how to do it make my client use SSL with MySQL. Can you help me? or give me some direction? My application runs on M$ Windows. It's written in M$ Visual Basic 6 from Visual Studio 6. I'm using MDAC 2.7 and M$ ADO. I'm using MyODBC 2.50 but can easily and happily upgrade to 3.51 (is 3.51 needed?) I have no idea what to do (set properties?) to cause my VB client to connect to the MySQL DB server using SSL? Any help would be huge! Thanx. -- 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]
Help using SSL from VB client, using MyODBC
I'm kind of new to the SSL scene. I've read all I can find on MySQL.org about setting up and using SSL. I'm on MySLQ 4.20 and have built mysql after configuring with --use-vio and --use-openssl. HAVE_OPENSSL = YES. I can handle setting up the user talbe and GRANTS to require SSL for users and connections. What I don't know how to do it make my client use SSL with MySQL. Can you help me? or give me some direction? My application runs on M$ Windows. It's written in M$ Visual Basic 6 from Visual Studio 6. I'm using MDAC 2.7 and M$ ADO. I'm using MyODBC 2.50 but can easily and happily upgrade to 3.51 (is 3.51 needed?) I have no idea what to do (set properties?) to cause my VB client to connect to the MySQL DB server using SSL? Any help would be huge! Thanx. -- William Blair Wagner : Education is not always knowing the answer, [EMAIL PROTECTED] : ...but rather knowing where to look for it! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Still problem with MyODBC :((
I will say it AGAIN :-( The ODBC drivers (your client if you go through them to access the database) ARE NOT 4.1+ CLIENTS. The most recent version shows that they are 3.xx.xx drivers which means that you are using a pre-4.1 client to access a post 4.1 server. The articles you read describe how to do permit this kind of access. I think the easiest work-around is to change the password on the account you use with the ODBC drivers. Assuming you are connecting with the account odbcuser and the password fixme you would need a statement like: update mysql.user set password = OLD_PASSWORD('fixme') where user = 'odbcuser'; Then you will be able to authenticate. Shawn Green Database Administrator Unimin Corporation - Spruce Pine Danesh Daroui [EMAIL PROTECTED] wrote on 09/11/2004 06:24:17 AM: Hi all, I have still problem with MyODBC. When I want to connect to my Database server which is a Linux machine, it returns an error: Client does not support authentication protocol requested by server; consider upgrading MySQL client I visited MySQL documents but the suggestions were about when a version prior to 4.1 attempts to connect to a server which runs MySQL version 4.1 or newer, but this is not my case. Because, both my client and server use same version of MySQL and they use MySQL version 4.1 not older releases. Can anyone help ? :(( Yours, Danesh Daroui
Re: Still problem with MyODBC :((
Danesh Daroui wrote: Hi all, I have still problem with MyODBC. When I want to connect to my Database server which is a Linux machine, it returns an error: Client does not support authentication protocol requested by server; consider upgrading MySQL client I visited MySQL documents but the suggestions were about when a version prior to 4.1 attempts to connect to a server which runs MySQL version 4.1 or newer, but this is not my case. Because, both my client and server use same version of MySQL and they use MySQL version 4.1 not older releases. Can anyone help ? :(( Yours, Danesh Daroui If you are using MyODBC, then the suggestions regarding a 'client prior to 4.1' *DO* apply to you. MyODBC is built against 4.0.x, so you must follow the instructions for connecting with a pre-4.1 client. Either that or downgrade the server to 4.0.x. -- 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]
Still problem with MyODBC :((
Hi all, I have still problem with MyODBC. When I want to connect to my Database server which is a Linux machine, it returns an error: Client does not support authentication protocol requested by server; consider upgrading MySQL client I visited MySQL documents but the suggestions were about when a version prior to 4.1 attempts to connect to a server which runs MySQL version 4.1 or newer, but this is not my case. Because, both my client and server use same version of MySQL and they use MySQL version 4.1 not older releases. Can anyone help ? :(( Yours, Danesh Daroui
Mysql 4.1 and MyODBC don't like each other
Hi, I tried to compile Myodbc 3.51.0[67] against mysql4.1, but while 0.7 doesn't even configure correctly because of undefined automake macros, .06 fails because it calls int2str() with three parameters instead of 4 (defined in m_string.h). What does the 4th parameter mean? Is MyODBC a dead/unmaintained project? Another problem: building the sources of Mysql*.src.rpm never builds Mysql-shared-compat, that is often indispensable. Can someone please update the specfile? Thanks, -- Nico Sabbi - Officine Digitali - Bologna Tel. 051 - 4187565 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
error while working with MySQL MyODBC and MS Access 97
hi their, i have a problem working with access mysql and myodbc. i ported a access database to mysql. now i had to integrate the mysql db in the old access frontend. i realized this with linked tables. now i have a problem, because myodbc seems to return the wrong results. the relation between the tables in mysql are fixed with the primary keys and the foreign keys. relations: observation // tablename observation_id // primary key ... activity_no_focal // tablename activity_no_focal_id // primary key observation_id // foreign key Activity1 Activity2 Activity3 Activity4 now their is a formular in access that allows me to create a new entry for the observation. this works fine. at this formular their is a button 'activity_no_focal'. pressing this button, a new formular pops up, and now their should be the possibility to enter data for the set activity_no_focal with observation_id like the new set i formerly created. now it is following problem i ran in: the formular opens, but all the fields for entering the new data do not exist. as i looked in the mysql log file, i recognized, that their is a select statement for this specific observation_id at activity_no_focal, and for sure, it is empty, as it should be. if access gets an empty set for a table, the fields access then presents are then used for updating the db. This is the reason why i think this should be a myodbc error. i guess myodbs gives back some strange data, access can't handle with, instead of the empty set, or the empty set is given back in a way access doesn't understand. So this is my question: does one know how to handle the problem? In advance, the technical data of the soft and hardware i use. Hardware: pentium 4 512 MB RAM 40 GB Hard Disk. Operating System: linux 2.4.20-4GB (Suse 9.1) Software under linux: VmWare (running win2k) Mysql Server running on linux Server mysql 3.23.55-Max-log apache, shh, mail ... Software under win2k: Access 97 MyODBC 3.51 All Service Packs installed (for Access i installed the latest Service Release) MDAC 2.8 thanks for every idea, joshua bacher joshua bacher max planck institute -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
install myodbc 2.50.39
I'm installing the myodbc2.50.39win95 in a Athlon XP 2200+, but when I start the setup.exe the following error: insufficient memory or disc space. After this, it's finishing the installation. My machine have RAM 256 and +/- 30GB free disc. What is happening? Thanks Silmara
myODBC connect problems
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
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]
MyODBC - SQLColAttribute with SQL_DESC_OCTET_LENGTH parameter
Hello, In my application, I am connecting to various RBDMS but primarily SQL Server and MySQL using ODBC 3.0 driver. In SQL Server, if I execute SQLCollAtrribute with SQL_DESC_OCTET_LENGTH, it is returning me the maximum number of bytes that the column can have irrespective of whether the column in the resultset has that much data or not. Whereas, the MySQL ODBC driver is returning the maximum data that a column has for that particular resultset. Why is the anomaly? Does this information differ from driver to driver. Is there any way to know the size of a perticular row in raw-bytes before doing an SQLFetch(). I would like to allocate the memory before I do SQLFetch(). Looking into Google Groups it seems that many people have the same problem but not much solution has been provided. What is the best way to know how much bytes the RDBMS takes in the disk to store that much information? __ Do you Yahoo!? Friends. Fun. Try the all-new Yahoo! Messenger. http://messenger.yahoo.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
myodbc - ms-access problem: table contents not shown
Hi, This post does in fact more belong to a windows-emulator group, but I've had no success there. Maybe someone on this list knows what's wrong. I want to make a database with an ms-access frontend (using codewavers wine implementation) and a mysql backend. I've installed ms-access (under codeweaves) and it works (can make and view tables and forms and modules, etc). I also setup ODBC (installed myodbc 3.51, newest mdac, and jet sp). I can make an ODBC-pointer to my database. In Access I can link to the ODBC definition and the table shows up in the table-list, I can view the table properties (field-names and types, etc). However when I try to open the table, I get an error saying that it cannot be shown in table view. Also using a form the data is not shown. When I open the database in MS-Query (also under codeweavers' cxoffice), than the data does show up in the table-view. This may as well be a generic ms-access problem or a codeweavers bug, but I can't find the anwer. Is there anyone on this list who known how to solve the problem? Thanks in advance. Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
myodbc compiling priblems
Dear Friends then in compiling MyODBC (3.51.06)... Making all in samples make[1]: Entering directory `/storage/MySQL/src/MyODBC-3.51.06/samples' source='my_basics.c' object='my_basics.o' libtool=no \ depfile='.deps/my_basics.Po' tmpdepfile='.deps/my_basics.TPo' \ depmode=gcc3 /bin/sh ../depcomp \ gcc -DHAVE_CONFIG_H -I. -I. -I../driver -/usr/local/mysql/include/mysql -I. -I.. -isystem -I/usr/local/include -O3 -DDBUG_OFF -c `test -f my_basics.c || echo './'`my_basics.c /bin/sh ../libtool --mode=link gcc -O3 -DDBUG_OFF -L/usr/local/mysql/lib/mysql -lmysqlclient -o my_basics my_basics.o ../driver/libmyodbc3.la -L/usr/local/lib -L/usr/local/mysql/lib/mysql -lm -lz -lodbcinst mkdir .libs gcc -O3 -DDBUG_OFF -o .libs/my_basics my_basics.o -L/usr/local/mysql/lib/mysql -L/usr/lib ../driver/.libs/libmyodbc3.so /usr/local/lib/mysql/libmysqlclient.so -lcrypt -lnsl -lssl -lcrypto -L/usr/local/lib -lm -lz /usr/local/lib/libodbcinst.so -ldl -lpthread -Wl,--rpath -Wl,/usr/local/lib -Wl,--rpath -Wl,/usr/local/lib/mysql ../driver/.libs/libmyodbc3.so: undefined reference to 'my_ismbhead' collect2: ld returned 1 exit status can some one help mysql 4.1.x compiled from source and instaled on /usr/local Regards Luiz -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MyODBC and Windows XP
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 __ José Angel Blanco Linares Depto Servicios de Apoyo Académico Centro de Enseñanza Técnica Industrial 3641-3250, ext: 264 -- 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]
Error installing MyODBC - Please help...
Hello all. I'm trying to 'make' MyODBC, and I receive the following error: gcc -DHAVE_CONFIG_H -I. -I. -I. -I/usr/local/mysql/include/mysql -Iyes/include -O3 -DDBUG_OFF -c utility.c -Wp,-MD,.deps/utility.TPlo -fPIC -DPIC -o utility.lo /bin/ksh ../libtool --mode=link gcc -O3 -DDBUG_OFF -o libmyodbc3.la -rpath /usr/local/lib -release 3.51.06 catalog.lo connect.lo cursor.lo dll.lo error.lo execute.lo handle.lo info.lo misc.lo myodbc3.lo options.lo prepare.lo results.lo transact.lo utility.lo -L/usr/local/mysql/lib/mysql -lmysqlclient -Lyes/lib -L/usr/local/mysql/lib/mysql -lm -lnsl -lsocket -lodbcinst ../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 does anyone know what this means or what I need to do to resolve this issue? Thanks
Re: Field Name whitespace via MyODBC
Yes, if you are using v3.23.6 or above, ALTER TABLE on the command line should accept quoted column names to allow you to change the column names. Pat... - Original Message - From: Brian Duke [EMAIL PROTECTED] To: 'Patrick Sherrill' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, December 11, 2003 11:19 AM Subject: RE: Field Name whitespace via MyODBC I can just alter table to rename the fields right? -Original Message- From: Patrick Sherrill [mailto:[EMAIL PROTECTED] Sent: Thursday, December 11, 2003 5:27 AM To: Brian Duke; [EMAIL PROTECTED] Subject: Re: Field Name whitespace via MyODBC Brian, I think you are going to need to rename your fields/columns. If you are unable to rename them in mysql then you will probably need to rename them in your jet database with Access and re-import them. Your column names should be literals not wrapped in graves or quotes and should contain no whitespace. Whitespace is frequently used as a delimiter. I also avoid any characters other than alphanumeric and the occasional underscore character in field/column names . It helps avoid OS idiosyncrasies and simplifies naming conventions. I hope this helps. Pat... [EMAIL PROTECTED] CocoNet Corporation SW Florida's First ISP 825 SE 47th Terrace Cape Coral, FL 33904 - Original Message - From: Brian Duke [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, December 11, 2003 2:50 AM Subject: Field Name whitespace via MyODBC On the windows machine I have Acess2003. I installed the MyODBC to push the data into the FreeBSD MySQL server. The connection worked like a dream. Kudos to the MyODBC team. The table that the connection created included field names that have spaces in the name. I'm trying to access the data thru my PHP scripts. I tried this: $sql7 = SELECT LERG_7_SHA.LATA ,LERG_7_SHA.SWITCH , `LERG_7_SHA.SHA INDICATOR` , `LERG_7_SHA.H ORG B TDM` FROM LERG_7_SHA WHERE ( LERG_7_SHA.SWITCH = \$npa\ AND `LERG_7_SHA.SHA INDICATOR` = \$nxx\ ) LIMIT 0, 30; And $sql7 = SELECT LERG_7_SHA.LATA ,LERG_7_SHA.SWITCH , \'LERG_7_SHA.SHA INDICATOR\' , \'LERG_7_SHA.H ORG B TDM\' ,\'LERG_7_SHA.H ORG C TDM\' , LERG_7_SHA.HOST , LERG_7_SHA.OCN , LERG_7_SHA.AOCN FROM LERG_7_SHA WHERE (LERG_7_SHA.SWITCH = \$npa\ AND \'LERG_7_SHA.SHA_INDICATOR\' = \$nxx\ ) LIMIT 0, 30; Both do not work. The query breaks down where the backticks are or tries to add the literal string of 'LERG_7_SHA.SHA INDICATOR' in the result data. I have tried with single quotes and double quotes. I can issue this command on the mysql command line and it does work. Can someone help me syntax this line correct? The script.php and the database are on the same FreeBSD machine. -- 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] -- 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]
Field Name whitespace via MyODBC
On the windows machine I have Acess2003. I installed the MyODBC to push the data into the FreeBSD MySQL server. The connection worked like a dream. Kudos to the MyODBC team. The table that the connection created included field names that have spaces in the name. I'm trying to access the data thru my PHP scripts. I tried this: $sql7 = SELECT LERG_7_SHA.LATA ,LERG_7_SHA.SWITCH , `LERG_7_SHA.SHA INDICATOR` , `LERG_7_SHA.H ORG B TDM` FROM LERG_7_SHA WHERE ( LERG_7_SHA.SWITCH = \$npa\ AND `LERG_7_SHA.SHA INDICATOR` = \$nxx\ ) LIMIT 0, 30; And $sql7 = SELECT LERG_7_SHA.LATA ,LERG_7_SHA.SWITCH , \'LERG_7_SHA.SHA INDICATOR\' , \'LERG_7_SHA.H ORG B TDM\' ,\'LERG_7_SHA.H ORG C TDM\' , LERG_7_SHA.HOST , LERG_7_SHA.OCN , LERG_7_SHA.AOCN FROM LERG_7_SHA WHERE (LERG_7_SHA.SWITCH = \$npa\ AND \'LERG_7_SHA.SHA_INDICATOR\' = \$nxx\ ) LIMIT 0, 30; Both do not work. The query breaks down where the backticks are or tries to add the literal string of 'LERG_7_SHA.SHA INDICATOR' in the result data. I have tried with single quotes and double quotes. I can issue this command on the mysql command line and it does work. Can someone help me syntax this line correct? The script.php and the database are on the same FreeBSD machine. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Field Name whitespace via MyODBC
Brian, I think you are going to need to rename your fields/columns. If you are unable to rename them in mysql then you will probably need to rename them in your jet database with Access and re-import them. Your column names should be literals not wrapped in graves or quotes and should contain no whitespace. Whitespace is frequently used as a delimiter. I also avoid any characters other than alphanumeric and the occasional underscore character in field/column names . It helps avoid OS idiosyncrasies and simplifies naming conventions. I hope this helps. Pat... [EMAIL PROTECTED] CocoNet Corporation SW Florida's First ISP 825 SE 47th Terrace Cape Coral, FL 33904 - Original Message - From: Brian Duke [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, December 11, 2003 2:50 AM Subject: Field Name whitespace via MyODBC On the windows machine I have Acess2003. I installed the MyODBC to push the data into the FreeBSD MySQL server. The connection worked like a dream. Kudos to the MyODBC team. The table that the connection created included field names that have spaces in the name. I'm trying to access the data thru my PHP scripts. I tried this: $sql7 = SELECT LERG_7_SHA.LATA ,LERG_7_SHA.SWITCH , `LERG_7_SHA.SHA INDICATOR` , `LERG_7_SHA.H ORG B TDM` FROM LERG_7_SHA WHERE ( LERG_7_SHA.SWITCH = \$npa\ AND `LERG_7_SHA.SHA INDICATOR` = \$nxx\ ) LIMIT 0, 30; And $sql7 = SELECT LERG_7_SHA.LATA ,LERG_7_SHA.SWITCH , \'LERG_7_SHA.SHA INDICATOR\' , \'LERG_7_SHA.H ORG B TDM\' ,\'LERG_7_SHA.H ORG C TDM\' , LERG_7_SHA.HOST , LERG_7_SHA.OCN , LERG_7_SHA.AOCN FROM LERG_7_SHA WHERE (LERG_7_SHA.SWITCH = \$npa\ AND \'LERG_7_SHA.SHA_INDICATOR\' = \$nxx\ ) LIMIT 0, 30; Both do not work. The query breaks down where the backticks are or tries to add the literal string of 'LERG_7_SHA.SHA INDICATOR' in the result data. I have tried with single quotes and double quotes. I can issue this command on the mysql command line and it does work. Can someone help me syntax this line correct? The script.php and the database are on the same FreeBSD machine. -- 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: Field Name whitespace via MyODBC
I can just alter table to rename the fields right? -Original Message- From: Patrick Sherrill [mailto:[EMAIL PROTECTED] Sent: Thursday, December 11, 2003 5:27 AM To: Brian Duke; [EMAIL PROTECTED] Subject: Re: Field Name whitespace via MyODBC Brian, I think you are going to need to rename your fields/columns. If you are unable to rename them in mysql then you will probably need to rename them in your jet database with Access and re-import them. Your column names should be literals not wrapped in graves or quotes and should contain no whitespace. Whitespace is frequently used as a delimiter. I also avoid any characters other than alphanumeric and the occasional underscore character in field/column names . It helps avoid OS idiosyncrasies and simplifies naming conventions. I hope this helps. Pat... [EMAIL PROTECTED] CocoNet Corporation SW Florida's First ISP 825 SE 47th Terrace Cape Coral, FL 33904 - Original Message - From: Brian Duke [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, December 11, 2003 2:50 AM Subject: Field Name whitespace via MyODBC On the windows machine I have Acess2003. I installed the MyODBC to push the data into the FreeBSD MySQL server. The connection worked like a dream. Kudos to the MyODBC team. The table that the connection created included field names that have spaces in the name. I'm trying to access the data thru my PHP scripts. I tried this: $sql7 = SELECT LERG_7_SHA.LATA ,LERG_7_SHA.SWITCH , `LERG_7_SHA.SHA INDICATOR` , `LERG_7_SHA.H ORG B TDM` FROM LERG_7_SHA WHERE ( LERG_7_SHA.SWITCH = \$npa\ AND `LERG_7_SHA.SHA INDICATOR` = \$nxx\ ) LIMIT 0, 30; And $sql7 = SELECT LERG_7_SHA.LATA ,LERG_7_SHA.SWITCH , \'LERG_7_SHA.SHA INDICATOR\' , \'LERG_7_SHA.H ORG B TDM\' ,\'LERG_7_SHA.H ORG C TDM\' , LERG_7_SHA.HOST , LERG_7_SHA.OCN , LERG_7_SHA.AOCN FROM LERG_7_SHA WHERE (LERG_7_SHA.SWITCH = \$npa\ AND \'LERG_7_SHA.SHA_INDICATOR\' = \$nxx\ ) LIMIT 0, 30; Both do not work. The query breaks down where the backticks are or tries to add the literal string of 'LERG_7_SHA.SHA INDICATOR' in the result data. I have tried with single quotes and double quotes. I can issue this command on the mysql command line and it does work. Can someone help me syntax this line correct? The script.php and the database are on the same FreeBSD machine. -- 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Possible MyODBC Bug?
First, is there a separate mailing list for MyODBC issues? I have Lotus Script code that uses odbc in an attempt to write data to a MySQL table. I can't get even the very first record inserted because I consistently get the following error: Field mapping failed due to a missing field, Connector 'odbc2' I have examined the MySQL table, the Lotus Notes database/connection objects, and the actual database string. Everything matches perfectly, including number of fields, name of fields, the two non-nullable fields, etc. I can send all 200 lines of code if any one is familiar with LotusScript so as to verify that I'm doing this right; but I have a strong suspicion that this is an ODBC issue. Thanks. Randy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MyODBC errors
Mysqlians, I am getting the following errors in an application log for 4.0.16 mysql and 3.51 myODBC SQL Error: SQLSTATE=S0002 Native error=1146 '[unixODBC][MySQL][ODBC 3.51 Driver][mysqld-4.0.16-Max-log]Table 'TRIBE.NETWORK_VECTOR' doesn't exist' SQL Error: SQLSTATE=S1000 Native error=1136 '[unixODBC][MySQL][ODBC 3.51 Driver][mysqld-4.0.16-Max-log]Column count doesn't match value count at row 1' I have no problems reading/writing when I connect with the same user from the command line or otherwise. The table does exist with correct permissions and is read by the application earlier. The failings all deal with write operations. Many Thanks, Trevor
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]
MyODBC and MySQL 4.1
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/
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]
MySQL/MyODBC/Access 97 alpha-sorting doesn't work. PLEASE HELP.
I have Mysql 4.0.14 with MyODBC3.51 and Access97. I have a query SELECT inquiry_data_simple.inquiry_id, inquiry_data_simple.organization, inquiry_data_simple.event_date, inquiry_data_simple.event_id FROM inquiry_data_simple ORDER BY inquiry_data_simple.organization; The organization field does not sort alpha. Any ideas what could that be. It is ONLY a problem on WindowsXP home systems. Other systems are just fine. I have relinked the tables, re-installed the MSOffice and MySQL, done tons of other stuff. I have spent two days on this and I have no idea what else to do. - Visit CARMEL MUSIC ENTERTAINMENT website http://carmelme.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Ann: New Article on SSH Port Forwarding of MyODBC
Hi Everyone; I have published a new article covering SSH port forwarding of MySQL sessions, which can be viewed at http://www.vbmysql.com/articles/sshtunnel.html The article covers connecting a Windows client to a *NIX based server. Anyone with previous experience will probably find the article redundant (although I would not mind feedback), but it should be useful for those without experience in port forwarding. In any case I hope you find it useful. Regards, Mike Hillyer www.vbmysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: New Article on SSH Port Forwarding of MyODBC
Hi Mike I have to ask this without wanting a howto explanation but at least a basic understanding What this means is that if an unscrupulous individual gets between your client and the server, they can have full access to all information transmitted. how can someone do this? without it being known? Andrew -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 27 October 2003 15:39 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Ann: New Article on SSH Port Forwarding of MyODBC Hi Everyone; I have published a new article covering SSH port forwarding of MySQL sessions, which can be viewed at http://www.vbmysql.com/articles/sshtunnel.html The article covers connecting a Windows client to a *NIX based server. Anyone with previous experience will probably find the article redundant (although I would not mind feedback), but it should be useful for those without experience in port forwarding. In any case I hope you find it useful. Regards, Mike Hillyer www.vbmysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.530 / Virus Database: 325 - Release Date: 22/10/2003 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: New Article on SSH Port Forwarding of MyODBC
Think of your information like a letter in the mail. Well, for this example, think of it even more as a post-card. Your message is written on the outside where the anyone that touches it can read it. This post-card is going through the post office. It is going through mail centers, hubs, etc. Whatever path it needs to take to get from point A to Point B. At anyone of these post offices, if someone wants to read it, they just look at it, read it, then pass it along like normal. How would you ever know someone read it? Regular internet traffic is not encrypted, when you send a request, you send a written request like a post-card. Anyone in the middle could decide to read it. If you encrypt it, then they may have a harder time reading it, they would have to decrypt it. Of course, with the encrypted message, they could say, photocopy your post card, pass the post-card along, then work on figuring out how to read it in their spare time. The better your encryption, the longer it would take them to figure out what it says. But, say your mail system is all internal. You are sending mail from inside your building to inside your building. In this case, if the system is set up right, your mail will go from your office, to another office with-out ever leaving your building, which makes it much more secure. Someone in your own building would have to be devious enough to read your post-cards.(hopefully, your internal mail system would know not to send this message out to the normal post-office, just so the post-office will send it back to you) Anyway, that's my take on it. -- MySQL ODBC Mailing List For list archives: http://lists.mysql.com/myodbc 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: New Article on SSH Port Forwarding of MyODBC
That is a pretty fair take on network traffic. SSH has strong enough encryption to make the decryption effort not worth it to all but those with supercomputers. As for the internal mail, I think we can agree that some mail would be critical enough to warrant encryption even on an internal network. Mike Quoting Adam Trimeloni [EMAIL PROTECTED]: Think of your information like a letter in the mail. Well, for this example, think of it even more as a post-card. Your message is written on the outside where the anyone that touches it can read it. This post-card is going through the post office. It is going through mail centers, hubs, etc. Whatever path it needs to take to get from point A to Point B. At anyone of these post offices, if someone wants to read it, they just look at it, read it, then pass it along like normal. How would you ever know someone read it? Regular internet traffic is not encrypted, when you send a request, you send a written request like a post-card. Anyone in the middle could decide to read it. If you encrypt it, then they may have a harder time reading it, they would have to decrypt it. Of course, with the encrypted message, they could say, photocopy your post card, pass the post-card along, then work on figuring out how to read it in their spare time. The better your encryption, the longer it would take them to figure out what it says. But, say your mail system is all internal. You are sending mail from inside your building to inside your building. In this case, if the system is set up right, your mail will go from your office, to another office with-out ever leaving your building, which makes it much more secure. Someone in your own building would have to be devious enough to read your post-cards.(hopefully, your internal mail system would know not to send this message out to the normal post-office, just so the post-office will send it back to you) Anyway, that's my take on it. -- MySQL ODBC Mailing List For list archives: http://lists.mysql.com/myodbc 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]
PHP/MySQL/MyODBC drivers
I need to know the syntax to link two tables together that are in two seperate DB's using the ODBC drivers in PHP. Can anyone help with an example? Thanks Terry L. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: PHP/MySQL/MyODBC drivers
At 16:43 -0400 10/1/03, [EMAIL PROTECTED] wrote: I need to know the syntax to link two tables together that are in two seperate DB's using the ODBC drivers in PHP. Can anyone help with an example? Depends on what you mean by link two tables together. if you're trying to perform a join, you can simply refer to the tables using db_name.tbl_name syntax. You can read about name syntax in the MySQL Reference Manual: http://www.mysql.com/doc/en/Legal_names.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]
myODBC on Cobalt RAQ4
Hello all, I was wondering if any of you have ever added the MyODBC to a Cobalt raq4? I have downloaded the RPM ( MyODBC-3.51.01.i386-1.rpm ) When I go to rpm the file I recieve the error below--- [root /JON]# rpm -ivh MyODBC-3.51.06-1.i386.rpm error: failed dependencies: libc.so.6(GLIBC_2.2) is needed by MyODBC-3.51.06-1 [root /JON]# - I have downloaded the glibc-2.2.4-23.i386.rpm and tryed to load that and I recive many errors complaining [root /JON]# rpm -Uvh glibc-2.2.4-23.i386.rpm error: failed dependencies: libdl.so.1 is needed by frontpage-4.0-3 /lib/ld-linux.so.1 is needed by libc-5.3.12-31 libdb.so.2 is needed by python-1.5.2-13 libdb.so.2 is needed by rpm-3.0.5-9.6x libdb.so.2 is needed by rpm-build-3.0.5-9.6x libdb.so.2 is needed by rpm-python-3.0.5-9.6x libdb.so.2(GLIBC_2.0) is needed by python-1.5.2-13 libdb.so.2(GLIBC_2.0) is needed by rpm-3.0.5-9.6x libdb.so.3 is needed by openldap-1.2.9-6 libdb.so.3 is needed by pam-0.72-7 libdb.so.3 is needed by perl-5.00503-2 libdb.so.3 is needed by python-1.5.2-13 libdb.so.3 is needed by chiliasp-3.5.2L-C3 libdb.so.3 is needed by vim-enhanced-5.7-0.6x libdb.so.3 is needed by cyrus-sasl-1.5.24-C4 libdb.so.3 is needed by apache-1.3.20-RaQ4_1C4stackguard libdb.so.3 is needed by apache-admsrv-1.3.20-RaQ4_1C4stackguard libdb.so.3 is needed by sendmail-8.10.2-C4 libdb.so.3(GLIBC_2.0) is needed by python-1.5.2-13 libdb.so.3(GLIBC_2.1) is needed by openldap-1.2.9-6 libdb.so.3(GLIBC_2.1) is needed by pam-0.72-7 libdb.so.3(GLIBC_2.1) is needed by perl-5.00503-2 libdb.so.3(GLIBC_2.1) is needed by cyrus-sasl-1.5.24-C4 libdb.so.3(GLIBC_2.1) is needed by sendmail-8.10.2-C4 [root /JON]# Any help would be appeciated :) -- Best Regards, Phil Phillip Blancher Web Developer Lead Graphic Designer http://www.ontarioweb.ca 1-866-209-0349 [EMAIL PROTECTED] --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.515 / Virus Database: 313 - Release Date: 9/1/2003 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 + 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]
Error configuring myodbc ver 3.51
New list member and mysql newbie with first time post. I'm running into a problem getting MyODBC ver3.51 configured on my RH7.3 server running mysql 4.0.12. Anyone happen to be familiar with this error when configuring MyODBC: Could not find 'libmysqlclient' from '/usr/local/mysql/lib/mysql' or '/usr/local/mysql'. Try another location. I attempted to configure myodbc with the following: $./configure --prefix=/usr/local --with-iodbc=/usr/local --with-mysql-dirs=/usr/local/mysql/lib/mysql --with-mysql-includes=/usr/local/mysql/include/mysql --without-debug --enable-thread-safe I tried to change --with-mysql-dirs to --with-mysql-libs and got this error: Could not find the mysql include file So I changed --with-mysql-includes=/usr/local/mysql/include/mysql to --with-mysql-includes=/usr/local/mysql/include and got this error: Unable to find iodbc headers in /usr/local/include I changed --with-iodbc=/usr/local to --with-iodbc=DIR That returned the same error so I tried to change it to: --with-iodbc-includes=INCDIR and got this error: Unable to find iodbc headers in INCDIR So I try to remove the iodbc option and still get that error. I'm tapped as these are all steps outlined in the install document. Can anyone else here assist with this? Any responses are appreciated. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Is the MyODBC password encrypted?
Hi I'm connecting to a MySQL server on the internet from a VB6 app on Win2K using MyODBC. I understand that the connection itself is not secure. I cannot implement SSH for the connection as my ISP does not support this with MySQL. However, when MyODBC sends the username and password etc to the MySQL server, is it encrypted or sent a plain text? Thanks
RE: Is the MyODBC password encrypted?
Plain text. Use of the upcoming MyODBC 3.52 will make it in binary form, but not encrypted. Is the remote server MySQL 4.x? You could possibly use Stunnel (www.stunnel.org) to access the server via SSL. Regards, Mike Hillyer www.vbmysql.com -Original Message- From: Mike Fish (Shoal Computer Solutions Ltd) [mailto:[EMAIL PROTECTED] Sent: Friday, June 27, 2003 10:51 AM To: [EMAIL PROTECTED] Subject: Is the MyODBC password encrypted? Hi I'm connecting to a MySQL server on the internet from a VB6 app on Win2K using MyODBC. I understand that the connection itself is not secure. I cannot implement SSH for the connection as my ISP does not support this with MySQL. However, when MyODBC sends the username and password etc to the MySQL server, is it encrypted or sent a plain text? Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Is the MyODBC password encrypted?
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Mike Hillyer wrote: Plain text. Use of the upcoming MyODBC 3.52 will make it in binary form, but not encrypted. Is the remote server MySQL 4.x? You could possibly use Stunnel (www.stunnel.org) to access the server via SSL. The MySQL protocol sends the _username_ in plain text, but in all versions of the protocol, the password is _never_ sent, just a hash of the password combined with a 'seed' that was sent from the server when the client connected. -Mark - -- For technical support contracts, visit https://order.mysql.com/?ref=mmma __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mark Matthews [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, SW Dev. Manager - J2EE/Windows /_/ /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA ___/ www.mysql.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.1 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQE+/HqltvXNTca6JD8RAhuSAJsEZ/hmELd27gXtTrLPlBqP84k42gCfZ5xh rOH0z+1RguqqS8MSadFGxFA= =DMus -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Authentication problem with MyODBC 3.51
At 9:17 +0200 6/17/03, Laura del Cano wrote: Hello, I have intalled Mysql 4.1.0 and MyODBC 3.51 under Windows 2000. I create a new database in Mysql and a user with all the privileges on it (using GRANT ALL privileges...). I create a User DSN in the windows Control Panel and when I test the connection (in the same DSN panel) I get the following message: [MySQL][ODBC 3.51 Driver]Client does not support authentication protocol requested by server. Consider upgrading MySQL client I get the same error if I try to connect using the Mysqlgui or from another application, but only if the mysql user has a password. If it does not have a password, it connects ok. Last comment, this does not happen in all the machines, I have the same configuration installed in other machine (Windows2000, Mysql 4.1.0 and MyODBC 3.51) and I do not have this problem. Does anybody knows what I am missing? 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 thanks, Laura. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- 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 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]
Authentication problem with MyODBC 3.51
Hello, I have intalled Mysql 4.1.0 and MyODBC 3.51 under Windows 2000. I create a new database in Mysql and a user with all the privileges on it (using GRANT ALL privileges...). I create a User DSN in the windows Control Panel and when I test the connection (in the same DSN panel) I get the following message: [MySQL][ODBC 3.51 Driver]Client does not support authentication protocol requested by server. Consider upgrading MySQL client I get the same error if I try to connect using the Mysqlgui or from another application, but only if the mysql user has a password. If it does not have a password, it connects ok. Last comment, this does not happen in all the machines, I have the same configuration installed in other machine (Windows2000, Mysql 4.1.0 and MyODBC 3.51) and I do not have this problem. Does anybody knows what I am missing? thanks, Laura. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MyODBC 3.51 for MySQL 4.1
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 Unless expressly stated to the contrary, the views expressed in this email are not necessarily the views of National Grid Transco plc or any of its subsidiaries or affiliates (Group Companies), and the Group Companies, their directors, officers and employees make no representation and accept no liability for its accuracy or completeness. This e-mail, and any attachments are strictly confidential and intended for the addressee(s) only. The content may also contain legal, professional or other privileged information. If you are not the intended recipient, please notify the sender immediately and then delete the e-mail and any attachments. You should not disclose, copy or take any action in reliance on this transmission. You may report the matter by calling us on + 44(0) 1455 230999 Please ensure you have adequate virus protection before you open or detach any documents from this transmission. The Group Companies do not accept any liability for viruses. An e-mail reply to this address may be subject to monitoring for operational reasons or lawful business practices. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Problem compiling MyODBC 3.51.06
Hi, I try to compile MyODBC-3.51.06 on my GNU/Linux system with gcc-3.2 there was no problem with the configure, but for the make I got this : # gmake Making all in driver gmake[1]: Entering directory `/tmp/MyODBC-3.51.06/driver' gmake all-am gmake[2]: Entering directory `/tmp/MyODBC-3.51.06/driver' source='catalog.c' object='catalog.lo' libtool=yes \ depfile='.deps/catalog.Plo' tmpdepfile='.deps/catalog.TPlo' \ depmode=gcc3 /bin/sh ../depcomp \ /bin/sh ../libtool --mode=compile gcc -s -DHAVE_CONFIG_H -I. -I. -I. -I/usr/local/mysql/include/mysql -I/usr/local/BerkeleyDB.4.1/include -I/usr/local/include -O3 -DDBUG_OFF -O3 -march=i686 -c -o catalog.lo `test -f catalog.c || echo './'`catalog.c gcc -s -DHAVE_CONFIG_H -I. -I. -I. -I/usr/local/mysql/include/mysql -I/usr/local/BerkeleyDB.4.1/include -I/usr/local/include -O3 -DDBUG_OFF -O3 -march=i686 -c catalog.c -MT catalog.lo -MD -MP -MF .deps/catalog.TPlo -fPIC -DPIC -o catalog.lo cc1: warning: changing search order for system directory /usr/local/include cc1: warning: as it has already been specified as a non-system directory In file included from myodbc3.h:106, from catalog.c:46: /usr/local/include/iodbcinst.h:77:20: config.h: No such file or directory gmake[2]: *** [catalog.lo] Error 1 gmake[2]: Leaving directory `/tmp/MyODBC-3.51.06/driver' gmake[1]: *** [all] Error 2 gmake[1]: Leaving directory `/tmp/MyODBC-3.51.06/driver' gmake: *** [all-recursive] Error 1 It would be great if you could help me with this ! Best regards, Pierre. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MyODBC on AIX 4.3.3
I was wondering whether somebody on this list has successfully installed MyODBC on AIX 4.3.3. I tried it today using the 3.51 binaries and could not get it to work with either the latest iODBC or unixODBC driver manager. I someone has experience I happy to post more detailed error messages. Thanks in advance/h -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Can't set timeout on MyODBC/MySQL from an ADO/ASP program on Windows XP?
Hi, I've tried without success to set a timeout for SQL queries on a MySQL server (version 4.0.12 - so far the latest production release) running on a Windows XP SP1 box. The calling program is a Web site developed in ASP (going through ADO to access MyODBC...). I tried many different methods but there is no way I can STOP a SQL query that takes too long to execute (like... more than 5 minutes) and RAISE AN ERROR to the calling application (in that case an ASP page). METHOD 1: ADODB.Connection.CommandTimeout = % var strConnectionString = DSN=MyDSN; var strSQLRequest = SELECT * FROM MyHugeTable; // Create connection object var objConnection = Server.CreateObject(ADODB.Connection); // Set CommandTimeout to 30 seconds (on the Connection object) objConnection.CommandTimeout = 30; // Open the connection objConnection.Open(strConnectionString); // Create recordset object var objRecordset = Server.CreateObject(ADODB.recordset); // Execute SQL request objRecordset.Open(strSQLRequest, objConnection); // The above line is very long to execute and NEVER TIMES OUT!!! // Just check if it's open and not empty Response.Write(objRecordset.EOF = +objRecordset.EOF+br); % METHOD 2: ADODB.Command.CommandTimeout = % var strConnectionString = DSN=MyDSN; var strSQLRequest = SELECT * FROM MyHugeTable; // Create connection object var objConnection = Server.CreateObject(ADODB.Connection); // Open the connection objConnection.Open(strConnectionString); var objCommand = Server.CreateObject(ADODB.Command); objCommand.ActiveConnection = objConnection; objCommand.CommandText = strSQLRequest; // Set CommandTimeout to 30 seconds (this time on the Command object) objCommand.CommandTimeout = 30; // Execute SQL request objRecordset = objCommand.Execute(); // The above line is very long to execute and NEVER TIMES OUT!!! // Just check if it's open and not empty Response.Write(objRecordset.EOF = +objRecordset.EOF+br); % METHOD 3: ADODB.Connection.Properties(General Timeout) = % var strConnectionString = DSN=MyDSN; var strSQLRequest = SELECT * FROM MyHugeTable; // Create connection object var objConnection = Server.CreateObject(ADODB.Connection); // Set General Timeout to 30 (seconds?) objConnection.Properties(General Timeout).Value = 30; // Open the connection objConnection.Open(strConnectionString); // Create recordset object var objRecordset = Server.CreateObject(ADODB.recordset); // Execute SQL request objRecordset.Open(strSQLRequest, objConnection); // The above line is very long to execute and NEVER TIMES OUT!!! // Just check if it's open and not empty Response.Write(objRecordset.EOF = +objRecordset.EOF+br); % Nothing works... Has anybody ever tried this? Am I the only one with this problem? Is there any known solution to that problem? Note: I tried this on a Windows XP SP1 box as well as on a Windows 2000 Server SP3, with MySQL 4.0.12 and MyODBC 3.51.05 (all production releases), and MDAC 2.7 Emmanuel KARTMANN Web Consultant Replay Software Development Company Email: [EMAIL PROTECTED] Phone: +33 (0)6 60 41 68 83 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Using LOAD DATA IN FILE or SOURCE with MyODBC.
Hello all, I am thinking about produceing a small app that will use MyODBC on a windows machine to connect to a MySQL server on a remote FreeBSD machine. I already have something that will open an MS Access database and output either a MySQL syntax or CSV file and before i start adding an 'export directly to MySQL server' option want to know if it is possiable to issue the 'LOAD DATA IN FILE' or 'SOURCE' SQL commands to export the data from the Windows machine to the FreeBSD machine. -- Regards, William Bailey. Pro-Net Internet Services Ltd. http://www.pro-net.co.uk http://wb.pro-net.co.uk -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Question on MySQL, MyODBC VC++
Hello Everybody, I install MySQL in my W2K server and MyODBC also. I created a new database named Log and tried to connect from my project in VC++ via MyODBC. But my program get a runtime error when it try to open the database. I used CRecordset class to open it. Then I tried to open MySQL bulid-in database in the same way. It works very well. I think it is because of security matter. Help me solve the problem please. *I create a DSN in in ODBC management. I didn't forget. Thank in Advance. Terry _ STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Question on MySQL, MyODBC VC++
Terry- Personally I cant do much until I can see the stack trace, local variables and any diagnostics from your try/catch.. Regards, -Martin Hello Everybody, I install MySQL in my W2K server and MyODBC also. I created a new database named Log and tried to connect from my project in VC++ via MyODBC. But my program get a runtime error when it try to open the database. I used CRecordset class to open it. Then I tried to open MySQL bulid-in database in the same way. It works very well. I think it is because of security matter. Help me solve the problem please. *I create a DSN in in ODBC management. I didn't forget. Thank in Advance. Terry _ STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail -- 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]
AUTO_INCREMENT Columns reacting differently to MyODBC
In one of my tables, I have an AUTO_INCREMENT column that changes to #Deleted in each column in Access when I add a new record. To read the data, I just entered, I must close the table and then reopen it. In another table when I do the same thing, I see the new AUTO_INCREMENT number come up in the record after I add it and I can read the data without closing and reopening it. I think this probably has something to do with my one table being created in an older version of MySQL... I'm currently running 4.0.9. What must I do to make the first table react like the second table? Thank you in advance! Andrew Sql, query - 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: access-myodbc-interruption_mode?
[EMAIL PROTECTED] schrieb: access-2000 w2k-prof/xp-prof via myodbc 3.51 different mysql-servers (win-lin) everywhere the same, including win9x if i leave ms-access longer than 25 minutes alone with mysql via myodbc 3.51 i cannot close ms-access: - free translation: this procedure will put the current code back into the interruption mode. would you like to stop the execution of the code? - german-original: dieser vorgang wird den aktuellen code in den unterbrechungsmodus zuruecksetzen. moechten sie die ausfuehrung des codes anhalten? i have to kill ms-access with the task-manager! after 24 minutes, no problems. seems to happen only while closing the table-window, closing the database-window or closing access_completely works sometimes is this a known problem with myodbc? access? how can i prevent this? than i can only hope that our boss don´t phone longer than 24 minutes ;-) thanks and bye -- shrek-m - 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: access-myodbc-interruption_mode?
[EMAIL PROTECTED] wrote: hi, access-2000 w2k-prof/xp-prof via myodbc 3.51 different mysql-servers (win-lin) if i leave ms-access longer than 25 minutes alone with mysql via myodbc 3.51 i cannot close ms-access: - free translation: this procedure will put the current code back into the interruption mode. would you like to stop the execution of the code? - german-original: dieser vorgang wird den aktuellen code in den unterbrechungsmodus zuruecksetzen. moechten sie die ausfuehrung des codes anhalten? i have to kill ms-access with the task-manager! after 24 minutes, no problems. my preferred solution would be: $killall -9 access.exe #rpm -e ms-office #rpm -e windows is this a known problem with myodbc? access? how can i prevent this? Search back through the archives of this list and the MyODBC list. The short answer is that Access is f**ked and will crash when left unattended. I had originally thought that it only affected Access 2002, as Venu couldn't reproduce my problem under Access 2000. But apparently not. One dodgy fix which I've considered but not used is to have a hidden form with a timer event which opens an ADO connection to MySQL and closes it every 3 minutes. I haven't tested it but since the problem only happens when there is no activity between Access and MySQL, I assume this will work. Personally I prefer to leave it as is and tell everybody to direct their complains to [EMAIL PROTECTED] I would _strongly_ recommend that if you are working on an original database that you close it before walking off to get a coffee. I have lost almost a full day's work on several occassions because of this. If you can be bothered, maybe turn on ODBC logging and send a log in to the MyODBC list. However I'm pretty sure the problem is with Access and not MySQL / MyODBC. Maybe it's even intended... -- Daniel Kasak IT Developer * NUS Consulting Group* Level 18, 168 Walker Street North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: www.nusconsulting.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