Provider and connection string

[Larry Hargis]

Hi,

I’m trying to connect to a FileMaker Pro 5.0 database through ADO.NET ODBC connection and have been having trouble trying to figure out what name to use for the provider in the connection string.

In the past I have always used code like the code below to connect to SQL Server and have never had any problems.
{
string connectionString="Provider=SQLOLEDB.1;"+
"Integrated Security=SSPI;"+
"Persist Security Info=FALSE;"+
"Initial Catalog=customers;"+
"Data Source=(local)";

OleDbConnection cn;
cn=new OleDbConnection(connectionString);
cn.Open();
…
}

I looked in the ODBC Data Source Administrator and saw the FileMaker Pro database driver installed as file FMFMP50.dll. But can’t determine the provider name from that. I also looked in the FileMaker Pro users manual and didn’t see it there either.

Does anyone know of a way I can find out what provider names are registered on a machine?

Thanks in advance,
Larry

[Larry Hargis]

Nevermind, it turns out I needed to download the Microsoft ODBC .NET Data Provider (Microsoft.Data.Odbc) and connect like this:

OdbcConnection connection=new OdbcConnection();
string connectionString="Driver={FileMaker Pro};";
connection.ConnectionString=connectionString;
connection.Open();