Bill; Hopefully, you've gotten past this by now - if not:
This error usually means that you have the incorrect "Data Source" in your connection string. This is what is in your UCI.CONFIG file. Note that (like most things in UD) it is case-sensitive. In your case use "asidevud". The Path/Location is the account. I usually like to use the full path "E:\DataTrust\DtaDemo" A common error is the timeout - error code = 81015. You can increase the timeout by changing the values in the unirpcservices file on the server. It defaults to 6 minutes (3600). One error that seems to get me every once in a while is error code = 81002. The first thing I do is check the NT permissions on the file "privilege" in the account you are trying to connect to. The user needs write access to this file in order to connect. This is all at the windows level. It seems that occasionally VSG will mess with the permissions on this file. We had one client that converted from D3 to UniData and was amazed at how much faster it ran in UD. Good luck Colin Alfke Calgary, Canada >-----Original Message----- >From: Bill Haskett > >I tried to make a UniOLEDB connection from MS VS2005 to >UniData and get the error "Died in UCI::SQLConnect() with >SQLSTATE IM976, Native error: 0 [IBM][SQL Client]UCI >connections to non UniVerse databases is not allowed." > >I've read and followed the 155 page UniOLEDB manual. The >following configurations exist: > >On the Client: > >Unirpcservices > uvcs E:\IBM\UV\bin\uvapi_server.exe * TCP/IP 0 3600 > defcs E:\IBM\UV\bin\uvapi_server.exe * TCP/IP 0 3600 > uvserver E:\IBM\UV\bin\uvsrvd.exe * TCP/IP 0 3600 > uvnet E:\IBM\UV\bin\uvnetd.exe * TCP/IP 0 3600 > uvdrsrv E:\IBM\UV\bin\uvdrsrvd.exe * TCP/IP 0 3600 > uvfilefix E:\IBM\UV\bin\uvfilefix_server.exe * TCP/IP 0 3600 > >I updated the uci.config file via the UCI Editor and it looks like: > >[ODBC DATA SOURCES] <-- this has looked funny from the beginning > ><localuv> >DBMSTYPE = UNIVERSE >network = TCP/IP >service = uvserver >host = localhost > ><localud> >DBMSTYPE = UNIDATA >network = TCP/IP >service = udserver >host = localhost > ><asidevud> >DBMSTYPE = UNIDATA >NETWORK = TCP/IP >SERVICE = udserver >HOST = AsiOlyWaDev >ACCOUNT = E:\DataTrust\DtaDemo >USERNAME = MyUserName ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
