PromptDataSource and password
I use PromptDataSource to allow users to setup a database connection.
connectionString := ADOdb.PromptDataSource(0, '');
However I can't get it to work with "Allow saving password" when using the SQL Server Native Client 10.0 provider:
PromptDataSource return a string with Persist Security Info=False, and the password is omitted, when using that provider:
Provider=SQNCLI10.1;Integrated Security="";Persist Security Info=False;User ID=MGH;Initial Catalog="";Data Source=stackoverflow.com;Initial File Name="";Server SPN=""
Other providers that I've tried worked, what can I do to fix this?
Note: I believe the provider is installed with MS SQL Server 2008 R2.
Edit: I forgot to include my answer: cannot be done.
Not the answer you want to hear, but i am going to guess that it is an intentional bug - and you will not convince Microsoft to fix it.
i can confirm that user supplied passwords work for:
- Microsoft.Jet.OLEDB.4.0: Microsoft Jet 4.0 OLE DB Provider (works)
- MSOLAP: Microsoft OLE DB Provider for Analysis Services 10.0 (works)
- MSDASQL: Microsoft OLE DB Provider for ODBC Drivers (works)
- MSDAORA: Microsoft OLE DB Provider for Oracle (works)
- SQLOLEDB: Microsoft OLE DB Provider for SQL Server (works)
- MSDataShape: MSDataShape (works)
- SQLNCLI: SQL Server Native Client (works) (Released with 2005)
and fail for
- SQLNCLI10: SQL Server Native Client 10.0 (fails) (Released with 2008)
- SQLNCLI11: SQL Server Native Client 11.0 (fails) (Released with 2012)
It looks like Microsoft's broken by default policy again.
Bonus Reading
More of Microsoft's broken by default things:
- How to get a list of tables with composite primary key in SQL Server?
- How to find all trigger associated with a table with SQL Server?
- SSRS Query execution failed for dataset
- SQL Server SELECT LAST N Rows
- Order by Specific id first then By rest
- SQL Server query to find all permissions/access for all users in a database
- Cannot access temporary tables from within a function
- Incorrect syntax near '1'. Expecting ID, QUOTED_ID, or '.' Error with SQL Pivot
- How to create table using select query in SQL Server?
- Get the database name in which Stored Procedure exists
- Errors: "INSERT EXEC statement cannot be nested." and "Cannot use the ROLLBACK statement within an INSERT-EXEC statement." How to solve this?
- Set variable to NULL if not found in query statement
- T-SQL USE satetement in condition
- Get MAX value of a BIT column
- Is full text search suitable for searching people's names?
- The transaction log for the database is full
- SQL Server 2008 R2 DeadLock on query Notification (SqlDependency)
- Why use the INCLUDE clause when creating an index?
- Why am I getting Data provider or other service returned an E_FAIL status? SQL Native Client
- Import Excel Spreadsheet Data to an EXISTING sql table?
- Retrieving billions of rows from remote server?
- Combining (concatenating) date and time into a datetime
- SQL ignore part of WHERE if parameter is null
- Schema objects not visible in SQL Server Management Studio 2008
- Using RegEx in SQL Server
- How to convert number of minutes to hh:mm format in TSQL?
- Error 'the subreport could not be found at the specified location. Please verify that the subreport has been published and that the name is correct'
- Retrieving last record in each group from database - SQL Server 2005/2008
- How to get the name of a the student who got max marks in each subject?
- Reset identity seed after deleting records in SQL Server