d3/nt, ODBC, works with SQLDEMO but not with TEST

d3/nt, ODBC, works with SQLDEMO but not with TEST

Post by Roge » Wed, 11 Dec 2002 17:00:10



Running D3/NT (7.1.4)
Created a DSN for sqldemo
Using ms-access, linked tables to access orders, customers, etc

Create FSI:STM account
SQL-CATALOG STM
CREATE-FILE TEST 1 1 with ID, NAME dictionaries
using ED, added record ID = 1
SQL-CREATE-TABLE TEST (OIZ      (looks ok)
CREATE-INDEX sql,tables, *
Changed account in DSN to TEST  (no password, just testing concepts)
Using ms-access to link tables, it gives me the link tables list to
select from (like with sqldemo's tables), but there is no table in the
list (expecting to see TEST)

this is what ODBCSV gives me

Microsoft Windows Socket Version 1.1
Child socket: 88
Preparing to Connect:
D3 Machine    :'PICK'
D3 User       :'DM'
D3 User Pwd   :'*NONE*'
D3 Account    :'STM'
D3 Account Pwd:'*NONE*'
Logon successful
Execute 00421650( SELECT Config, nValue FROM MSysConf )
 SQLTables 00421650 (%, %, %, 'TABLE','VIEW','SYSTEM
TABLE','ALIAS','SYNONYM')
Execute 00421650( select Table_Qualifier, Table_Owner, Table_Name,
Table_Type, R
emarks from SQL.TABLES where  Table_Name  is not NULL and Table_Owner
= 'STM'
and Table_Type in ('TABLE','VIEW','SYSTEMTABLE','ALIAS','SYNONYM')
order by Tabl
e_Type, Table_Qualifier, Table_Owner, Table_Name )
[0] Read Index Records ( TABLES Table_Owner )
[1] Extract Columns
[2] Check Condition
[3] Check Condition
[4] Check Condition
 Number of Columns = 5
Drop statement 00421650
Logoff successful

Identical to sqldemo odbcsv output, except it has
   Column Desc. for 5 columns (128 bytes) for stmt 00421648.
   Fetched 4 rows of 5 columns (207 bytes) for statement 00421648
after 'Number of Columns = 5'

:LIST TABLES WITH ACCOUNT = \STM\ ACCOUNT TABLE_NAME
Page   1     TABLES                                     00:58:07 10
Dec 2002

TABLES.... Account..........................
Table_Name.......................

004367     STM                               TEST

[4051] 1 item listed.

tried account-save of SQLDEMO and account-restore fsi:TEST, did all
the steps above, but still a blank link tables list

what step I am missing that allows it to work with SQLDEMO but not
with other accounts ?

 
 
 

d3/nt, ODBC, works with SQLDEMO but not with TEST

Post by Albert D. Kalla » Wed, 11 Dec 2002 18:45:53


I noticed that you :

Quote:> CREATE-FILE TEST 1 1 with ID, NAME dictionaries
> using ED, added record ID = 1
> SQL-CREATE-TABLE TEST (OIZ      (looks ok)

What fields did you add to table test? You need to add some fields to the
table right? (that is probably why the sql demo works, as you can bet that
the TABLES in that account at least have some fields defined).

Perahps you left out this fact in your post ? (and perhaps you did actually
add some fields to the table?)

I would think before anything works you would at least add a few fields to
the pick file. I am not sure if you are familier with pick, trying to setup
odbc, or the other way around?

You might also get into the habit of placing those fields in the
SQL-create-table command.

Also, if you do start attaching to some existing files, you might consider
building a new dict for that file. It is a unfortunate fact that a good many
of us Pick people did not always make a base table of dict items (A types)
and then for additional synonym are supposed to be a  s type. So many of us
just copied the dict items over and over to create these synonyms, when in
fact we should have been changing them to a type s.

Thus, when you do a

list dict table

You don't get a separation between synonym fields, and the actual base table
fields.

So, add a few fields to the table.

--
Albert D. Kallal
Edmonton, Alberta Canada

www.attcanada.net/~kallal.msn

 
 
 

d3/nt, ODBC, works with SQLDEMO but not with TEST

Post by Roge » Wed, 11 Dec 2002 23:07:24


more info, I think the CREATE-INDEX SQL,TABLES, * is not running
because field 8 has a problem
008 IDCALL SQL.get_table_id]I937A1:";":2:";":3]I938A0]I939A1]I940A2]I941A3]I942
    A21]I943A23

Field 8 on another system (which works properly) is
008 I0ALL SQL.get_table_id]I2340A1:";":2:";":3]I2341A0]I2342A1]I2343A2]I2344A3]
    I2345A21]I2346A23

a create-index on the good system shows
:CREATE-INDEX TABLES *
Creating index on *
Creating index on ALL SQL.get_table_id
0000018
Creating index on A1:";":2:";":3
0000018
Creating index on A0
0000018
Creating index on A1
0000018
Creating index on A2
0000018
Creating index on A3
0000018
Creating index on A21
0000018
Creating index on A23
0000018

the same thing on the problem system does nothing
:CREATE-INDEX TABLES *
Creating index on *

does anyone have a suggestion on how to clean the bad index ?
I restored the SQL account on this device  C:\Program
F...grams\D3Data.D3P..
to a DUMMY account and field 8 content is bad


> Running D3/NT (7.1.4)
> Created a DSN for sqldemo
> Using ms-access, linked tables to access orders, customers, etc

> Create FSI:STM account
> SQL-CATALOG STM
> CREATE-FILE TEST 1 1 with ID, NAME dictionaries
> using ED, added record ID = 1
> SQL-CREATE-TABLE TEST (OIZ      (looks ok)
> CREATE-INDEX sql,tables, *
> Changed account in DSN to TEST  (no password, just testing concepts)
> Using ms-access to link tables, it gives me the link tables list to
> select from (like with sqldemo's tables), but there is no table in the
> list (expecting to see TEST)

> this is what ODBCSV gives me

> Microsoft Windows Socket Version 1.1
> Child socket: 88
> Preparing to Connect:
> D3 Machine    :'PICK'
> D3 User       :'DM'
> D3 User Pwd   :'*NONE*'
> D3 Account    :'STM'
> D3 Account Pwd:'*NONE*'
> Logon successful
> Execute 00421650( SELECT Config, nValue FROM MSysConf )
>  SQLTables 00421650 (%, %, %, 'TABLE','VIEW','SYSTEM
> TABLE','ALIAS','SYNONYM')
> Execute 00421650( select Table_Qualifier, Table_Owner, Table_Name,
> Table_Type, R
> emarks from SQL.TABLES where  Table_Name  is not NULL and Table_Owner
> = 'STM'
> and Table_Type in ('TABLE','VIEW','SYSTEMTABLE','ALIAS','SYNONYM')
> order by Tabl
> e_Type, Table_Qualifier, Table_Owner, Table_Name )
> [0] Read Index Records ( TABLES Table_Owner )
> [1] Extract Columns
> [2] Check Condition
> [3] Check Condition
> [4] Check Condition
>  Number of Columns = 5
> Drop statement 00421650
> Logoff successful

> Identical to sqldemo odbcsv output, except it has
>    Column Desc. for 5 columns (128 bytes) for stmt 00421648.
>    Fetched 4 rows of 5 columns (207 bytes) for statement 00421648
> after 'Number of Columns = 5'

> :LIST TABLES WITH ACCOUNT = \STM\ ACCOUNT TABLE_NAME
> Page   1     TABLES                                     00:58:07 10
> Dec 2002

> TABLES.... Account..........................
> Table_Name.......................

> 004367     STM                               TEST

> [4051] 1 item listed.

> tried account-save of SQLDEMO and account-restore fsi:TEST, did all
> the steps above, but still a blank link tables list

> what step I am missing that allows it to work with SQLDEMO but not
> with other accounts ?

 
 
 

d3/nt, ODBC, works with SQLDEMO but not with TEST

Post by Mark Brow » Thu, 12 Dec 2002 09:15:25


1)    The create-index filename * has a bug that tries to create anything
that starts with an I and does not ignore the ID (how to create an item id).
The system you describe as the "good" system, has the bad index.

2)    When you do the SQL-CREATE-TABLE, you MUST be in the account where the
file lives, in this case STM.  That establishes the "owner" of the table.

Mark

--
-------------------------------
Mark Brown
President/CEO
Computer Mgmt & Resource Consultants
714/537-4437
484/716-6154 (Cell)
413/487-7925 (Fax)

Illegitimis non carborundum.


Quote:> more info, I think the CREATE-INDEX SQL,TABLES, * is not running
> because field 8 has a problem
> 008 IDCALL

SQL.get_table_id]I937A1:";":2:";":3]I938A0]I939A1]I940A2]I941A3]I942
Quote:>     A21]I943A23

> Field 8 on another system (which works properly) is
> 008 I0ALL

SQL.get_table_id]I2340A1:";":2:";":3]I2341A0]I2342A1]I2343A2]I2344A3]
>     I2345A21]I2346A23

> a create-index on the good system shows
> :CREATE-INDEX TABLES *
> Creating index on *
> Creating index on ALL SQL.get_table_id
> 0000018
> Creating index on A1:";":2:";":3
> 0000018
> Creating index on A0
> 0000018
> Creating index on A1
> 0000018
> Creating index on A2
> 0000018
> Creating index on A3
> 0000018
> Creating index on A21
> 0000018
> Creating index on A23
> 0000018

> the same thing on the problem system does nothing
> :CREATE-INDEX TABLES *
> Creating index on *

> does anyone have a suggestion on how to clean the bad index ?
> I restored the SQL account on this device  C:\Program
> F...grams\D3Data.D3P..
> to a DUMMY account and field 8 content is bad




- Show quoted text -

Quote:> > Running D3/NT (7.1.4)
> > Created a DSN for sqldemo
> > Using ms-access, linked tables to access orders, customers, etc

> > Create FSI:STM account
> > SQL-CATALOG STM
> > CREATE-FILE TEST 1 1 with ID, NAME dictionaries
> > using ED, added record ID = 1
> > SQL-CREATE-TABLE TEST (OIZ      (looks ok)
> > CREATE-INDEX sql,tables, *
> > Changed account in DSN to TEST  (no password, just testing concepts)
> > Using ms-access to link tables, it gives me the link tables list to
> > select from (like with sqldemo's tables), but there is no table in the
> > list (expecting to see TEST)

> > this is what ODBCSV gives me

> > Microsoft Windows Socket Version 1.1
> > Child socket: 88
> > Preparing to Connect:
> > D3 Machine    :'PICK'
> > D3 User       :'DM'
> > D3 User Pwd   :'*NONE*'
> > D3 Account    :'STM'
> > D3 Account Pwd:'*NONE*'
> > Logon successful
> > Execute 00421650( SELECT Config, nValue FROM MSysConf )
> >  SQLTables 00421650 (%, %, %, 'TABLE','VIEW','SYSTEM
> > TABLE','ALIAS','SYNONYM')
> > Execute 00421650( select Table_Qualifier, Table_Owner, Table_Name,
> > Table_Type, R
> > emarks from SQL.TABLES where  Table_Name  is not NULL and Table_Owner
> > = 'STM'
> > and Table_Type in ('TABLE','VIEW','SYSTEMTABLE','ALIAS','SYNONYM')
> > order by Tabl
> > e_Type, Table_Qualifier, Table_Owner, Table_Name )
> > [0] Read Index Records ( TABLES Table_Owner )
> > [1] Extract Columns
> > [2] Check Condition
> > [3] Check Condition
> > [4] Check Condition
> >  Number of Columns = 5
> > Drop statement 00421650
> > Logoff successful

> > Identical to sqldemo odbcsv output, except it has
> >    Column Desc. for 5 columns (128 bytes) for stmt 00421648.
> >    Fetched 4 rows of 5 columns (207 bytes) for statement 00421648
> > after 'Number of Columns = 5'

> > :LIST TABLES WITH ACCOUNT = \STM\ ACCOUNT TABLE_NAME
> > Page   1     TABLES                                     00:58:07 10
> > Dec 2002

> > TABLES.... Account..........................
> > Table_Name.......................

> > 004367     STM                               TEST

> > [4051] 1 item listed.

> > tried account-save of SQLDEMO and account-restore fsi:TEST, did all
> > the steps above, but still a blank link tables list

> > what step I am missing that allows it to work with SQLDEMO but not
> > with other accounts ?

 
 
 

d3/nt, ODBC, works with SQLDEMO but not with TEST

Post by Roge » Thu, 12 Dec 2002 20:44:19


Mark

In this SQL account, I used INDEXER (A
:INDEXER (A

[404] 13 items selected out of 1567 items.
Creating indices for account SQL
  Creating index for SQL,base_types,
  Creating index for SQL,constraints_types,
  Creating index for SQL,data_types,
  Creating index for SQL,index_types,
  Creating index for SQL,retrieve_types,
  Creating index for SQL,SQL_databases,
  Creating index for SQL,SQL_stmts,
  Creating index for SQL,table,
  Creating index for SQL,tables,

Then in the SQLDEMO account I created a file called TEST with 2
dictionaries
   KEY      A     0
   NAME     A     1

And a data record (1, ROGER)  ... just like the original setup in the
STM account

then I ran SQL-CREATE-TABLE TEST (OIZ, and the table is created
but when I use MS-ACCESS with a system dsn pointing to SQLDEMO, it
just shows me a list of the original tables (customers, orders, etc)
but not the TEST table
I'm running odbcsv -dpv from the command line and everything there
looks fine

this is leading me to believe that the problem is with indexing ...
but how to resolve it ?

can I fix the 'create-index filename * ' without upgrading to another
version ?
(I am running the latest patch from the RD site)


> 1)    The create-index filename * has a bug that tries to create anything
> that starts with an I and does not ignore the ID (how to create an item id).
> The system you describe as the "good" system, has the bad index.

> 2)    When you do the SQL-CREATE-TABLE, you MUST be in the account where the
> file lives, in this case STM.  That establishes the "owner" of the table.

> Mark

> --
> -------------------------------
> Mark Brown
> President/CEO
> Computer Mgmt & Resource Consultants
> 714/537-4437
> 484/716-6154 (Cell)
> 413/487-7925 (Fax)

> Illegitimis non carborundum.



> > more info, I think the CREATE-INDEX SQL,TABLES, * is not running
> > because field 8 has a problem
> > 008 IDCALL
>  SQL.get_table_id]I937A1:";":2:";":3]I938A0]I939A1]I940A2]I941A3]I942
> >     A21]I943A23

> > Field 8 on another system (which works properly) is
> > 008 I0ALL
>  SQL.get_table_id]I2340A1:";":2:";":3]I2341A0]I2342A1]I2343A2]I2344A3]
> >     I2345A21]I2346A23

> > a create-index on the good system shows
> > :CREATE-INDEX TABLES *
> > Creating index on *
> > Creating index on ALL SQL.get_table_id
> > 0000018
> > Creating index on A1:";":2:";":3
> > 0000018
> > Creating index on A0
> > 0000018
> > Creating index on A1
> > 0000018
> > Creating index on A2
> > 0000018
> > Creating index on A3
> > 0000018
> > Creating index on A21
> > 0000018
> > Creating index on A23
> > 0000018

> > the same thing on the problem system does nothing
> > :CREATE-INDEX TABLES *
> > Creating index on *

> > does anyone have a suggestion on how to clean the bad index ?
> > I restored the SQL account on this device  C:\Program
> > F...grams\D3Data.D3P..
> > to a DUMMY account and field 8 content is bad



> > > Running D3/NT (7.1.4)
> > > Created a DSN for sqldemo
> > > Using ms-access, linked tables to access orders, customers, etc

> > > Create FSI:STM account
> > > SQL-CATALOG STM
> > > CREATE-FILE TEST 1 1 with ID, NAME dictionaries
> > > using ED, added record ID = 1
> > > SQL-CREATE-TABLE TEST (OIZ      (looks ok)
> > > CREATE-INDEX sql,tables, *
> > > Changed account in DSN to TEST  (no password, just testing concepts)
> > > Using ms-access to link tables, it gives me the link tables list to
> > > select from (like with sqldemo's tables), but there is no table in the
> > > list (expecting to see TEST)

> > > this is what ODBCSV gives me

> > > Microsoft Windows Socket Version 1.1
> > > Child socket: 88
> > > Preparing to Connect:
> > > D3 Machine    :'PICK'
> > > D3 User       :'DM'
> > > D3 User Pwd   :'*NONE*'
> > > D3 Account    :'STM'
> > > D3 Account Pwd:'*NONE*'
> > > Logon successful
> > > Execute 00421650( SELECT Config, nValue FROM MSysConf )
> > >  SQLTables 00421650 (%, %, %, 'TABLE','VIEW','SYSTEM
> > > TABLE','ALIAS','SYNONYM')
> > > Execute 00421650( select Table_Qualifier, Table_Owner, Table_Name,
> > > Table_Type, R
> > > emarks from SQL.TABLES where  Table_Name  is not NULL and Table_Owner
> > > = 'STM'
> > > and Table_Type in ('TABLE','VIEW','SYSTEMTABLE','ALIAS','SYNONYM')
> > > order by Tabl
> > > e_Type, Table_Qualifier, Table_Owner, Table_Name )
> > > [0] Read Index Records ( TABLES Table_Owner )
> > > [1] Extract Columns
> > > [2] Check Condition
> > > [3] Check Condition
> > > [4] Check Condition
> > >  Number of Columns = 5
> > > Drop statement 00421650
> > > Logoff successful

> > > Identical to sqldemo odbcsv output, except it has
> > >    Column Desc. for 5 columns (128 bytes) for stmt 00421648.
> > >    Fetched 4 rows of 5 columns (207 bytes) for statement 00421648
> > > after 'Number of Columns = 5'

> > > :LIST TABLES WITH ACCOUNT = \STM\ ACCOUNT TABLE_NAME
> > > Page   1     TABLES                                     00:58:07 10
> > > Dec 2002

> > > TABLES.... Account..........................
> > > Table_Name.......................

> > > 004367     STM                               TEST

> > > [4051] 1 item listed.

> > > tried account-save of SQLDEMO and account-restore fsi:TEST, did all
> > > the steps above, but still a blank link tables list

> > > what step I am missing that allows it to work with SQLDEMO but not
> > > with other accounts ?

 
 
 

d3/nt, ODBC, works with SQLDEMO but not with TEST

Post by Coli » Fri, 13 Dec 2002 05:29:26


Roger;

I just set up a couple of these (although on Aix D3 7.1.0) and had no
trouble seeing my tables. I found using excel the fastest/easiest way
to see the tables. I did not have to build/rebuild any of the indices
in the SQL account.

After you created the new table in the SQLDEMO account did you change
the DSN to point back to the SQLDEMO account?

Were you in the correct account when you did the SQL-CREATE-TABLE?

If you logto SQL can you do:

LIST TABLES WITH ACCOUNT = "SQLDEMO" A1 A2 A3

and see the table listed? If not, try a find on tables for your
file.name and see which account it is in. Also, the table will get
re-named dict items if you try using a reserved word. ie. a dict named
DESC will be renamed RSV_DESC in the table. I wouldn't think TEST
would be reservered - but I've seen stranger things.

hth

Colin Alfke
Calgary, Alberta Canada


> Mark

> In this SQL account, I used INDEXER (A
> :INDEXER (A

> [404] 13 items selected out of 1567 items.
> Creating indices for account SQL
>   Creating index for SQL,base_types,
>   Creating index for SQL,constraints_types,
>   Creating index for SQL,data_types,
>   Creating index for SQL,index_types,
>   Creating index for SQL,retrieve_types,
>   Creating index for SQL,SQL_databases,
>   Creating index for SQL,SQL_stmts,
>   Creating index for SQL,table,
>   Creating index for SQL,tables,

> Then in the SQLDEMO account I created a file called TEST with 2
> dictionaries
>    KEY      A     0
>    NAME     A     1

> And a data record (1, ROGER)  ... just like the original setup in the
> STM account

> then I ran SQL-CREATE-TABLE TEST (OIZ, and the table is created
> but when I use MS-ACCESS with a system dsn pointing to SQLDEMO, it
> just shows me a list of the original tables (customers, orders, etc)
> but not the TEST table
> I'm running odbcsv -dpv from the command line and everything there
> looks fine

> this is leading me to believe that the problem is with indexing ...
> but how to resolve it ?

> can I fix the 'create-index filename * ' without upgrading to another
> version ?
> (I am running the latest patch from the RD site)

 
 
 

d3/nt, ODBC, works with SQLDEMO but not with TEST

Post by Mark Brow » Mon, 16 Dec 2002 12:50:49


Roger,

If all else fails, log to SQL and UD TABLES.  Replace the line that says

IALL something

to

IDCALL something...

You are probalby right.  The SQL query that returns to list of filenames
makes heavy use of indexes for finding the files and data.  If you are in
the SQLDEMO account and create your file, do your  SQL-CREATE-INDEX and
still do not see the file in the list, there is almost certainly an index
issue.

Very last resort: simply clear attribute 8 of the file defining item of
TABLES.  Add the IDCALL line and then do create-index for each individual
index.  It was easy for me, 'cause I have two telnet windows and had all the
index names on the screen.

Good Luck!!!

Mark

--
-------------------------------
Mark Brown
President/CEO
Computer Mgmt & Resource Consultants
714/537-4437
484/716-6154 (Cell)
413/487-7925 (Fax)

Illegitimis non carborundum.

"Roger" <rlespera...@smednet.com> wrote in message

news:1e6e5b5b.0212110344.14af5907@posting.google.com...
> Mark

> In this SQL account, I used INDEXER (A
> :INDEXER (A

> [404] 13 items selected out of 1567 items.
> Creating indices for account SQL
>   Creating index for SQL,base_types,
>   Creating index for SQL,constraints_types,
>   Creating index for SQL,data_types,
>   Creating index for SQL,index_types,
>   Creating index for SQL,retrieve_types,
>   Creating index for SQL,SQL_databases,
>   Creating index for SQL,SQL_stmts,
>   Creating index for SQL,table,
>   Creating index for SQL,tables,

> Then in the SQLDEMO account I created a file called TEST with 2
> dictionaries
>    KEY      A     0
>    NAME     A     1

> And a data record (1, ROGER)  ... just like the original setup in the
> STM account

> then I ran SQL-CREATE-TABLE TEST (OIZ, and the table is created
> but when I use MS-ACCESS with a system dsn pointing to SQLDEMO, it
> just shows me a list of the original tables (customers, orders, etc)
> but not the TEST table
> I'm running odbcsv -dpv from the command line and everything there
> looks fine

> this is leading me to believe that the problem is with indexing ...
> but how to resolve it ?

> can I fix the 'create-index filename * ' without upgrading to another
> version ?
> (I am running the latest patch from the RD site)

> "Mark Brown" <drw...@flash.net> wrote in message

<news:xsvJ9.13916$1y5.10417@newssvr16.news.prodigy.com>...

- Show quoted text -

> > 1)    The create-index filename * has a bug that tries to create
anything
> > that starts with an I and does not ignore the ID (how to create an item
id).
> > The system you describe as the "good" system, has the bad index.

> > 2)    When you do the SQL-CREATE-TABLE, you MUST be in the account where
the
> > file lives, in this case STM.  That establishes the "owner" of the
table.

> > Mark

> > --
> > -------------------------------
> > Mark Brown
> > President/CEO
> > Computer Mgmt & Resource Consultants
> > 714/537-4437
> > 484/716-6154 (Cell)
> > 413/487-7925 (Fax)

> > Illegitimis non carborundum.

> > "Roger" <rlespera...@smednet.com> wrote in message
> > news:1e6e5b5b.0212100607.244cfbf2@posting.google.com...
> > > more info, I think the CREATE-INDEX SQL,TABLES, * is not running
> > > because field 8 has a problem
> > > 008 IDCALL
> >  SQL.get_table_id]I937A1:";":2:";":3]I938A0]I939A1]I940A2]I941A3]I942
> > >     A21]I943A23

> > > Field 8 on another system (which works properly) is
> > > 008 I0ALL
> >  SQL.get_table_id]I2340A1:";":2:";":3]I2341A0]I2342A1]I2343A2]I2344A3]
> > >     I2345A21]I2346A23

> > > a create-index on the good system shows
> > > :CREATE-INDEX TABLES *
> > > Creating index on *
> > > Creating index on ALL SQL.get_table_id
> > > 0000018
> > > Creating index on A1:";":2:";":3
> > > 0000018
> > > Creating index on A0
> > > 0000018
> > > Creating index on A1
> > > 0000018
> > > Creating index on A2
> > > 0000018
> > > Creating index on A3
> > > 0000018
> > > Creating index on A21
> > > 0000018
> > > Creating index on A23
> > > 0000018

> > > the same thing on the problem system does nothing
> > > :CREATE-INDEX TABLES *
> > > Creating index on *

> > > does anyone have a suggestion on how to clean the bad index ?
> > > I restored the SQL account on this device  C:\Program
> > > F...grams\D3Data.D3P..
> > > to a DUMMY account and field 8 content is bad

> > > rlespera...@smednet.com (Roger) wrote in message
> >  <news:1e6e5b5b.0212100000.5dfd5667@posting.google.com>...
> > > > Running D3/NT (7.1.4)
> > > > Created a DSN for sqldemo
> > > > Using ms-access, linked tables to access orders, customers, etc

> > > > Create FSI:STM account
> > > > SQL-CATALOG STM
> > > > CREATE-FILE TEST 1 1 with ID, NAME dictionaries
> > > > using ED, added record ID = 1
> > > > SQL-CREATE-TABLE TEST (OIZ      (looks ok)
> > > > CREATE-INDEX sql,tables, *
> > > > Changed account in DSN to TEST  (no password, just testing concepts)
> > > > Using ms-access to link tables, it gives me the link tables list to
> > > > select from (like with sqldemo's tables), but there is no table in
the
> > > > list (expecting to see TEST)

> > > > this is what ODBCSV gives me

> > > > Microsoft Windows Socket Version 1.1
> > > > Child socket: 88
> > > > Preparing to Connect:
> > > > D3 Machine    :'PICK'
> > > > D3 User       :'DM'
> > > > D3 User Pwd   :'*NONE*'
> > > > D3 Account    :'STM'
> > > > D3 Account Pwd:'*NONE*'
> > > > Logon successful
> > > > Execute 00421650( SELECT Config, nValue FROM MSysConf )
> > > >  SQLTables 00421650 (%, %, %, 'TABLE','VIEW','SYSTEM
> > > > TABLE','ALIAS','SYNONYM')
> > > > Execute 00421650( select Table_Qualifier, Table_Owner, Table_Name,
> > > > Table_Type, R
> > > > emarks from SQL.TABLES where  Table_Name  is not NULL and
Table_Owner
> > > > = 'STM'
> > > > and Table_Type in ('TABLE','VIEW','SYSTEMTABLE','ALIAS','SYNONYM')
> > > > order by Tabl
> > > > e_Type, Table_Qualifier, Table_Owner, Table_Name )
> > > > [0] Read Index Records ( TABLES Table_Owner )
> > > > [1] Extract Columns
> > > > [2] Check Condition
> > > > [3] Check Condition
> > > > [4] Check Condition
> > > >  Number of Columns = 5
> > > > Drop statement 00421650
> > > > Logoff successful

> > > > Identical to sqldemo odbcsv output, except it has
> > > >    Column Desc. for 5 columns (128 bytes) for stmt 00421648.
> > > >    Fetched 4 rows of 5 columns (207 bytes) for statement 00421648
> > > > after 'Number of Columns = 5'

> > > > :LIST TABLES WITH ACCOUNT = \STM\ ACCOUNT TABLE_NAME
> > > > Page   1     TABLES                                     00:58:07 10
> > > > Dec 2002

> > > > TABLES.... Account..........................
> > > > Table_Name.......................

> > > > 004367     STM                               TEST

> > > > [4051] 1 item listed.

> > > > tried account-save of SQLDEMO and account-restore fsi:TEST, did all
> > > > the steps above, but still a blank link tables list

> > > > what step I am missing that allows it to work with SQLDEMO but not
> > > > with other accounts ?