Welcome, Guest. Please Login.
05/03/24 at 12:49:28
News:
Home Help Search Login


ISTech Support Forum › Crystal Reports, ODBC & Access › ODBC General Issues ‹ Previous topic | Next topic ›
Pages: 1
Send Topic Print
ODBC/Access on BKARCUST (Read 1033 times)
fast
Member
**




Posts: 61
Gender: male
ODBC/Access on BKARCUST
02/09/07 at 10:52:10  
Created the source w/ OEM/ANSI conversion box checked
Passed the Test
Generated the DDF's
Opened Access
Get Link
Tried to grab table BKARCUST
 
And got the following error message:
 
 
'BKAR_ADD2[ 1]' is not a calid name.  Make sure that is does not include invalid characters or punctuation and that it is not too long
 
 
I am able to pull in other tables just fine (BKICMSTR/BKAPINVT/BKABEND...).  So it seem to be "working" properly, just not the OEM/ANSI conversion.
 
I have recreated the source a few times via Pervassive Administrator.  I went into Pervassive Control Center and opened the source/table/bkarcust and all the information shows perfectly.  just not via Access on this Table.
 
Any suggestions/thoughts would be great!
Back to top
 
 


  IP Logged
kevind
Active Member
*****


I was more than
willing to
"pony up",
how b'out U?

Posts: 639
Gender: male
Re: ODBC/Access on BKARCUST
Reply #1 - 02/09/07 at 11:34:35  
Make sure that you are using the DDF files in the same folder as the data files.
 
These are the ones created by ODBCDDF that are ODBC Compliant (no illegal field names, etc.).
 
Do not use the DDF files in the main DBAMFG folder.
 
 
 
Back to top
 
 
Kevin Damke
Spectronics Corporation
ISTECH 2004.1 7/26/13 SP1 - 20 user
Evo-ERP Build 7/25/13 T7 -7i R6 - 3 user
(Prev version was 2004.1 10/24/12)
(All Patches Installed as of 7/26/13)
Pervasive 2000i SP4 - Crystal Reports V10
Email WWW   IP Logged
fast
Member
**




Posts: 61
Gender: male
Re: ODBC/Access on BKARCUST
Reply #2 - 02/09/07 at 12:03:55  
Changed it from DBAMFG to DBAMFG/Default...works like a charm.  Much thanks
Back to top
 
 


  IP Logged
Pages: 1
Send Topic Print
ISTech Support Forum › Crystal Reports, ODBC & Access › ODBC General Issues ‹ Previous topic | Next topic ›

ISTech Support Forum » Powered by YaBB 2.1!
YaBB © 2000-2005. All Rights Reserved.

Valid XHTML Valid CSS Powered by Perl Source Forge