check the powerpoint presentation and streaming media on this link:
http://support.microsoft.com/default.aspx?scid=kb;en-us;324972#appliesto
i hope this helps.
gus121,
TRY THIS TO ASSIGN VALUE TO PARAMETERS B4 EXECUTE.
cmd.Parameters("@CategoryID") = INTEGER VALUE HERE
cmd.Parameters("@SectionID") = INTEGER VALUE HERE
cmd.Parameters("@SectionMask") = INTEGER VALUE HERE
i think you should check these articles:
http://msexchange.org/tutorials/Configuring-Mobile-Devices-Exchange2003.html
http://msexchange.org/tutorials/Managing-Mobile-Access-Exchange-Server-2003.html
http://msexchange.org/tutorials/OMA_Exchange_Server_2003.html
i have successfully run an exchange 2003 server. i can send and receive emails. but i'd like to be able to send about 30mb file size attached to my email. right now i can't send a large file. anyone knows how to adjust the send message size limit? thanks.
if you use ADO connection in your report it works. it works for me even if switch from one server to another. just use ini file if you like to change server at run time.
i did not try the test connectivity. just try to use it.
the error is in the setlogoninfo.
you can use report.Database.Tables(i).SetLogOnInfo "connection string"
or
report.Database.Tables(i).SetLogOnInfo
"Provider=SQLOLEDB.1;Persist Security Info=True;Data Source=Service Desk", "ovsd4", "system"...
do this in VB:
Private crxAppl As CRAXDRT.Application
Private crxReport As CRAXDRT.Report
Private Sub OpenReport()
Set crxAppl = New CRAXDRT.Application
Set crxReport = crxAppl.OpenReport(App.Path & "\rptSample.rpt")
crxReport.DiscardSavedData
For i = 1 To...
use setlogoninfo to change sqlserver. when using setlogoninfo make sure that you will specify the sqloledb provider together with the server name in the server name parameter. it works for me since i have switch server when i deploy the program to the live data server.
if you will use setprivatedata, do it like this:
craxReport.Database.Tables.Item(i).SetPrivateData 3, rsData
where i is your table's index in the Report & rsData is your adodb.recordset to pass. dont change 3, its a default value. craxReport is a craxdrt report.
if you will use...
if you are using ado connection, you can pass your recordset from vb to your crystal report, use setprivatedata method of your crystal report component.
use the sqloledb provider in your connection string.
are you using odbc connection? if you are, use CrystalReport1.SQLQuery = "write your sql string here with the table name you like to pass"
like this:
CrystalReport1.SQLQuery = "SELECT
PEPHR0303."LastName", PEPHR0303."FirstName", PEPHR0303."MI"...
open your report in crystal and goto database in the menu & select visual linking expert. link the tables to their respective fields. right click the link & select option then in the join type select the left outer join then click ok. your table is now joined.
try this code snippet...
crxReport.Database.SetDataSource rsSample1, 3, 1
crxReport.Database.SetDataSource rsSample2, 3, 2
crxReport.ReadRecords
rsSample1 & rsSample2 are ADODB.recorset. number 3 is default dont change that. 1 & 2 are the index of the tables in your report.
i hope this...
if you don't like to use ODBC in your report you have to use ADO connection. to do that open crystal then logonserver then select Active Data(ADO) on the server type.
then select ado or ole connectionstring & enter your connection string: connection string is like this...
save then login name & password in your ODBC DSN. goto your DataSources(ODBC) in the control panel. select your DSN in ODBC & click configure button. then click advance button. then enter your login name & password in the respective entry & click ok button. then exit on the ODBC setup.
i hope...
hi! does anyone knows how to use the crystalreport1.logonserver method in VB when using access database. i am using a ADO connection in my report. my connection string is
Provider=MSDASQL.1;Password=poweruser;Persist Security Info=True;User ID=admin;Extended Properties=DSN=MS Access...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.