[Search for users]
[Overall Top Noters]
[List of all Conferences]
[Download this site]
| Title: | DEC ODBC Driver |
| Notice: | DEC ODBC Driver V2.0 Now Available |
| Moderator: | SQLSRV::MAVRIS |
|
| Created: | Tue Dec 29 1992 |
| Last Modified: | Fri Jun 06 1997 |
| Last Successful Update: | Fri Jun 06 1997 |
| Number of topics: | 1357 |
| Total number of notes: | 4864 |
1340.0. "2 passthru sql cursors in VB cause odbc 3146 err" by BROKE::BITHER () Fri May 09 1997 14:10
Hi,
Have a customer using latest sql/services and odbc driver. Also using
Visual Basic passthru to get to Rdb.
Customer says when they do a 2 record set using Visual Basic passthru SQL
they get an ODBC error 3146 which is odbc call failed.
What works:
----------
1 record set NOT using passthru SQL in VB.
1 record set using passthru SQL in VB.
2 record set NOT using passthru SQL in VB. (They don't want to do this since
they say performance is much better using passthru.)
What doesn't work:
-----------------
2 record set using passthru SQL in VB.
They are doing "move nexts" in the VB code.
I asked them to send the following:
1) example of VB code that works
2) example of VB code that doesn't work (so we can get an idea of what
they are doing.)
3) client.log
4) odbcrdb.log
They didn't send the VB code, only the log files which show almost nothing
and appear below. As soon as I get the VB code, I'll post as a reply to
this note. Wanted to get this in anyway in case someone had ideas based
on the info I already have.
Thanks, Diane
-------------------------------
ODBCRDB.LOG
-----------
Oracle ODBC 32 Bit Driver for Rdb Version 2.10.11.0.0
Oracle ODBC 32 Bit Driver for Rdb File Version 2.10.11.0.0
CLIENT.LOG
----------
Log file generated by C:\WINNT\System32\sqsapi32.dll
Oracle Sql/Services Version 7.00
ASSOCIATE LEVEL LOG
----SQLSRV_ASSOCIATE
--------SQLSRV_ASSOCIATE ID: 6911478
--------NODE: 132.147.160.20, USERNAME: FILIA_L_VB, SQLCODE: 0, SQLERRD[0] 0
--------NETWORK TRANSPORT: TCP/IP
ROUTINE LEVEL LOG at 15:33:32 on 07-May-1997
----SELECT LIST SQLDA
ROUTINE LEVEL LOG at 15:33:33 on 07-May-1997
----SELECT LIST SQLDA
ROUTINE LEVEL LOG at 15:33:33 on 07-May-1997
----SELECT LIST SQLDA
ROUTINE LEVEL LOG at 15:33:33 on 07-May-1997
----SELECT LIST SQLDA
ROUTINE LEVEL LOG at 15:33:33 on 07-May-1997
----SELECT LIST SQLDA
ROUTINE LEVEL LOG at 15:33:33 on 07-May-1997
----SELECT LIST SQLDA
ROUTINE LEVEL LOG at 15:33:33 on 07-May-1997
----SELECT LIST SQLDA
ROUTINE LEVEL LOG at 15:33:33 on 07-May-1997
----SELECT LIST SQLDA
ROUTINE LEVEL LOG at 15:33:33 on 07-May-1997
----SELECT LIST SQLDA
ROUTINE LEVEL LOG at 15:33:33 on 07-May-1997
----SELECT LIST SQLDA
ROUTINE LEVEL LOG at 15:33:33 on 07-May-1997
----SELECT LIST SQLDA
ROUTINE LEVEL LOG at 15:33:33 on 07-May-1997
----SELECT LIST SQLDA
ROUTINE LEVEL LOG at 15:33:33 on 07-May-1997
----SELECT LIST SQLDA
ROUTINE LEVEL LOG at 15:33:33 on 07-May-1997
----SELECT LIST SQLDA
ROUTINE LEVEL LOG at 15:33:33 on 07-May-1997
----SELECT LIST SQLDA
ROUTINE LEVEL LOG at 15:33:33 on 07-May-1997
----SELECT LIST SQLDA
ROUTINE LEVEL LOG at 15:33:33 on 07-May-1997
----SELECT LIST SQLDA
ROUTINE LEVEL LOG at 15:33:33 on 07-May-1997
----SELECT LIST SQLDA
ROUTINE LEVEL LOG at 15:33:33 on 07-May-1997
----SELECT LIST SQLDA
ROUTINE LEVEL LOG at 15:33:33 on 07-May-1997
----SELECT LIST SQLDA
ROUTINE LEVEL LOG at 15:33:37 on 07-May-1997
----SELECT LIST SQLDA
ROUTINE LEVEL LOG at 15:33:37 on 07-May-1997
----SELECT LIST SQLDA
ROUTINE LEVEL LOG at 15:33:37 on 07-May-1997
----SELECT LIST SQLDA
ROUTINE LEVEL LOG at 15:33:37 on 07-May-1997
----SELECT LIST SQLDA
ROUTINE LEVEL LOG at 15:33:37 on 07-May-1997
----SELECT LIST SQLDA
ROUTINE LEVEL LOG at 15:33:37 on 07-May-1997
----SELECT LIST SQLDA
ROUTINE LEVEL LOG at 15:33:38 on 07-May-1997
----SELECT LIST SQLDA
ROUTINE LEVEL LOG at 15:33:38 on 07-May-1997
----SELECT LIST SQLDA
ROUTINE LEVEL LOG at 15:33:38 on 07-May-1997
----SELECT LIST SQLDA
ROUTINE LEVEL LOG at 15:33:38 on 07-May-1997
----SELECT LIST SQLDA
ROUTINE LEVEL LOG at 15:33:38 on 07-May-1997
----SELECT LIST SQLDA
ROUTINE LEVEL LOG at 15:33:38 on 07-May-1997
----SELECT LIST SQLDA
ROUTINE LEVEL LOG at 15:33:38 on 07-May-1997
----SELECT LIST SQLDA
ROUTINE LEVEL LOG at 15:33:38 on 07-May-1997
----SELECT LIST SQLDA
ROUTINE LEVEL LOG at 15:33:38 on 07-May-1997
----SELECT LIST SQLDA
ROUTINE LEVEL LOG at 15:33:38 on 07-May-1997
----SELECT LIST SQLDA
ROUTINE LEVEL LOG at 15:33:38 on 07-May-1997
----SELECT LIST SQLDA
ROUTINE LEVEL LOG at 15:33:38 on 07-May-1997
----SELECT LIST SQLDA
ROUTINE LEVEL LOG at 15:33:38 on 07-May-1997
----SELECT LIST SQLDA
ROUTINE LEVEL LOG at 15:33:38 on 07-May-1997
----SELECT LIST SQLDA
ROUTINE LEVEL LOG at 15:33:38 on 07-May-1997
----SELECT LIST SQLDA
ROUTINE LEVEL LOG at 15:33:38 on 07-May-1997
----SELECT LIST SQLDA
ROUTINE LEVEL LOG at 15:33:38 on 07-May-1997
----SELECT LIST SQLDA
ROUTINE LEVEL LOG at 15:33:38 on 07-May-1997
----SELECT LIST SQLDA
ROUTINE LEVEL LOG at 15:33:38 on 07-May-1997
----SELECT LIST SQLDA
ROUTINE LEVEL LOG at 15:33:38 on 07-May-1997
----SELECT LIST SQLDA
ROUTINE LEVEL LOG at 15:33:38 on 07-May-1997
----SELECT LIST SQLDA
ROUTINE LEVEL LOG at 15:33:38 on 07-May-1997
----SELECT LIST SQLDA
ROUTINE LEVEL LOG at 15:33:38 on 07-May-1997
----SELECT LIST SQLDA
ROUTINE LEVEL LOG at 15:33:38 on 07-May-1997
----SELECT LIST SQLDA
ROUTINE LEVEL LOG at 15:33:38 on 07-May-1997
----SELECT LIST SQLDA
ROUTINE LEVEL LOG at 15:33:38 on 07-May-1997
----SELECT LIST SQLDA
ROUTINE LEVEL LOG at 15:33:38 on 07-May-1997
----SELECT LIST SQLDA
ROUTINE LEVEL LOG at 15:33:38 on 07-May-1997
----SELECT LIST SQLDA
ROUTINE LEVEL LOG at 15:33:38 on 07-May-1997
----SELECT LIST SQLDA
ROUTINE LEVEL LOG at 15:33:51 on 07-May-1997
----SELECT LIST SQLDA
ROUTINE LEVEL LOG at 15:33:51 on 07-May-1997
----SELECT LIST SQLDA
ROUTINE LEVEL LOG at 15:33:52 on 07-May-1997
----SELECT LIST SQLDA
ROUTINE LEVEL LOG at 15:33:52 on 07-May-1997
----SELECT LIST SQLDA
ROUTINE LEVEL LOG at 15:33:52 on 07-May-1997
----SELECT LIST SQLDA
ROUTINE LEVEL LOG at 15:33:53 on 07-May-1997
----SELECT LIST SQLDA
ROUTINE LEVEL LOG at 15:33:54 on 07-May-1997
----SELECT LIST SQLDA
ASSOCIATE LEVEL LOG
----SQLSRV_RELEASE
--------SQLSRV_ASSOCIATE ID: 6911478
| T.R | Title | User | Personal
Name | Date | Lines |
|---|
| 1340.1 | need logs or a real error message | M5::JBALOGH | | Fri May 09 1997 17:01 | 13 |
| Well, the 3146 ODBC call failed error is worthless. get the customer to
walk through the errors().description collection or we need to get the
real error from a odbc or client log.
That log you posted was missing just about everything. They need to set
client logging to a higher number (like 7).
We may be able to determine something if we can get the error message.
I actually do recordset.movenext in VB all the time without a problem.
(both with and without passthrough queries).
John
|
| 1340.2 | log files and vb code available - thanks | BROKE::BITHER | | Wed May 14 1997 19:03 | 185 |
| 1340.3 | Customer solved - here is solution fyi | BROKE::BITHER | | Tue May 27 1997 18:28 | 12 |
| Customer resolved this themselves. Putting solution here in case anybody
else needs it.
Diane
--------------------------------
SOLUTION: (in customer's words)
We resolved the problem related with the 2 cursors . The problem was that
in visual basic when you open more then 2 databases you have to create the
workspace. We were using a default workspace for the 2 databases, it seems
that when you are using sqlpassthrough , it gets mixed up.
|