ERROR: SQL PASSTHROUGH CONNECTION MUST BE SHARED?? 
Author Message
 ERROR: SQL PASSTHROUGH CONNECTION MUST BE SHARED??

Hi,

I believe I have delphi and Personal Oracle 7 and ODBC-Oracle installed
correctly because I was able to view my oracle tables from within Delphi.

However I now get a SQL PASSTHROUGH CONNECTION MUST BE SHARED error whenever
my Query object tries to access the Oracle table.  Does anyone know what's
wrong?  I'm just trying to do a simple select from the Query.SQL property
such as 'select * from emp'.  Help!?



Thu, 21 May 1998 03:00:00 GMT  
 ERROR: SQL PASSTHROUGH CONNECTION MUST BE SHARED??

Quote:
>However I now get a SQL PASSTHROUGH CONNECTION MUST BE SHARED

I am currently using Delphi/SQLnet without ODBC. But....

Check your BDE( or ODBC ) configuration. (Under TOOLS option)

Under Driver option in BDE config, when you click on ORACLE option,
it should display parameters on the right.

In the parameter list(near the bottom), there is an option called
"SQLPASSTHRU MODE".  The value on that parameter should be
"shared (autocommit/nonautocommit)".

Since you are using ODBC driver, maybe you should check this parameter in
ODBC setup.

Sandra Kim

--
                                               ______________________  
                                          o O /                      \  
                                        o    |  What's Delphi? GPF??  |  
                                              \______________________/  
               <>+<>                 //////      __v__        __\/__  
   `\|||/      /---\     """""""    | _ - |     (_____)   .  / ^  _ \  .


_ooO_<_>_Ooo_ooO_U_Ooo_ooO__v__Ooo_ooO_u_Ooo_ooO__(_)__Ooa__oOO_()_OOo___

[_____}_____!____.}_____{_____|_____}_____i____.}_____!_____{_____}_____]

SSDS*SSDS*SSDS*SSDS*SSDS*SSDS*SSDS*SSDS*INC*INC*INC*INC*INC*INC*INC*INC*I
NC



Fri, 29 May 1998 03:00:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Passthrough SQL Connection must be shared (??? What ???)

2. Passthrough SQL

3. AccessViolations and the need for Passthrough SQL

4. Pdox 7 SQLLinks BDE Passthrough SQL InMemoryTCursor

5. Experience with Passthrough SQL anyone ?

6. Passthrough SQL

7. Sharing Database Connections

8. Sharing a Database connection between executables

9. HELP: sharing database connection (like Delphi and Database Explorer)

10. Sharing Database connections -- how is it possible?

11. Oracle - Multiple apps sharing 1 database connection

12. Sharing database connection

 

 
Powered by phpBB® Forum Software