OraFAQ Forum: Windows » Data Type: Access MEMO to Oracle LONG

Home » Infrastructure » Windows » Data Type: Access MEMO to Oracle LONG

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Data Type: Access MEMO to Oracle LONG [message #100182]

Tue, 27 August 2002 08:53

Mark
Messages: 284
Registered: July 1998

Senior Member

I have been appending records into Oracle 7.3.4 from Access 97 without a problem. Recently started using Access 2000 and converted my database. I now get the following error:

ODBC--Insert on a linked table
failed
[[Oracle]][[ODBC Oracle Driver]]String Data, Length Mismatch (#0)

The datatypes on each database are still the same (MEMO on Access, LONG on Oracle).

Any ideas anyone?

Many thanks...

Report message to a moderator

Re: Data Type: Access MEMO to Oracle LONG [message #100183 is a reply to message #100182]

Tue, 27 August 2002 12:54

Grant
Messages: 578
Registered: January 2002

Senior Member

I do not think 2000 is support for Oracle 7. I would suggest u look in MetaLink and see their compatibility matrix.

Report message to a moderator

compare between orcale and acess type [message #100381 is a reply to message #100182]

Sun, 24 November 2002 23:34

Hind
Messages: 6
Registered: October 2000

Junior Member

please compare between orcale and acess type

Report message to a moderator

Re: missing information [message #100481 is a reply to message #100182]

Fri, 17 January 2003 00:55

Rosa Arambula
Messages: 1
Registered: January 2003

Junior Member

The following list of employees are missing information in their personnel files.

Please provide the Personnel department with the information requested at your earliest convenience.

Thank you in advance for your cooperation.

Report message to a moderator

Previous Topic:	Re: ODBC error on Windows 95
Next Topic:	My two errors

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 23 03:04:06 CDT 2024