Mike Did you add this to the RBASE.INI file?
David Blocker ----- Original Message ----- From: "Ramsour Mike" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> Sent: Tuesday, September 09, 2003 11:09 AM Subject: [RBASE-L] - Re: Using ODBC to connect to DB2 database > 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 > > > >
