Did the name of the box change? You need to enter the name via WRKRDBDIRE.
I suspect you'll have to recycle ODBC prestart jobs for it to take effect
for all users (ENDHOSTSVR *DATABASE, ENDPJ QUSRWRK QZDASOINIT
OPTION(*IMMED), STRHOSTSVR *DATABASE).
Here's a link that may help:
http://publib.boulder.ibm.com/infocenter/iseries/v5r3/topic/rzaii/rzaiiodbc3
8.htm
HTH, Elvis
Celebrating 10-Years of SQL Performance Excellence
http://centerfieldtechnology.com/training.asp
-----Original Message-----
Subject: SQL0114 & WRKRDBDIRE
We have recently moved from on Iseries to another. When our users try
to use some Excel spreadsheets they were getting the SQL0114 error.
After a search on the archives I found a few entries concerning the
WRKRDBDIRE command.
The current entry is the serial number of the machine. I tried adding
an entry with the IP ADDR of the machine and 127.0.0.1 the loop back
address. Neither worked and I couldn't add another local entry.
I'm hesitant to change the existing entry because I don't know what
effect it would have on my machine.
Any ideas in getting the ODBC connections working again are appreciated.
Glenn Thompson
midrange.com
