Setting up SQL Settings - ODBC Error 8 - Page 2 - Advanced Installer Community

We’re moving our forums to a new platform.

You can still browse and search existing topics, but you can no longer create new topics or post replies.

For questions, technical issues, or feature requests, please don’t hesitate to contact our support team at support@advancedinstaller.com.

Thank you for your understanding!

GabrielBarbu
Posts: 2146
Joined: Thu Jul 09, 2009 11:24 am
Contact: Website

Re: Setting up SQL Settings - ODBC Error 8

Hello,

The SQL configurations should work on all Windows Installer versions 64bit platforms (from 3.1 onwards).

Regards,
Gabriel
Gabriel Barbu
Advanced Installer Team
http://www.advancedinstaller.com/
Codename K
Posts: 479
Joined: Fri Jan 29, 2010 3:04 pm

Re: Setting up SQL Settings - ODBC Error 8

Hello,

Thank you for your support so far. I'll let you know the results soon.

Regards
K
Codename K
Posts: 479
Joined: Fri Jan 29, 2010 3:04 pm

Re: Setting up SQL Settings - ODBC Error 8

Hello Gabriel,

Sorry about the delay in response. But I like to say thank you for your support. The solutions you provided made my MSI installer work 100% correctly without any errors. So thank you again for your help.

Regards

:D :D :D :D :D
K
GabrielBarbu
Posts: 2146
Joined: Thu Jul 09, 2009 11:24 am
Contact: Website

Re: Setting up SQL Settings - ODBC Error 8

Hello,

You are welcome. Glad I could help.

Regards,
Gabriel
Gabriel Barbu
Advanced Installer Team
http://www.advancedinstaller.com/
Codename K
Posts: 479
Joined: Fri Jan 29, 2010 3:04 pm

Re: Setting up SQL Settings - ODBC Error 8

Hello,

I created this post a while ago with few issues I had about running SQL scripts while installing and all the issues were resolved by Advanced Installer support. Thanks for that. The installer worked perfectly.

Now, I created another similar installer same way. And I got the below error message when the SQL script is running while installing,

Code: Select all

SQL_State HY000 can't connect to MySQL server on local host 10061
Regards
K
mihai.petcu
Posts: 3860
Joined: Thu Aug 05, 2010 8:01 am

Re: Setting up SQL Settings - ODBC Error 8

Hello,

I have dealt with a similar issue in this thread. Please follow it and let us know on the outcome.

Regards,
Mihai
Mihai Petcu - Advanced Installer Team
Follow us: Twitter - Facebook - YouTube
Codename K
Posts: 479
Joined: Fri Jan 29, 2010 3:04 pm

Re: Setting up SQL Settings - ODBC Error 8

Hello,

Sorry for the delay in response. I went through the thread and it did not solve the issue.

I like to explain more about the installer I am creating. The installer will first show the "Prerequisite" dialog. It will show the ".NET framework 2.0" and the "SQL Server 2005 Express SP3". There is nothing wrong with .NET framework installation. At the SQL Express installation it runs as follwos with command-line arguments,

Code: Select all

sqlexpr32.EXE
/QB REBOOT=REALLYSUPPRESS ADDLOCAL=ALL INSTANCENAME=CLEARCUTADMIN SAPWD=LInda SECURITYMODE=SQL SQLAUTOSTART=1 DISABLENETWORKPROTOCOLS=0
This creates a new SQL instance CLEARCUTADMIN. This creates the SQL instance while installing it without any issues. After that when the main installation begins it actually installs the ODBC files required. And then executes the SQL connection. This is where the below error occurs,

Code: Select all

{SQL_State HY000} Can't connect to MySQL server on 'localhost' {10061}
I also like to point there is a chained MSi installer in this installer. The chained installer worked fine without the the SQL connection part (I mean I tested the installer without including the SQL connection settings). Below are the SQL values used in the SQL connection,

Server: localhost
Port: 1433
Username: sa
Password: {The password used in the SQL Server installation arguments)
Database: Clearcut


Regards
K
mihai.petcu
Posts: 3860
Joined: Thu Aug 05, 2010 8:01 am

Re: Setting up SQL Settings - ODBC Error 8

Hello,

Can you please specify which of our predefined connection types are you using?
I noticed the error refers to MySql server while you are trying to connect to SQL Server.

Regards,
Mihai
Mihai Petcu - Advanced Installer Team
Follow us: Twitter - Facebook - YouTube
Codename K
Posts: 479
Joined: Fri Jan 29, 2010 3:04 pm

Re: Setting up SQL Settings - ODBC Error 8

Hello,

Until now I used MySQL Server as the predefined connection type. But when you mentioned about it I changed it to Microsoft SQL Server / MSDE. So below are the settings I use now,

Connection Type: Microsoft SQL Server / MSDE
Connection Mode: ODBC Driver
Server: localhost/clearcutadmin
Port: 1433
Username: sa
Password: Linda

And I got the following different error message now when the SQL is executed,

Code: Select all

{SQL_State HY000} Unknown MySQL server host 'localhost/clearcutadmin' {11004}
The Windows Firewall (that's the only one) is turned off.

Regards
K
Codename K
Posts: 479
Joined: Fri Jan 29, 2010 3:04 pm

Re: Setting up SQL Settings - ODBC Error 8

Hello,

Until now I used MySQL Server as the predefined connection type. But when you mentioned about it I changed it to Microsoft SQL Server / MSDE. So below are the settings I use now,

Connection Type: Microsoft SQL Server / MSDE
Connection Mode: ODBC Driver
Server: localhost/clearcutadmin
Port: 1433
Username: sa
Password: Linda

And I got the following different error message now when the SQL is executed,

Code: Select all

{SQL_State HY000} Unknown MySQL server host 'localhost/clearcutadmin' {11004}
The Windows Firewall (that's the only one) is turned off. Moreover, when I give the server name as,

Server: localhost

I get the below error message,

Code: Select all

{SQL_State HY000} Can't connect to MySQL server on 'localhost' {10016}
Regards
K
mihai.petcu
Posts: 3860
Joined: Thu Aug 05, 2010 8:01 am

Re: Setting up SQL Settings - ODBC Error 8

Hi,

I also noticed you are using localhost or localhost/clearcutadmin in your server textfield.
Here is the correct syntax to use instead of localhost and you can try both ways:

Code: Select all

(local)

Code: Select all

(local)\clearcutadmin
or

Code: Select all

.

Code: Select all

.\clearcutadmin
Regards,
Mihai
Mihai Petcu - Advanced Installer Team
Follow us: Twitter - Facebook - YouTube
Codename K
Posts: 479
Joined: Fri Jan 29, 2010 3:04 pm

Re: Setting up SQL Settings - ODBC Error 8

Hello,

I tired all 4 of these methods,

Code: Select all

(local)

Code: Select all

(local)/clearcutadmin

Code: Select all

.

Code: Select all

./clearcutadmin
Yes I got the following errors respectively,

Code: Select all

{SQL_State HY000} Unknown MySQL server host '(local)' {11001}

Code: Select all

{SQL_State HY000} Unknown MySQL server host '(local)/clearcutadmin' {11004}

Code: Select all

{SQL_State HY000} Can't open named pipe to host: . pipe:MySQL (2)

Code: Select all

{SQL_State HY000} Unknown MySQL server host './clearcutadmin' {11001}
Regards
K
mihai.petcu
Posts: 3860
Joined: Thu Aug 05, 2010 8:01 am

Re: Setting up SQL Settings - ODBC Error 8

Hello,

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

Regards,
Mihai
Mihai Petcu - Advanced Installer Team
Follow us: Twitter - Facebook - YouTube
Codename K
Posts: 479
Joined: Fri Jan 29, 2010 3:04 pm

Re: Setting up SQL Settings - ODBC Error 8

Hello,

Thank you Advanced Installer support team for providing support through email. You solved the SQL connection issues I had with the installer. :D :D :D
So below are the settings that worked in the SQL connection,

Connection Type: Microsoft SQL Server / MSDE
Connection Mode: ODBC Driver
ODBC Driver: SQL Server
Server: .\clearcutadmin
Port: 1433
Username: sa
Password: Linda

----------------------------------------------------------------------------------------

Furthermore, I created another installer which uses SQL connection with the same method. Below are the SQL settings used,

Connection Type: Microsoft SQL Server / MSDE
Connection Mode: ODBC Driver
ODBC Driver: SQL Server
Server: .\SQLEXPRESS
Port: 1433
Username: sa
Password: kkk

But this showed the following error,

Code: Select all

SQL_STATE:28000 Login Failed for user 'sa'
It seems the user name given (sa) is not associated with a trusted SQL Server connection. So I changed the SQL settings in the SQL Scripts page in the Advanced Installer as show in the image below,

Image
The SQL settings are retrieved from the SQL connection window when installing. The [LogonUser] property retrieves the current logged in username.

This time the installer locks when the installer is executing the SQL scirpt (When this line is shown in the installer: Executing the install SQL scripts). This stops after 3/4 of the progress is completed.

Regards
K
mihai.petcu
Posts: 3860
Joined: Thu Aug 05, 2010 8:01 am

Re: Setting up SQL Settings - ODBC Error 8

Hello,
It seems the user name given (sa) is not associated with a trusted SQL Server connection.
The default authentication mode for MSDE is Windows Authentication. MSDE installs with a built-in system administrator (SA) user account. However, because SQL Server Authentication is disabled by default, you cannot access the built-in account after a typical installation. You can find related information in this article.

You should review your SQL Server accounts and authentication mode, perhaps reinstall SQL Server so you can have the right connection setting in your Advanced Installer project.

Best,
Mihai
Mihai Petcu - Advanced Installer Team
Follow us: Twitter - Facebook - YouTube

Return to “Common Problems”