Welcome, Guest. Please Login.
04/25/24 at 00:16:10
News:
Home Help Search Login


Pages: 1
Send Topic Print
Re: Not a Valid Name message BKARCUST file (Read 3266 times)
GasGiant
Administrator
*****


How can I help?

Posts: 1523
Gender: male
Re: Not a Valid Name message BKARCUST file
10/06/09 at 08:46:16
 
The three address lines are bkar_add1, bkar_add2_1, and bkar_add2_2 for ODBC
Back to top
 
 


Email WWW GasGiant GasGiant 31012781 swordworlder swordworlder   IP Logged
Kelloggs
Active Member
*****


Do crazy people know
they are crazy?

Posts: 785
Gender: male
Re: Not a Valid Name message BKARCUST file
Reply #1 - 10/06/09 at 11:10:49
 
Are you trying to import the entire table?
Are you linking the table then using a query to import data?
 
If so, DONT USE any of these methods
 
Use a "Pass-through Query" !!!!!
 
"SELECT BKAR_CUSTCODE, BKAR_ADD1, BKAR_ADD2_1, BKAR_ADD2_2, BKAR_CITY, BKAR_EMAIL_2, BKAR_STATE, BKAR_ZIP, BKAR_CONTACT_2 , BKAR_TELEPHONE_1, BKAR_FAX_PHONE FROM BKARCUST"
 
then use a "Make Table Query" to import data!!!
 
 
 Cool
 
Kelloggs
Back to top
 
 

Evo ERP - 35 Users
Dumped MS Access like a hot potato (VB.Net rules!!!)
Email WWW   IP Logged
Kelloggs
Active Member
*****


Do crazy people know
they are crazy?

Posts: 785
Gender: male
Re: Not a Valid Name message BKARCUST file
Reply #2 - 10/06/09 at 11:34:49
 
Do you know how to create a Pass-through Query?
Back to top
 
 

Evo ERP - 35 Users
Dumped MS Access like a hot potato (VB.Net rules!!!)
Email WWW   IP Logged
Kelloggs
Active Member
*****


Do crazy people know
they are crazy?

Posts: 785
Gender: male
Re: Not a Valid Name message BKARCUST file
Reply #3 - 10/06/09 at 12:21:41
 
You link has a very good "How to", it really shoundnt matter if it is for MS SQL or any other database system.
If your problem continues. IT is your ODBC Connection
 
Try this link
 
http://www.mwaccounting.com/dba/white_paper.htm
 
 
1.- Create a Blank MS Access Database
2.- Goto Insert, then Query, then select "Design View"
3.- On the Show Table window, click Close
4.- Goto View, select "SQL View"
5.- Paste "SELECT BKAR_CUSTCODE, BKAR_ADD1, BKAR_ADD2_1, BKAR_ADD2_2, BKAR_CITY, BKAR_EMAIL_2, BKAR_STATE, BKAR_ZIP, BKAR_CONTACT_2 ,       BKAR_TELEPHONE_1, BKAR_FAX_PHONE FROM BKARCUST" whitout the quotes
6.- Goto Query, select "SQL Specific", then select "Pass-through"
7.- Goto View, then select "Properties" and find the "ODBC Connection Srt" line, select it, then click on the "..."
8.- Select your ODBC Connection then click Yes to save to connection string.
9.- Save the Query
 
Done!!
 
From here you can view the data as  well as import it into ms access using a "Make Table Query"
 
 Tongue
 
Kelloggs
Back to top
 
 

Evo ERP - 35 Users
Dumped MS Access like a hot potato (VB.Net rules!!!)
Email WWW   IP Logged
Kelloggs
Active Member
*****


Do crazy people know
they are crazy?

Posts: 785
Gender: male
Re: Not a Valid Name message BKARCUST file
Reply #4 - 10/06/09 at 12:39:11
 
did you run the "ODBCDDF.RUN" on DBA/EVO?
 
open UT-A
 
see what happens.
 
 embarrassed
Back to top
 
 

Evo ERP - 35 Users
Dumped MS Access like a hot potato (VB.Net rules!!!)
Email WWW   IP Logged
Kelloggs
Active Member
*****


Do crazy people know
they are crazy?

Posts: 785
Gender: male
Re: Not a Valid Name message BKARCUST file
Reply #5 - 10/06/09 at 14:11:48
 
Try This:
 
Goto Control Panel
Open Administrative Tools
Open Data Sources (ODBC)
Select System DSN
Click Add
Select Pervasive ODBC Client Interface
Click Finish
 
Data Source Name: EVO_ACCESS (or whatever you want)
Address: type your name of your server or it's IP
Click on Get DSN List
 
Select the DBA/EVO's Data Source
click Test
 
reconect your ms access query (Connection String)
 
if this doesnt work, I dont know what else could it be.
 
 undecided
 
Kelloggs
 
Back to top
 
 

Evo ERP - 35 Users
Dumped MS Access like a hot potato (VB.Net rules!!!)
Email WWW   IP Logged
GasGiant
Administrator
*****


How can I help?

Posts: 1523
Gender: male
Re: Not a Valid Name message BKARCUST file
Reply #6 - 10/07/09 at 09:01:37
 
When you run the ODBCDDF.RUN it creates field names that are ODBC friendly, including replacing dots with underscores and flattening arrays (e.g. [1], [2]) into additional fields (e.g. _1, _2). So, either there is a problem with ODBCDDF.RUN, which I doubt, or else Access is looking at the wrong set of DDFs.  
 
Where are your .B files located? are they in the Default folder or mixed into the root of the DBAMFG folder? Did you create the database in the Pervasive Control Center and can you see the table and the fields from there? Is the field named with the [1] in there or does it show with the _1 instead? And which version of PSQL are you using, 2000i?
Back to top
 
 


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