Results 1 to 4 of 4

Thread: Error in crystal reports

  1. Jun 29th, 2009, 02:05 AM #1
    shukla
    shukla is offline

    Thread Starter
    Fanatic Member
    Join Date
    Jul 2006
    Location
    nasik,india
    Posts
    909

    Error in crystal reports

    Hi .
    I was using access as my backend.
    Now i am switching to sql server 2005.
    Now my crystal report is linked with datasource.
    I have just changed my dsn for sql server.

    But while loading crystal report,its giving me error as

    Logon Failed.
    "Details 28000:[Microsoft][ODBC Sql server driver][SQL server]Login failed for user 'sa'.
    WHETHER YOU SUCCEED OR FAIL IS NOT AS IMPORTANT AS WHETHER YOU TRIED YOUR BEST
    Reply With Quote Reply With Quote
  2. Jul 24th, 2009, 01:19 AM #2
    shukla
    shukla is offline

    Thread Starter
    Fanatic Member
    Join Date
    Jul 2006
    Location
    nasik,india
    Posts
    909

    Re: Error in crystal reports

    can anybody tell me solution ?
    WHETHER YOU SUCCEED OR FAIL IS NOT AS IMPORTANT AS WHETHER YOU TRIED YOUR BEST
    Reply With Quote Reply With Quote
  3. Jul 26th, 2009, 11:33 PM #3
    jggtz
    jggtz is offline
    Frenzied Member
    Join Date
    May 2006
    Location
    some place in the cloud
    Posts
    1,886

    Re: Error in crystal reports

    Say Crystal Reports version and post the code, if you're using an app to load the rpt
    Reply With Quote Reply With Quote
  4. Aug 1st, 2009, 05:49 AM #4
    jepperly
    jepperly is offline
    Junior Member
    Join Date
    Jul 2007
    Posts
    25

    Re: Error in crystal reports

    For x = 1 To Report.Database.Tables.Count
    Report.Database.Tables(x).ConnectionProperties("user id") = "userid"
    Report.Database.Tables(x).ConnectionProperties("password") = "password"
    Next x

    this is for VB6 using crystal report
    Last edited by jepperly; Aug 1st, 2009 at 06:03 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width