Skip to Content
avatar image
Former Member

CR 2008 SQL Connection Fails


Using Crystal Reports 2008, connecting to SQL 2008 R2.  Trying to produce the report at runtime and export to .pdf format.  The export has worked flawlessly using a dsn conneciton from the web front end to the database.  I'm tyring to change it to a dsn less connection and no matter what I try the "database login failed" message comes up.  Here is my code (in the attached text file).  Any thoughts?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jan 02, 2015 at 07:22 PM

    Hi Robert,

    Try hardcoding all of the values first to make sure it does work, then use variables to build the connection string.

    Don

    Add comment
    10|10000 characters needed characters exceeded