SQL Connections and Running Scripts

[mihai.petcu]

Hello,

As far as I know, to run an SQL statement you would have to already be connected to an SQL Server using some credentials. The issue you described involves the installer cannot connect to an SQL Server with the given credentials.
If I am mistaken, can you please specify what is the statement you used to connect to an SQL Server with the same credentials?

In my last post, I suggested an SQL Management tool like the one from the following article:
http://msdn.microsoft.com/en-us/library/ms174173.aspx

The idea is to assure that with the credentials used in the installer, you can connect to the SQL Server using another tool, thus they are correct.

All the best,
Mihai

[proactis]

Any ideas why this won't work from the errors that I have posted?

[Bogdan]

Hi,

I'm afraid we don't know what is happening on your machine. In earlier post you said you managed to connect to your using an sql statement.
Can you please specify what is the statement you used to connect to an SQL Server with the same credentials?

Regards,
Bogdan

[navya]

Hi,
my requirement is, when i install my application it need to connect with oracle DB and store the installation script in it.
I am done with my application front part, but i am unable to connect to Database,
please help me out with exact procedure ,How to create inf files for driver or get inf files

[navya]

Hi,

[navya]

Please can any help me out how to connect to Oracle Database in advanced installer,
1. i created Sql Connection Dig in Dialog box
2. In ODBC
a) i added driver OBDC32.dll file
Driver Name: ODBC DRIVER
File: APPDIR\odbc\odbc32.dll
Set Up File: APPDIR\odbc\odbc32.dll

b)I added Data Source
Name:ODBC
Driver Name:ODBC DRIVER
Registration: User
c)Translator
Translator Name: ODBC
File: APPDIR\odbc\odbc32.dll
Set Up File: APPDIR\odbc\odbc32.dll
then when i build and run the application i am getting the following error

[mihai.petcu]

Hello and welcome to Advanced Installer forums,

Have you followed this user guide article before trying to implement the functionality into your main project?

All the best,
Mihai

[navya]

Hi,

Can any one please help be to solve the above issue. i am getting the above error

[navya]

Hi,

Ya i am using the user guide, i am following each and every step of it

[mihai.petcu]

Hello,

Can you please send us the .AIP ( project file ) and a verbose log of the installation to support at advancedinstaller dot com so we can investigate them?

All the best,
Mihai

[navya]

Hi,

I am very new to advanced installer, can u please suggest me what project type should i take ,to develop .exe file for my( flex4.0+spring+java) application.
FROM PAST 1WEEK I AM STRUGGLING WITH IT.

[mihai.petcu]

Hello,

Here's the tutorial for authoring a java product installation. You can easily set the Spring theme for this type of package.

Also, if your application requires Flash Player, you can add it as a prerequisite:
http://www.advancedinstaller.com/user-g ... requisites

All the best,
Mihai

[navya]

Hi Mihal,
My Package has Database Credentials, how can i set my temporary Database in Set Up, Please let me know about it.
I am following user Guide, to Connect to driver it is asking me for INF files, what are driver inf files and where they are located in server, and which ddl file do we upload in application for oracle 10g

[navya]

Hi,

Can any 1 please tell me how my (flex+java)application communicates with database, do i need to set any environment variables for any XML files, please tell me"step by step". presently my application is in Tomcat, do i need to add tomcat folder for it. i am clueless

[mihai.petcu]

Hello,

Can you please send us the .AIP ( project file ) and a verbose log of the installation to support at advancedinstaller dot com so we can investigate them?

All the best,
Mihai