Re: ODBC Connections


"pcourterelle" <someone@xxxxxx> wrote in message
news:rFNxf.79245$OU5.32137@xxxxxxxxxxx
>
> "Mark Reed" <mreed@xxxxxxxxxxxxxxx> wrote in message
> news:Xns9743E51E7D627mreedfusionmagiccom@xxxxxxxxxxxxxxxxx
>> Doug Anderson <dougcpa@xxxxxxx> wrote in news:2005121416321816807%
>> dougcpa@maccom:
>>
>>> Using FMP8 on OS X and I've got a successful connection with a
>>> Microsoft SQL server using a 3rd party ODBC driver. I can import
>>> data/tables from the MSSQL database. My question is in FMP8 can you
>>> just link to the external tables? The problem I have is that the MSSQL
>>> table data changes constantly during the day, so I can't just import
>>> the data every so often. In MS Access I'm able to link to external SQL
>>> tables and it works pretty slick.
>>>
>>> I'm new to FM, so I wasn't sure if there was a trick or other option
>>> I'm missing while using ODBC.
>>>
>>>
>>
>> im curious to this as well... count me as a newbie as well.
>>
>
> An intermediary script or program or two might be the answer. The MSSQL db
> is set to dump every 10 min or so to a watched folder. The script or
> program watches the folder and then triggers a FM script to import
> whatever file is in the watch folder. Clunky for sure but a workaround???
>
> pc
>
>
>


.

Relevant Pages

  • Re: SQL Server Compact Ed
    ... Does your setup work as it did with SQL Mobile. ... I had followed this proc to install mobile ... Run ConnWiz30.exe from the Microsoft SQL Server 2005 Mobile ... Edition\Server folder. ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: SSCE 3.1 Tools install
    ... Please see my reply to you on the compactframework newsgroup. ... Run ConnWiz30.exe from the Microsoft SQL Server 2005 Mobile ... Edition\Server folder. ...
    (microsoft.public.sqlserver.ce)
  • Incorrect syntax near ANSI_PADDING.
    ... I have scripted my whole database and one of the parts that is installed in two different database applications is the ASP.NET Membership schemas. ... Both projects are based on Microsoft SQL Server 2005 ... Both of my projects use SQLCMD to run a "master script" that sequences all the other 'child' SQL scripts including the 4-5 files mentioned above. ... In project A the Membership Schema passes through the installation without any problems. ...
    (microsoft.public.sqlserver.tools)
  • Re: Evaluation Period
    ... Right click on the Microsoft SQL Server ... folder, select properties and view the date the folder was created. ... If this was a clean eval install a little arithmetic should get you ... >I installed SQL 2000 Enterprise Evaluation edition, ...
    (microsoft.public.sqlserver.setup)
  • Re: ActiveX or TSQL to remove trailing blank spaces from source
    ... There is a transform type of Trim String ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. ... > I was wondering if it was possible in TSQL to have a default in a> varchar column that can remove trailing blank spaces from a string. ... > In Active X script I would have to work out a way to replace the> trailing blank spaces with a "". ...
    (microsoft.public.sqlserver.dts)