EricNguyen
Posts: 21
Joined: Sat Feb 17, 2007 1:58 am

Test ORA connection parameters?

Hi,
In the help file of AI there's a section explains how to test SQL connection parameters and it works perfectly for me.
If I want to test connection to a Oracle 10g database, do I have to include sqora32.dll? and if so then how do I construct the argument?
Or can I use available connection string in Tnsnames.ORA file?

Thanks,
Eric
gigi
Posts: 2103
Joined: Tue Apr 11, 2006 9:55 am
Contact: Website

Hi Eric,
If I want to test connection to a Oracle 10g database, do I have to include sqora32.dll?
No, you don't need this DLL. The connection to the SQL server (Oracle 10g) is made only through an ODBC Driver.

Note that the testing functionality will work only in the case of a pre-existing ODBC driver (because at this stage of the installation the ODBC drivers installed by the package are not available yet).

Regards,
Gigi
______________
Gheorghe Rada
Advanced Installer Team
http://www.advancedinstaller.com
EricNguyen
Posts: 21
Joined: Sat Feb 17, 2007 1:58 am

Gigi,

Normally if I installed Oracle client (e.g. 10g client) then I should have Oracle driver in my PC. Do I have to manually create a DSN to connect to Oracle before I run AI?

As we require several input in SQLConnectionDlg screen, how do these values fit in the parameter of SQLconnection test?

Thanks,
gigi
Posts: 2103
Joined: Tue Apr 11, 2006 9:55 am
Contact: Website

Hi,
Do I have to manually create a DSN to connect to Oracle before I run AI?
No, you don't need to create a DSN.
As we require several input in SQLConnectionDlg screen, how do these values fit in the parameter of SQLconnection test?
For each SQLConnectionDlg screen you have different properties for the edit controls (Server, Port, Username, etc). You need to repeat (with appropriate parameter) the following tutorial for each SQLConnectionDlg screen:
http://www.advancedinstaller.com/user-g ... ction.html

Regards,
Gigi
______________
Gheorghe Rada
Advanced Installer Team
http://www.advancedinstaller.com
EricNguyen
Posts: 21
Joined: Sat Feb 17, 2007 1:58 am

Gigi,

I did not know that I can use the same parameter for both Oracle & SQL server.
For my case, as I'm using Oracle 10g, I put "Oracle in XE" in ODBC resource string together with user & password and it works great for me.
Thanks much for your help.

Eric
EricNguyen
Posts: 21
Joined: Sat Feb 17, 2007 1:58 am

Surprisingly enough, although the TestODBCconnection action can detect (and display error message) if DB user or password is incorrect, next dialog is still brought up....
Not sure what I missed. I followed exactly what explained here http://www.advancedinstaller.com/user-g ... ction.html and added SqlConnectionOK = "1" to NewDialog Event of the next button....
And it happened for both SQL & Oracle connections

Any light?
gigi
Posts: 2103
Joined: Tue Apr 11, 2006 9:55 am
Contact: Website

Hi,

If the next dialog is still shown, this is because the SqlConnectionOK property is always "1". Have you declared this property with "1" as default value.

If this is not the case please sent the AIP file to support at advancedinstaller dot com so we can take a look.

Regards,
Gigi
______________
Gheorghe Rada
Advanced Installer Team
http://www.advancedinstaller.com
EricNguyen
Posts: 21
Joined: Sat Feb 17, 2007 1:58 am

Gigi,

I figured out what happened.
If we put in correct user/pass the first time, sqlConnectionOK will be set as "1" and the value remains unchanged even if we go back to SqlDialog again.
I did enter all the correct information the first time then use "Back" button to go back and try it with incorrect data.... Error message was displayed but next dialog was still brought up because SqlConnectionOK was set to "1" before....
I know it sounds a little bit picky and may not make much sense but I think it'll be great if we could reset the value of sqlConnectionOK everytime we start SQLConnectionDialog...

Eric
gigi
Posts: 2103
Joined: Tue Apr 11, 2006 9:55 am
Contact: Website

Hi Eric,

You are right the "SqlConnectionOK" property must be set to 0 when user select the back button. We will implement this for the next version of AI. Thank you for bringing this to our attention.

Until then under the back button (of the dialog immediately after the "SQLConnectionDlg") add a published event like this:
Name: select SetProperty and type [SqlConnectionOK] in the combobox
Argument: 0

Regards,
Gigi
______________
Gheorghe Rada
Advanced Installer Team
http://www.advancedinstaller.com
EricNguyen
Posts: 21
Joined: Sat Feb 17, 2007 1:58 am

That should be good enough.

Gigi, thanks for the help.

Return to “Common Problems”