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!

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

Search results for query: *

  1. shokti

    Publishing an SQL2000 server - opening ports

    how about creating an IP packet filter rule on the ports?
  2. shokti

    DMZ NAT

    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.
  3. shokti

    Problem with Stored Procedure in SQL 2000, ASP

    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
  4. shokti

    Web Mail access Question (VersaMail) ??

    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
  5. shokti

    how to change send size limit

    thanks for the reply. i already solved the problem.
  6. shokti

    how to change send size limit

    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.
  7. shokti

    VB & Server has not yet been opened

    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.
  8. shokti

    VB & Server has not yet been opened

    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&quot...
  9. shokti

    Connect to SQL Server without DSN

    i am using different server and it works fine, just change the connection string in the .SetLogOnInfo. it works for me
  10. shokti

    Connect to SQL Server without DSN

    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...
  11. shokti

    Crystal Reports - data joining

    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.
  12. shokti

    Set DataSource Location Problem

    i believe you can achieve the same thing by using SetLogonInfo. i can switch to differrent sql server using SetLogonInfo.
  13. shokti

    New to Creating Report from an SQL Database

    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...
  14. shokti

    New to Creating Report from an SQL Database

    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.
  15. shokti

    Multiple tables, one report

    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&quot...
  16. shokti

    How to do a FULL OUTER JOIN?

    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.
  17. shokti

    How to pass two recordsets for a report/subreport?

    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...
  18. shokti

    Connect to SQL Server without DSN

    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...
  19. shokti

    Microsoft Access?

    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...
  20. shokti

    how to crystalreport1.logonserver when using access database

    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...

Part and Inventory Search

Back
Top