Re: .1 in Providername

From: Stefan Westner (s_at_westner.de)
Date: 02/25/05


Date: 25 Feb 2005 13:59:37 -0800

Hello Dennis,

thanks. Further question: if I build the connection-string dynamically
in my datamodule I have to set the provider. If I want to use
SQL-Server I set SQLOLEDB. Do I need to add the .1 and is the .1 the
same on every computer or could this vary and if this could vary is it
a problem to set it to the wrong value or where should I get the right
value?

Stefan

Dennis Passmore wrote:

> The ".1" is actually a part of the actual 'ProgID' value in the
> registry for that provider. Just do a search in regedit for
> 'SQLOLEDB.1'
>
>
> Dennis Passmore
> Ultimate Software, Inc.



Relevant Pages

  • Re: ADP Project Trusted Connection Issue?
    ... Sorry, for the provider, it's my error. ... Go into safe mode if necessary to change the setting. ... the services window to see if they are nothing unusual about the SQL-Server ... > I also noticed that I can no longer stop SQL Server on my machine. ...
    (microsoft.public.access.security)
  • Oracle-DB an SQL-Server anbinden
    ... Hierfür habe ich auf dem SQL-Server einen Verbindungsserver über ... den OLE DB Provider 'MSDAORA' eingerichtet. ... [OLE/DB provider returned message: Oracle Client- und Netzwerkverbindung ...
    (microsoft.public.de.sqlserver)
  • Re: Datenbank =?iso-8859-1?Q?=FCber?= Internet ansprechen
    ... sollte man man lieber in eine Umstellung ... Leider kenne ich mich mit SQL-Server nicht aus. ... Provider über TCP/IP ansprechen? ... Desktop-Programm einen geeigenten Connection-String angeben könnte, ...
    (microsoft.public.de.german.entwickler.dotnet.datenbank)
  • Re: create aspnetdb from scratch
    ... need it locally it would seem your hoster is forcing this ... should be on the hosting site only SQL-Server 2005. ... but the hosting provider tell me everything O.K, ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: MSDE Portumleitung
    ... > mein Provider hat auf meinem Webserver MDSE installiert. ... > Daher suche ich einen Weg, die Standart-Ports von MSDE zu ... (Wie connecte ich dann auf den SQL-Server via ... SQL-Server-Clientkonfiguration ...
    (microsoft.public.de.sqlserver)