Datatype Error on Insert

		Wrox Programmer Forums > .NET > Other .NET > ADO.NET
Datatype Error on Insert

ADO.NET For discussion about ADO.NET.Â Â Topics such as question regarding the System.Data namespace are appropriate.Â Â Questions specific to a particular application should be posted in a forum specific to the application .

Welcome to the p2p.wrox.com Forums.

You are currently viewing the ADO.NET section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

November 5th, 2003, 01:40 PM

cavada1

Registered User

Join Date: Nov 2003

Posts: 1

Thanks: 0

Thanked 0 Times in 0 Posts

Datatype Error on Insert

I'm trying to update records in an Oracle DB with records from an Access db, but I'm getting an error saying that I can only update Long Recordtype to Long Columns. The majority of the fields are Text in Access, and VarChar2 in the Oracle table, or they are numeric. How can I change the datatype of the insert record before i's inserted? Say, from adLongVarWChar to adVariant.

I appreciate any help, Thanks.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Insert Query Error & Run-Time Error 3022	DavidWE	Access	1	July 31st, 2008 11:17 AM
Insert Error	FishBoy	SQL Server ASP	2	April 7th, 2008 06:45 AM
INSERT INTO error	akibaMaila	Beginning VB 6	1	January 13th, 2005 02:44 PM