jstuardo
Posts: 87
Joined: Mon Nov 09, 2015 10:44 pm

"Changed database context" error

Hello,

I have this SQLServer Dialog:

SQLServer_AI_6.png
SQLServer_AI_6.png (72.72 KiB) Viewed 1936 times

When I press "Next" button, TestODBCConnection custom action is called, but the same dialog stays. I need to cilck "Next" button again in order to continue with the next dialog in the wizard.

Later, when installing, at Executing Install SQL script stage, a "Change Database Context" error is shown.

SQLServer_AI_7.png
SQLServer_AI_7.png (73.64 KiB) Viewed 1936 times

How can I solve it?

I am attaching the project file as well.

By the way, this started happening when I added TestODBCConnection functionality using instructions in this page: https://www.advancedinstaller.com/user- ... ction.html

Regards
Jaime
Attachments
Control de Visitas 3.aip
(92.74 KiB) Downloaded 206 times
Catalin
Posts: 6608
Joined: Wed Jun 13, 2018 7:49 am

Re: "Changed database context" error

Hello Jaime,

I believe we discussed the first part of this thread here:

Bad behaviour when using Test ODBC Connection dialog

In what regards the second part of the thread, that is an SQL Driver predefined message that appears when the working database is changed.

Please have a look on the following thread which I think debates a similar scenario:

SQLExecDirect error message

Hope this helps.

Best regards,
Catalin
Catalin Gheorghe - Advanced Installer Team
Follow us: Twitter - Facebook - YouTube

Return to “Common Problems”