Go Back   Access World Forums > Microsoft Access Discussion > Tables

Thread Tools Rate Thread Display Modes
Old 01-10-2017, 09:24 AM   #1
Newly Registered User
Join Date: Jul 2014
Posts: 158
Thanks: 5
Thanked 11 Times in 10 Posts
RogerCooper is on a distinguished road
Oracle BLOB field links as Short Text

I have a problem when linking to back end Oracle files, that BLOB fields are considered by the ODBC driver to be Short Text fields. This results in such errors as "Microsoft ODBC Drive Manager Function Sequence Error (#0)" when I try to view the table.

Is there a way of specifying the field type or a better ODBC driver? I can't change the backend.

RogerCooper is offline   Reply With Quote

blob , linking table , long text , odbc , oracle

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Joining a 'long integer' field to a 'short text' number peskywinnets General 24 01-22-2016 03:25 PM
Setting text box format to short date and optional short time choaspes Forms 7 06-21-2013 08:29 AM
Printing Pictures from an Oracle BLOB smbarney Reports 0 03-12-2010 07:30 AM
Displaying text that is stored in a blob field in a SQL table haydenal Reports 1 01-27-2010 06:00 PM
Conversion of OLE Object into field BLOB of Oracle Table Pierre Letiexhe Other Software 0 02-04-2008 06:26 AM

All times are GMT -8. The time now is 02:55 PM.

Microsoft Access Help
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post

Sponsored Links

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World