Skip to Content
avatar image
Former Member

Crystal Reports 2016 - ODBC connection seems good but...

The ODBC connections test successfully...but it seems to connect to just one DB and I cannot switch it to another, it used to prompt (this is a new pc install and I know very little about CR. Thank you in advance!

Kim

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Nov 28, 2017 at 07:11 PM

    Hi Kim,

    If they are doing this in Crystal Reports, they need to go to Database | Change Datasource Location. They will need to make a new connection to the new database and have the report use that.

    Simply changing the connection information won't work.

    Good luck,

    Brian

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Kim,

      What database are they using?

      If they created a new report and saved it, do you know if they are able to change databases on it?

      It's strange that the report can't do a Set Datasource properly. But I've had cases where something in the report was stuck and I only found a way around it by starting from scratch. So strange is not an uncommon occurrence.

      Good luck,

      Brian

  • avatar image
    Former Member
    Nov 28, 2017 at 04:44 PM

    more information: they pull a report and then they open a report for a different DB and when they select to refresh the data a prompt comes up requesting a password - this is where the user changes the port number and DB name and therefore it then grabs data from a different database. this is using it incorrectly but it justifies the means so the question for this user is how do I make it prompt for a password for each database? it must be possible...anyone please??

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 30, 2017 at 12:17 AM

    Hi Kim,

    If you can, would you consider using OLE DB with your data source to replace the ODBC connection?

    Here's a video which can walk you through the process: https://www.youtube.com/watch?v=9KbvKQ5WOMc&t=127s

    I hope that helps.

    Edwin

    Add comment
    10|10000 characters needed characters exceeded