Welcome, Guest. Please Login.
05/06/24 at 16:39:56
News:
Home Help Search Login


Pages: 1
Send Topic Print
CR11 can't get off the ground (Read 1340 times)
Dawn
Full Member
***


I love YaBB 1G -
SP1!

Posts: 156
Gender: female
CR11 can't get off the ground
10/16/07 at 07:41:23
 
We just got CR11 and I'm starting to play around with it.  I keep getting errors "Failed to retrieve data from database"  or "Btrieve error status: 3032".  I'm not sure waht I'm doing wrong.  I wanted to try something simple like list all our customers and addresses.  I used BKARCUST.B and sort by state.  Then I get the error messages.  I also noticed that my list under "Available Data Source" is missing lots of files.  Currently it only lists 34 .B files and I know there is alot more than that.  The GL are not even listed.   It is currently looking at a database called I:\DBAMFG\INDEX.DDF.  When I look at I:\DBAMFG file it looks like my actual data is in a file called DEFAULT not INDEX.DDF.  Is that right?  How do I fix this.  I can't even get off the ground yet to see any actual data to play with.  Help - completely new at this. cry
Back to top
 
 

Dawn
Classic - 7/5/10 update
WWW   IP Logged
David Waldmann
Active Member
*****


Live to work, or
work to live?

Posts: 1924
Gender: male
Re: CR11 can't get off the ground
Reply #1 - 10/16/07 at 09:37:26
 
I would suggest using ODBC to connect to the data. There are three steps you need to do:
 
Create the ODBC compliant DDFs
Create an ODBC System DSN on your server
Create an ODBC User DSN on any workstation that will use CR
 
There are probably some previous posts that will help you set these up if you're not familiar with ODBC. If you can't figure it, out give a shout.
Back to top
 
 

David N Waldmann
President
Vermont Hardwoods
Chester, VT

Evo-ERP, 5 user
IST Build: 3/4/19, patched 04/30/19
Pervasive v11.31
Server 2012 / Win10 x64
Crystal Reports v11
Email WWW   IP Logged
Dawn
Full Member
***


I love YaBB 1G -
SP1!

Posts: 156
Gender: female
Re: CR11 can't get off the ground
Reply #2 - 10/16/07 at 11:51:21
 
I think I got it.  I ran UT-J and now I have WAY more than 34 files to choose from. Cheesy  Nothing like going from one extreme to another.  Now to sort thru it all.  I know there was talk in the past about getting an updated list of the data files with descriptions it that still going on or has it fallen thru.  Maybe this could get brought up at the symosium next week.
Back to top
 
 

Dawn
Classic - 7/5/10 update
WWW   IP Logged
David Waldmann
Active Member
*****


Live to work, or
work to live?

Posts: 1924
Gender: male
Re: CR11 can't get off the ground
Reply #3 - 10/17/07 at 05:36:43
 
Quote from Dawn on 10/16/07 at 11:51:21:
I ran UT-J and now I have WAY more than 34 files to choose from.

 
Yes, you probably have all the files from every company. If you use ODBC you can/should have one set for each company - much easier to find what you're looking for. ODBC compliant DDFs are created using ODBCDDF (including .RUN if in Evo) in UT-A.
Back to top
 
 

David N Waldmann
President
Vermont Hardwoods
Chester, VT

Evo-ERP, 5 user
IST Build: 3/4/19, patched 04/30/19
Pervasive v11.31
Server 2012 / Win10 x64
Crystal Reports v11
Email WWW   IP Logged
David Waldmann
Active Member
*****


Live to work, or
work to live?

Posts: 1924
Gender: male
Re: CR11 can't get off the ground
Reply #4 - 10/17/07 at 05:40:17
 
Quote from Dawn on 10/16/07 at 11:51:21:
Now to sort thru it all.

 
It's not complete, but there is a spreadsheet available somewhere on the IS Tech Support site that has a list of files, fields and descriptions.
 
Also, Help > File Names is a quick reference that may be helpful.
 
Lastly, if you have the source code readily available you can sometimes use that to figure out what files/fields are being used by a particular program.
 
As you mentioned, the caveat with any of the methods I mention is that they are not up to date. So if you are, you may be out of luck on some items.
Back to top
 
 

David N Waldmann
President
Vermont Hardwoods
Chester, VT

Evo-ERP, 5 user
IST Build: 3/4/19, patched 04/30/19
Pervasive v11.31
Server 2012 / Win10 x64
Crystal Reports v11
Email WWW   IP Logged
GasGiant
Administrator
*****


How can I help?

Posts: 1523
Gender: male
Re: CR11 can't get off the ground
Reply #5 - 10/17/07 at 05:55:39
 
You are always welcome to ask here for help on which field is for what. I'm up-to-date and use many of the new files, as well as the old. JEMM and Novazyg will answer, too.
Back to top
 
 


Email WWW GasGiant GasGiant 31012781 swordworlder swordworlder   IP Logged
Pages: 1
Send Topic Print