WSOCK Error 10054 is connection reset. Sounds like the service doesn't exist, or it's refusing your connection. Why you'd need rexec, or any other *nix process, on Windows is beyond my knowledge. Maybe you should recheck your setup? Is there options for Unix versus Windows?
Glen > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] 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/
