crystal report connect to database SQL Server
Please help me how to crystal report connect to database(SQL Server) within code Visual Basic.
Thanks!
Re: please help me...hot...
Refer
cr.LogonServer (dllName$, ServerName$, DatabaseName$, UserID$, Password$)
Quote:
Originally posted by thienloclt
Please help me how to crystal report connect to database (SQL Server) within code Visual Basic.
Ex:
in MS Access:
crCommon.LogonInfo(0)= "dsn=;uid=;pwd=madras;dsq="
crCommon.DataFiles(0)= "C:\Mydata.mdb"
in SQL Server?
crCommon.LogonInfo(0)= ?
crCommon.DataFiles(0)= ?
Login info:
Server name: THIENLOC
Database name: PAYROLL
UserID: sa
Password:
Thanks!
Re: crystal report connect to database SQL Server
Logs on to a SQL server.
Usage
[form.]Report.Connect[= Name;UserID;Password;DatabaseQualifier$]
For example:
Report1.Connect = "DSN = Accounting;UID = 734;PWD = bigboard;DSQ = Administration"
Quote:
Originally posted by thienloclt
Please help me how to crystal report connect to database(SQL Server) within code Visual Basic.
Thanks!
Text into Crystal Reports Page/Report Header
Hello Babu,
I was wondering if there is a way that I could type in some text in VB 6.0 and post that data from a Textbox into a field or label in a Crystal Reports Page/Report Header?
Thanks,
John-