ADO/Oracle/ODBC 2000 Character Cutoff?

I've got an Oracle8 database with a column that is a Varchar2(4000). When I move data into this column and save it, a null is being inserted at position 2001. I was forced to convert this column to a LONG to avoid this, but I'd rather not because I can't sort and the like on it now.

What's with this 2000 limit? Is it ADO, ASP, ODBC, or Oracle? ? Help!

Thanks!
LVL 1
jablanAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

mgfranzCommented:
Oracle has a 2Mb limit on varChar() fields so it's not Oracle, what version of MDAC are you using?
0
mgfranzCommented:
Sorry, bad data... the 2Mb is really 2Gb and it is for a Long() datatype, the 2k cutoff you are experiencing ~could be that the type is not being recognized and it's being interpreted as Char().
0
jablanAuthor Commented:
Let me clarify:

Column was type VARCHAR2(4000).

When I inserted data into the column via ASP/ADO (Microsoft Oracle Driver latest version), it inserts a null char at position 2001.

I don't think it's Oracle, I think it's ASP/ADO/ODBC...
0
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

mgfranzCommented:
Yeah... thats why I asked what version of MDAC you had loaded?

Mark
0
jablanAuthor Commented:
it's the 4202.3 version. The latest according to the MS site. I just checked.
0
mgfranzCommented:
The OLEDB for Oracle should look like this;
MSDAORA.DLL 02.10.3711.0 Microsoft OLE DB Provider for Oracle

0
edwardpoonCommented:
But it seems that the ODBC provided by Microsoft doesn't work well. Have you download the ODBC driver from the Oracle Homepage?

I am using Oracle 8i Server, I have downloaded the ODBC driver from the Oracle Homepage, it works well and your problem doesn't exist.

0
jablanAuthor Commented:
I've had problems with Oracle's ODBC driver. Specifically when it comes to public synonyms. It used to not recognize them. I'll give it a try.
0
mgfranzCommented:
The versions of the drivers I use with my Oracle8.0 are the following;

MS Driver   2.73.728   MSORCL32.dll
Oracle Dr.  8.00.050   SQORA32.dll

I have not had any driver related issues with these... yet... ;-)

BTW, we use NCLOB for most of our text fields...
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
jablanAuthor Commented:
Thanks for the info. We're using ODBC, not the OLE DB stuff. I'm not sure how to switch that over.
0
mgfranzCommented:
I don't use OLE either, strictly ODBC or ADO.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
ASP

From novice to tech pro — start learning today.