Guidance Forums / Reginald Rexx / ODBC problem-Guidance指路人

Guidance
指路人
g.yi.org

Guidance Forums / Reginald Rexx / ODBC problem

Home

Software

Upload

回顶部

⇑

Forum List • Thread List • Reply • Refresh • New Topic • Search • Previous • Next

1. 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)

#13376

Posted by: Jeff Glatt 2010-10-09 16:18:27

Try the latest RxOdbc, and see if it works.

3. 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

掌柜推荐

¥860.00 ·

¥900.00 ·

¥810.00 ·

¥317.00 ·

¥1,370.00 ·

¥660.00 ·

g.yi.org Hits:0