Subject: | Re: Firebird connection
| Date: | Wed, 26 Jun 2019 09:49:30 +0200
| From: | =?UTF-8?Q?G=c3=bcnter?= <info@NoSpam-mk-news.com>
| Newsgroups: | pnews.paradox-client_server
|
i still trying to do it with Firebird, and i am not sure what yo mean
with "and connect via ODBC", there is a entry in the BDE called
"Firebird/InterBase(r) driver", but my current access is via Native
INTRBASE connection. can you explain how to access via ODBC, i mean in OPAL?
Am 26.06.2019 um 05:11 schrieb Tom Krieg:
> Are you using the BDE with SQL links and native interbase driver?
> Because newer versions of firebird in future would probably be
> incompatible. Try and use the latest Firebird ODBC driver and connect
> via ODBC. Aso try not to use Firebird tables in any datamodel but only
> extracted data in Paradox tables in priv. Also try not to do any updates
> via tcursors, performance will be like a dead dog. Always use
> pass-through SQL and stored procedures.
>
> I've also used Firebird and MS SQL Server with Paradox via ODBC and it
> worked like a dream, but that was as far back as 2008. In my last
> Paradox project for a very large Appliance Service company with many
> mobile technicians using the application via remote access tablets I had
> to use GIS and interface with Google maps so I used PostgreSQL because
> it had a very good GIS functionality. I had to solve the "Travelling
> Salesman" problem and did it with Postgres GIS.
>
> BTW I've now got a copy of my PostgreSQL interface library, so if you
> let me know an email I can send it to you if you're still using
> PostgreSQL. It uses ODBC connection. I still think PgSQL is the way to
> go as Postgres community always have up-to-date ODBC drivers as well as
> NuGet packages for Visual Studio for native .NET data provider for PgSQL.
>
>
> Günter wrote on 25/06/2019 7:41 PM:
>> Problem solved:
>> 1) put fbclient.dll (32Bit) as GDS32.dll in BDE directory
>> 2)Aliasdys["SERVER NAME"]
>> = "192.168.111.151:C:\\gm\\FB\\employee.fdb"
>> Aliasdys["USER NAME"] = "SYSDBA"
>> Aliasdys["OPEN MODE"] = "READ/WRITE"
>> Aliasdys["SCHEMA CACHE SIZE"] = "8"
>> Aliasdys["NET PROTOCOL"] = "SPX/IPX"
>> 3)addAlias("Diedeldum", "INTRBASE", Aliasdys)
>> 4) add Firebird as allowed App in Firewall
>> 5) try all steps first with isql.exe
>>
>
>
|