Hello Stephen,

Looking at the error stack, it looks like the connection string isn't being parsed correctly when you use this.GetDataSet().

I suggest putting a breakpoint in mmBusinessObject.CreateDataAccessObject(string dataAccessClassName) -- near the top and watch which connection string it's picking up.

Hope that gets you on the track,
---J

>OLEDB Paradox source for data. I can't use the BizObject to fill a ds, but I can fill one myself via:
>OleDbConnection strConnection = new OleDbConnection( OakLeaf.MM.Main.mmAppBase.DatabaseMgr.GetConnectionString("EdCat"));
>OleDbCommand objCommand = new OleDbCommand(lcSQL, strConnection);
>
>OleDbDataAdapter DA = new OleDbDataAdapter();
>DA.SelectCommand = objCommand;
>DA.Fill(DS);
>
>Error's on this line:
>return this.GetDataSet("SELECT * FROM CHECTLOG " );
>
>From the Application Log:
>Keyword not supported: 'provider'.
>Source: System.Data
>Target Site: Char[] ParseInternal(Char[], System.Data.Common.UdlSupport, System.Data.Common.NameValuePair ByRef)
>Stack Trace: at System.Data.Common.DBConnectionString.ParseInternal(Char[] connectionString, UdlSupport checkForUdl, NameValuePair& keychain)
> at System.Data.Common.DBConnectionString..ctor(String connectionString, UdlSupport checkForUdl)
> at System.Data.SqlClient.SqlConnectionString..ctor(String connectionString)
> at System.Data.SqlClient.SqlConnectionString.ParseString(String connectionString)
> at System.Data.SqlClient.SqlConnection.set_ConnectionString(String value)
> at System.Data.SqlClient.SqlConnection..ctor(String connectionString)
> at OakLeaf.MM.Main.Data.mmDataAccessSql.CreateSqlConnection()
> at OakLeaf.MM.Main.Data.mmDataAccessSql.FillDataSet(DataSet ds, IDbDataAdapter dbAdapter, String tableName, Boolean clearOnFill)
> at OakLeaf.MM.Main.Data.mmDataAccessSql.FillDataSet(DataSet ds, IDbCommand command, String tableName, Boolean clearOnFill)
> at OakLeaf.MM.Main.Data.mmDataAccessSql.FillDataSet(DataSet ds, String command, String tableName, CommandType cmdType, IDbDataParameter[] dataParms, Boolean clearOnFill)
> at OakLeaf.MM.Main.Business.mmBusinessObject.FillDataSet(DataSet ds, String command, String tableName, String databaseKey, CommandType cmdType, IDbDataParameter[] dataParams)
> at OakLeaf.MM.Main.Business.mmBusinessObject.GetDataSet(String command, String tableName, String databaseKey, CommandType cmdType, IDbDataParameter[] dataParams)
> at OakLeaf.MM.Main.Business.mmBusinessObject.GetDataSet(String command, String tableName, String databaseKey, IDbDataParameter[] dataParams)
> at OakLeaf.MM.Main.Business.mmBusinessObject.GetDataSet(String command, String tableName, String databaseKey)
> at OakLeaf.MM.Main.Business.mmBusinessObject.GetDataSet(String command, String tableName)
> at OakLeaf.MM.Main.Business.mmBusinessObject.GetDataSet(String command)
> at SRA.EdCat.Business.EdCat1.GetDrawings() in c:\win_projects\edcat\edcat business\edcat1.cs:line 21
>
>Any ideas on this?