|
ISTech Support Forum
http://www.istechforum.com/YaBB.pl Crystal Reports, ODBC & Access >> ODBC General Issues >> BKICMSTR Table after 2/14/07 update http://www.istechforum.com/YaBB.pl?num=1172167452 Message started by rvallier on 02/22/07 at 10:04:12 |
|
Title: BKICMSTR Table after 2/14/07 update Post by rvallier on 02/22/07 at 10:04:12 I seem to be having a problem accessing my BKICMSTR table through my DBA connection manager setup since we have installed the 2/14/07 update. All other tables seem to open fine. I am getting: ODBC Call Failed [Pervasive][ODBC Client Interface]Numeric Value out of range. (#0) when I try to view the BKICMSTR table. I thought this might be because we had set our SD-Q to Require Category codes, but did not have them set up before doing this. Is this a situation where I need to 'reindex the file' - will this help? Lynn has said we have a program called NZIndex - is this how you reindex a file? Anybody have any ideas on how to help me. I do not want to use the MTICMSTR file because it does not contain the category codes I need for sorting. Thanks, Robin |
|
Title: Re: BKICMSTR Table after 2/14/07 update Post by Kelloggs on 02/22/07 at 11:50:01 Numeric Value out of range means that there is a record that contains data that does not comply with the field type. You can reindex the table but that may not fix the problem. By the way, you need NZIndex only if you want to reindex more that one table at a time. Use UT-C. There is another utility that could help UT-K-I. But you will need to run it during the night. It takes a very very long time. And most important BACKUP, BACKUP and BACKUP. Regards, Kelloggs |
|
Title: Re: BKICMSTR Table after 2/14/07 update Post by rvallier on 02/23/07 at 08:38:54 Kelloggs, Thank you for your prompt reply. I ran both the UT-C on BKICMSTR, and I've run UT-K-I. When I ran UT-K-I, it ran through 23 of 23 files, then hung up at the end of 77 of 77 files, and would not exit. I had to force an End Task, and reboot the server. Neither of the procedures has helped completely although I have noticed a change in how the data is acting. Now I seem to be able to look at the data within Access, but as soon as I want to export the data, it hangs on the ODBC failed error again. My next step is going to be to try to recreate a new Pervasive Database Engine...do you have any other ideas? Thanks, Robin |
|
Title: Re: BKICMSTR Table after 2/14/07 update Post by kevind on 02/23/07 at 08:41:32 Have you tried creating a fresh set of ODBC DDF files? If there were any changes to the tables by ISTECH, you should re-run ODBCDDF.RUN to create current DDF files. Hope that helps. |
|
Title: Re: BKICMSTR Table after 2/14/07 update Post by rvallier on 02/23/07 at 08:53:10 Funny you should mention that - yes I have, and I run into the following error: Btrieve Error - V:\Default\File.ddf - 5. I had sent this message to Bill Rouser, who suggested I use a global.exe file to find a duplicate file. I ran this file, and it looked like it came back with something similar to MEATTRIB, but Bill did not explain how to use the program he sent, so I am back to being lost. I find that having our data files stored on a different drive letter creates a lot of havoc in my life. Our DBAMFG files are stored on our U: drive, and our Default folder is stored on V:. Can you shed any more light on this situation? Thanks again, Robin |
|
Title: Re: BKICMSTR Table after 2/14/07 update Post by kevind on 02/23/07 at 09:10:34 Are you saying that you received the Btrieve Error when you ran ODBCDDF, or that you now get this error after running ODBCDDF successfully? What is the 'DBA Connection Manager' that you referred too in your first post? |
|
Title: Re: BKICMSTR Table after 2/14/07 update Post by rvallier on 02/23/07 at 09:13:37 I received that Btrieve Error during the ODBCDDF process, I said ok, then it kept going with what it was doing. DBA Connection Manager is a program I downloaded to link my tables from DBA to MS Access 2003. |
|
Title: Re: BKICMSTR Table after 2/14/07 update Post by kevind on 02/23/07 at 09:22:59 I would rename the DDF files that you created when you got the error, and then try and create new one's. I don't have the newest ISTECH update installed yet, so I can't try it out. I found this: Quote:
on the Midwest Accounting Web site. Did you try that? |
|
Title: Re: BKICMSTR Table after 2/14/07 update Post by rvallier on 02/23/07 at 10:23:46 Sorry - don't understand what you mean - did I try what - rebooting? Yes. What about my inability to complete the ODBCDDF.run without an error? |
|
Title: Re: BKICMSTR Table after 2/14/07 update Post by kevind on 02/23/07 at 12:59:38 rvallier wrote:
No, I'm sorry ... I was not very clear. Since I don't have the latest ISTECH updates installed yet, I can't try ODBCDDF myself. Did you rename your existing ODBC DDF files and try and recreate them with ODBCDDF without error? |
|
Title: Re: BKICMSTR Table after 2/14/07 update Post by rvallier on 02/23/07 at 13:04:35 Refresh my understanding, the ODBC DDF files are stored in the Default folder? and if I rename the something like file.old - I can then create new DDF files? I have two default folders, I am assuming you mean my actual current data file Default folder that is stored on a different drive? Thanks again for your help....I am trying to contact mwaccounting for help as well....Robin |
|
Title: Re: BKICMSTR Table after 2/14/07 update Post by kevind on 02/23/07 at 13:08:25 The ODBC DDF files are stored in the same folder as your company .Bxx files. You should never have your company .Bxx files in the DBAMFG folder because there are DDF files there for ALL companies that are not ODBC Compliant. You can safely rename, move or delete the DDF files in the Company folder (again, not the main DBAMFG program folder) and use ODBCDDF.RUN to re-create them while you are logged into that company. |
|
Title: Re: BKICMSTR Table after 2/14/07 update Post by rvallier on 02/23/07 at 13:14:34 Kevin, I just tried this - renaming the FILE.DDF in my Default folder where my BXX files are to File-old.ddf and reran ODBCDDF - I still get the same error - Btrieve Error - V:\Default\File.ddf - 5. You wrote below to use ODBCDDF.RUN - when I type that in I am told I do not have this program. Are these two different actions? Robin |
|
Title: Re: BKICMSTR Table after 2/14/07 update Post by kevind on 02/23/07 at 13:30:46 No, they are the same ... the actual filename is ODBCDDF.RUN ... Sorry about that. Can anyone that has installed the latest ISTECH update confirm if ODBCDDF is working correctly? |
|
Title: Re: BKICMSTR Table after 2/14/07 update Post by tdlugosh on 03/16/07 at 16:24:46 I can. Ran the update and it trashed one of the indexes in the BKIC_MSTR. Ran the Pervasive Rebuild utility at Lynn's suggestion then the ODBCDDF.run and it solved the the index corruption and our Access ODBC link. John |
|
ISTech Support Forum » Powered by YaBB 2.1! YaBB © 2000-2005. All Rights Reserved. |