Print Page | Close Window

User ID & Password needed?

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22188
Printed Date: 28 Mar 2024 at 10:30pm


Topic: User ID & Password needed?
Posted By: baysidegirl
Subject: User ID & Password needed?
Date Posted: 11 Jan 2017 at 3:41am
I am new to Crystal and am using VFP7 data.
I had no trouble connecting to the VFP container and using the tables - with NO entry of User ID or Password. But now I need to use a standalone table and am unable to do so because I have NO idea what User ID or Password it wants or how to 'turn off' this prompt.

Please HELP!



Replies:
Posted By: kevlray
Date Posted: 11 Jan 2017 at 4:04am
I have never heard of  VFP7 (Visual Fox Pro?). You are connecting to a database and thus there normally is a user id and password for it (but many times when I am accessing MS-Access databases there is none).  But the login screen will pop up anyhow.


Posted By: baysidegirl
Date Posted: 11 Jan 2017 at 4:12am
Yes, using Visual FoxPro 7
The table I am trying to access is a free table - NOT within a database container.

If there is NO User ID or Password associated with the free table, how do I get Crystal to access it?


Posted By: kevlray
Date Posted: 11 Jan 2017 at 7:46am
Don't know.  Normally (at least with MS-Access) if you just hit ok (I think it is ok) at the login screen then it should connect even though you have not put in a user id or password.  I do not have any Visual FoxPro databases around anymore to test with.


Posted By: baysidegirl
Date Posted: 11 Jan 2017 at 7:57am
Thanks for trying!
The weird thing is that only 4 months ago I did just that for a different free table. It worked fine and it is still showing as available to use in reports.
But for some odd reason I can NOT add any connections now.
I have not changed OS or workstation - so I can not imagine what is going on.
I am so frustrated!
Wondering if maybe a dll has become corrupted or needs updating. I have read some odd problems have been resolved by re-installing a dll. When reviewing the properties on the free table that is connected and working, the database DLL stated is
crdb_p2bxbs.dll
Any suggestions on where I can safely download a new copy of this dll or do you think this would be a waste of time?


Posted By: kevlray
Date Posted: 11 Jan 2017 at 12:34pm
I have no idea anymore.  I have not worked VFP in years.  I trying to remember if there was Crystal Reports native driver that would work.


Posted By: hilfy
Date Posted: 13 Jan 2017 at 4:29am
Which version of Crystal are you using? Have you upgraded your OS in that four months? What OS are you using? That might be causing this problem as there are some differences in how the db drivers work.

-Dell

-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics


Posted By: baysidegirl
Date Posted: 13 Jan 2017 at 4:37am
I have been given an new urgent project to work on - so I guess this will need to wait a while.
I will be back in touch



Print Page | Close Window