Hi,
I can connect to any database on my server (mySQL 4.0.11a-gamma on =
Linux)
via MySQL ODBC 3.51.06.00 using Query Tool ODBC 4.1.1
(http://gpoulose.home.att.net/). But if I select a different database =
(from
a drop-down menu) it may or may not report an error, quite arbitrarily. =
When
it reports an error, it is that the database is unknown; but the =
database
name quoted in the error message has one or more (usually one) spurious
characters appended to it, usually printable, sometimes not. The =
following
traces illustrate this point. Despite the error though, the database is =
in
fact selected and queries return data from the selected database =
correctly.
The author of Query Tool assures me that the fault lies with myODBC, not =
his
software!
Edward Leigh
~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ =
~ ~
~
E-mail: eleigh [at] excogitate.[REMOVE]co.uk |=A0 Independent New Media =
Consultant
=A0=A0=A0=A0=A0=A0=A0 Cambridge, UK=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 =
|=A0
=A0=A0 Web: http://www.osolis.com/=A0=A0 | Shareware =
registration service
=A0=A0 Web: http://www.urlorg.com/=A0=A0 | URL =
Organizer 2
~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ =
~ ~
~
Database is in fact: 'osolis_reformist':
>SQLSetConnectAttr
| enter: Atrr: 109, ValuePtr: 0x11c1d28, StrLenPtr: 16
| >mysql_select_db
| | enter: db: 'osolis_reformisto'
| | >vio_is_blocking
| | | exit: 1
| | <vio_is_blocking
| | >vio_blocking
| | | enter: set_blocking_mode: 0
| | <vio_blocking
| | >vio_is_blocking
| | | exit: 1
| | <vio_is_blocking
| | >net_flush
| | | >vio_is_blocking
| | | | exit: 1
| | | <vio_is_blocking
| | | >net_real_write
| | | | >vio_write
| | | | | enter: sd=3D668 size=3D22
| | | | | exit: 22
| | | | <vio_write
| | | <net_real_write
| | <net_flush
| | >vio_is_blocking
| | | exit: 1
| | <vio_is_blocking
| | >vio_read
| | | enter: sd=3D668 size=3D4
| | | exit: 4
| | <vio_read
| | >vio_read
| | | enter: sd=3D668 size=3D39
| | | exit: 39
| | <vio_read
| | error: Got error: 1049 (Unknown database 'osolis_reformisto')
| <mysql_select_db
| >copy_error
| | error: code :1049, state: S1000, err :Unknown database
'osolis_reformisto'
| | exit : SQL_ERROR
| <copy_error
| exit : SQL_ERROR
<SQLSetConnectAttr
>SQLGetDiagRec
| values: 2,0x178810,1,0x12ebe0,0x12f328,0x11c2d58,511,0x12f330
<SQLGetDiagRec
>SQLGetDiagRec
| values: 2,0x178810,2,0x12ebe0,0x12f328,0x11c2d58,511,0x12f330
| exit : SQL_NO_DATA_FOUND
<SQLGetDiagRec
Database name is in fact: 'osolis_goodmatchtest':
>SQLSetConnectAttr
| enter: Atrr: 109, ValuePtr: 0x11c1c08, StrLenPtr: 20
| >mysql_select_db
| | enter: db: 'osolis_goodmatchtest [at] =02=1C=01m'
| | >vio_is_blocking
| | | exit: 1
| | <vio_is_blocking
| | >vio_blocking
| | | enter: set_blocking_mode: 0
| | <vio_blocking
| | >vio_is_blocking
| | | exit: 1
| | <vio_is_blocking
| | >net_flush
| | | >vio_is_blocking
| | | | exit: 1
| | | <vio_is_blocking
| | | >net_real_write
| | | | >vio_write
| | | | | enter: sd=3D668 size=3D30
| | | | | exit: 30
| | | | <vio_write
| | | <net_real_write
| | <net_flush
| | >vio_is_blocking
| | | exit: 1
| | <vio_is_blocking
| | >vio_read
| | | enter: sd=3D668 size=3D4
| | | exit: 4
| | <vio_read
| | >vio_read
| | | enter: sd=3D668 size=3D47
| | | exit: 47
| | <vio_read
| | error: Got error: 1049 (Unknown database =
'osolis_goodmatchtest [at] =02=1C=01m')
| <mysql_select_db
| >copy_error
| | error: code :1049, state: S1000, err :Unknown database
'osolis_goodmatchtest [at] =02=1C=01m'
| | exit : SQL_ERROR
| <copy_error
| exit : SQL_ERROR
<SQLSetConnectAttr
--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=3Dgcdmo-myodbc [at] m.gmane.o rg
