🚀 go-pugleaf

.----- On Wed, 21 Jul 1999 09:02:28 +0100, Alain BORGO posted:
|Hello,
|
|I have a field LONG in a oracle database.
|
|When I use Win32::ODBC, I can correctly retrieve this field and print
|it in an ASP page.
|
|BUT, when I use Win32::OLE, I get this error :
|
|Microsoft OLE DB Provider for ODBC Drivers error '80040e21' 
|Des erreurs sont survenues. 
|
|Can someone tell me why ?
|-- 
|A bient�t.
'-------------------------------------

I don't know what 'Des erreurs sont survenues' means in English, but I can
make a small suggestion. If you are using ASP, as this post indicates, then
use the supplied 'server component' for database access rather than the perl
modules, eg:

Set OBJdbConnection = Server.CreateObject("ADODB.Connection")  
OBJdbConnection.Open "DSN Name"

SQLQuery = "SELECT * FROM tablename ORDER BY Name ASC"

Set db = OBJdbConnection.Execute(SQLQuery) 

and so on...

It works fine for me, but then my fields are strings.

Hope this helps,
-Martin
|\/| _..__|_o._   /\_|_| o._  _   mart.atkins@--
|  |(_||  |_|| | /--\|_|<|| |_>            --bigfoot.com