Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

QUERYING VIA MERANT ODBC 1

Status
Not open for further replies.
AHHH

AHHH

IS-IT--Management
Oct 30, 2002
6
GB
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.
 
Sort by date Sort by votes
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.
 
Upvote 0 Downvote
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] &quot;[MERANT][ODBC PROGRESS driver][PROGRESS]Error in conver&quot;
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] &quot;[MERANT][ODBC PROGRESS driv&quot;
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] &quot;[MERANT][ODBC PROGRESS driv&quot;
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
 
Upvote 0 Downvote
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

I typed in the SQLfreestmt into the search and found a work around list that might help. Otherwise try this forum It has a lot of knowledgeable members.
 
Upvote 0 Downvote
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.
 
Upvote 0 Downvote
Hi Folks,

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

Hope i can get your good news~

Thanks a lot!
 
Upvote 0 Downvote
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.
 
Upvote 0 Downvote
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
 
Upvote 0 Downvote
Thanks very much for the advice. That seems to have sorted the problem. Quite a relief to finally get the ODBC link working properly!
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

IsraelBermejo
  • Locked
  • Question
Updating data in progress using ODBC
Replies
0
Views
341
IsraelBermejo
IsraelBermejo
bordway
  • Locked
  • Question
Remote ODBC connection to 10.1B that is running on XP test installation
Replies
2
Views
343
bordway
bordway
madvalpreston
  • Locked
  • Question
Epicor Vantage does not show results from crytsal via Porgress
Replies
0
Views
100
madvalpreston
madvalpreston
ehetzel
  • Locked
  • Question
ODBC to Progress
Replies
0
Views
75
ehetzel
ehetzel
focusbiz1
  • Locked
  • Question
Getting around Vantage 6.1 ODBC 'Select Only' Security Settings
Replies
0
Views
111
focusbiz1
focusbiz1

Part and Inventory Search

Sponsor

Back
Top