RE: Database Lookup Functoid Access Connection String

From: ktz4 (
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 does not support it. Any ideas?
> >