The IBM tech guy for our company gave me a couple of suggestions. After some tinkering I was able to successfully attach to the DB2 tables. Specifically I had to add two entries to the .INI file. For anyone's interest and edification here's what I added verbatim under the QISDB stanza:
CURRENTSCHEMA=USERID CURRENTSQLID=USERID Along with the other settings the addition of these two values did the trick. Thanks for the responses. Mike -----Original Message----- From: J. Stephen Wills [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 09, 2003 11:03 AM To: [EMAIL PROTECTED] Subject: [RBASE-L] - Re: Using ODBC to connect to DB2 database Mike, this is just a shot in the dark, but, could it have something to do w/quote settings such that the way strings are formatted/parsed between RBase and DB2 is the problem? Not really an answer, but maybe a valid question? Good luck and I'll be watching f/the ultimate solution. Later, Steve in Memphis ----- Original Message ----- From: "Ramsour Mike" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> Sent: Tuesday, September 09, 2003 8:08 AM Subject: [RBASE-L] - Using ODBC to connect to DB2 database > Good morning: > > I am trying to access tables in our corporate IBM DB2 database using ODBC. > I can SCONNECT to the database but when I try to SATTACH to the tables I get > an error message as follows: [IBM][CLI Driver][DB2/6000]SQL0204N > "CWMTMAR.SSSPEC" is an undefined name. SQLSTATE=42704 > > The CWMTMAR.SSSPEC consists of my user id of CWMTMAR and the table name of > SSSPEC. When the list of available tables appears in R:Base I only see the > SSSPEC portion. The actual tables themselves in DB2 are defined as > USERID.SSSPEC. The DB2 database is translating the USERID portion into my > user ID. > > Does anyone have any experience with how to configure a system to access DB2 > tables? If so how do you configure a Windows 2000 system for access? > Incidentally, when I use MS-Access 97 (boo! hiss!) to link to the tables > with ODBC there is no problem. Also, I get the same results as mentioned > above in both 6.5++ and R:Base VII. > > Any comments or suggestions will be greatly appreciated. I have a golden > opportunity to show what R:Base is made of which may result in it being used > more widely throughout the corporation. > > Thanks. > > Mike Ramsour > Voice: 740-829-4340 >
