Not positive, but it sounds to me like it could be as simple as possibly the Universe REXEC service is not running on your W2K (Universe Server). Possibly the startup mode is not set to automatic. Just check services on the Universe server and make very certain that UV REXEC service is in fact up and running - that's a start.
> -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Cooper, Rudy > Sent: Wednesday, September 22, 2004 4:18 PM > To: [EMAIL PROTECTED] > Subject: [U2] UvOdbc > > I'm having a problem getting my odbc connection to UV working. > > I know many of you have already overcome this problem so I'm > looking for some help in getting this going on my end. > > Here is what we have: > > UV 10.0.10 > W2K (UV Server) > W2K (Client) > Wintegrate 4.2.1 > Client side odbc driver = IBM Universe ODBC Driver > 3.07.02.1130 File = FASTPA32.DLL Date = 06/19/2002 100 user > license for UVODBC > > My ultimate goal is to query UV tables from Sql Server, but > as a "simple" test I thought I would try using Excel. > > I used the existing user dsn for "UV/ODBC Sales Sample". I > changed the server connection information to reflect my > system obviously. > > Here is my problem: > > I can ping my server without a problem, the moment I click the "Test" > button I get the following error: > > UniVerse ODBC configuration test failed. > > [IBM][UVODBC][0301892]Error ID: 110 Severity: SEVERE > Facility: LINKERR > - TCP error > > The odbc documentation, yes I actually read the > documentation, states the following for Error id 110: > > TCP error. > Other error messages (including strange character sequences) > typically indicate that the port number in the Link > Parameters field in the configu-ration file is incorrectly > specified; you have connected to a service other than the > rexec daemon (UNIX). > Use UniVerse ODBC Config to check the port number of the > rexec or autostart daemon or service (typically 512). > Retry the connection. If this fails, reboot your PC and try > again. If this fails, check to see if the host and its TCP/IP > inetd, rexec, or autostart daemon are running. > Error ID: 110, Severity: SEVERE, Facility: LINKERR > > My odbc config says 512, so I'm not really sure where the > problem could be. > > I even turned on the trace in the odbc configuration editor, > I see the error, but I have no idea what it means. Here's the trace: > > If someone could enlighten me I would greatly appreciate it. > > thx, > > rudy > > > > e uvodbc_config 6c8-7f0 ENTER SQLAllocEnv > HENV * 0142FBFC > > e uvodbc_config 6c8-7f0 EXIT SQLAllocEnv with return code 0 > (SQL_SUCCESS) > HENV * 0x0142FBFC ( 0x00911540) > > e uvodbc_config 6c8-7f0 ENTER SQLAllocConnect > HENV 00911540 > HDBC * 0142FBF8 > > e uvodbc_config 6c8-7f0 EXIT SQLAllocConnect with > return code 0 > (SQL_SUCCESS) > HENV 00911540 > HDBC * 0x0142FBF8 ( 0x009115e8) > > e uvodbc_config 6c8-7f0 ENTER SQLDriverConnectW > HDBC 009115E8 > HWND 000604BC > WCHAR * 0x00237310 [ -3] "******\ 0" > SWORD -3 > WCHAR * 0x00237310 > SWORD 8 > SWORD * 0x00000000 > UWORD 3 > <SQL_DRIVER_COMPLETE_REQUIRED> > > e uvodbc_config 6c8-7f0 EXIT SQLDriverConnectW with > return code -1 > (SQL_ERROR) > HDBC 009115E8 > HWND 000604BC > WCHAR * 0x00237310 [ -3] "******\ 0" > SWORD -3 > WCHAR * 0x00237310 > SWORD 8 > SWORD * 0x00000000 > UWORD 3 > <SQL_DRIVER_COMPLETE_REQUIRED> > > DIAG [08S01] [IBM][UVODBC][0301892]Error ID: 110 > Severity: SEVERE Facility: LINKERR - TCP error (10054) > > e uvodbc_config 6c8-7f0 ENTER SQLErrorW > HENV 00911540 > HDBC 009115E8 > HSTMT 00000000 > WCHAR * 0x0142FBB8 (NYI) > SDWORD * 0x0142FC04 > WCHAR * 0x0142F7B8 > SWORD 511 > SWORD * 0x0142FC00 > > e uvodbc_config 6c8-7f0 EXIT SQLErrorW with return code 0 > (SQL_SUCCESS) > HENV 00911540 > HDBC 009115E8 > HSTMT 00000000 > WCHAR * 0x0142FBB8 (NYI) > SDWORD * 0x0142FC04 (10054) > WCHAR * 0x0142F7B8 [ 84] > "[IBM][UVODBC][0301892]Error ID: 110 Sever" > SWORD 511 > SWORD * 0x0142FC00 (84) > > e uvodbc_config 6c8-7f0 ENTER SQLFreeConnect > HDBC 009115E8 > > e uvodbc_config 6c8-7f0 EXIT SQLFreeConnect with return code 0 > (SQL_SUCCESS) > HDBC 009115E8 > > e uvodbc_config 6c8-7f0 ENTER SQLFreeEnv > HENV 00911540 > > e uvodbc_config 6c8-7f0 EXIT SQLFreeEnv with return code 0 > (SQL_SUCCESS) > HENV 00911540 > > ODBC Sales Samp 768-7b8 ENTER SQLAllocEnv > HENV * 0142FBFC > > ODBC Sales Samp 768-7b8 EXIT SQLAllocEnv with return code 0 > (SQL_SUCCESS) > HENV * 0x0142FBFC ( 0x00911540) > > ODBC Sales Samp 768-7b8 ENTER SQLAllocConnect > HENV 00911540 > HDBC * 0142FBF8 > > ODBC Sales Samp 768-7b8 EXIT SQLAllocConnect with > return code 0 > (SQL_SUCCESS) > HENV 00911540 > HDBC * 0x0142FBF8 ( 0x009115e8) > > ODBC Sales Samp 768-7b8 ENTER SQLDriverConnectW > HDBC 009115E8 > HWND 000D041C > WCHAR * 0x00237310 [ -3] "******\ 0" > SWORD -3 > WCHAR * 0x00237310 > SWORD 8 > SWORD * 0x00000000 > UWORD 3 > <SQL_DRIVER_COMPLETE_REQUIRED> > > ODBC Sales Samp 768-7b8 EXIT SQLDriverConnectW with > return code -1 > (SQL_ERROR) > HDBC 009115E8 > HWND 000D041C > WCHAR * 0x00237310 [ -3] "******\ 0" > SWORD -3 > WCHAR * 0x00237310 > SWORD 8 > SWORD * 0x00000000 > UWORD 3 > <SQL_DRIVER_COMPLETE_REQUIRED> > > DIAG [08S01] [IBM][UVODBC][0301892]Error ID: 110 > Severity: SEVERE Facility: LINKERR - TCP error (10054) > > ODBC Sales Samp 768-7b8 ENTER SQLErrorW > HENV 00911540 > HDBC 009115E8 > HSTMT 00000000 > WCHAR * 0x0142FBB8 (NYI) > SDWORD * 0x0142FC04 > WCHAR * 0x0142F7B8 > SWORD 511 > SWORD * 0x0142FC00 > > ODBC Sales Samp 768-7b8 EXIT SQLErrorW with return code 0 > (SQL_SUCCESS) > HENV 00911540 > HDBC 009115E8 > HSTMT 00000000 > WCHAR * 0x0142FBB8 (NYI) > SDWORD * 0x0142FC04 (10054) > WCHAR * 0x0142F7B8 [ 84] > "[IBM][UVODBC][0301892]Error ID: 110 Sever" > SWORD 511 > SWORD * 0x0142FC00 (84) > > ODBC Sales Samp 768-7b8 ENTER SQLFreeConnect > HDBC 009115E8 > > ODBC Sales Samp 768-7b8 EXIT SQLFreeConnect with return code 0 > (SQL_SUCCESS) > HDBC 009115E8 > > ODBC Sales Samp 768-7b8 ENTER SQLFreeEnv > HENV 00911540 > > ODBC Sales Samp 768-7b8 EXIT SQLFreeEnv with return code 0 > (SQL_SUCCESS) > HENV 00911540 > > ODBC Sales Samp 7ac-748 ENTER SQLAllocEnv > HENV * 0142FBFC > > ODBC Sales Samp 7ac-748 EXIT SQLAllocEnv with return code 0 > (SQL_SUCCESS) > HENV * 0x0142FBFC ( 0x00911540) > > ODBC Sales Samp 7ac-748 ENTER SQLAllocConnect > HENV 00911540 > HDBC * 0142FBF8 > > ODBC Sales Samp 7ac-748 EXIT SQLAllocConnect with > return code 0 > (SQL_SUCCESS) > HENV 00911540 > HDBC * 0x0142FBF8 ( 0x009115e8) > > ODBC Sales Samp 7ac-748 ENTER SQLDriverConnectW > HDBC 009115E8 > HWND 00080536 > WCHAR * 0x00237310 [ -3] "******\ 0" > SWORD -3 > WCHAR * 0x00237310 > SWORD 8 > SWORD * 0x00000000 > UWORD 3 > <SQL_DRIVER_COMPLETE_REQUIRED> > > ODBC Sales Samp 7ac-748 EXIT SQLDriverConnectW with > return code -1 > (SQL_ERROR) > HDBC 009115E8 > HWND 00080536 > WCHAR * 0x00237310 [ -3] "******\ 0" > SWORD -3 > WCHAR * 0x00237310 > SWORD 8 > SWORD * 0x00000000 > UWORD 3 > <SQL_DRIVER_COMPLETE_REQUIRED> > > DIAG [08S01] [IBM][UVODBC][0301892]Error ID: 110 > Severity: SEVERE Facility: LINKERR - TCP error (10054) > > ODBC Sales Samp 7ac-748 ENTER SQLErrorW > HENV 00911540 > HDBC 009115E8 > HSTMT 00000000 > WCHAR * 0x0142FBB8 (NYI) > SDWORD * 0x0142FC04 > WCHAR * 0x0142F7B8 > SWORD 511 > SWORD * 0x0142FC00 > > ODBC Sales Samp 7ac-748 EXIT SQLErrorW with return code 0 > (SQL_SUCCESS) > HENV 00911540 > HDBC 009115E8 > HSTMT 00000000 > WCHAR * 0x0142FBB8 (NYI) > SDWORD * 0x0142FC04 (10054) > WCHAR * 0x0142F7B8 [ 84] > "[IBM][UVODBC][0301892]Error ID: 110 Sever" > SWORD 511 > SWORD * 0x0142FC00 (84) > > ODBC Sales Samp 7ac-748 ENTER SQLFreeConnect > HDBC 009115E8 > > ODBC Sales Samp 7ac-748 EXIT SQLFreeConnect with return code 0 > (SQL_SUCCESS) > HDBC 009115E8 > > ODBC Sales Samp 7ac-748 ENTER SQLFreeEnv > HENV 00911540 > > ODBC Sales Samp 7ac-748 EXIT SQLFreeEnv with return code 0 > (SQL_SUCCESS) > HENV 00911540 > ------- > u2-users mailing list > [EMAIL PROTECTED] > To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
