Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Ken Murphy
  Where is Ken Murphy?
 Springhill
 Canada
 Ken Murphy
 To: yaser awwad
  Where is yaser awwad?
 amman
 Jordan
 yaser awwad
 Tags
Subject: RE: Crystal Reports
Thread ID: 96128 Message ID: 112822 # Views: 2 # Ratings: 0
Version: Visual FoxPro 8 Category: Reports and Printers
Date: Monday, November 13, 2006 2:34:14 PM         
   


> I Check the user account in SQL Enterprise manager,
>
> But How make Can I pass username and password combination
> In Foxpro From Sql To Crystal repot on form
>
> thanks alot


Yaser,

The user's credentials are checked when the connection is created. You can simply leave the user name and password out of the connection string and the user will be asked to enter the user name and password at the time that the connection is made. The other way to handle it is to create a "trustedconnection." This makes use of the user's windows login credentials. (Check out SQLSTRINGCONNECT() in help.)

Once the connection has been made, you can automate CR to produce your report without further need of the login credential.

Ken
You shall know the truth - and the truth shall set you free. (John 8:33)

ENTIRE THREAD

Crystal Reports Posted by yaser awwad @ 5/16/2006 10:17:23 AM
RE: Crystal Reports Posted by William Sanders @ 5/18/2006 12:41:41 AM
RE: Crystal Reports Posted by yaser awwad @ 11/13/2006 12:38:02 PM
RE: Crystal Reports Posted by Ken Murphy @ 11/13/2006 2:34:14 PM