WISE_SQL_CONN_STR problems

[Adriano]

Hi,

 

I'm evaluation Wise Installer Pro, and trying to install some database tables. SO I create a new project and:

 

1) I setup a "SQL Server Scripts" feature:

Name:SqlScript1

Connection String:[WISE_SQL_CONN_STR]

 

and import some sql.

 

2) I set Dialogs:Single Feature Destination OFF

 

3) I added a SQL Connection Dialog

 

 

 

But when I install, the connection fails. It doesnt appear to populate WISE_SQL_CONN_STR. Heres the error:

 

SQL server connection failed.

 

Error Details:

[Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not esist or access is denied.

 

 

4) Then I Add an ODBC driver:

Type:Driver

Name:SQL Server

 

But now when I install I get: Internal Error 2715 sqlsrv32.dll

 

 

 

Any help gratefully recieved, thanks, Adrian

 

 

[alan]

no real clue to SQL problems, but error 2715 is
The specified File key ('[2]') not found in the File table.

so check whether sqlsvr32.dll is in your package, or if it isn't, why
it's expected to be.

[Adriano]

Thanks Alan,

It turns out that the dialog was in fact revealing the error. The error was
"SQL Server does not exist or access is denied.".

I will try and figure how I can get the dialog not show the rather confusing
"[Microsoft][ODBC SQL Server Driver][Shared Memory]" to the user.

Will also investigate the sqlsvr32.dll in my package, cheers, Adrian

"alan" <nos...@nowhere.com> wrote in message
news:eF7FUIHJ...@TK2MSFTNGP04.phx.gbl...

[James Drain]

Hi Adriano

Have you tried using (ie adding) the dialogs to the UI? The default ones
populate WISE_SQL_CONN_STR for you.

Hope this helps,
James
http://dotmsi.com