By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,291 Members | 1,123 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,291 IT Pros & Developers. It's quick & easy.

Unable to fetch Oracle clob datatype from ODBC in MS-ACCESS 2003

P: 1
Using Oracle Migration Workbench, I migrated ms-access 2003 database to oracle 9i. The memo datatype in ms-access mapped to clob datatype in oracle. I have created a system dsn to access oracle tables through ms-access so that the front-end will remain in ms-access.

While fetching clob datatype fields - I get ODBC error
ODBC--call failed.
[Microsoft][ODBCDriver Manager] Function sequence error(#0)

System Info :
Windows 2003 SP-2
MS-Office 2003
MS-ACCESS 2003 but database is in MS-ACCESS 2000 format
Oracle 9i ver-9.2.0.1

Can somebody give solution ?
Jun 1 '07 #1
Share this Question
Share on Google+
1 Reply

MMcCarthy
Expert Mod 10K+
P: 14,534
Using Oracle Migration Workbench, I migrated ms-access 2003 database to oracle 9i. The memo datatype in ms-access mapped to clob datatype in oracle. I have created a system dsn to access oracle tables through ms-access so that the front-end will remain in ms-access.

While fetching clob datatype fields - I get ODBC error
ODBC--call failed.
[Microsoft][ODBCDriver Manager] Function sequence error(#0)

System Info :
Windows 2003 SP-2
MS-Office 2003
MS-ACCESS 2003 but database is in MS-ACCESS 2000 format
Oracle 9i ver-9.2.0.1

Can somebody give solution ?
Change the clob datatype to a varchar and Access should treat it as a memo field if it has a char size of over 255
Jun 2 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.