Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Need to be able to change the SQL Native Client from v10.0 to 11.0 etc on runtime, otherwise it causes failed login #47

Open
fabian-sta opened this issue May 13, 2021 · 1 comment

Comments

@fabian-sta
Copy link
Collaborator

fabian-sta commented May 13, 2021

We are in the process of migrating to the cloud, new servers etc
I don't want to modify all the existing reports and update SQL Driver - SQL Server Native Client 10.0 and new server is 11.0
I have tested without modifying the report and it fails login, even though it feeds back the correct info.
If I update the DB details in the report it works ok.

Need to be able to change the setting on Runtime.

I have updated the CRExport code to respond with the ACTUAL log on info, rather then what is set in the Parameters
I moved the "_logger.Write..." line into the Loop and changed the returned values to the variable being set.
It now returns the INTERNAL Report DB info if no parameters supplied, or the set info if supplied, see attached snip!
PerformDBLogin .txt

@fabian-sta
Copy link
Collaborator Author

fabian-sta commented May 13, 2021

Error log attached
error.txt

@fabian-sta fabian-sta changed the title Failed Login to DB when you specify the logon info correctly but the DATASOURCE in the Report file is for a different server Need to be able to change the SQL Native Client from v10.0 to 11.0 etc on runtime, otherwise it causes failed login May 18, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant