RE: BUG? Inserting BLOB or CLOB values when table and field names are created with "quotes"
Hi!
Thanks for the reply!
I downloaded the oledb upgrade what you showed me, but the problem was the
same.
Still not able to insert >4000 bytes of data if the column name is created
with quotes ("").
Without the quotes, everything is fine.
(ado 2.6 sp1, oraOLEDB 8.1.7.03)
Bye,
Daniel
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: daniel szabo
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
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).
BUG? Inserting BLOB or CLOB values when table and field names are created with "quotes"
Hello, i don't know if it's a bug, but probably, yes.
The case is the following:
We're using Oracle server 8.1.6, running on MS Windows 2000, and Oracle
OLEDB Provider version 8.1.7.02 on the client side.
We're tried to use ADO 2.6 sp1 to create ADO Command objects to insert data
values to BLOB or CLOB fields.
The cases were the following:
1. If you create the table and field names with quotes ("tablename",
"FieldName", etc), then you cannot insert BLOB or CLOB values larger than
4000 bytes (error is: Invalid Column Name). Data which is smaller or equal
then 4000 bytes is simply OK.
2. If you create the table and field names without quotes (create table
blobtest (id number, bdata blob);), then all names are capitalised to UPPER
CASE, AND YOU ARE ABLE TO INSERT DATA normally (large as you want).
I don't know, if it's a bug inside the Oracle, or what.
Any suggestions?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: daniel szabo
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
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).
RE: Microsoft Transaction Server hangs
Hello, What about the oramts service? Is it stopping or something? you should turn the trace on. Daniel -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Stephen AndertSent: Wednesday, November 28, 2001 8:35 PMTo: Multiple recipients of list ORACLE-LSubject: Microsoft Transaction Server hangs I'm looking into this for a colleague. Environment NT 4 SP 6 Oracle server 8.1.5 At several times throughout the day, the connection hangs. MTS seems to still be running, the db is still accessible. Bouncing the MTS service resolves the problem for a while. I have asked them to check listener status when this hanging takes place. Has anyone encountered this? Any ideas where to look? Stephen
oraMTS service and NT4 locale setting
Hi, this is just an info or little trick for those who are configuring microsoft transaction server to work together with an Oracle database as the resource manager. So, when you configure the oramts service on the MTS host, be sure, that the system's default locale is set to **!!!English!!!**, otherwise the oramts service is unable to store the encrypted password in the registry! And thatswhy the service won't start. This is a really-really-really-really silly thing, and at one of our french customer, we lost a lot of time because of this (because they have french NT4 with french locale set by default). So, use english servers everywhere, and you won't have silly problems ;) bye Daniel Szabo -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: daniel szabo INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
oracle 8i and mts problem
Hello there, Oracle users!I am new here, as new to the Oracle technology. We are developping a =software which must be transaction compliant, and we're on microsoft =platform, and thatswy we're using sql2000 and microsoft transaction =server for our application server components.=20But one of our clients wants to use oracle 8i db as the resource =manager. We had to make the proper work mts with oracle. I red all of =the oracle documentation within this topic, and i successfully installed =the Oracle Services for MTS on our development machine at the workplace. =(created the mts_proxy_info table, granted the specific roles to a =specific db user, the specific privileges, the xa views, and so on), and =it is working nicely, the log says "accepting new enlistment request", =everything is wonderful.But at the client, i repeated all of the steps (the only difference is, =that they have the server on a HP-UX machine instead of winnt), and when =i wanted to start the oracle services for MTS on the Application server, =the log says this: "incorrect password, or username". I really don't =undestand it, because i can connect through the OLEDB driver with the =specified username, password and Service name.=20If anybody had an idea i would be very happythanks in advance,daniel szabo
