Problems attaching to Tables...Please Help!!!
Configurations:
Server IBM RS/6000 AIX 3.2.5
Informix SE 5.01.UD3
INET 5.01.UD3
Client Compaq 486/66 DX2
Microsoft Access 2.0
Q+E ODBC Pack 1.2
INET 5.01.WD1
Procedures:
I open Microsoft Access and select to add a new database. After giving the name of the new database, I try to attach to a table. I select SQL Database and thename of my Data Source. Next I find the table that I am trying to attach to, and select to save the ID and password locally. I receive a message indicating that I have a successful attachment.
The problem that I encounter happens when I try to open the table. The
following message populates all columns and rows, for the first 5 or so rows:
'ERROR#'.
After the 5 rows, '#NAME?' fills all columns and rows, which is followed by a
'General Protection Fault in Module MSAJT200.DLL at 0038:0041.'
If I try to attach to a different table first, then attach to this table, I enjoy limited success. When I save the database, exit Access and Windows, and reboot going back into Access and to re-open the database and table, I get the same error.
Has anyone encoutered this error? Can I pinpoint the error to INET, ODBC or Access? I have been working with Intersolv Q+E tech support, but have had no success. Is there a limitation to the size of table, index, etc.?
I have included the schema information of the table I am trying to
attach:
DBSCHEMA Schema Utility INFORMIX-SQL Version 5.01.UD3
Copyright (C) Informix Software, Inc., 1984-1991
Software Serial Number AAA#C678044
{ TABLE "informix".strcustr row size = 650 number of columns = 74 index size = 81 }
create "informix".table strcustr
(
cust_code char(6),
bridge_code char(6),
bus_name char(30),
taxable char(6),
contact char(20),
phone char(20),
fax_phone char(20),
address1 char(30),
address2 char(30),
city char(20),
state char(2),
zip char(10),
country char(20),
ar_type char(1),
preferred char(1),
frequent char(1),
stmt_cycle smallint,
fin_chg char(1),
credit_limit decimal(12),
order_limit decimal(12),
terms_code char(6),
act_grp char(6),
ar_acct_dflt integer,
ar_department_dflt char(3),
stmt_date date,
stmt_amount decimal(12),
acct_bal decimal(12),
obtained_date date,
last_order_date date,
last_pay_date date,
inactive_date date,
on_acct_amt decimal(12),
arch_bal decimal(12),
sls_psn_code char(6),
trd_ds_code char(6),
st_tx_code char(6),
co_tx_code char(6),
ci_tx_code char(6),
comm_code char(6),
pay_method char(6),
card_no char(20),
exp_date char(5),
card_holder char(20),
consol_code char(6),
credit_hold char(1),
billing_msg1 char(30),
billing_msg2 char(30),
bill_remind char(60),
ack_code char(1),
edi_inv char(1),
cc_method char(6),
mtax_fc char(6),
currency_code char(3),
pnlty_pct decimal(4,2),
ship_via char(15),
fob char(15),
map_locn char(6),
cust_type char(6),
mtax_freight char(6),
mtax_misc char(6),
broker_flg char(1),
ship_via_cd char(3),
tax_exempt_no char(15),
cred_hld_typ char(1),
bl_style char(1),
inv_style char(1),
hi_amt decimal(12),
hi_amt_date date,
cntry_cd char(3),
final_dest char(2),
edi_id char(3),
quo_rnd char(1),
quo_near smallint,
comm_pct decimal(5,2)
);
revoke all on "informix".strcustr from "public";
create unique index "informix".i1rcustr on "informix".strcustr (cust_code);
create index "informix".i2rcustr on "informix".strcustr (bus_name);
create index "informix".i3rcustr on "informix".strcustr (sls_psn_code);
--
cpilot@teleport.COM Public Access User --- Not affiliated with Teleport
Public Access UNIX and Internet at (503) 220-1016 (2400-14400, N81)