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 >
