This discussion is archived
14 Replies Latest reply: Feb 21, 2013 4:54 AM by 992079 RSS

Error connecting foxpro ODBC with Oracle XE

992079 Newbie
Currently Being Moderated
Hello,

I'm trying comunicate Foxpro database with Oracle XE 11 and for details, the configurated listener.ora, tnsnames.ora and initsid.ora is listed on bottom topic.

Well I guess I did a correct configuration, because I got some selects from empty tables. My problem is when I select any filled table...


I'm receiving this error ... so I guess that error is somenthing about character returned from Oracle to Driver FOxPro but I'm not sure....

I saw a lot of threads to check oracle_home/hs/log files, but it doesn't exist ! I tried create it but no one file is created there !

I tried created on server... I tried created in client oracle... and i'm being crazy !

Please, someone can give me a way to see this errors (logs)...




ORA-28500: conexão do ORACLE com um sistema não Oracle retornou esta mensagem:
[Microsoft][ODBC Driver Manager] Tipo de descritor fora do intervalo {HY091}
ORA-02063: precedendo 2 lines a partir de DBMATRIZ



They are :


listener.ora

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oraclexe\app\oracle\product\11.2.0\server)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = C:\oraclexe\app\oracle\product\11.2.0\server)
(PROGRAM = extproc)
)

(SID_DESC =
(PROGRAM = dg4odbc)
(SID_NAME = fpmatriz)
(ORACLE_HOME = C:\oraclexe\app\oracle\product\11.2.0\server)
)

)




LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = WIN-ESRA2A7742K)(PORT = 1521))
)
)



DEFAULT_SERVICE_LISTENER = (XE)



tsnnames.ora

XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = WIN-ESRA2A7742K)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)
fpmatriz =
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=WIN-ESRA2A7742K)(PORT=1521))
(CONNECT_DATA=(SID=fpmatriz))
(HS=OK)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)




initfpmatriz.ora
HS_FDS_CONNECT_INFO = fpmatriz
HS_FDS_TRACE_LEVEL = debug
HS_FDS_QUOTE_IDENTIFIER=FALSE
  • 1. Re: Error connecting foxpro ODBC with Oracle XE
    kgronau Guru
    Currently Being Moderated
    Could you please select from one of these failing tables and post the gateway trace?

    In the gateway init file you already have turned on tracing (HS_FDS_TRACE_LEVEL = debug) so have a look at C:\oraclexe\app\oracle\product\11.2.0\server\hs\trace where the trace files are located and find the mathing trace, then post it.

    Thanks,
    Klaus
  • 2. Re: Error connecting foxpro ODBC with Oracle XE
    992079 Newbie
    Currently Being Moderated
    Thanks for reply,

    It's a problem for me, because I haven't trace past inside C:\oraclexe\app\oracle\product\11.2.0\server\hs.

    I just have admin and lib under hs. So, I tried look for whole oraclexe and subfolders using (*.trc). I just found some trc from C:\ORACLEXE\APP\ORACLE\diag\rdbms\xe\xe\trace\

    are there a limitation for oracle xe do not generate logs for HS ?

    Or.... there are a extra componente for generate log from that comunication ?


    I'm using windows 7 32 bits.


    race file C:\ORACLEXE\APP\ORACLE\diag\rdbms\xe\xe\trace\xe_lgwr_1504.trc
    Oracle Database 11g Express Edition Release 11.2.0.2.0 - Production
    Windows NT Version V6.1
    CPU : 1 - type 586, 1 Physical Cores
    Process Affinity : 0x0x00000000
    Memory (Avail/Total): Ph:142M/511M, Ph+PgF:471M/1535M, VA:1372M/2047M
    VM name : VMWare Version (6)
    Instance name: xe
    Redo thread mounted by this instance: 1
    Oracle process number: 11
    Windows thread id: 1504, image: ORACLE.EXE (LGWR)


    *** 2013-02-20 08:39:57.091
    *** SESSION ID:(11.1) 2013-02-20 08:39:57.091
    *** CLIENT ID:() 2013-02-20 08:39:57.091
    *** SERVICE NAME:(SYS$BACKGROUND) 2013-02-20 08:39:57.091
    *** MODULE NAME:() 2013-02-20 08:39:57.091
    *** ACTION NAME:() 2013-02-20 08:39:57.091

    Warning: log write elapsed time 2668ms, size 0KB

    Edited by: 989076 on 20/02/2013 03:51
  • 3. Re: Error connecting foxpro ODBC with Oracle XE
    kgronau Guru
    Currently Being Moderated
    Well, in the listener you state as Oracle_Home:
    (ORACLE_HOME = C:\oraclexe\app\oracle\product\11.2.0\server)
    So you then should have under that Oracle_home directory a bin directory which contains the gateway executable (dg4odbc.exe). In addition you then should have created your gateway init file initfpmatriz.ora in C:\oraclexe\app\oracle\product\11.2.0\hs\admin.
    You state that you have the hs directory and a lib directory, but no trace. Could you please open a command line window and provide me the output of:
    dir C:\oraclexe\app\oracle\product\11.2.0\server\bin\dg4*.*
    and
    dir C:\oraclexe\app\oracle\product\11.2.0\server\hs


    The gateway trace is always written on Windows platforms to a trace directory within the hs directory - maybe it would make sense that you create it manually and check again.

    Thanks,
    Klaus
  • 4. Re: Error connecting foxpro ODBC with Oracle XE
    HighTen76 Newbie
    Currently Being Moderated
    I have exactly the same issue. I'm using 11g XE and can't get find the hs trace files. My ODBC link worked without any issues in 10g XE but I have been unable to get it to work under 11g XE with the dg4odbc so far.

    The result of the dir commands for me are:

    dir C:\oraclexe\app\oracle\product\11.2.0\server\hs
    Volume in drive C

    Directory of C:\oraclexe\app\oracle\product\11.2.0\server\hs

    02/06/2013 02:46 PM <DIR> .
    02/06/2013 02:46 PM <DIR> ..
    02/13/2013 11:28 AM <DIR> admin
    02/06/2013 02:46 PM <DIR> lib

    C:\oraclexe\app\oracle\product\11.2.0>dir C:\oraclexe\app\oracle\product\11.2.0\server\bin\dg4*.*
    Volume in drive C

    Directory of C:\oraclexe\app\oracle\product\11.2.0\server\bin

    08/27/2011 09:58 AM 835,584 dg4odbc.exe
    1 File(s) 835,584 bytes

    ...sorry, I don't mean to hijack the other person's post, I just thought I would share the fact that I seem to be having the same trace issue. How do we get the trace to work under 11g XE? The trace directory doesn't seem to exist.

    Thank you
    Francois
  • 5. Re: Error connecting foxpro ODBC with Oracle XE
    mkirtley-Oracle Expert
    Currently Being Moderated
    Hi,
    What happens if you manually create a trace directory -

    C:\oraclexe\app\oracle\product\11.2.0\server\hs\trace

    Do you then get a trace file created if you set th etrace parameter -

    HS_FDS_TRACE_LEVEL=debug

    Also, in his update it looks like Klaus made a mistake. He said -

    "In addition you then should have created your gateway init file initfpmatriz.ora in C:\oraclexe\app\oracle\product\11.2.0\hs\admin"

    but the gateway init file should be in the directory -

    C:\oraclexe\app\oracle\product\11.2.0\server\hs\admin

    as the ORACLE_HOME is -

    C:\oraclexe\app\oracle\product\11.2.0\server

    Regards,
    Mike
  • 6. Re: Error connecting foxpro ODBC with Oracle XE
    HighTen76 Newbie
    Currently Being Moderated
    worked for me to get the trace file to create once I manually added the C:\oraclexe\app\oracle\product\11.2.0\server\hs\trace directory as you suggested.
    Francois
  • 7. Re: Error connecting foxpro ODBC with Oracle XE
    mkirtley-Oracle Expert
    Currently Being Moderated
    Francois,
    Thanks for letting us know that creating the directory allowed the traces to be created. It will help with problem diagnosis.

    Regards,
    Mike

    Edited by: mkirtley on Feb 20, 2013 4:41 PM
  • 8. Re: Error connecting foxpro ODBC with Oracle XE
    992079 Newbie
    Currently Being Moderated
    You are the man ! The log file was created.


    Well, I'm posting it when I run a problematic query.




    Oracle Corporation --- QUARTA-FEIRA FEV 20 2013 14:14:58.213


    Heterogeneous Agent Release
    11.2.0.2.0




    Oracle Corporation --- QUARTA-FEIRA FEV 20 2013 14:14:58.197

    Version 11.2.0.2.0

    Entered hgogprd
    HOSGIP for "HS_FDS_TRACE_LEVEL" returned "debug"
    Entered hgosdip
    setting HS_OPEN_CURSORS to default of 50
    setting HS_FDS_RECOVERY_ACCOUNT to default of "RECOVER"
    setting HS_FDS_RECOVERY_PWD to default value
    setting HS_FDS_TRANSACTION_LOG to default of HS_TRANSACTION_LOG
    setting HS_IDLE_TIMEOUT to default of 0
    setting HS_FDS_TRANSACTION_ISOLATION to default of "READ_COMMITTED"
    setting HS_NLS_NCHAR to default of "UCS2"
    setting HS_FDS_TIMESTAMP_MAPPING to default of "DATE"
    setting HS_FDS_DATE_MAPPING to default of "DATE"
    setting HS_RPC_FETCH_REBLOCKING to default of "ON"
    setting HS_FDS_FETCH_ROWS to default of "100"
    setting HS_FDS_RESULTSET_SUPPORT to default of "FALSE"
    setting HS_FDS_RSET_RETURN_ROWCOUNT to default of "FALSE"
    setting HS_FDS_PROC_IS_FUNC to default of "FALSE"
    setting HS_FDS_MAP_NCHAR to default of "TRUE"
    setting HS_NLS_DATE_FORMAT to default of "YYYY-MM-DD HH24:MI:SS"
    setting HS_FDS_REPORT_REAL_AS_DOUBLE to default of "FALSE"
    setting HS_LONG_PIECE_TRANSFER_SIZE to default of "65536"
    setting HS_SQL_HANDLE_STMT_REUSE to default of "FALSE"
    setting HS_FDS_QUERY_DRIVER to default of "TRUE"
    setting HS_FDS_SUPPORT_STATISTICS to default of "FALSE"
    HOSGIP returned value of "FALSE" for HS_FDS_QUOTE_IDENTIFIER
    setting HS_KEEP_REMOTE_COLUMN_SIZE to default of "OFF"
    setting HS_FDS_GRAPHIC_TO_MBCS to default of "FALSE"
    setting HS_FDS_MBCS_TO_GRAPHIC to default of "FALSE"
    Default value of 32 assumed for HS_FDS_SQLLEN_INTERPRETATION
    setting HS_CALL_NAME_ISP to "gtw$:SQLTables;gtw$:SQLColumns;gtw$:SQLPrimaryKeys;gtw$:SQLForeignKeys;gtw$:SQLProcedures;gtw$:SQLStatistics;gtw$:SQLGetInfo"
    setting HS_FDS_DELAYED_OPEN to default of "TRUE"
    setting HS_FDS_WORKAROUNDS to default of "0"
    Exiting hgosdip, rc=0
    ORACLE_SID is "fpmatriz"
    Product-Info:
    Port Rls/Upd:2/0 PrdStat:0
    Agent:Oracle Database Gateway for ODBC
    Facility:hsa
    Class:ODBC, ClassVsn:11.2.0.2.0_0008, Instance:fpmatriz
    Exiting hgogprd, rc=0
    Entered hgoinit
    HOCXU_COMP_CSET=1
    HOCXU_DRV_CSET=178
    HOCXU_DRV_NCHAR=1000
    HOCXU_DB_CSET=873
    HS_LANGUAGE not specified
    rc=1000 attempting to get LANG environment variable.
    HOCXU_SEM_VER=112000
    Entered hgolofn at 2013/02/20-14:15:06
    Exiting hgolofn, rc=0 at 2013/02/20-14:15:06
    HOSGIP for "HS_OPEN_CURSORS" returned "50"
    HOSGIP for "HS_FDS_FETCH_ROWS" returned "100"
    HOSGIP for "HS_LONG_PIECE_TRANSFER_SIZE" returned "65536"
    HOSGIP for "HS_NLS_NUMERIC_CHARACTER" returned ".,"
    HOSGIP for "HS_KEEP_REMOTE_COLUMN_SIZE" returned "OFF"
    HOSGIP for "HS_FDS_DELAYED_OPEN" returned "TRUE"
    HOSGIP for "HS_FDS_WORKAROUNDS" returned "0"
    HOSGIP for "HS_FDS_MBCS_TO_GRAPHIC" returned "FALSE"
    HOSGIP for "HS_FDS_GRAPHIC_TO_MBCS" returned "FALSE"
    Invalid value of 32 given for HS_FDS_SQLLEN_INTERPRETATION
    treat_SQLLEN_as_compiled = 1
    Exiting hgoinit, rc=0 at 2013/02/20-14:15:07
    Entered hgolgon at 2013/02/20-14:15:07
    reco:0, name:GERXML, tflag:0
    Entered hgosuec at 2013/02/20-14:15:07
    Exiting hgosuec, rc=0 at 2013/02/20-14:15:07
    HOSGIP for "HS_FDS_RECOVERY_ACCOUNT" returned "RECOVER"
    HOSGIP for "HS_FDS_TRANSACTION_LOG" returned "HS_TRANSACTION_LOG"
    HOSGIP for "HS_FDS_TIMESTAMP_MAPPING" returned "DATE"
    HOSGIP for "HS_FDS_DATE_MAPPING" returned "DATE"
    HOSGIP for "HS_FDS_MAP_NCHAR" returned "TRUE"
    HOSGIP for "HS_FDS_RESULTSET_SUPPORT" returned "FALSE"
    HOSGIP for "HS_FDS_RSET_RETURN_ROWCOUNT" returned "FALSE"
    HOSGIP for "HS_FDS_PROC_IS_FUNC" returned "FALSE"
    HOSGIP for "HS_FDS_REPORT_REAL_AS_DOUBLE" returned "FALSE"
    using GERXML as default value for "HS_FDS_DEFAULT_OWNER"
    HOSGIP for "HS_SQL_HANDLE_STMT_REUSE" returned "FALSE"
    Entered hgocont at 2013/02/20-14:15:08
    HS_FDS_CONNECT_INFO = "fpmatriz"
    RC=-1 from HOSGIP for "HS_FDS_CONNECT_STRING"
    Entered hgogenconstr at 2013/02/20-14:15:08
    dsn:fpmatriz, name:GERXML
    optn:
    Entered hgocip at 2013/02/20-14:15:09
    dsn:fpmatriz
    Exiting hgocip, rc=0 at 2013/02/20-14:15:09
    Exiting hgogenconstr, rc=0 at 2013/02/20-14:15:09
    Entered hgopoer at 2013/02/20-14:15:14
    hgopoer, line 231: got native error 0 and sqlstate 01000; message follows...
    [Microsoft][ODBC Driver Manager] O driver não oferece suporte à versão de comportamento de ODBC solicitada pelo aplicativo (consulte SQLSetEnvAttr). {01000}
    Exiting hgopoer, rc=0 at 2013/02/20-14:15:14
    hgocont, line 2687: calling SqlDriverConnect got sqlstate 01000
    Entered hgolosf at 2013/02/20-14:15:15
    Exiting hgolosf, rc=0 at 2013/02/20-14:15:15
    DriverName:VFPODBC.DLL, DriverVer:06.86.0001
    DBMS Name:Visual FoxPro, DBMS Version:03.00.0000
    Exiting hgocont, rc=0 at 2013/02/20-14:15:15 with error ptr FILE:hgocont.c LINE:2687 ID:SQLDriverConnect
    Entered hgopoer at 2013/02/20-14:15:15
    hgopoer, line 231: got native error 0 and sqlstate HYC00; message follows...
    [Microsoft][ODBC Visual FoxPro Driver]Driver not capable {HYC00}
    Exiting hgopoer, rc=0 at 2013/02/20-14:15:15
    hgolgon, line 804: calling SQLGetInfo got sqlstate HYC00
    SQLGetInfo returns N for SQL_CATALOG_NAME
    Exiting hgolgon, rc=0 at 2013/02/20-14:15:16 with error ptr FILE:hgolgon.c LINE:804 ID:GetInfo: Support catalogs
    Entered hgoulcp at 2013/02/20-14:15:17
    Entered hgowlst at 2013/02/20-14:15:17
    Exiting hgowlst, rc=0 at 2013/02/20-14:15:17
    SQLGetInfo returns 0x0 for SQL_OWNER_USAGE
    TXN Capable:1, Isolation Option:0x2
    SQLGetInfo returns 0 for SQL_MAX_SCHEMA_NAME_LEN
    SQLGetInfo returns 128 for SQL_MAX_TABLE_NAME_LEN
    SQLGetInfo returns 0 for SQL_MAX_PROCEDURE_NAME_LEN
    HOSGIP returned value of "FALSE" for HS_FDS_QUOTE_IDENTIFIER
    SQLGetInfo returns Y for SQL_COLUMN_ALIAS
    4 instance capabilities will be uploaded
    capno:1964, context:0x00000000, add-info: 0
    capno:1989, context:0x00000000, add-info: 0
    capno:1991, context:0x00000000, add-info: 0
    capno:1992, context:0x00000000, add-info: 0
    Exiting hgoulcp, rc=0 at 2013/02/20-14:15:18
    Entered hgouldt at 2013/02/20-14:15:19
    NO instance DD translations were uploaded
    Exiting hgouldt, rc=0 at 2013/02/20-14:15:19
    Entered hgobegn at 2013/02/20-14:15:21
    tflag:0 , initial:1
    hoi:0x12f05c, ttid (len 19) is ...
    00: 58452E36 39303939 6466392E 342E372E [XE.69099df9.4.7.]
    10: 363231 [621]
    tbid (len 25) is ...
    00: 58455B34 2E372E36 32315D5B 312E3432 [XE[4.7.621][1.42]
    10: 39343936 37323935 5D [94967295]]
    Exiting hgobegn, rc=0 at 2013/02/20-14:15:22
    Entered hgodtab at 2013/02/20-14:15:22
    count:1
    table: NFENTRAD
    Allocate hoada[0] @ 034C189C
    Entered hgopoer at 2013/02/20-14:15:23
    hgopoer, line 231: got native error 0 and sqlstate 07009; message follows...
    [Microsoft][ODBC Visual FoxPro Driver]Invalid column number {07009}
    Exiting hgopoer, rc=0 at 2013/02/20-14:15:23
    hgodtab, line 588: calling SQLFetch got sqlstate 07009
    Entered hgodafr, cursor id 0 at 2013/02/20-14:15:23
    Free hoada @ 034C189C
    Exiting hgodafr, rc=0 at 2013/02/20-14:15:23
    The hoada for table NFENTRAD follows...
    hgodtab, line 1092: NO hoada to print
    Exiting hgodtab, rc=28500 at 2013/02/20-14:15:24 with error ptr FILE:hgodtab.c LINE:588 ID:Fetching result set for tble descr
    Entered hgopars, cursor id 1 at 2013/02/20-14:15:24
    type:0
    SQL text from hgopars, id=1, len=22 ...
    00: 53454C45 4354202A 2046524F 4D204E46 [SELECT * FROM NF]
    10: 454E5452 4144 [ENTRAD]
    Exiting hgopars, rc=0 at 2013/02/20-14:15:24
    Entered hgoopen, cursor id 1 at 2013/02/20-14:15:24
    hgoopen, line 87: NO hoada to print
    Deferred open until first fetch.
    Exiting hgoopen, rc=0 at 2013/02/20-14:15:24
    Entered hgodscr, cursor id 1 at 2013/02/20-14:15:24
    Allocate hoada @ 034C1850
    Entered hgodscr_process_sellist_description at 2013/02/20-14:15:24
    Entered hgopoer at 2013/02/20-14:15:24
    hgopoer, line 231: got native error 0 and sqlstate HY091; message follows...
    [Microsoft][ODBC Visual FoxPro Driver]Descriptor type out of range {HY091}
    Exiting hgopoer, rc=0 at 2013/02/20-14:15:24
    hgodscr_process_sellist_description, line 741: calling SQLColAttribute got sqlstate HY091
    Entered hgopcda at 2013/02/20-14:15:24
    Column:1(chave): dtype:1 (CHAR), prc/scl:38/0, nullbl:0, octet:38, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2013/02/20-14:15:25
    Entered hgopoer at 2013/02/20-14:15:25
    hgopoer, line 231: got native error 0 and sqlstate HY091; message follows...
    [Microsoft][ODBC Visual FoxPro Driver]Descriptor type out of range {HY091}
    Exiting hgopoer, rc=0 at 2013/02/20-14:15:25
    hgodscr_process_sellist_description, line 741: calling SQLColAttribute got sqlstate HY091
    Entered hgopcda at 2013/02/20-14:15:25
    Column:2(especie): dtype:1 (CHAR), prc/scl:5/0, nullbl:0, octet:5, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2013/02/20-14:15:25
    Entered hgopoer at 2013/02/20-14:15:25
    hgopoer, line 231: got native error 0 and sqlstate HY091; message follows...
    [Microsoft][ODBC Visual FoxPro Driver]Descriptor type out of range {HY091}
    Exiting hgopoer, rc=0 at 2013/02/20-14:15:25
    hgodscr_process_sellist_description, line 741: calling SQLColAttribute got sqlstate HY091
    Entered hgopcda at 2013/02/20-14:15:25
    Column:3(serie): dtype:1 (CHAR), prc/scl:3/0, nullbl:0, octet:3, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2013/02/20-14:15:26
    Entered hgopoer at 2013/02/20-14:15:26
    hgopoer, line 231: got native error 0 and sqlstate HY091; message follows...
    [Microsoft][ODBC Visual FoxPro Driver]Descriptor type out of range {HY091}
    Exiting hgopoer, rc=0 at 2013/02/20-14:15:26
    hgodscr_process_sellist_description, line 741: calling SQLColAttribute got sqlstate HY091
    Entered hgopcda at 2013/02/20-14:15:26
    Column:4(subserie): dtype:1 (CHAR), prc/scl:2/0, nullbl:0, octet:2, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2013/02/20-14:15:26
    Entered hgopoer at 2013/02/20-14:15:26
    hgopoer, line 231: got native error 0 and sqlstate HY091; message follows...
    [Microsoft][ODBC Visual FoxPro Driver]Descriptor type out of range {HY091}
    Exiting hgopoer, rc=0 at 2013/02/20-14:15:27
    hgodscr_process_sellist_description, line 741: calling SQLColAttribute got sqlstate HY091
    Entered hgopcda at 2013/02/20-14:15:27
    Column:5(numinici): dtype:1 (CHAR), prc/scl:10/0, nullbl:0, octet:10, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2013/02/20-14:15:27
    Entered hgopoer at 2013/02/20-14:15:27
    hgopoer, line 231: got native error 0 and sqlstate HY091; message follows...
    [Microsoft][ODBC Visual FoxPro Driver]Descriptor type out of range {HY091}
    Exiting hgopoer, rc=0 at 2013/02/20-14:15:28
    hgodscr_process_sellist_description, line 741: calling SQLColAttribute got sqlstate HY091
    Entered hgopcda at 2013/02/20-14:15:28
    Column:6(cnpj): dtype:1 (CHAR), prc/scl:18/0, nullbl:0, octet:18, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2013/02/20-14:15:28
    Entered hgopoer at 2013/02/20-14:15:28
    hgopoer, line 231: got native error 0 and sqlstate HY091; message follows...
    [Microsoft][ODBC Visual FoxPro Driver]Descriptor type out of range {HY091}
    Exiting hgopoer, rc=0 at 2013/02/20-14:15:29
    hgodscr_process_sellist_description, line 741: calling SQLColAttribute got sqlstate HY091
    Entered hgopcda at 2013/02/20-14:15:29
    Column:7(digito): dtype:1 (CHAR), prc/scl:2/0, nullbl:0, octet:2, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2013/02/20-14:15:30
    Entered hgopcda at 2013/02/20-14:15:30
    Column:8(dtemiss): dtype:91 (DATE), prc/scl:10/0, nullbl:0, octet:2, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2013/02/20-14:15:30
    Entered hgopcda at 2013/02/20-14:15:30
    Column:9(dtdocum): dtype:91 (DATE), prc/scl:10/0, nullbl:0, octet:2, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2013/02/20-14:15:31
    Entered hgopoer at 2013/02/20-14:15:31
    hgopoer, line 231: got native error 0 and sqlstate HY091; message follows...
    [Microsoft][ODBC Visual FoxPro Driver]Descriptor type out of range {HY091}
    Exiting hgopoer, rc=0 at 2013/02/20-14:15:31
    hgodscr_process_sellist_description, line 741: calling SQLColAttribute got sqlstate HY091
    Entered hgopcda at 2013/02/20-14:15:32
    Column:10(uf): dtype:1 (CHAR), prc/scl:2/0, nullbl:0, octet:2, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2013/02/20-14:15:32
    Entered hgopcda at 2013/02/20-14:15:32
    Column:11(nfcancel): dtype:-7 (BIT), prc/scl:1/0, nullbl:0, octet:2, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2013/02/20-14:15:32
    Entered hgopcda at 2013/02/20-14:15:32
    Column:12(vlrcont): dtype:2 (NUMERIC), prc/scl:18/2, nullbl:0, octet:2, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2013/02/20-14:15:32
    Entered hgopoer at 2013/02/20-14:15:32
    hgopoer, line 231: got native error 0 and sqlstate HY091; message follows...
    [Microsoft][ODBC Visual FoxPro Driver]Descriptor type out of range {HY091}
    Exiting hgopoer, rc=0 at 2013/02/20-14:15:32
    hgodscr_process_sellist_description, line 741: calling SQLColAttribute got sqlstate HY091
    Entered hgopcda at 2013/02/20-14:15:32
    Column:13(dipamcid): dtype:1 (CHAR), prc/scl:4/0, nullbl:0, octet:4, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2013/02/20-14:15:33
    Entered hgopcda at 2013/02/20-14:15:33
    Column:14(dipamvlr): dtype:2 (NUMERIC), prc/scl:18/2, nullbl:0, octet:4, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2013/02/20-14:15:33
    Entered hgopcda at 2013/02/20-14:15:33
    Column:15(livrocx): dtype:-7 (BIT), prc/scl:1/0, nullbl:0, octet:4, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2013/02/20-14:15:33
    Entered hgopcda at 2013/02/20-14:15:33
    Column:16(frete): dtype:2 (NUMERIC), prc/scl:1/0, nullbl:0, octet:4, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2013/02/20-14:15:34
    Entered hgopoer at 2013/02/20-14:15:34
    hgopoer, line 231: got native error 0 and sqlstate HY091; message follows...
    [Microsoft][ODBC Visual FoxPro Driver]Descriptor type out of range {HY091}
    Exiting hgopoer, rc=0 at 2013/02/20-14:15:34
    hgodscr_process_sellist_description, line 741: calling SQLColAttribute got sqlstate HY091
    Entered hgopcda at 2013/02/20-14:15:34
    Column:17(numlanc): dtype:1 (CHAR), prc/scl:2/0, nullbl:0, octet:2, sign:1, radix:0
  • 9. Re: Error connecting foxpro ODBC with Oracle XE
    992079 Newbie
    Currently Being Moderated
    Continuing.

    Exiting hgopcda, rc=0 at 2013/02/20-14:15:34
    Entered hgopoer at 2013/02/20-14:15:34
    hgopoer, line 231: got native error 0 and sqlstate HY091; message follows...
    [Microsoft][ODBC Visual FoxPro Driver]Descriptor type out of range {HY091}
    Exiting hgopoer, rc=0 at 2013/02/20-14:15:36
    hgodscr_process_sellist_description, line 741: calling SQLColAttribute got sqlstate HY091
    Entered hgopcda at 2013/02/20-14:15:37
    Column:18(coddipam): dtype:1 (CHAR), prc/scl:3/0, nullbl:0, octet:3, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2013/02/20-14:15:38
    Entered hgopoer at 2013/02/20-14:15:38
    hgopoer, line 231: got native error 0 and sqlstate HY091; message follows...
    [Microsoft][ODBC Visual FoxPro Driver]Descriptor type out of range {HY091}
    Exiting hgopoer, rc=0 at 2013/02/20-14:15:38
    hgodscr_process_sellist_description, line 741: calling SQLColAttribute got sqlstate HY091
    Entered hgopcda at 2013/02/20-14:15:39
    Column:19(vnuminic): dtype:1 (CHAR), prc/scl:10/0, nullbl:0, octet:10, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2013/02/20-14:15:39
    Entered hgopoer at 2013/02/20-14:15:40
    hgopoer, line 231: got native error 0 and sqlstate HY091; message follows...
    [Microsoft][ODBC Visual FoxPro Driver]Descriptor type out of range {HY091}
    Exiting hgopoer, rc=0 at 2013/02/20-14:15:40
    hgodscr_process_sellist_description, line 741: calling SQLColAttribute got sqlstate HY091
    Entered hgopcda at 2013/02/20-14:15:40
    Column:20(vserie): dtype:1 (CHAR), prc/scl:3/0, nullbl:0, octet:3, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2013/02/20-14:15:41
    Entered hgopcda at 2013/02/20-14:15:41
    Column:21(vdtemiss): dtype:91 (DATE), prc/scl:10/0, nullbl:0, octet:3, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2013/02/20-14:15:42
    Entered hgopoer at 2013/02/20-14:15:42
    hgopoer, line 231: got native error 0 and sqlstate HY091; message follows...
    [Microsoft][ODBC Visual FoxPro Driver]Descriptor type out of range {HY091}
    Exiting hgopoer, rc=0 at 2013/02/20-14:15:43
    hgodscr_process_sellist_description, line 741: calling SQLColAttribute got sqlstate HY091
    Entered hgopcda at 2013/02/20-14:15:43
    Column:22(protocol): dtype:1 (CHAR), prc/scl:10/0, nullbl:0, octet:10, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2013/02/20-14:15:43
    Entered hgopcda at 2013/02/20-14:15:43
    Column:23(vlcancel): dtype:2 (NUMERIC), prc/scl:18/2, nullbl:0, octet:10, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2013/02/20-14:15:43
    Entered hgopcda at 2013/02/20-14:15:44
    Column:24(emitente): dtype:2 (NUMERIC), prc/scl:1/0, nullbl:0, octet:10, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2013/02/20-14:15:44
    Entered hgopoer at 2013/02/20-14:15:44
    hgopoer, line 231: got native error 0 and sqlstate HY091; message follows...
    [Microsoft][ODBC Visual FoxPro Driver]Descriptor type out of range {HY091}
    Exiting hgopoer, rc=0 at 2013/02/20-14:15:44
    hgodscr_process_sellist_description, line 741: calling SQLColAttribute got sqlstate HY091
    Entered hgopcda at 2013/02/20-14:15:44
    Column:25(modelo): dtype:1 (CHAR), prc/scl:2/0, nullbl:0, octet:2, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2013/02/20-14:15:44
    Entered hgopcda at 2013/02/20-14:15:44
    Column:26(nfcompl): dtype:-7 (BIT), prc/scl:1/0, nullbl:0, octet:2, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2013/02/20-14:15:45
    Entered hgopcda at 2013/02/20-14:15:45
    Column:27(extempor): dtype:-7 (BIT), prc/scl:1/0, nullbl:0, octet:2, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2013/02/20-14:15:45
    Entered hgopcda at 2013/02/20-14:15:45
    Column:28(codlanc): dtype:2 (NUMERIC), prc/scl:18/0, nullbl:0, octet:2, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2013/02/20-14:15:45
    Entered hgopoer at 2013/02/20-14:15:45
    hgopoer, line 231: got native error 0 and sqlstate HY091; message follows...
    [Microsoft][ODBC Visual FoxPro Driver]Descriptor type out of range {HY091}
    Exiting hgopoer, rc=0 at 2013/02/20-14:15:45
    hgodscr_process_sellist_description, line 741: calling SQLColAttribute got sqlstate HY091
    Entered hgopcda at 2013/02/20-14:15:46
    Column:29(atribut): dtype:1 (CHAR), prc/scl:1/0, nullbl:0, octet:1, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2013/02/20-14:15:46
    Entered hgopcda at 2013/02/20-14:15:46
    Column:30(vlrdeduc): dtype:2 (NUMERIC), prc/scl:18/2, nullbl:0, octet:1, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2013/02/20-14:15:47
    Entered hgopoer at 2013/02/20-14:15:47
    hgopoer, line 231: got native error 0 and sqlstate HY091; message follows...
    [Microsoft][ODBC Visual FoxPro Driver]Descriptor type out of range {HY091}
    Exiting hgopoer, rc=0 at 2013/02/20-14:15:47
    hgodscr_process_sellist_description, line 741: calling SQLColAttribute got sqlstate HY091
    Entered hgopcda at 2013/02/20-14:15:47
    Column:31(servtrans): dtype:1 (CHAR), prc/scl:1/0, nullbl:0, octet:1, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2013/02/20-14:15:47
    Entered hgopcda at 2013/02/20-14:15:47
    Column:32(relcrprout): dtype:-7 (BIT), prc/scl:1/0, nullbl:0, octet:1, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2013/02/20-14:15:47
    Entered hgopcda at 2013/02/20-14:15:47
    Column:33(irrf): dtype:2 (NUMERIC), prc/scl:18/2, nullbl:0, octet:1, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2013/02/20-14:15:47
    Entered hgopcda at 2013/02/20-14:15:48
    Column:34(irrfcheck): dtype:-7 (BIT), prc/scl:1/0, nullbl:0, octet:1, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2013/02/20-14:15:48
    Entered hgopoer at 2013/02/20-14:15:48
    hgopoer, line 231: got native error 0 and sqlstate HY091; message follows...
    [Microsoft][ODBC Visual FoxPro Driver]Descriptor type out of range {HY091}
    Exiting hgopoer, rc=0 at 2013/02/20-14:15:48
    hgodscr_process_sellist_description, line 741: calling SQLColAttribute got sqlstate HY091
    Entered hgopcda at 2013/02/20-14:15:48
    Column:35(cod_usua): dtype:1 (CHAR), prc/scl:4/0, nullbl:0, octet:4, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2013/02/20-14:15:48
    Entered hgopcda at 2013/02/20-14:15:49
    Column:36(codrec): dtype:2 (NUMERIC), prc/scl:4/0, nullbl:0, octet:4, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2013/02/20-14:15:49
    Entered hgopcda at 2013/02/20-14:15:49
    Column:37(codreccs): dtype:2 (NUMERIC), prc/scl:4/0, nullbl:0, octet:4, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2013/02/20-14:15:49
    Entered hgopoer at 2013/02/20-14:15:49
    hgopoer, line 231: got native error 0 and sqlstate HY091; message follows...
    [Microsoft][ODBC Visual FoxPro Driver]Descriptor type out of range {HY091}
    Exiting hgopoer, rc=0 at 2013/02/20-14:15:49
    hgodscr_process_sellist_description, line 741: calling SQLColAttribute got sqlstate HY091
    Entered hgopcda at 2013/02/20-14:15:49
    Column:38(horaemiss): dtype:1 (CHAR), prc/scl:8/0, nullbl:0, octet:8, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2013/02/20-14:15:50
    Entered hgopoer at 2013/02/20-14:15:50
    hgopoer, line 231: got native error 0 and sqlstate HY091; message follows...
    [Microsoft][ODBC Visual FoxPro Driver]Descriptor type out of range {HY091}
    Exiting hgopoer, rc=0 at 2013/02/20-14:15:50
    hgodscr_process_sellist_description, line 741: calling SQLColAttribute got sqlstate HY091
    Entered hgopcda at 2013/02/20-14:15:50
    Column:39(horadocum): dtype:1 (CHAR), prc/scl:8/0, nullbl:0, octet:8, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2013/02/20-14:15:50
    Entered hgopoer at 2013/02/20-14:15:50
    hgopoer, line 231: got native error 0 and sqlstate HY091; message follows...
    [Microsoft][ODBC Visual FoxPro Driver]Descriptor type out of range {HY091}
    Exiting hgopoer, rc=0 at 2013/02/20-14:15:51
    hgodscr_process_sellist_description, line 741: calling SQLColAttribute got sqlstate HY091
    Entered hgopcda at 2013/02/20-14:15:51
    Column:40(cancelredf): dtype:1 (CHAR), prc/scl:254/0, nullbl:0, octet:254, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2013/02/20-14:15:51
    Entered hgopoer at 2013/02/20-14:15:51
    hgopoer, line 231: got native error 0 and sqlstate HY091; message follows...
    [Microsoft][ODBC Driver Manager] Tipo de descritor fora do intervalo {HY091}
    Exiting hgopoer, rc=0 at 2013/02/20-14:15:51
    hgodscr_process_sellist_description, line 831: calling SQLColAttribute got sqlstate HY091
    Free hoada @ 034C1850
    hgodscr, line 457: NO hoada to print
    Exiting hgodscr, rc=28500 at 2013/02/20-14:15:52
    Entered hgodtab at 2013/02/20-14:16:01
    count:1
    table: NFENTRAD
    Allocate hoada[0] @ 034C189C
    Entered hgopoer at 2013/02/20-14:16:01
    hgopoer, line 231: got native error 0 and sqlstate 07009; message follows...
    [Microsoft][ODBC Visual FoxPro Driver]Invalid column number {07009}
    Exiting hgopoer, rc=0 at 2013/02/20-14:16:01
    hgodtab, line 588: calling SQLFetch got sqlstate 07009
    Entered hgodafr, cursor id 0 at 2013/02/20-14:16:01
    Free hoada @ 034C189C
    Exiting hgodafr, rc=0 at 2013/02/20-14:16:02
    The hoada for table NFENTRAD follows...
    hgodtab, line 1092: NO hoada to print
    Exiting hgodtab, rc=28500 at 2013/02/20-14:16:02 with error ptr FILE:hgodtab.c LINE:588 ID:Fetching result set for tble descr
    Entered hgoclse, cursor id 1 at 2013/02/20-14:16:02
    Exiting hgoclse, rc=0 at 2013/02/20-14:16:02
    Entered hgopars, cursor id 1 at 2013/02/20-14:16:02
    type:0
    SQL text from hgopars, id=1, len=22 ...
    00: 53454C45 4354202A 2046524F 4D204E46 [SELECT * FROM NF]
    10: 454E5452 4144 [ENTRAD]
    Exiting hgopars, rc=0 at 2013/02/20-14:16:02
    Entered hgoopen, cursor id 1 at 2013/02/20-14:16:02
    hgoopen, line 87: NO hoada to print
    Deferred open until first fetch.
    Exiting hgoopen, rc=0 at 2013/02/20-14:16:02
    Entered hgodscr, cursor id 1 at 2013/02/20-14:16:02
    Allocate hoada @ 034C1850
    Entered hgodscr_process_sellist_description at 2013/02/20-14:16:02
    Entered hgopoer at 2013/02/20-14:16:02
    hgopoer, line 231: got native error 0 and sqlstate HY091; message follows...
    [Microsoft][ODBC Visual FoxPro Driver]Descriptor type out of range {HY091}
    Exiting hgopoer, rc=0 at 2013/02/20-14:16:03
    hgodscr_process_sellist_description, line 741: calling SQLColAttribute got sqlstate HY091
    Entered hgopcda at 2013/02/20-14:16:03
    Column:1(chave): dtype:1 (CHAR), prc/scl:38/0, nullbl:0, octet:38, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2013/02/20-14:16:03
    Entered hgopoer at 2013/02/20-14:16:03
    hgopoer, line 231: got native error 0 and sqlstate HY091; message follows...
    [Microsoft][ODBC Visual FoxPro Driver]Descriptor type out of range {HY091}
    Exiting hgopoer, rc=0 at 2013/02/20-14:16:04
    hgodscr_process_sellist_description, line 741: calling SQLColAttribute got sqlstate HY091
    Entered hgopcda at 2013/02/20-14:16:04
    Column:2(especie): dtype:1 (CHAR), prc/scl:5/0, nullbl:0, octet:5, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2013/02/20-14:16:04
    Entered hgopoer at 2013/02/20-14:16:04
    hgopoer, line 231: got native error 0 and sqlstate HY091; message follows...
    [Microsoft][ODBC Visual FoxPro Driver]Descriptor type out of range {HY091}
    Exiting hgopoer, rc=0 at 2013/02/20-14:16:04
    hgodscr_process_sellist_description, line 741: calling SQLColAttribute got sqlstate HY091
    Entered hgopcda at 2013/02/20-14:16:05
    Column:3(serie): dtype:1 (CHAR), prc/scl:3/0, nullbl:0, octet:3, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2013/02/20-14:16:05
    Entered hgopoer at 2013/02/20-14:16:05
    hgopoer, line 231: got native error 0 and sqlstate HY091; message follows...
    [Microsoft][ODBC Visual FoxPro Driver]Descriptor type out of range {HY091}
    Exiting hgopoer, rc=0 at 2013/02/20-14:16:05
    hgodscr_process_sellist_description, line 741: calling SQLColAttribute got sqlstate HY091
    Entered hgopcda at 2013/02/20-14:16:05
    Column:4(subserie): dtype:1 (CHAR), prc/scl:2/0, nullbl:0, octet:2, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2013/02/20-14:16:06
    Entered hgopoer at 2013/02/20-14:16:06
    hgopoer, line 231: got native error 0 and sqlstate HY091; message follows...
    [Microsoft][ODBC Visual FoxPro Driver]Descriptor type out of range {HY091}
    Exiting hgopoer, rc=0 at 2013/02/20-14:16:06
    hgodscr_process_sellist_description, line 741: calling SQLColAttribute got sqlstate HY091
    Entered hgopcda at 2013/02/20-14:16:06
    Column:5(numinici): dtype:1 (CHAR), prc/scl:10/0, nullbl:0, octet:10, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2013/02/20-14:16:06
    Entered hgopoer at 2013/02/20-14:16:06
    hgopoer, line 231: got native error 0 and sqlstate HY091; message follows...
    [Microsoft][ODBC Visual FoxPro Driver]Descriptor type out of range {HY091}
    Exiting hgopoer, rc=0 at 2013/02/20-14:16:07
    hgodscr_process_sellist_description, line 741: calling SQLColAttribute got sqlstate HY091
    Entered hgopcda at 2013/02/20-14:16:07
    Column:6(cnpj): dtype:1 (CHAR), prc/scl:18/0, nullbl:0, octet:18, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2013/02/20-14:16:07
    Entered hgopoer at 2013/02/20-14:16:07
    hgopoer, line 231: got native error 0 and sqlstate HY091; message follows...
    [Microsoft][ODBC Visual FoxPro Driver]Descriptor type out of range {HY091}
    Exiting hgopoer, rc=0 at 2013/02/20-14:16:07
    hgodscr_process_sellist_description, line 741: calling SQLColAttribute got sqlstate HY091
    Entered hgopcda at 2013/02/20-14:16:07
    Column:7(digito): dtype:1 (CHAR), prc/scl:2/0, nullbl:0, octet:2, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2013/02/20-14:16:07
    Entered hgopcda at 2013/02/20-14:16:07
    Column:8(dtemiss): dtype:91 (DATE), prc/scl:10/0, nullbl:0, octet:2, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2013/02/20-14:16:07
    Entered hgopcda at 2013/02/20-14:16:07
    Column:9(dtdocum): dtype:91 (DATE), prc/scl:10/0, nullbl:0, octet:2, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2013/02/20-14:16:07
    Entered hgopoer at 2013/02/20-14:16:07
    hgopoer, line 231: got native error 0 and sqlstate HY091; message follows...
    [Microsoft][ODBC Visual FoxPro Driver]Descriptor type out of range {HY091}
    Exiting hgopoer, rc=0 at 2013/02/20-14:16:07
    hgodscr_process_sellist_description, line 741: calling SQLColAttribute got sqlstate HY091
    Entered hgopcda at 2013/02/20-14:16:07
    Column:10(uf): dtype:1 (CHAR), prc/scl:2/0, nullbl:0, octet:2, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2013/02/20-14:16:08
    Entered hgopcda at 2013/02/20-14:16:08
    Column:11(nfcancel): dtype:-7 (BIT), prc/scl:1/0, nullbl:0, octet:2, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2013/02/20-14:16:08
    Entered hgopcda at 2013/02/20-14:16:08
    Column:12(vlrcont): dtype:2 (NUMERIC), prc/scl:18/2, nullbl:0, octet:2, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2013/02/20-14:16:08
    Entered hgopoer at 2013/02/20-14:16:08
    hgopoer, line 231: got native error 0 and sqlstate HY091; message follows...
    [Microsoft][ODBC Visual FoxPro Driver]Descriptor type out of range {HY091}
    Exiting hgopoer, rc=0 at 2013/02/20-14:16:09
    hgodscr_process_sellist_description, line 741: calling SQLColAttribute got sqlstate HY091
    Entered hgopcda at 2013/02/20-14:16:09
    Column:13(dipamcid): dtype:1 (CHAR), prc/scl:4/0, nullbl:0, octet:4, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2013/02/20-14:16:09
    Entered hgopcda at 2013/02/20-14:16:09
    Column:14(dipamvlr): dtype:2 (NUMERIC), prc/scl:18/2, nullbl:0, octet:4, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2013/02/20-14:16:09
    Entered hgopcda at 2013/02/20-14:16:09
    Column:15(livrocx): dtype:-7 (BIT), prc/scl:1/0, nullbl:0, octet:4, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2013/02/20-14:16:09
    Entered hgopcda at 2013/02/20-14:16:09
    Column:16(frete): dtype:2 (NUMERIC), prc/scl:1/0, nullbl:0, octet:4, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2013/02/20-14:16:09
    Entered hgopoer at 2013/02/20-14:16:09
    hgopoer, line 231: got native error 0 and sqlstate HY091; message follows...
    [Microsoft][ODBC Visual FoxPro Driver]Descriptor type out of range {HY091}
    Exiting hgopoer, rc=0 at 2013/02/20-14:16:10
    hgodscr_process_sellist_description, line 741: calling SQLColAttribute got sqlstate HY091
    Entered hgopcda at 2013/02/20-14:16:10
    Column:17(numlanc): dtype:1 (CHAR), prc/scl:2/0, nullbl:0, octet:2, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2013/02/20-14:16:10
    Entered hgopoer at 2013/02/20-14:16:10
    hgopoer, line 231: got native error 0 and sqlstate HY091; message follows...
    [Microsoft][ODBC Visual FoxPro Driver]Descriptor type out of range {HY091}
    Exiting hgopoer, rc=0 at 2013/02/20-14:16:10
    hgodscr_process_sellist_description, line 741: calling SQLColAttribute got sqlstate HY091
    Entered hgopcda at 2013/02/20-14:16:11
    Column:18(coddipam): dtype:1 (CHAR), prc/scl:3/0, nullbl:0, octet:3, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2013/02/20-14:16:11
    Entered hgopoer at 2013/02/20-14:16:11
    hgopoer, line 231: got native error 0 and sqlstate HY091; message follows...
    [Microsoft][ODBC Visual FoxPro Driver]Descriptor type out of range {HY091}
    Exiting hgopoer, rc=0 at 2013/02/20-14:16:12
    hgodscr_process_sellist_description, line 741: calling SQLColAttribute got sqlstate HY091
    Entered hgopcda at 2013/02/20-14:16:12
    Column:19(vnuminic): dtype:1 (CHAR), prc/scl:10/0, nullbl:0, octet:10, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2013/02/20-14:16:12
    Entered hgopoer at 2013/02/20-14:16:13
    hgopoer, line 231: got native error 0 and sqlstate HY091; message follows...
    [Microsoft][ODBC Visual FoxPro Driver]Descriptor type out of range {HY091}
    Exiting hgopoer, rc=0 at 2013/02/20-14:16:13
    hgodscr_process_sellist_description, line 741: calling SQLColAttribute got sqlstate HY091
    Entered hgopcda at 2013/02/20-14:16:13
    Column:20(vserie): dtype:1 (CHAR), prc/scl:3/0, nullbl:0, octet:3, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2013/02/20-14:16:13
    Entered hgopcda at 2013/02/20-14:16:13
    Column:21(vdtemiss): dtype:91 (DATE), prc/scl:10/0, nullbl:0, octet:3, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2013/02/20-14:16:13
    Entered hgopoer at 2013/02/20-14:16:13
    hgopoer, line 231: got native error 0 and sqlstate HY091; message follows...
    [Microsoft][ODBC Visual FoxPro Driver]Descriptor type out of range {HY091}
    Exiting hgopoer, rc=0 at 2013/02/20-14:16:14
    hgodscr_process_sellist_description, line 741: calling SQLColAttribute got sqlstate HY091
    Entered hgopcda at 2013/02/20-14:16:14
    Column:22(protocol): dtype:1 (CHAR), prc/scl:10/0, nullbl:0, octet:10, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2013/02/20-14:16:14
    Entered hgopcda at 2013/02/20-14:16:14
    Column:23(vlcancel): dtype:2 (NUMERIC), prc/scl:18/2, nullbl:0, octet:10, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2013/02/20-14:16:14
    Entered hgopcda at 2013/02/20-14:16:14
    Column:24(emitente): dtype:2 (NUMERIC), prc/scl:1/0, nullbl:0, octet:10, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2013/02/20-14:16:15
    Entered hgopoer at 2013/02/20-14:16:15
    hgopoer, line 231: got native error 0 and sqlstate HY091; message follows...
    [Microsoft][ODBC Visual FoxPro Driver]Descriptor type out of range {HY091}
    Exiting hgopoer, rc=0 at 2013/02/20-14:16:15
    hgodscr_process_sellist_description, line 741: calling SQLColAttribute got sqlstate HY091
    Entered hgopcda at 2013/02/20-14:16:15
    Column:25(modelo): dtype:1 (CHAR), prc/scl:2/0, nullbl:0, octet:2, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2013/02/20-14:16:15
    Entered hgopcda at 2013/02/20-14:16:16
    Column:26(nfcompl): dtype:-7 (BIT), prc/scl:1/0, nullbl:0, octet:2, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2013/02/20-14:16:16
    Entered hgopcda at 2013/02/20-14:16:16
    Column:27(extempor): dtype:-7 (BIT), prc/scl:1/0, nullbl:0, octet:2, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2013/02/20-14:16:16
    Entered hgopcda at 2013/02/20-14:16:16
    Column:28(codlanc): dtype:2 (NUMERIC), prc/scl:18/0, nullbl:0, octet:2, sign:1, radix:0
    Exiting hgopcda, rc=0 at 2013/02/20-14:16:16
    Entered hgopoer at 2013/02/20-14:16:16
    hgopoer, line 231: got native error 0 and sqlstate HY091; message follows...
    [Microsoft][ODBC Visual FoxPro Driver]Descriptor type out of range {HY091}
    Exiting hgopoer, rc=0 at 2013/02/20-14:16:17
    hgodscr_process_sellist_description, line 741: calling SQLColAttribute got sqlstate HY091
    Entered hgopcda at 2013/02/20-14:16:17
  • 10. Re: Error connecting foxpro ODBC with Oracle XE
    992079 Newbie
    Currently Being Moderated
    Hum..

    I was reading log and saw .

    Microsoft][ODBC Visual FoxPro Driver]Invalid column number {07009}

    There are a way to see what column numer it's trying ?
  • 11. Re: Error connecting foxpro ODBC with Oracle XE
    kgronau Guru
    Currently Being Moderated
    There are several issues visible in the trace file.

    First of all the driver compatibility:
    [Microsoft][ODBC Driver Manager] O driver não oferece suporte à versão de comportamento de ODBC solicitada pelo aplicativo (consulte SQLSetEnvAttr). {01000}

    DG4ODBC is now an ODBC level 3 compliant application and requires an ODBC level 3 compliant driver. Unfortunately the FoxPro ODBC driver DriverName:VFPODBC.DLL, DriverVer:06.86.0001 is not ODBC level 3 compliant and Microsoft didn't enhance the driver anymore.

    To determine the root cause of [Microsoft][ODBC Visual FoxPro Driver]Invalid column number {07009} we need to have a look at the ODBC trace file - maybe it just has to do that the driver misses an ODBC function. Same for the other 2 errors:
    [Microsoft][ODBC Visual FoxPro Driver]Descriptor type out of range {HY091}
    [Microsoft][ODBC Driver Manager] Tipo de descritor fora do intervalo {HY091}


    ODBC Tracinf is enabled on Windows in the ODBC Administrator. First let's check if there's an old ODBC trace file in %WINDIR%\temp, please delete the sql.log file if it exists. Then open the ODBC Administrator and click on Tracing Tab and enable MACHINE WIDE tracing. As the Gateway Listener is running in the LOCAl SYSTEM account you have to enable machine wide tracing and the ODBC trace file is always written to the %WINDOR%\temp directory - it is also always called sql.log.
    So after you enabled ODBC tracing, please open a new SQL*Plus session and select again using the gateway. Once you got the error, please exit and check out if you find the sql.log file - post its content here. Then please do not forget to disable ODBC tracing again.

    - Klaus
  • 12. Re: Error connecting foxpro ODBC with Oracle XE
    992079 Newbie
    Currently Being Moderated
    Realy it's make sence.


    I'll try generate log, but just wondering, are there another driver compatible with oracle dblink to buy for foxpro ?

    some tested for oracle.
  • 13. Re: Error connecting foxpro ODBC with Oracle XE
    kgronau Guru
    Currently Being Moderated
    Oracle does not test/certify any foreign ODBC driver to be compatible with DG4ODBC.

    As far as I know there's no foreign ODBC driver for FoxPro and MS has already stopped ODBC support for FoxPro a long time ago.

    - Klaus
  • 14. Re: Error connecting foxpro ODBC with Oracle XE
    992079 Newbie
    Currently Being Moderated
    Ok Np.

    Thanks for help, you are the man.

    I'll change my application to oledb. I'll make a bridge to comunicate oracle x foxpro.


    Cya !
    Yours
    Fernando.

    Edited by: 989076 on 21/02/2013 04:53

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points