Tool works great when using MS SQL database but want to connect to two other data sources. One is Excel database and the other another database on the mainframe system. I have System DSN setup for both of them and work fine with tests using MSQuery on the the server. When trying to use with SQLVIEW I get teh following error which indicates the syntax being used isn't right but that's where I falter, not knowing what the correct syntax would be. error: DotNetNuke.Services.Exceptions.ModuleLoadException: 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). ---> System.ArgumentException: 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). at System.Data.OleDb.OleDbConnectionString.ValidateNotMSDASQL(String progid) at System.Data.OleDb.OleDbConnectionString.ValidateParse() at System.Data.Common.DBConnectionString..ctor(String connectionString, UdlSupport checkForUdl) at System.Data.OleDb.OleDbConnectionString.ParseString(String connectionString) at System.Data.OleDb.OleDbConnection.set_ConnectionString(String value) at System.Data.OleDb.OleDbConnection..ctor(String connectionString) at DNNStuff.SQLView.SQLView.RetrieveData(String QueryText) at DNNStuff.SQLView.SQLView.BindGrid() --- End of inner exception stack trace --- Connection string: Provider=MSDASQL;PersistSecurityInfo=False;Trusted_Connection=Yes;Data Source=SCR also tried Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\excel\scr.xls;Extended Properties=""Excel 11.0;HDR=Yes;IMEX=1" without joy Think if I can crack one I stand a chance of relating that to the mainframe connection possibly. Looked at the www.connectionstrings.com site for inspiration but failed to be inspired! Thanks in advance, Andy

Andy, The second connection string is the one that should work because that's the OLEDB one. I just ran a quick sample and it works fine for me. Here is what I used. [quote]OLEDB Connection String Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Simpsons.xls;Extended Properties='Excel 8.0;HDR=Yes;IMEX=1' Query SELECT * FROM [sheet1$] [/quote]

Cheers was all down to format - quote marks. Much appreciated, got the Excel working. Next battle is the mainframe connection - uses Easysoft ODBC, hopefully can work that one through one way or another. Regards, Andy