Information générale
Catégorie:
Crystal Reports
Titre:
Logon to SQL Server from VFP passing info to crystal reports
I created a system DSN ODBC connection to SQL Server using SQL server authentication. When I test the the connection it says it is successful.
When I try to connect to the server to pass crystal reports the parameters
I get an error "20599 Cannot open SQL Server". I know it must be authentication related because it works when I set the dsn connection to use windows authentication.
I am using the following code
OLECONTROL1=CREATEOBJECT("Crystal.CrystalReport")
I know I have to pass crystal the SQL login name and password but I cannot figure out which method to use and also what syntax to use ?
Thanks For Your Help !
Stephen J. Hunt
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement