Error 3706 when connexion SQL Server 2K using ado

Hello everybody,
"
PuAdoConnection As ADODB.Connection
...
Set PuAdoConnection = New ADODB.Connection
PuAdoConnection.Open "Provider=sqloledb.1;Data Source=xxx;Initial
Catalog=xxx;user id=sa;pwd=xxx;"
"
On "Open", error 3706 "Impossible to find the supplier. It is perhaps badly
installed" (somethings like that, because it's in French : "Impossible de
trouver le fournisseur. Il est peut-tre mal install")
I reinstalled mdac 2.8, but it's not better.
I can connect to my database by ODBC or "Enterprise Manager".
What's the problem ?
Thanks.On Wed, 12 Jul 2006 15:24:11 +0200, "yan" <yan@.nospam.fr> wrote:
Hello everybody,
"
PuAdoConnection As ADODB.Connection
...
Set PuAdoConnection = New ADODB.Connection
PuAdoConnection.Open "Provider=sqloledb.1;Data Source=xxx;Initial
Catalog=xxx;user id=sa;pwd=xxx;"
"
On "Open", error 3706 "Impossible to find the supplier. It is perhaps badl
y
installed" (somethings like that, because it's in French : "Impossible de
trouver le fournisseur. Il est peut-tre mal install")
I reinstalled mdac 2.8, but it's not better.
I can connect to my database by ODBC or "Enterprise Manager".
Have you tried installing the latest version of MDAC? It sounds like the SQL
Server OLEDB provider
is not installed or there is a configuration problem with it.
http://www.microsoft.com/downloads/...&displaylang=en
Paul
~~~~
Microsoft MVP (Visual Basic)|||I've tried with mdac 2.8, but it's not better.
Is it possible to uninstall the drivers before ?
"Paul Clement" <UseAdddressAtEndofMessage@.swspectrum.com> a crit dans le
message de news: if4ab213c83j7jnklbq31vasfse16tv8s9@.4ax.com...
> On Wed, 12 Jul 2006 15:24:11 +0200, "yan" <yan@.nospam.fr> wrote:
> Hello everybody,
>
> "
> PuAdoConnection As ADODB.Connection
> ...
> Set PuAdoConnection = New ADODB.Connection
> PuAdoConnection.Open "Provider=sqloledb.1;Data Source=xxx;Initial
> Catalog=xxx;user id=sa;pwd=xxx;"
> "
>
> On "Open", error 3706 "Impossible to find the supplier. It is perhaps
> badly
> installed" (somethings like that, because it's in French : "Impossible
> de
> trouver le fournisseur. Il est peut-tre mal install")
>
> I reinstalled mdac 2.8, but it's not better.
>
> I can connect to my database by ODBC or "Enterprise Manager".
>
> Have you tried installing the latest version of MDAC? It sounds like the
> SQL Server OLEDB provider
> is not installed or there is a configuration problem with it.
> http://www.microsoft.com/downloads/...&displaylang=en
>
> Paul
> ~~~~
> Microsoft MVP (Visual Basic)|||On Wed, 12 Jul 2006 17:41:40 +0200, "yan" <yan@.nospam.fr> wrote:
I've tried with mdac 2.8, but it's not better.
Is it possible to uninstall the drivers before ?
Try the following first:
http://www.macropool.com/en/download/mdac_xp_sp2.html
Paul
~~~~
Microsoft MVP (Visual Basic)|||It works now thanks to MDAC Repair Tool from your link.
Thank you very much !
"Paul Clement" <UseAdddressAtEndofMessage@.swspectrum.com> a crit dans le
message de news: 14rcb2de2o5810htominid4ubcrllcvgk4@.4ax.com...
> On Wed, 12 Jul 2006 17:41:40 +0200, "yan" <yan@.nospam.fr> wrote:
> I've tried with mdac 2.8, but it's not better.
>
> Is it possible to uninstall the drivers before ?
>
>
> Try the following first:
> http://www.macropool.com/en/download/mdac_xp_sp2.html
>
> Paul
> ~~~~
> Microsoft MVP (Visual Basic)