myodbc - ms-access problem: table contents not shown

2004-04-06 Thread Mike Bosschaert
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 cod

Re: Can't connect (error 2003) to mysql 5.0 on other server

2004-04-04 Thread Mike Bosschaert
s 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

Can't connect (error 2003) to mysql 5.0 on other server

2004-04-04 Thread Mike Bosschaert
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 connec

Re: Can I get the matching expression from REGEXP

2002-12-11 Thread Mike Bosschaert
ution 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

Can I get the matching expression from REGEXP

2002-12-10 Thread Mike Bosschaert
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 col