Search results for query: *

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...

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...

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...

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...

Hi. I have been trying to establish the level of unicode support provided by ASE 12.5. As far as I can tell, there are two new character types; UNICHAR and UNIVARCHAR and that is it. Is it possible to configure a ct-lib application so that all of the "meta-data"; username, password...

Hi. I have just done a default install of Syabse ASE 12.5 on Windows 2000. I have got past the SYCONFIG problem and side-stepped the LC_ALL pitfall and have managed to setup a default database to do some testing! Yet as soon as I have run about 100 or so SQL statements from my client...

Hi. When I try connecting to Dynamic Server running on Redhat 6.2 from a Linux client (running Suse 7.3) I get the old classic- -956 Client-name or user is not trusted by the database server. (I can connect fine from a Win98 client). The Error manual says to append the /etc/hosts.equiv and...

Hi again. With most other DBMSs, it is possible to interrogate the database (a table or a function) to establish the database version, etc being used. Is this possible with Informix Databases? TIA Gary

For some time, I have been trying to find a way to add new users to Informix Universal Server running on Linux. Is this as simple as inserting rows into the sysusers table or is there a more established way of doing this? As far as the Informix Docs are concerned, this would appear to be a very...

When an ITStatement is prepared and an array of ITStrings is supplied, datetime qualifiers do do appear to get registered (e.g. year to fraction). Later on, if you do an ITStatement->Param()->TypeOf().Name() and an ITStatement->Param()->TypeOf().Qualifier(), the name comes back as...