Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2002
    Posts
    9

    Unanswered: 2005/2005Express SQLOLEDB Provider problem

    When creating a connection string in ADO (using Delphi7), I insert the provider like this:

    Provider=SQLOLEDB;Data Source=.;Initial Catalog=master;Integrated Security=SSPI;User ID=sa;Password=masterkey

    Now, when I try to run this on a SQL Server 2005 or SQL2005 Express database, it won't create the connection
    unless I use the SQLNCLI provider.

    Is there a way to force them to use the OLEDB provider?
    I have MDAC2.8-SP1 installed.

  2. #2
    Join Date
    Apr 2002
    Posts
    9
    Try explicitly adding the server name

    Provider=SQLOLEDB;Data Source=<Server Name>;Initial Catalog=master;Integrated Security=SSPI;User ID=sa;Password=masterkey

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •