|
|
341658 |
|
PB Enterprise |
|
DB ODBC |
|
|
Closed |
|
Microsoft Windows 2000 |
|
8.0.4 |
|
|
|
|
|
|
When connected to the ProvideX database using odbc,
only 1 table appears in the db painter view or the table list when creating a
datawindow.
The sql.log files shows the following error:
pb80 ce4-7d4 ENTER SQLExecDirect
HSTMT 02552600
UCHAR * 0x01260D40 [ -3] "CREATE TABLE pbcattbl ()\ 0"
SDWORD -3
pb80 ce4-7d4 EXIT SQLExecDirect with return code -1 (SQL_ERROR)
HSTMT 02552600
UCHAR * 0x01260D40 [ -3] "CREATE TABLE pbcattbl ()\ 0"
SDWORD -3
DIAG [37000] [ProvideX][ODBC Driver]Expected lexical element not found: <identifier> (1015)
pb80 ce4-7d4 ENTER SQLErrorW
HENV 02551540
HDBC 025515E8
HSTMT 02552600
WCHAR * 0x0012E260 (NYI)
SDWORD * 0x0012E2AC
WCHAR * 0x0012DE60
SWORD 512
SWORD * 0x0012E2B4
pb80 ce4-7d4 EXIT SQLErrorW with return code 0 (SQL_SUCCESS)
HENV 02551540
HDBC 025515E8
HSTMT 02552600
WCHAR * 0x0012E260 (NYI)
SDWORD * 0x0012E2AC (1015)
WCHAR * 0x0012DE60 [ 71] "[ProvideX][ODBC Driver]Expected lex"
SWORD 512
SWORD * 0x0012E2B4 (71)
You can connect to excel and see all the tables. The log file from ProvideX shows the following when connected to excel:
<3140> ISAMOpen: Open file D:\pse-80\10987656\Nomads\providex.ddf , returns fhFile=1496064
<3140> <Customer Classes> Open file D:\pse-80\10987656\Nomads\clsfile , fhFile =1549832 , maxksz=35
<3140> ISAMCloseTable: Closing table Customer Classes - 0 file reads, 0 re-reads, 0 writes, 0 removes
<3140> CACHE STATS - 0 reads, size 11264 estimated, 0 used
<3140> <Customer Classes> Open file D:\pse-80\10987656\Nomads\clsfile , fhFile =1548352 , maxksz=35
<3140> ISAMCloseTable: Closing table Customer Classes - 0 file reads, 0 re-reads, 0 writes, 0 removes
<3140> CACHE STATS - 0 reads, size 11264 estimated, 0 used
<3140> <Salesman> Open file D:\pse-80\10987656\Nomads\smnfile , fhFile =1548352 , maxksz=35
<3140> ISAMCloseTable: Closing table Salesman - 0 file reads, 0 re-reads, 0 writes, 0 removes
<3140> CACHE STATS - 0 reads, size 4096 estimated, 0 used
<3140> <Salesman> Open file D:\pse-80\10987656\Nomads\smnfile , fhFile =1548352 , maxksz=35
<3140> ISAMCloseTable: Closing table Salesman - 0 file reads, 0 re-reads, 0 writes, 0 removes
<3140> CACHE STATS - 0 reads, size 4096 estimated, 0 used
<3140> ------------------------------
<3140> SELECT DISTINCT SMN_NAME FROM ""Salesman Salesman
----------------------------
When connected thru PowerBuilder, you don't see it getting past the first table--customer:
64> ISAMOpen: Open file D:\pse-80\10987656\Nomads\providex.ddf , returns fhFile=1964064
<3364> <Customer> Open file D:\pse-80\10987656\Nomads\cstfile , fhFile =1975680 , maxksz=35
<3364> ISAMCloseTable: Closing table Customer - 0 file reads, 0 re-reads, 0 writes, 0 removes
<3364> CACHE STATS - 0 reads, size 9216 estimated, 0 used
<3364> <customer> Open file D:\pse-80\10987656\Nomads\cstfile , fhFile =1972664 , maxksz=35
<3364> ISAMCloseTable: Closing table customer - 0 file reads, 0 re-reads, 0 writes, 0 removes
<3364> CACHE STATS - 0 reads, size 9216 estimated, 0 used
<3364> <customer> Open file D:\pse-80\10987656\Nomads\cstfile , fhFile =1972664 , maxksz=35
<3364> ISAMCloseTable: Closing table customer - 0 file reads, 0 re-reads, 0 writes, 0 removes
<3364> CACHE STATS - 0 reads, size 9216 estimated, 0 used
<3364> <customer> Open file D:\pse-80\10987656\Nomads\cstfile , fhFile =1972664 , maxksz=35
<3364> ISAMCloseTable: Closing table customer - 0 file reads, 0 re-reads, 0 writes, 0 removes
<3364> CACHE STATS - 0 reads, size 9216 estimated, 0 used
SOLUTION: Add the following to the pbodbxx.ini file:
;ProvideX odbc driver
[ProvideX]
PBFileManager='YES'
Block=1 |
|
|
|