Hi, I m using LLBLGen Pro 2 (self servicing), C# ASP.NET, and ORacle 9i

I faced this problem with the connection string i had:

My connection string setup at Web.config: <add key="Main.ConnectionString" value="provider=MSDAORA;data source=SB;user id=sb;password=sb;persist security info=false;"/>

Error: Keyword not supported: 'provider'

When i remove the provider tag, i got another error saying that missing Provider such as Provider=SQLOleDB. Am i missing out something here?

And also, how can we determine what provider has been used if the "Provider" tag is not included in the connection string?

Thank you for the help

yj

When i remove the provider tag, i got another error saying that missing Provider such as Provider=SQLOleDB.

Please post the error that appears when the provider is missing.

And also, how can we determine what provider has been used if the "Provider" tag is not included in the connection string?

It depends on what exactly do you mean by the Provider?

The connection string is an OleDB connection string, while the oracle code of LLBLGen Pro uses native ADO.NET providers (ODP.NET or MSOracle client). So adjust your connection string to the one generated into the app.config file of the generated code.