RE: Database Lookup Functoid Access Connection String

From: ktz4 (ktz4_at_discussions.microsoft.com)
Date: 06/14/04


Date: Mon, 14 Jun 2021 12:39:01 -0700

I have tried the following and these are the results I get:

Provider=MSDASQL.1;Data Source = DataSourceName

The .Net Framework Data Provider for OLEDB (System.Data.OleDb) does not support the Microsoft OLE DB Provider for ODBC Drivers (MSDASQL). Use the .Net Framework Data Provider for ODBC (System.Data.Odbc).
-------------------------------------------------------------
Provider=ODBC;Data Source = DataSourceName

The 'ODBC' provider is not registered on the local machine.
-------------------------------------------------------------
Provider=SQLOLEDB.1;Data Source = DataSourceName

Invaild authorization specification
------------------------------------------------------------- The DSN is configured to use the Microsoft Access Driver (*.mdb). Any ideas would be greatly appreciated.
                                                                                                                                                                                                      

"Scott White" wrote:

> Try
>
> provider=SQLOLEDB.1
>
> "Ktz4" wrote:
>
> > In Biztalk 2002 we are performing a Database lookup functoid using Provider=MSDASQL.1. When I try to use the same provider in Biztalk 2004 system.data does not support it. Any ideas?
> >