[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 471
  • Last Modified:

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!
0
jablan
Asked:
jablan
  • 6
  • 4
1 Solution
 
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
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
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
 
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

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

  • 6
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now