×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

QUERYING VIA MERANT ODBC

QUERYING VIA MERANT ODBC

QUERYING VIA MERANT ODBC

(OP)
Have hit a brick wall with this!  Trying to query on Progress Database using MS Access via Merant odbc.  Getting intermittent error message 3146, ODBC call failed which, as I have found out, doesn't mean much!  Sometimes queries works, other times they don't.  Queries consist of main table with 3 or 4 lookup tables.  Creating a report using the query seems to work ok!  Simple queries on one or two tables seem to be fine.  Platforms as follows:

Progress8.3B on a Sun Solaris Unix platform
Microsoft Access 2002 on a Windows 2000 platform
ODBC - Merant 3.70 32-BIT

Network capacity is 1gbps (still get error message after business hours)

Tried everything I can think off so any help/ideas would be much appreciated.

RE: QUERYING VIA MERANT ODBC

Run an ODBC trace and output the Log.  This will give you the ODBC call that failed.  Post that and I might be able to help.  To run and ODBC trace click the trace tab in the ODBC administrator.

RE: QUERYING VIA MERANT ODBC

(OP)
Thanks for the advice. I put a trace on and have selected the end of the log where the error has occurred (log was far too long to copy all of it). Looks like a problem with data but I've no idea why it works some of the time and there is no problem when using one or two of the tables.  Again, any ideas would be appreciated. Thanks.

 3fc-160    EXIT  SQLBindParameter  with return code 0 (SQL_SUCCESS)
        HSTMT               086C1AD0
        UWORD                       10
        SWORD                        1 <SQL_PARAM_INPUT>
        SWORD                       99 <SQL_C_DEFAULT>
        SWORD                       12 <SQL_VARCHAR>
        SQLULEN                    3
        SWORD                        0
        PTR                0x0F6664F4
        SQLLEN                     0
        SQLLEN *            0x0F6664F0 (3)

Secured         3fc-160    ENTER SQLExecute
        HSTMT               086C1AD0

Secured         3fc-160    EXIT  SQLExecute  with return code -1 (SQL_ERROR)
        HSTMT               086C1AD0

        DIAG [S1000] [MERANT][ODBC PROGRESS driver][PROGRESS]Error in conversion.  String does not contain an integer value. (2627) (2627)

Secured         3fc-160    ENTER SQLErrorW
        HENV                086C1250
        HDBC                086C12F8
        HSTMT               086C1AD0
        WCHAR *             0x0012D0BC (NYI)
         SDWORD *            0x0012D108
        WCHAR *             0x0269B348
        SWORD                     4095
        SWORD *             0x0012D0F8

Secured         3fc-160    EXIT  SQLErrorW  with return code 0 (SQL_SUCCESS)
        HENV                086C1250
        HDBC                086C12F8
        HSTMT               086C1AD0
        WCHAR *             0x0012D0BC (NYI)
         SDWORD *            0x0012D108 (2627)
        WCHAR *             0x0269B348 [     110] "[MERANT][ODBC PROGRESS driver][PROGRESS]Error in conver"
        SWORD                     4095
        SWORD *             0x0012D0F8 (110)

Secured         3fc-160    ENTER SQLErrorW
        HENV                086C1250
        HDBC                086C12F8
        HSTMT               086C1AD0
        WCHAR *             0x0012D0BC (NYI)
         SDWORD *            0x0012D108
        WCHAR *             0x0269B43C
        SWORD                     3973
        SWORD *             0x0012D0F8

Secured         3fc-160    EXIT  SQLErrorW  with return code 100 (SQL_NO_DATA_FOUND)
        HENV                086C1250
        HDBC                086C12F8
        HSTMT               086C1AD0
        WCHAR *             0x0012D0BC (NYI)
         SDWORD *            0x0012D108
        WCHAR *             0x0269B43C
        SWORD                     3973
        SWORD *             0x0012D0F8

Secured         3fc-160    ENTER SQLFreeStmt
        HSTMT               086C1AD0
        UWORD                        0 <SQL_CLOSE>

Secured         3fc-160    EXIT  SQLFreeStmt  with return code 0 (SQL_SUCCESS)
        HSTMT               086C1AD0
        UWORD                        0 <SQL_CLOSE>

Secured         3fc-160    ENTER SQLFreeStmt
        HSTMT               086C1AD0
        UWORD                        1 <SQL_DROP>

Secured         3fc-160    EXIT  SQLFreeStmt  with return code 0 (SQL_SUCCESS)
        HSTMT               086C1AD0
        UWORD                        1 <SQL_DROP>

Secured         3fc-160    ENTER SQLFreeStmt
        HSTMT               086C4EC8
        UWORD                        1 <SQL_DROP>

Secured         3fc-160    EXIT  SQLFreeStmt  with return code 0 (SQL_SUCCESS)
        HSTMT               086C4EC8
        UWORD                        1 <SQL_DROP>

Secured         3fc-160    ENTER SQLFreeStmt
        HSTMT               086C5240
        UWORD                        1 <SQL_DROP>

Secured         3fc-160    EXIT  SQLFreeStmt  with return code -1 (SQL_ERROR)
        HSTMT               086C5240
        UWORD                        1 <SQL_DROP>

        DIAG [S1010] [MERANT][ODBC PROGRESS driver]Function sequence error. (0)

Secured         3fc-160    ENTER SQLErrorW
        HENV                086C1250
        HDBC                086C12F8
        HSTMT               086C5240
        WCHAR *             0x0012D460 (NYI)
         SDWORD *            0x0012D4AC
        WCHAR *             0x0269B348
        SWORD                     4095
        SWORD *             0x0012D49C

Secured         3fc-160    EXIT  SQLErrorW  with return code 0 (SQL_SUCCESS)
        HENV                086C1250
        HDBC                086C12F8
        HSTMT               086C5240
        WCHAR *             0x0012D460 (NYI)
         SDWORD *            0x0012D4AC (0)
        WCHAR *             0x0269B348 [      54] "[MERANT][ODBC PROGRESS driv"
        SWORD                     4095
        SWORD *             0x0012D49C (54)

Secured         3fc-160    ENTER SQLErrorW
        HENV                086C1250
        HDBC                086C12F8
        HSTMT               086C5240
        WCHAR *             0x0012D460 (NYI)
         SDWORD *            0x0012D4AC
        WCHAR *             0x0269B3C6
        SWORD                     4032
        SWORD *             0x0012D49C

Secured         3fc-160    EXIT  SQLErrorW  with return code 100 (SQL_NO_DATA_FOUND)
        HENV                086C1250
        HDBC                086C12F8
        HSTMT               086C5240
        WCHAR *             0x0012D460 (NYI)
         SDWORD *            0x0012D4AC
        WCHAR *             0x0269B3C6
        SWORD                     4032
        SWORD *             0x0012D49C

Secured         3fc-160    ENTER SQLFreeStmt
        HSTMT               086C5940
        UWORD                        1 <SQL_DROP>

Secured         3fc-160    EXIT  SQLFreeStmt  with return code -1 (SQL_ERROR)
        HSTMT               086C5940
        UWORD                        1 <SQL_DROP>

        DIAG [S1010] [MERANT][ODBC PROGRESS driver]Function sequence error. (0)

Secured         3fc-160    ENTER SQLErrorW
        HENV                086C1250
        HDBC                086C12F8
        HSTMT               086C5940
        WCHAR *             0x0012D460 (NYI)
         SDWORD *            0x0012D4AC
        WCHAR *             0x0269B348
        SWORD                     4095
        SWORD *             0x0012D49C

Secured         3fc-160    EXIT  SQLErrorW  with return code 0 (SQL_SUCCESS)
        HENV                086C1250
        HDBC                086C12F8
        HSTMT               086C5940
        WCHAR *             0x0012D460 (NYI)
         SDWORD *            0x0012D4AC (0)
        WCHAR *             0x0269B348 [      54] "[MERANT][ODBC PROGRESS driv"
        SWORD                     4095
        SWORD *             0x0012D49C (54)

Secured         3fc-160    ENTER SQLErrorW
        HENV                086C1250
        HDBC                086C12F8
        HSTMT               086C5940
        WCHAR *             0x0012D460 (NYI)
         SDWORD *            0x0012D4AC
        WCHAR *             0x0269B3C6
        SWORD                     4032
        SWORD *             0x0012D49C

Secured         3fc-160    EXIT  SQLErrorW  with return code 100 (SQL_NO_DATA_FOUND)
        HENV                086C1250
        HDBC                086C12F8
        HSTMT               086C5940
        WCHAR *             0x0012D460 (NYI)
         SDWORD *            0x0012D4AC
        WCHAR *             0x0269B3C6
        SWORD                     4032
        SWORD *             0x0012D49C

RE: QUERYING VIA MERANT ODBC

I haven't seen this one.  The error seems odd.  No integer in string and error in conversion.  I know Progress converts it's 4GL datatype to SQL datatypes.  I can only suggest a few websites

http://www.progress.com/services/support/cgi-bin/techweb-kbase.cgi/webkb.p  I typed in the SQLfreestmt into the search and found a work around list that might help.  Otherwise try this forum  www.progresstalk.com  It has a lot of knowledgeable members.  

RE: QUERYING VIA MERANT ODBC

(OP)
Thanks for taking the time to have a look at the problem.  I'll take a look at the websites and see how I get on.

RE: QUERYING VIA MERANT ODBC

Hi Folks,

Did you solve this ?
I encountered the same problem...

Hope i can get your good news~

Thanks a lot!

RE: QUERYING VIA MERANT ODBC

(OP)
Unfortunately I haven't found the solution yet. I've been working with Progress Helpdesk for a while now trying to solve the problem but with no luck. I'll post any further developments.

RE: QUERYING VIA MERANT ODBC

This might help you(if you haven't it done before)

Change in MS Access on your Query definition - go to Query Properties - change RecordSet Type = Snapshot(if you don't want to update) and rise your ODBC Timeout setting

RE: QUERYING VIA MERANT ODBC

(OP)
Thanks very much for the advice.  That seems to have sorted the problem. Quite a relief to finally get the ODBC link working properly!

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close