Search results for query: *

Sorry it took so long to respond. The connection string I am using in my code for DB2 is as follows: &quot;DSN=<datasource_name>\0DBALIAS=<database_name>\0\0&quot; 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: &quot;Can't use \x{} without 'use utf8' declaration at /tmp/Config-IniFiles-2.29/blib/lib/Config/IniFiles.pm line 518.&quot; This occurs for every test. I ran make install anyway...

Thanks for your help. I got it working 2 minutes before I got your post...I did something similar to what you did. Thanks again.

I have a program that requires a string to have a null char in the middle of the string (i.e. &quot;Keyword=value\0Keyword=value&quot;). 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 &quot;DSN=datasourcename&quot;, they use &quot;DBALIAS=dbname&quot; 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 &quot;DSN=datasourcename&quot;, they use &quot;DBALIAS=dbname&quot; 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: &quot;Driver's ConfigDSN, ConfigDriver, or ConfigTranslator failed&quot; when using the &quot;IBM DB2 ODBC DRIVER&quot;. 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: &quot;IBM DB2 ODBC DRIVER (32 bit)&quot; but if I try to use that, it complains that the...

Yes, I am running from NT(2k actually) and going to a DB2 system via ODBC and it is on a PC. Thanks for all your help.

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

Evidently, they are used as delimeters between parameters. Seems to work fine for Oracle...but not DB2!! Any ideas??

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

Very, very helpful, thank you!!! The GetDesktopWindow() call gives me a dialog with no values put in...and the error message returned from SQLInstallerError() is: &quot;Driver's ConfigDSN, ConfigDriver, or ConfigTranslator failed&quot; So, I am trying to find the right parameters for...

Thanks for the help dds82. GetLastError() returns a zero, and and FormatMessage() appeared to return successfully (&quot;The Operation Completed Successfully&quot;). This is apart from the fact that my DB2 ODBC DataSource cfg failed miserably. The funny part is this: SQLConfigDataSource()...

Whoops...obviously I don't know too much about MFC...sorry! Thanks for the help. I can't seem to get this to work...i.e. it never gets to the catch stmt... could you give me a specific code example? I imagine it would be similar to mine: try{ printf(&quot;\nSetting up %s...

I'm not working in java, but in C

Yes, the db is local and I can configure it manually through the ODBC GUI tool, and I can cfg it using DB2 CLP catalog commands, but it fails at creation time using SQLConfigureDataSource()...I don't know how to get the error. Like I said, it works with other drivers. Here is the call: result...