I am using the evaluation version of StrataFrame.  I need to be able to connect to a Transoft ODBC U/SQL datasource.  If I am reading the documentation properly, it looks like this can be done, but only with the full version.  Is this correct?

The trial version has all of the functionality as the full version (minus the source code).  It is possible to talk to an ODBC data source...but it will require some additional work.  If Transoft has an OLEDB provider, then you can use the OLEDB provider with SF out-of-the-box.  So the first thing that I would look into is if Transoft has an OLEDB provider, if so, then this would be your best bet.

Hi Trent,

Do you have the instruction for using ODBC data source?  I am using PervasiveSQL 2000i, which I am not allowed to upgrade to new version, so I must use the ODBC way to connect.

Thanks,

Calvin

You should just need to manually provide the connection string.  We have native OLEDB providers if this database has an OLEDB provider.  In either case, you will need to manually specify the connection string.

MicroFour.StrataFrame.Data.DataBasics.DataSources.Add(New OLEDBDataSourceItem("","YourConnectionString"))