Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

StoredProcParam

Status
Not open for further replies.
isotope508

isotope508

Programmer
Dec 16, 2001
2
PH
hi there! i would like to ask on how to use an SQL statement stored in access 97 which accepts 2 params. i am still using crystal reports 4.5 on vb6. i have difficulty in the LogOnServer method, should i use this? please give some code samples.
also, are there other means of generating reports using parameter passing on sql using vb6?
thanks!Ü
 
Sort by date Sort by votes
You don't need to use .LogonServer for Access. Just open the report in VB.
 
Upvote 0 Downvote
Also, if I remember correctly, when you are designing the report, you must choose ODBC as your data source. You cannot choose Data File / then your .MDB database. It will not see a parameterized query as a data source.
 
Upvote 0 Downvote
i already used odbc connection, but i still get the error message "Runtime error 20527: SQL server error" when the Action property of crystal reports gets executed. i have 2 parameters (of date type) in the stored sql procedure in access dbase.
what whould be the possible solution/s here?
thanks.
 
Upvote 0 Downvote
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top