Sorry it took so long to respond. The connection string I am using in my code for DB2 is as follows:
"DSN=<datasource_name>\0DBALIAS=<database_name>\0\0"
It was tricky to get it working in my C code, but these are the right parameters for DB2. If you need parameters for different db...
I can't seem to stop a remote instance that I am attached to from the DB2 CLP. I can do it from the control center just fine, so doesn't it make sense that I should be able to from the command line???
Does anyone know how to:
1. db2stop a remote instance from a DB2 server or client command...
As an answer to the first post, if you've already taken 1Z0-001, it is accepted in place of 1Z0-007 to go towards OCA for 9i. I would highly recommend taking 007 exam if you have not already taken 001, because 007 is entirely online. I passed it last week. It is not an extremely easy test...
I can't be sure this is not user error, but after downloading and running make test, I get the following error: "Can't use \x{} without 'use utf8' declaration at /tmp/Config-IniFiles-2.29/blib/lib/Config/IniFiles.pm line 518." This occurs for every test. I ran make install anyway...
I have a program that requires a string to have a null char in the middle of the string (i.e. "Keyword=value\0Keyword=value"). I am getting the value part of that string from the command line and am having a tough time constructing the string. I do the following...
YES, YES, YES!!! While digging through some DB2 docs, I found that DB2's ODBC driver config parameters ARE different than the rest of the worlds'. Instead of using "DSN=datasourcename", they use "DBALIAS=dbname" and it MUST match an existing database name cataloged in the...
YES, YES, YES!!! While digging through some DB2 docs, I found that DB2's ODBC driver config parameters ARE different than the rest of the worlds'. Instead of using "DSN=datasourcename", they use "DBALIAS=dbname" and it MUST match an existing database name cataloged in the...
Thanks for being so helpful...my current machine configuration is simply this:
Windows 2000 with DB2 UDB v7.2
The SQLConfigDataSource() is returning: "Driver's ConfigDSN, ConfigDriver, or ConfigTranslator failed" when using the "IBM DB2 ODBC DRIVER". The official error...
I'm still failing miserably with the DB2 driver...The driver name is the correct name (from the Admin GUI and the registry). One strange thing is that in the ODBCINST.INI file, the DB2 driver is listed as: "IBM DB2 ODBC DRIVER (32 bit)" but if I try to use that, it complains that the...
Thanks for the info, but that does not work. The funny thing is, it is reading my user id and password parameters just fine...makes me think I am putting in the wrong keywords or something!!!
Ok, I've narrowed it down to the wrong key/value pairs for the IBM DB2 ODBC DRIVER...DSN,DESCRIPTION,and DATABASE are not being passed correctly. UID and PWD are being inserted in the datasource though...
Is there any way of programatically finding what the key/value pairs are supposed to be...
I have a program that creates ODBC datasources programatically using the Windows API SQLConfigDataSource(). It works fine for other drivers, but not IBM DB2 ODBC DRIVER. I have narrowed it down to a keyword/value pair problem in the following call:
SQLConfigDataSource(GetDesktopWindow()...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.