Re: reading longvarchar(484), data always empty in Excel Options

On Oct 24, 7:41 pm, "fitzjarr..._at_cox.net" <fitzjarr..._at_cox.net> wrote:
> On Oct 23, 11:39 pm, Sonnich Jensen <sonnich.jen..._at_jotautomation.com>
> wrote:
>
>
>
>
>
> > I have a problem with reading data from Oracle in Excel. When reading
> > a
> > longvarchar, I get nothing - it does not read any data out.
> > The code (VBA in Excel) below is in use, and when reading a normal
> > varchar2 field it
> > works. The current is a longvarchar(484), and it is always empty,
> > causing EOF to be true - always - trying to to read data before reads
> > nothing...
> > The SQL works well in PHP, DB Explorer and such.... but M$ does not
> > like it,
>
> > Help, please...
>
> > Set oWS = CreateWorkspace("server", "me", "qwerty", dbUseODBC)
> > oWS.DefaultCursorDriver = dbUseODBCCursor
> > oWS.LoginTimeout = 280
>
> > Set Connection = oWS.OpenConnection("server", dbDriverNoPrompt,
> > True, _
> > "ODBC;DSN=datastuff;UID=me;PWD=qwerty")
> > Connection.QueryTimeout = 480
>
> > sSQL = "select something from whatever"
> > Set oRec = oConn.OpenRecordset(sSQL, dbOpenDynaset)
>
> > If oRec.EOF Then '<- always false, even that SQL returns data
> > sResult = ""
>
> What, exactly, is a 'longvarchar(484)'? That isn't a valid datatype
> in Oracle.

Well, that is what DB explorer shows me... anyway, some kind of long varchar, which shows as a "MEMO". I dont have that well access to the DB to tell you much more.
When reading those long strings I get those problems.

WBR
Sonnich Received on Thu Oct 25 2007 - 01:27:27 CDT