Do you know if the connections (sessions) created for the web app are shared
or dedicated?
If it's dedicated, did you try to connect using sqlplus from that win2k
server and other hosts?
Trying to isolate the problem?
Regards,
Waleed
-----Original Message-----
Sent: Thursday, December 26, 2002 10:44 AM
To: Multiple recipients of list ORACLE-L
> Does your app connect to the database using the listener or
> directly (BEQ) without specifying a connect string?
>
> It should connect using the listener and a connect string.
>
> Regards,
>
> Waleed
>
Waleed
Yes, it's a web application and uses a listener. The listener entry has
not been modified. There was a vague reference in the MTS docs that
eluded to using a special connection string. But I got the impression
that you would use a special connection string *if* you wanted the
abillity to chooose between direct connection or mts (shared).
In my case Id simply like to have all connections to use MTS.
Should I be using a special connection string or listener entry? If so
where can I find some examples
Here is my asp application connection string (using the Oracle OLEDB
provider wich is current)
Connect=Provider=OraOLEDB.Oracle;PLSQLRSet=1;Password=z;Persist Security
Info=True;User ID=me;Data Source=mydb
Here is my traditional sql+ connection
username/password@instance
So, Im wondering what type of "special" connection string I'd need for
mts (if that's the case)
Listener entry
(SID_DESC =
(GLOBAL_DBNAME =mydb)
(ORACLE_HOME = C:\Oracle\Ora81)
(SID_NAME = mydb)
)
This is on win2k server, Oracle 8.1.7
Thanks!
bob
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Bob Metelsky
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Khedr, Waleed
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
