ODBC and runtime?

[welby]

Hi, I have a FM database in FM8.5 advanced and I have created a runtime for distribution.

I have an import script that connects to a ODBC SQL data source and imports the required data.

After I have created the runtime I try and run the import script and finds that it cancels itself and asks if I want the script to continue.

I have run this runtime on my own pc so the ODBC connection should hold true and allow the database to connect and get its data.

I have looked to see if it is a permissions error, but I am testing the runtime with full admin permissions to no avail.

Has anyone else experienced this?

Am I missing something? I have looked in all the manuals, but can't find the relevant information.

Thank you in advance.

[IdealData]

AFAIK ODBC connectivity is achieved using the xDBC plugins - plugins don't work in runtimes.

[welby]

Hi,

thanks for the reply. After doing more research I have since found out that you cannot use ODBC in runtimes, which really is stupid!

I believe crystal can.

hmmmmm

[Genx]

plugins don't work in runtimes.

... Since when? You just have to replicate the extensions folder in the structure as far as i know to get plugins to work..

[Genx]

... However, for ODBC to work you need to be able to host content, but FM only acts as a host for files for actual FM Pro -- not runtimes. Which is kind of dumb really -- just another limitation you have to look out for again, you can always use XML docs to import data into Excel if you have to, but can't modify FM data from outside it unfortunatley...

[GManNAtl]

I know it has been a while since this post, but if you haven't already found out there are several plugins that will allow you to access ODBC content via a runtime. Here is a link to the plugin I have used for runtimes.

http://www.frontbase.fi/products/fbsql/index.php4