Guidance
指路人
g.yi.org
Guidance Forums / Reginald Rexx / ODBC problem

Register 
新用户注册
Search 搜索
首页 
Home Home
Software
Upload

  
Forum List • Thread List • Reply • Refresh • New Topic • Search • Previous • Next First 1 Last
Message1. ODBC problem
#13373
Posted by: Michael S 2010-10-07 18:14:36
When running the following code in RPC in an existing (working) script, I have 2 problems

set_odbc_connect_options:

rc = odbcsetconnectopt('TXN', 'UNCOMMIT')
IF rc <> '' THEN
	SAY 'TXN, UNCOMMIT 'rc
rc = odbcsetconnectopt('TRACE', 1)
IF rc <> '' THEN
	SAY 'TRACE, 1 'rc
rc = odbcsetconnectopt('TRACEFILE', "c:\temp\misi01_sql.log")
IF rc <> '' THEN
	SAY "TRACEFILE, c:\temp\misi01_sql.log "rc

rc = odbcgetconnectopt('TRACEFILE', my_tracefile)	

RETURN 0
The first problem is that RPC crashes on the odbcgetconnectopt call. If I remove that, the calls above seem correct, but I never see any ODBC trace in the file specified (in fact, I don't see the file either)
Message2.
#13376
Posted by: Jeff Glatt 2010-10-09 16:18:27
Try the latest RxOdbc, and see if it works.
Message3. That didn't seem to help - same problem
#13377
Posted by: Michael S 2010-10-11 18:10:18
I debugged the code to confirm that I've performed the OdbcAllocDatabase before trying the calls above (as indicated in the docs).

The version for the rxodbc.dll is 0,0,0,5 (if that helps at all)
Forum List • Thread List • Reply • Refresh • New Topic • Search • Previous • Next First 1 Last
掌柜推荐
 
 
 
 
 
 
 
 
 
 
 
 
© Sun 2017-11-19  Guidance Laboratory Inc.
Email:webmaster1g.yi.org Hits:0