mySQL on unix vs ODBC
Hi everyone ! We've got a problem: running mySQL on unix(sun) we connect a third party windows software over ODBC. All is nice until a windows path is stored in the db Trying to store C:\Program Files\3p SW\ I find that it becomes C:Program Files3p SW. Is it possible, by means of configuration, to have backslashes preserved ? Either in ODBC or ... somewhere ? Facts: 3d party software = no code no chance of changes ODBC - installed from myodbc-2.50.37-nt.zip mySQL - 3.23.39 ( 3.23.41 could be used) thanx in advance peter - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: mySQL on unix vs ODBC
Thanks Will, to avoid further misunderstandings - the escapefeature of backslash is fully understood. The problem is that the 3d party sw or the myODBC doesn't understand that the inbound text SHOULD HAVE backslash but does exactly whats expected - escape the next char. What I'm asking is - is there any configurable way that ODBC can be made to add that extra escaping backslash needed other than recompiling ODBC which isn't an option for the moment. anyone have clue !?? again, thanx in advance peter Will French [EMAIL PROTECTED] 09/12/01 10:20AM mySQL sees back slashes (\) as escape sequence characters. Use either \\ or substitute forward slashes (/). -Original Message- From: Peter Gad [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 12, 2001 4:10 AM To: [EMAIL PROTECTED] Subject: mySQL on unix vs ODBC Hi everyone ! We've got a problem: running mySQL on unix(sun) we connect a third party windows software over ODBC. All is nice until a windows path is stored in the db Trying to store C:\Program Files\3p SW\ I find that it becomes C:Program Files3p SW. Is it possible, by means of configuration, to have backslashes preserved ? Either in ODBC or ... somewhere ? Facts: 3d party software = no code no chance of changes ODBC - installed from myodbc-2.50.37-nt.zip mySQL - 3.23.39 ( 3.23.41 could be used) thanx in advance peter - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Problem installing/compiling 3.23.39 on solaris 8
Hello, concerning problem with installing/compiling mysql 3.23.39 on solaris 8 using gcc 3.0 Solution: compile with gcc 2.95.3 I would still like to use gcc 3.0 thou :-) peter gad - 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
Problem installing/compiling 3.23.39 on solaris 8
Hello every/any-one, hopefully someone can point me to a solution to this problem... (As I'm not sure my subcription to the mysql list(s) is yet valid, could you please respond to mail address [EMAIL PROTECTED].) thank you. Peter Gad The problem: I'm trying to install/compile mysql 3.23.39 on Solaris 8 (sun4u,sparc) using gcc 3.0 (local build) but get the following error # Partial copy of the make output make[3]: Entering directory `/misc/source/mysql-3.23.39/sql' gcc -DMYSQL_SERVER -DDEFAULT_MYSQL_HOME=\/usr/local/mysql\ -DDATADIR=\/usr/local/mysql/var\ -DSHAREDIR=\/usr/local/mysql/share/mysql\ -DHAVE_CONFIG_H -I./../include -I./../regex-I. -I../include -I.. -I.-O3 -DDBUG_OFF -DHAVE_CURSES_H -I/misc/source/mysql-3.23.39/include -DHAVE_RWLOCK_T -c password.c /bin/sh ../libtool --mode=link gcc -O3 -DDBUG_OFF -fno-implicit-templates -fno-exceptions -fno-rtti -DHAVE_CURSES_H -I/misc/source/mysql-3.23.39/include -DHAVE_RWLOCK_T -o mysqlbinlog mysqlbinlog.o mini_client.o net_serv.o mini_client_errors.o violite.o password.o ../isam/libnisam.a ../merge/libmerge.a ../myisam/libmyisam.a ../myisammrg/libmyisammrg.a ../heap/libheap.a ../mysys/libmysys.a ../dbug/libdbug.a ../regex/libregex.a ../strings/libmystrings.a ../isam/libnisam.a ../merge/libmerge.a ../myisam/libmyisam.a ../myisammrg/libmyisammrg.a ../heap/libheap.a ../mysys/libmysys.a ../dbug/libdbug.a ../regex/libregex.a ../strings/libmystrings.a-ldl -lpthread -lthread -lz -lcrypt -lgen -lsocket -lnsl -lm -lpthread -lthread mkdir .libs gcc -O3 -DDBUG_OFF -fno-implicit-templates -fno-exceptions -fno-rtti -DHAVE_CURSES_H -I/misc/source/mysql-3.23.39/include -DHAVE_RWLOCK_T -o mysqlbinlog mysqlbinlog.o mini_client.o net_serv.o mini_client_errors.o violite.o password.o ../isam/libnisam.a ../merge/libmerge.a ../myisam/libmyisam.a ../myisammrg/libmyisammrg.a ../heap/libheap.a ../mysys/libmysys.a ../dbug/libdbug.a ../regex/libregex.a ../strings/libmystrings.a ../isam/libnisam.a ../merge/libmerge.a ../myisam/libmyisam.a ../myisammrg/libmyisammrg.a ../heap/libheap.a ../mysys/libmysys.a ../dbug/libdbug.a ../regex/libregex.a ../strings/libmystrings.a -ldl -lpthread -lthread -lz -lcrypt -lgen -lsocket -lnsl -lm -lpthread -lthread Undefined first referenced symbol in file __cxa_pure_virtual mysqlbinlog.o ld: fatal: Symbol referencing errors. No output written to mysqlbinlog collect2: ld returned 1 exit status make[3]: *** [mysqlbinlog] Error 1 make[3]: Leaving directory `/misc/source/mysql-3.23.39/sql' make[2]: *** [all-recursive] Error 1 make[2]: Leaving directory `/misc/source/mysql-3.23.39/sql' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/misc/source/mysql-3.23.39' make: *** [all-recursive-am] Error 2 - 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