This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Accept
Reject
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
sthoeum
Level 3
‎Jan 27, 2010 09:24 AM

ISSQLFilteredList and ISSQLServerList does not detect SQL Server 2008 instances

Hi

I used a basic msi project. In my dialog I have a combobox that uses ISSQLFilteredList custom action to display instances of SQLServer and I also have SQLBrowse that uses ISSQLServerList to display all SQL Servers on the netwok. The problem is I don't see SQL SERVER 2008 instances. I see SQL Server 2005.
It evens put sometimes in my combobox a number 1 or sometimes a value like #TEMP0004 ( I don't know where that comes from).

Anybody know if it is an issue?
Labels (1)
Labels
0 Kudos
(1) Reply
hidenori
Level 17
‎Feb 08, 2010 02:10 PM

Can you try to change InstallShield use the Microsoft SQL Server Native Client ODBC driver by following the steps below, and see if the problem is solved?

[LIST=1]
  • Go to the ISSQLDBMetaData table in the Direct Editor.
  • Find the "MSSQLServer" row.
  • Change the AdoDriverName column from "sqlolddb" to "sqlncli".
  • Change the DsnODBCName column from "{SQL Server}" to "{SQL Native Client}"
  • Rebuild your setup.

    Note that the SQL Native Client ODBC driver needs to be present on the machine that your setup is running.
    • 0 Kudos