StrataFrame Forum » StrataFrame Application Framework - V1 » Business Objects and Data Access (How do I?) » How do you connect to an ODBC database?

How do you connect to an ODBC database?

Robert Moore — Tue, 13 May 2008 09:19:52 GMT

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?

RE: How do you connect to an ODBC database?

Dustin Taylor — Tue, 13 May 2008 09:19:52 GMT

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

RE: How do you connect to an ODBC database?

Calvin Y Tang — Mon, 12 May 2008 15:03:06 GMT

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

RE: How do you connect to an ODBC database?

Trent L. Taylor — Thu, 17 Jan 2008 08:09:18 GMT

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.