OLEDB in .Net 2.0 web

23 Mar 2006 7:38 PM

David

In my web page I am using the following OLE command to connect to a SQL 2005
db.
Dim conFileData As OleDbConnection

conFileData = New
OleDbConnection("Provider=SQLNCLI;Server=Server01;Database=Filedata;Trusted_Connection=yes;")

conFileData.Open()

How can I change this Provider to run from a server (Server03) with SQL 2000
on it? It fails right now probably because SQLNCLI.dll etc. is not
installed on SQL 2000 server. Thanks.

David

24 Mar 2006 12:31 AM

Dan Guzman

Try:

"Provider=SQLOLEDB;Server=Server01;Database=Filedata;Trusted_Connection=yes;"

--
Hope this helps.

Dan Guzman
SQL Server MVP

Show quote

"David" <dlch***@lifetimeinc.com> wrote in message
news:eCqpIGrTGHA.5808@TK2MSFTNGP12.phx.gbl...
> In my web page I am using the following OLE command to connect to a SQL
> 2005 db.
> Dim conFileData As OleDbConnection
>
> conFileData = New
> OleDbConnection("Provider=SQLNCLI;Server=Server01;Database=Filedata;Trusted_Connection=yes;")
>
> conFileData.Open()
>
> How can I change this Provider to run from a server (Server03) with SQL
> 2000 on it? It fails right now probably because SQLNCLI.dll etc. is not
> installed on SQL 2000 server. Thanks.
>
> David
>
>