ISTech Support Forum - Pervasive and ODBC requiring password

PamB

Browser

Posts: 21

Pervasive and ODBC requiring password
04/29/08 at 10:16:42

I am a newbie, and our company is using the old version of DBA.

I'm trying to connect to the DBA tables either via Pervasive or ODBC. I can get to the point where I can see the tables, but then I am being asked for a password. No one here knows of any password, and I've tried the normal Admin stuff. Is there a generic password, or a way around this?

My IT guy can't figure it out either.

Any suggestions?

Thanks,
PamB

Back to top

Pam Bailey
Star Engineering

DBA Classic Version 2004.1 x 10 users
Client/Server
Pervasive Version 8.5

IP Logged

JDlugosh Browser Posts: 25 Gender:	Re: Pervasive and ODBC requiring password Reply #1 - 04/29/08 at 13:04:24 Pervasive OBDC sometimes requires the server Administrator name and server Admin password in order to connect.
Back to top	John Dlugosh Dlugosh Cabinet & Fixture Inc. EVO Current Update 7 Regular 5 D.C. Users W2k3 servers + T.S. x64 Pervasive 9.x 20 Users IP Logged

kevind

Active Member

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

Posts: 639
Gender: male

Re: Pervasive and ODBC requiring password
Reply #2 - 04/29/08 at 13:13:23

Quote:

... our company is using the old version of DBA

1. What Version of the Pervasive Database software are you using?

2. Is it the Client/Server or Workstation product?

3. Are you using the DDF files created by ODBCDDF (off menu) utility for your ODBC data source?

The DDF files created by ODBCDDF do not have security enabled by default for Pervasive 2000 and up.

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

IP Logged

PamB

Browser

Posts: 21

Re: Pervasive and ODBC requiring password
Reply #3 - 04/30/08 at 12:05:23

Hello,
Here is are the answers to your questions:

1. What Version of the Pervasive Database software are you using? Version 9.5

2. Is it the Client/Server or Workstation product? Client/Server

3. Are you using the DDF files created by ODBCDDF (off menu) utility for your ODBC data source? I want to use ODBC data source (live) so I can get into the tables if I need to.

Thank You for your help!
Pam

Back to top

Pam Bailey
Star Engineering

DBA Classic Version 2004.1 x 10 users
Client/Server
Pervasive Version 8.5

IP Logged

PamB Browser Posts: 21	Re: Pervasive and ODBC requiring password Reply #4 - 05/01/08 at 07:13:33 hI, whoops! Our version of Pervasive is actually 8.5. thanks, Pam
Back to top	Pam Bailey Star Engineering DBA Classic Version 2004.1 x 10 users Client/Server Pervasive Version 8.5 IP Logged

kevind

Active Member

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

Posts: 639
Gender: male

Re: Pervasive and ODBC requiring password
Reply #5 - 05/01/08 at 07:27:45

Check out THIS thread. It provides instructions to create an ODBC data source with the Client/Server Pervasive.

There my be some minor differences between it and your version 8.5, but they should be minor.

The basic process to create an ODBC data source is:
1. Run ODBCDDF from DBA. (in Classic, use UT-A, and enter ODBCDDF as the program to run)
2. Create an Engine ODBC data source on the server that points to the newly created DDF files
3. Create a Client ODBC data source on the Client Machine that points to the Engine data source created above

I hope this helps.

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

IP Logged

PamB Browser Posts: 21	Re: Pervasive and ODBC requiring password Reply #6 - 05/01/08 at 11:17:10 Thank you so much for all of your help! I'm running the ODBCDDF, and I'm getting a BTRIEVE warning error on all files it's going through- is this normal? thanks, Pam
Back to top	Pam Bailey Star Engineering DBA Classic Version 2004.1 x 10 users Client/Server Pervasive Version 8.5 IP Logged

kevind Active Member I was more than willing to "pony up", how b'out U? Posts: 639 Gender:	Re: Pervasive and ODBC requiring password Reply #7 - 05/01/08 at 13:41:32 What does the error say? (Please consider setting up a Signature (similar to mine below) with your DBA and Pervasive Version information. This really helps people help each other.)
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 IP Logged

PamB Browser Posts: 21	Re: Pervasive and ODBC requiring password Reply #8 - 05/06/08 at 06:53:44 Hello, I have added my signature below, please let me know if I need to include any more information. The error message I receive is M:\Dbamfg\DEFAULT\FILE.DDF-46 I get an error message for each file the program is trying to access, so I have to keep pressing enter until the whole job is complete. Thanks, Pam
Back to top	Pam Bailey Star Engineering DBA Classic Version 2004.1 x 10 users Client/Server Pervasive Version 8.5 IP Logged

kevind

Active Member

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

Posts: 639
Gender: male

Re: Pervasive and ODBC requiring password
Reply #9 - 05/06/08 at 07:55:01

Pam,
I have never seen any error messages when running ODBCDDF. It looks like it cannot write to the DDF files in the DEFAULT folder. Try removing all ODBC data sources you have defined that are pointing to the M:\Dbamfg\DEFAULT folder. If something
else is using the DDF files, ODBCDDF will not be able to write to them.

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

IP Logged

kkmfg Senior Member Ghost of the code Posts: 411 Gender:	Re: Pervasive and ODBC requiring password Reply #10 - 05/06/08 at 07:59:58 Error 46 means that access to the requested file was denied. I think that KevinD is correct. Remove all ODBC data sources that refer to your DBA installation. Maybe even reboot for good measure. Then try to create the DDF files again.
Back to top	Collin K & K Manufacturing, Inc EvoERP Version 1-22-10 SP3 5 User Workgroup Pervasive 10 IP Logged