Welcome, Guest. Please Login.
04/29/24 at 17:10:12
News:
Home Help Search Login


Pages: 1
Send Topic Print
connection to default data (Read 2161 times)
cathyh
Active Member
*****


I used to be
indecisive; now I'm
not so sure......

Posts: 1213
Gender: female
connection to default data
10/27/04 at 13:44:34
 
I was trying to look at password data ( see another thread under TAS EVO) and found that the data exists only in the default company, not my WG company that we use.  I made an ODBC connection to the data but came up with no files when I connected in excel.  I assume this is a problem with DDF files.  I assumed they were already there.  How do I get them?
Back to top
 
 

Cathy Hamilton
Wing Inflatables, Inc.
EVO-ERP2008.1(20 users) w/IS Tech update 5/25/09 (as of 08/21/09)
Windows 2008 Server/client
Pervasive V10.1
Email WWW   IP Logged
aricon
Active Member
*****


Systems
Consulting-See
website for
products!

Posts: 1283
Gender: male
Re: connection to default data
Reply #1 - 10/27/04 at 14:06:00
 
UT-A, Program name: ODBCDDF. This creats the DDF files for all of the OTHER companies. Then you need to set up a seperate ODBC connection to go to each compnay you want to connect to.
Back to top
 
 

Sincerely,

Lorne Rogers
President
Aria Consulting & Implementers Ltd.
Phone: (780) 471-1430
Fax: (780) 471-4918
E-mail: lrogers@ariaconsulting.net
Email WWW   IP Logged
cathyh
Active Member
*****


I used to be
indecisive; now I'm
not so sure......

Posts: 1213
Gender: female
Re: connection to default data
Reply #2 - 10/27/04 at 14:22:55
 
Do you mean by OTHER all the companies except default?  My "problem" is that the BKSLEVEL and BKSYUSER  only exist in the default (B) and the demo(B99) company.  There are no files with the extension BWG.  So to look at these I need DDF's for the default.  Do these exist or can I make them with ODBCDDF?
Back to top
 
 

Cathy Hamilton
Wing Inflatables, Inc.
EVO-ERP2008.1(20 users) w/IS Tech update 5/25/09 (as of 08/21/09)
Windows 2008 Server/client
Pervasive V10.1
Email WWW   IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5681
Re: connection to default data
Reply #3 - 10/27/04 at 14:54:03
 
The password files only need to exist in the default company.  Regardless which company you are in, the password restrictions come from the Default company.
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
cathyh
Active Member
*****


I used to be
indecisive; now I'm
not so sure......

Posts: 1213
Gender: female
Re: connection to default data
Reply #4 - 10/29/04 at 10:40:04
 
I guess that is my problem.  When using Access to link to a table in my company, the tables are not there because they reside in the default company.  I have established an odbc connection to the default company, but I don't see any data files to choose.  What if anything do I do next?
Back to top
 
 

Cathy Hamilton
Wing Inflatables, Inc.
EVO-ERP2008.1(20 users) w/IS Tech update 5/25/09 (as of 08/21/09)
Windows 2008 Server/client
Pervasive V10.1
Email WWW   IP Logged
aricon
Active Member
*****


Systems
Consulting-See
website for
products!

Posts: 1283
Gender: male
Re: connection to default data
Reply #5 - 10/29/04 at 10:46:30
 
If you don't see the table names when you try to create either a new link or import, then there is something wrong with your ODBC connection. You did not set it up correctly.
Back to top
 
 

Sincerely,

Lorne Rogers
President
Aria Consulting & Implementers Ltd.
Phone: (780) 471-1430
Fax: (780) 471-4918
E-mail: lrogers@ariaconsulting.net
Email WWW   IP Logged
cathyh
Active Member
*****


I used to be
indecisive; now I'm
not so sure......

Posts: 1213
Gender: female
Re: connection to default data
Reply #6 - 10/29/04 at 11:13:59
 
Well, I am connecting to Default Db which is the only choice besides DemoData other than my company and my test company. The Default Company  is set up in ODBC just like my other company data and it works fine.  I even went to the default company and ran the odbcddf program.  Nothing changed.  When I try an excel query, it says the data source contains no visible tables.  If I look in Maintain database, I can see that most of the files have no records. Still,  I must be connected to the wrong data but I have looked on the server and default database is named Default DB.  I am stumped.
Back to top
 
 

Cathy Hamilton
Wing Inflatables, Inc.
EVO-ERP2008.1(20 users) w/IS Tech update 5/25/09 (as of 08/21/09)
Windows 2008 Server/client
Pervasive V10.1
Email WWW   IP Logged
cathyh
Active Member
*****


I used to be
indecisive; now I'm
not so sure......

Posts: 1213
Gender: female
Re: connection to default data
Reply #7 - 10/29/04 at 11:36:57
 
Nevermind, of course you were right, Lorne.  I redid the ODBC engine and though it's a mystery how I had set it up, when I set it up again it worked.  I think I was not pointing correctly to the default company ddf's.
Of course the whole point of this exercise is moot since the data I want isn't going to make any sense anyway.  Thanks for all your input, Lorne! Smiley
Back to top
 
 

Cathy Hamilton
Wing Inflatables, Inc.
EVO-ERP2008.1(20 users) w/IS Tech update 5/25/09 (as of 08/21/09)
Windows 2008 Server/client
Pervasive V10.1
Email WWW   IP Logged
Pages: 1
Send Topic Print