ADO & Vista (aka Longhon)

I have today tested a Delphi 5 app that uses the following connection
string to a SQL Server, and it fails if I use the ODBC Connection
dialog that comes with Vista I get a Provider of SQL Server rather than
Provider=SQLOLEDB.1 what is the correct value for Provider?

TIA

Graham Harris
--

.

Relevant Pages

  • Re: SqlDataReader on Sql 2005
    ... file names from *.BAK files. ... add a named instance it fails. ... Provider, error: 0 - An existing connection was forcibly closed by the ... was that it was a result of an internal error in SQL Server or SqlClient, ...
    (comp.databases.ms-sqlserver)
  • Re: Get a list of available stored procedures
    ... Well, if you don't have a SQL Server, then you will have to use whatever ... DB-specific method will give you a list of the stored procedures (there is ... provider that can connect to many data sources, as is OLEDB) unless it is ... I m using an ODBC connection, ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: ADO & Vista (aka Longhon)
    ... Server" is name of ODBC driver for MS SQL Server 2000 and prior, ... I very recommend to use native OLEDB provider, not ODBC, with ADO and MS SQL ... > string to a SQL Server, and it fails if I use the ODBC Connection ...
    (borland.public.delphi.database.ado)
  • Re: Disabling ASP.net 2.0 Membership
    ... I checked out the article you referenced and implemented my own provider. ... as a FoxPro database, an Oracle database, or other data sources. ... custom connection string so that I can use the Commerce Server SQL Server ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: ERROR: Provider Management - Could not establish a connection to t
    ... If you have not yet created the SQL Server database, ... Can any data provider be used to ... Exception Details: System.Data.SqlClient.SqlException: A connection ...
    (microsoft.public.dotnet.framework.aspnet)