Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

oracle inconsistent datatypes error

Status
Not open for further replies.
buzaseni

buzaseni

Programmer
May 30, 2005
7
0
0
RO
Hello,
I have an oracle table with 2 fields type - clob,
Any select command result is an error - inconsistent datatypes. How can I avoid that error - with some transf. functions?

thanks.
 
Sort by date Sort by votes
Hi,
How are you connecting to Oracle..Not all ODBC clients support CLOBS.

[profile]

To Paraphrase:"The Help you get is proportional to the Help you give.."
 
Upvote 0 Downvote
hi

My connectionstring is
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open "Provider=MSDAORA;Data Source=..;User Id=..;Password=..;"
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Krus1972
  • Locked
  • Question
msxml3.dll error '80072f7d' - An error occurred in the secure Channel support
Replies
7
Views
181
Krus1972
Krus1972
leifoet
  • Locked
  • Question
Using date picker gives an error message, only at application start
Replies
1
Views
77
MarkSweetland
MarkSweetland
chikwendu
  • Locked
  • Question
OraOLEDB error '80040e4b'
Replies
1
Views
187
xwb
xwb
evr72
  • Locked
  • Question
formatting error
Replies
3
Views
53
evr72
evr72
BunBo900
  • Locked
  • Question
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
Replies
1
Views
85
BunBo900
BunBo900

Part and Inventory Search

Sponsor

Back
Top