This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
- Revenera Community
- :
- InstallShield
- :
- InstallShield Forum
- :
- SQLBrowse2 and SQLRTGetServers2 display random servers
Subscribe
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Oct 05, 2010
06:15 AM
SQLBrowse2 and SQLRTGetServers2 display random servers
Hello,
we are encountering difficulties with the functions "SQLBrowse2" and "SQLRTGetServers2". We want to display a number of available database servers in our network and at first everything seemed ok. Both functions detected some servers but on closer examination we found out that the list of available servers seems to be absolutely random! On the first attempt we get 10 servers, on the second attempt only 3 and on the third attempt 5. There seems to be no regularity as to which servers are shown and which servers are skipped.
I tried to change the driver to native, but then I don't get a single server...
We are kind of helpless at this point because we tried nearly everything and I also searched this forum but didn't find a solution.
Any advice would be great!
Best regards
we are encountering difficulties with the functions "SQLBrowse2" and "SQLRTGetServers2". We want to display a number of available database servers in our network and at first everything seemed ok. Both functions detected some servers but on closer examination we found out that the list of available servers seems to be absolutely random! On the first attempt we get 10 servers, on the second attempt only 3 and on the third attempt 5. There seems to be no regularity as to which servers are shown and which servers are skipped.
I tried to change the driver to native, but then I don't get a single server...
We are kind of helpless at this point because we tried nearly everything and I also searched this forum but didn't find a solution.
Any advice would be great!
Best regards
(5) Replies
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Oct 05, 2010
01:29 PM
Have you tried changing InstallShield use the Microsoft SQL Server Native Client driver as follows, and see if the behavior is changed?
[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
Make sure that you have the SQL Native Client driver installed on your target machine.
[LIST=1]
Make sure that you have the SQL Native Client driver installed on your target machine.
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Oct 06, 2010
07:18 AM
We can't guarantee that on the target machines the native client is installed...
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Oct 06, 2010
07:46 AM
InstallShield retrieves the list of Microsoft SQL Servers using an ODBC driver (SQL Server driver by default), and we have no control over the behavior that you are experiencing. If the SQL Native Client driver resolves the issue, you may want to consider adding the SQL Native Client prerequisite to your setup.
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Oct 07, 2010
04:18 AM
The problem is, we need this functionality prior to the installation process. We ask the user to specify on which Server the application should be installed and therefor we use the SQLBrowse function. So we would have to install the native drivers before we call the dialogues for the user.
Nevertheless I tried the native driver and it works pretty well. And now? Damn it... :rolleyes:
Nevertheless I tried the native driver and it works pretty well. And now? Damn it... :rolleyes:
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Oct 07, 2010
01:08 PM
Setup prerequisites will be installed before the OnFirstUIBefore event. So it should be fine.
![](/skins/images/D60DF682EA37BF37032955CE10F3F0BB/responsive_peak/images/icon_anonymous_message.png)