Recent content by GaryAshford

PS) Needless to say, the error has nothing to do with /tmp/mysql.sock error message. Sockets can only be used to connect to a local MySQL server (as I understand it) and do not apply when connecting to a remote MySQL server. You should definitely not get this error when your DSN contains the...

Hi again. Here I go answering my own question- but for anyone who is having the same problem, I now have some further information on this. Every site i've been to with regard to the "Can't connect to local MySQL Server" problem seems to imply that the user is doing something wrong, where...

Hi. Does anyone know a way to obtain information about AUTO_INCREMENT columns in tables using the ODBC API? As far as I can see, the only way to obtain this information is when you have a result set pending- in which case you can use SQLColAttribute. Is it possible to query this without a result...

Thanks for this info, i'll see if there are any fix-packs I haven't installed yet. (funny how IBM don't mention this problem in their flashy TV adverts!)

Hi. I have found that DB2 runtime client version 8.1 (On Win2000) doesn't like connecting to server version 7.2 (also Windows2000). I haven't tried server versions 7.1 or 6 so this may have the same problem. When I try connecting from the CLP, I get; SQL0902C A system error (reason code =...

Hi. Does anyone know how the CS-LIB or CT-LIB API can be used to retrieve the information returned by the BACKUP SERVER when executing a "dump database" command?? If you execute this from isql, you get the full story, e.g: Backup Server session id is: 11. Use this value when...

Hi. Lots of people have had a go at addressing the error you get when trying to connect to MySQL from a Linux machine, but none of the answers seem to apply when trying to connect to a REMOTE server via the MyODBC driver. Why should you get this message when the ODBC DSN in the .odbc.ini file...

Hi. Has anyone found that when querying the sysprocesses table, the hostname column only seems to be filled in for clients connecting from Windows and Unix? When connecting from Mac OS X, the hostname column is empty, presumeably because the Mac doesn't broadcast a hostname. Does anyone know if...

Hi- yes I sort of solved the problem. It seems that the .DEF file which accompanies the project file doesn't export the prepared statement functions. You just need to edit this file and add these to the list, then rebuild. I also built the MySQL client library on MacOSX, Linux and Solaris and...

Does anyone know what the story is with the dynamic mysql library (called libmysql.dll on Windows) the the C API functions which deal with Prepared Statements, e.g. mysql_prepare() & mysql_execute()... These were supposed to be available from version 4.1 onwards. The functions have prototype...

Ah- good question. I am using an iMac running MacOS9.2.2 talking via Openlink's Generic ODBC driver and the iODBC Driver Manager to a Win2k DataDirect ODBC datasource at the other end which is talking to MySQL running on a Linux box! So I guess I am using Openlink's ODBC API. I seem to remember...

Thanks, this is great. So I guess it would be true to say that whilst innoDB tables support transactions, the API call; SQLSetConnectOption( SQL_AUTOCOMMIT, on/off) is not supported by MySQL.

Thanks for your reply. I'm not trying to use any tables just yet. I am trying to tell MySQL what I want the transaction mode to be once I have logged on, i.e. manual transaction mode. Can this be done at the connection level? Maybe I have to have one or more innoDB tables before this will work?

Any programmers out there? :o) Assuming that transactions are supported in MySQL version 3.23.38, how is it that when my ODBC application does SQLSetConnectOption(..,SQL_AUTOCOMMIT,false) the call fails with error message; "Driver not capable" ? SQLGetInfo(..,SQL_TXN_CAPABLE,..)...

Hi. Can't find anything specific about this in the Oracle Docs: Does anyone know if it is possible to bind a CLOB or an NCLOB column in the WHERE clause of a SELECT statement? e.g. SELECT * from table WHERE clobcol = :clobval (I am writing an application using the OCI so the mechanics of...