Re: Database Lookup Functoid Access Connection String
From: Jan Eliasen (spam_at_eliasen.dk)
Date: 06/15/04
- Next message: Frank Schumacher: "Getting active processes in C# (BT2004)"
- Previous message: Peter Timkó: "Re: Stream handling in custom pipeline component"
- In reply to: ktz4: "RE: Database Lookup Functoid Access Connection String"
- Next in thread: ktz4: "Re: Database Lookup Functoid Access Connection String"
- Reply: ktz4: "Re: Database Lookup Functoid Access Connection String"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 15 Jun 2021 08:56:41 +0200
Hi. Try with
Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security
Info=False;Initial Catalog=<database>;Data Source=<db-server>
Replace the strings in brackets with something useful. The above
connectionstring is for integrated security and not username/password.
Jan Eliasen.
On Mon, 14 Jun 2021 12:39:01 -0700, "ktz4"
<ktz4@discussions.microsoft.com> wrote:
>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?
>> >
-- Jan Eliasen, representing himself and not the company he works for.
- Next message: Frank Schumacher: "Getting active processes in C# (BT2004)"
- Previous message: Peter Timkó: "Re: Stream handling in custom pipeline component"
- In reply to: ktz4: "RE: Database Lookup Functoid Access Connection String"
- Next in thread: ktz4: "Re: Database Lookup Functoid Access Connection String"
- Reply: ktz4: "Re: Database Lookup Functoid Access Connection String"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
