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]
Can't connect (error 2003) to mysql 5.0 on other server
Hi, I installed mysql 5.0 on server A and mysql 4.0 on server B. Starting mycompA$mysql -h mycompB -u mysql -p on host A, I can connect and to the mysql-server on host B. However when I start mycompB$mysql -h mycompA -u mysql -p on host B, I get the error message: ERROR 2003: Can't connect to MySQL server on 'mycompA' (111) On mycompA the user [EMAIL PROTECTED] has all privileges. This is what tcpdump reports: tcpdump: listening on eth1 port 3306 13:50:32.732182 mycompB.33431 mycompA.mysql: S 2312810184:2312810184(0) win 5840 mss 1460,sackOK,timestamp 11242088 0,nop,wscale 0 (DF) 13:50:32.732570 mycompA.mysql mycompBt.33431: R 0:0(0) ack 2312810185 win 0 (DF) Any suggestions? Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Can't connect (error 2003) to mysql 5.0 on other server
Bingo!! With the installation of the 5.0 (I assume) skip-networking was set by default in /etc/mysql/my.cnf. That was it. Thanks. Mike I assume you have already verified that the mysql server is actually running on server A. Have you verified that server A is accepting tcp connections? Try running mysql -h mycompA -u mysql -p from server A. If it lets you in, try SELECT CURRENT_USER(); just to make sure it says @mycompA rather than @localhost. Alternatively, try telnet mycompA 3306 from both machines to see if you get an answer. If it doesn't let you in, check to see if mysql was started with --skip-networking on A, and look for anything which blocks mysql's port. Michael Mike Bosschaert wrote: Hi, I installed mysql 5.0 on server A and mysql 4.0 on server B. Starting mycompA$mysql -h mycompB -u mysql -p on host A, I can connect and to the mysql-server on host B. However when I start mycompB$mysql -h mycompA -u mysql -p on host B, I get the error message: ERROR 2003: Can't connect to MySQL server on 'mycompA' (111) On mycompA the user [EMAIL PROTECTED] has all privileges. This is what tcpdump reports: tcpdump: listening on eth1 port 3306 13:50:32.732182 mycompB.33431 mycompA.mysql: S 2312810184:2312810184(0) win 5840 mss 1460,sackOK,timestamp 11242088 0,nop,wscale 0 (DF) 13:50:32.732570 mycompA.mysql mycompBt.33431: R 0:0(0) ack 2312810185 win 0 (DF) Any suggestions? Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Can I get the matching expression from REGEXP
Thanks for the reply. I agree on the scripting languages. However it was a one time conversion problem. I managed with the substring_index sugestion. Regards, Mike On Wednesday 11 December 2002 02:05, Robert Citek wrote: Hello Mike, The short answer: use Perl, Python, Ruby, etc. You are pressing the boundaries between a query language (SQL) and a programming/scripting language (Perl, Python, Ruby, etc.). Scripting languages as these already have those capabilities and can easily connect to MySQL an many other database. That is, if you create a solution with a scripting language you will also create a more portable solution. Regards, - Robert - At 12:40 AM 12/11/2002 +0100, Mike Bosschaert wrote: Now I want to remove the 1 or 2 letter combination from this column into another column. I can select the rows with WHERE colX REGEXP . .{1,2}$ This wil return the first two rows only. But I cannot figure out how to get the query to return the matching result (being ef and i). - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Can I get the matching expression from REGEXP
Hi, In one of my tables I have a column which contains a combination of a string (characters only), a space and a 1 or 2 letter combination. The string has no fixed lenght. Like: abcd ef bcdefgh i etc Now I want to remove the 1 or 2 letter combination from this column into another column. I can select the rows with WHERE colX REGEXP . .{1,2}$ This wil return the first two rows only. But I cannot figure out how to get the query to return the matching result (being ef and i). Any help appreciated Mike - 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