StrataFrame Forum

How do you connect to an ODBC database?

http://forum.strataframe.net/Topic13505.aspx

By Robert Moore - 1/16/2008

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?
By Trent L. Taylor - 1/17/2008

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.
By Calvin Y Tang - 5/12/2008

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

By Dustin Taylor - 5/13/2008

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"))