Watch, Follow, &
Connect with Us

For forums, blogs and more please visit our
Developer Tools Community.


Welcome, Guest
Guest Settings
Help

Thread: FDPhysODBCDriverLink is missing in Delphi Tokyo



Permlink Replies: 15 - Last Post: Sep 27, 2017 6:51 AM Last Post By: Ian Kirk Threads: [ Previous | Next ]
MA Y

Posts: 5
Registered: 7/14/04
FDPhysODBCDriverLink is missing in Delphi Tokyo
Click to report abuse...   Click to reply to this thread Reply
  Posted: Aug 26, 2017 10:31 AM
Hi

We are registered RAD Studio Tokyo Professional and it seems our product doesn't have FDPhysODBCDriverLink so we can not use ODBC here. What we are trying to do is to migrate from old friend paradox to some other database like SQLite or etc.

We need this driver to be able to read Paradox tables without BDE and dump them into our new db. We can not just download an app to do that as we need to deploy this to our customers, so our app will do the work silently.

Does anyone know what is the problem?
Jeff Overcash (...

Posts: 1,529
Registered: 9/23/99
Re: FDPhysODBCDriverLink is missing in Delphi Tokyo
Click to report abuse...   Click to reply to this thread Reply
  Posted: Aug 26, 2017 11:17 AM   in response to: MA Y in response to: MA Y
Atilla Yurtseven wrote:
Hi

We are registered RAD Studio Tokyo Professional and it seems our product doesn't have FDPhysODBCDriverLink so we can not use ODBC here. What we are trying to do is to migrate from old friend paradox to some other database like SQLite or etc.

We need this driver to be able to read Paradox tables without BDE and dump them into our new db. We can not just download an app to do that as we need to deploy this to our customers, so our app will do the work silently.

Does anyone know what is the problem?

ODBC FireDAC links do not ship with pro according to the feature list. It ships
with the Addon pack. SQLLite local connection native driver should be there though.

From - https://www.embarcadero.com/docs/rad-studio-feature-matrix.pdf

Pro Add-on pack

Enhanced in 10.2 Tokyo! Windows/Mac enterprise database support, including
MySQL, MariaDB, Microsoft SQL Server, Oracle Database, InterBase, PostgreSQL,
Informix, Sybase SQL Anywhere, Microsoft Access, IBM DB2 Server, Firebird,
Advantage Database, generic ODBC driver

Included in Pro

Enhanced in 10.2 Tokyo! Support for local databases, including Microsoft Access
database, SQLite and MariaDB database, InterBase ToGo / IBLite, InterBase on
localhost, MySQL Embedded, MySQL Server on localhost, Advantage Database local
engine, PostgreSQL on localhost, Firebird Embedded, Firebird on localhost

--
Jeff Overcash (TeamB)
(Please do not email me directly unless asked. Thank You)
Learning is finding out what you already know. Doing is demonstrating that you
know it. Teaching is reminding others that they know it as well as you. We are
all leaners, doers, teachers. (R Bach)
MA Y

Posts: 5
Registered: 7/14/04
Re: FDPhysODBCDriverLink is missing in Delphi Tokyo
Click to report abuse...   Click to reply to this thread Reply
  Posted: Aug 27, 2017 12:13 AM   in response to: Jeff Overcash (... in response to: Jeff Overcash (...
Jeff,

Thank you for your response. And which uptade do we have to purchase?

Jeff Overcash (TeamB) wrote:
Hi

We are registered RAD Studio Tokyo Professional and it seems our product doesn't have FDPhysODBCDriverLink so we can not use ODBC here. What we are trying to do is to migrate from old friend paradox to some other database like SQLite or etc.

We need this driver to be able to read Paradox tables without BDE and dump them into our new db. We can not just download an app to do that as we need to deploy this to our customers, so our app will do the work silently.

Does anyone know what is the problem?

ODBC FireDAC links do not ship with pro according to the feature list. It ships
with the Addon pack. SQLLite local connection native driver should be there though.

From - https://www.embarcadero.com/docs/rad-studio-feature-matrix.pdf

Pro Add-on pack

Enhanced in 10.2 Tokyo! Windows/Mac enterprise database support, including
MySQL, MariaDB, Microsoft SQL Server, Oracle Database, InterBase, PostgreSQL,
Informix, Sybase SQL Anywhere, Microsoft Access, IBM DB2 Server, Firebird,
Advantage Database, generic ODBC driver

Included in Pro

Enhanced in 10.2 Tokyo! Support for local databases, including Microsoft Access
database, SQLite and MariaDB database, InterBase ToGo / IBLite, InterBase on
localhost, MySQL Embedded, MySQL Server on localhost, Advantage Database local
engine, PostgreSQL on localhost, Firebird Embedded, Firebird on localhost

--
Jeff Overcash (TeamB)
(Please do not email me directly unless asked. Thank You)
Learning is finding out what you already know. Doing is demonstrating that you
know it. Teaching is reminding others that they know it as well as you. We are
all leaners, doers, teachers. (R Bach)
Jeff Overcash (...

Posts: 1,529
Registered: 9/23/99
Re: FDPhysODBCDriverLink is missing in Delphi Tokyo
Click to report abuse...   Click to reply to this thread Reply
  Posted: Aug 27, 2017 11:19 AM   in response to: MA Y in response to: MA Y
MA Y wrote:
Jeff,

Thank you for your response. And which uptade do we have to purchase?

You want the FireDAC C/S addon pac.

https://www.embarcadero.com/app-development-tools-store

--
Jeff Overcash (TeamB)
(Please do not email me directly unless asked. Thank You)
Learning is finding out what you already know. Doing is demonstrating that you
know it. Teaching is reminding others that they know it as well as you. We are
all leaners, doers, teachers. (R Bach)
Augusto Afonso ...

Posts: 5
Registered: 8/8/09
Re: FDPhysODBCDriverLink is missing in Delphi Tokyo
Click to report abuse...   Click to reply to this thread Reply
  Posted: Sep 7, 2017 1:08 AM   in response to: MA Y in response to: MA Y
Hi,

I think Jeff is wrong about this question. TFDPhysODBCDriverLink is available in Delphi Tokyo 10.2. Which is not is TFDPhysMSSQLDriverLink, that is in the Add-On pack.

Take a look to this post: [https://forums.embarcadero.com/thread.jspa?threadID=255838&tstart=0]

Regards,

A.Afonso

Ian Kirk

Posts: 12
Registered: 10/24/01
Re: FDPhysODBCDriverLink is missing in Delphi Tokyo
Click to report abuse...   Click to reply to this thread Reply
  Posted: Sep 26, 2017 5:31 AM   in response to: MA Y in response to: MA Y
To chip in, we recently updated to Tokyo Pro a few weeks ago, from XE5 Pro.

In XE5 Pro we had working code that accessed the ODBC driver via FireDAC.Phys.ODBC in one of our module user list.

We've just found that this no long builds in Tokyo; checking

C:\Program Files (x86)\Embarcadero\Studio\19.0\lib\win32\debug


that contains FireDAC.Phys.ODBCBase.dcu, FireDAC.Phys.ODBCCli.dcu and FireDAC.Phys.ODBCWrapper.dcu, but not FireDAC.Phys.ODBC

Have Embarcadero really dropped support for a major DBMS that was accessible in an earlier version?

Ian

MA Y wrote:
Jeff,

Thank you for your response. And which uptade do we have to purchase?

Jeff Overcash (TeamB) wrote:
Hi

We are registered RAD Studio Tokyo Professional and it seems our product doesn't have FDPhysODBCDriverLink so we can not use ODBC here. What we are trying to do is to migrate from old friend paradox to some other database like SQLite or etc.

We need this driver to be able to read Paradox tables without BDE and dump them into our new db. We can not just download an app to do that as we need to deploy this to our customers, so our app will do the work silently.

Does anyone know what is the problem?

ODBC FireDAC links do not ship with pro according to the feature list. It ships
with the Addon pack. SQLLite local connection native driver should be there though.

From - https://www.embarcadero.com/docs/rad-studio-feature-matrix.pdf

Pro Add-on pack

Enhanced in 10.2 Tokyo! Windows/Mac enterprise database support, including
MySQL, MariaDB, Microsoft SQL Server, Oracle Database, InterBase, PostgreSQL,
Informix, Sybase SQL Anywhere, Microsoft Access, IBM DB2 Server, Firebird,
Advantage Database, generic ODBC driver

Included in Pro

Enhanced in 10.2 Tokyo! Support for local databases, including Microsoft Access
database, SQLite and MariaDB database, InterBase ToGo / IBLite, InterBase on
localhost, MySQL Embedded, MySQL Server on localhost, Advantage Database local
engine, PostgreSQL on localhost, Firebird Embedded, Firebird on localhost

--
Jeff Overcash (TeamB)
(Please do not email me directly unless asked. Thank You)
Learning is finding out what you already know. Doing is demonstrating that you
know it. Teaching is reminding others that they know it as well as you. We are
all leaners, doers, teachers. (R Bach)
Lajos Juhasz

Posts: 801
Registered: 3/14/14
Re: FDPhysODBCDriverLink is missing in Delphi Tokyo
Click to report abuse...   Click to reply to this thread Reply
  Posted: Sep 26, 2017 5:47 AM   in response to: Ian Kirk in response to: Ian Kirk
Ian Kirk wrote:

Have Embarcadero really dropped support for a major DBMS that was
accessible in an earlier version?

According to the feature matrix for the pro version it's available only
as add on - FireDAC Client/Server pack. For more details:
https://www.embarcadero.com/docs/rad-studio-feature-matrix.pdf page 17

Enhanced in 10.2 Tokyo! Windows/Mac enterprise database support,
including MySQL, MariaDB,
Microsoft SQL Server, Oracle Database, InterBase, PostgreSQL, Informix,
Sybase SQL Anywhere,
Microsoft Access, IBM DB2 Server, Firebird, Advantage Database, generic
ODBC driver

Professional version: C2 D2

X2 = Optional with FireDAC Client/Server pack in Professional editions
(all products)

Ian Kirk

Posts: 12
Registered: 10/24/01
Re: FDPhysODBCDriverLink is missing in Delphi Tokyo
Click to report abuse...   Click to reply to this thread Reply
  Posted: Sep 26, 2017 6:09 AM   in response to: Lajos Juhasz in response to: Lajos Juhasz
Hmmmm - I have to admit, I'm struggling to see "not there at all" - which from my perspective is the change compared to the last version I used - as that wonderful an enhancement. :/

Ian

(Any and all sarcasm in the above comment directed solely at Embarcadero)

Lajos Juhasz wrote:
Ian Kirk wrote:

Have Embarcadero really dropped support for a major DBMS that was
accessible in an earlier version?

According to the feature matrix for the pro version it's available only
as add on - FireDAC Client/Server pack. For more details:
https://www.embarcadero.com/docs/rad-studio-feature-matrix.pdf page 17

Enhanced in 10.2 Tokyo! Windows/Mac enterprise database support,
including MySQL, MariaDB,
Microsoft SQL Server, Oracle Database, InterBase, PostgreSQL, Informix,
Sybase SQL Anywhere,
Microsoft Access, IBM DB2 Server, Firebird, Advantage Database, generic
ODBC driver

Professional version: C2 D2

X2 = Optional with FireDAC Client/Server pack in Professional editions
(all products)

Jeff Overcash (...

Posts: 1,529
Registered: 9/23/99
Re: FDPhysODBCDriverLink is missing in Delphi Tokyo
Click to report abuse...   Click to reply to this thread Reply
  Posted: Sep 26, 2017 9:48 AM   in response to: Ian Kirk in response to: Ian Kirk
Ian Kirk wrote:
Hmmmm - I have to admit, I'm struggling to see "not there at all" - which from my perspective is the change compared to the last version I used - as that wonderful an enhancement. :/

Ian

This isn't a change in policy though. I suspect you bought the add on pack for
XE5 because ODBC was not supported out of the box for Pro in XE5 either. Ever
since they introduced FireDAC, nothing that has been supported out of the box in Pro has
been removed (only things added).

From the XE5 feature matrix PDF

"New in XE5! Support for local databases, including Microsoft Access database,
SQLite database, InterBase ToGo / IBLite, InterBase on localhost, MySQL
Embedded, MySQL Server on localhost, Advantage Database local engine, PostgreSQL
on localhost, Firebird Embedded, Firebird on localhost"

All other drivers are marked in the matrix as optional for pro with the CS Addon.

Here is the wording from the Tokyo FM

"Enhanced in 10.2 Tokyo! Support for local databases, including Microsoft Access
database, SQLite and MariaDB database, InterBase ToGo / IBLite, InterBase on
localhost, MySQL Embedded, MySQL Server on localhost, Advantage Database local
engine, PostgreSQL on localhost, Firebird Embedded, Firebird on localhost"

Only thing added was MariaDB. XE4 actually lists FireDAC for Win/Mac to only be
available through the addon pack. Pro level only had it for local access on
mobile in pro.

(http://www.embarcadero.com.pl/produkty/rad-studio/rsxe4/rad-studio-feature-matrix.pdf
page 11)

So over the years things have been added to pro, I can not find any instance where
it was removed from pro.

--
Jeff Overcash (TeamB)
(Please do not email me directly unless asked. Thank You)
Learning is finding out what you already know. Doing is demonstrating that you
know it. Teaching is reminding others that they know it as well as you. We are
all leaners, doers, teachers. (R Bach)
Ian Kirk

Posts: 12
Registered: 10/24/01
Re: FDPhysODBCDriverLink is missing in Delphi Tokyo
Click to report abuse...   Click to reply to this thread Reply
  Posted: Sep 27, 2017 2:30 AM   in response to: Jeff Overcash (... in response to: Jeff Overcash (...
Hi Jeff,

Thanks for getting back to me on this, but I'm afraid I am very sure that we didn't have any add on packs installed with XE5. We're a small shop, and anything related to development tool purchases would go through me - other than the basic XE5 Pro and assorted 3rd party tools, there's nothing on our development and build systems.

(I'm extra sure of this because a few years back we were considering buying the client/server pack to allow direct SQL Server access - we decided not to in the short term as we'd verified we could get by by going through ODBC)

Our old XE5 systems are still accessible, and I did prepare a screenshot with the About dialog showing the [lack of] addons installed and the ODBC FireDAC link component in the same view - with help from Robert Triest and Lajos Juhasz available here: https://forums.embarcadero.com/thread.jspa?messageID=900848󛻰 (please let me know if this doesn't contain the necessary information).

Cheers,
Ian

Jeff Overcash (TeamB) wrote:
Ian Kirk wrote:
Hmmmm - I have to admit, I'm struggling to see "not there at all" - which from my perspective is the change compared to the last version I used - as that wonderful an enhancement. :/

Ian

This isn't a change in policy though. I suspect you bought the add on pack for
XE5 because ODBC was not supported out of the box for Pro in XE5 either. Ever
since they introduced FireDAC, nothing that has been supported out of the box in Pro has
been removed (only things added).

From the XE5 feature matrix PDF

"New in XE5! Support for local databases, including Microsoft Access database,
SQLite database, InterBase ToGo / IBLite, InterBase on localhost, MySQL
Embedded, MySQL Server on localhost, Advantage Database local engine, PostgreSQL
on localhost, Firebird Embedded, Firebird on localhost"

Edited by: Ian Kirk on Sep 27, 2017 11:22 AM

Edited by: Ian Kirk on Sep 27, 2017 11:25 AM
Robert Triest

Posts: 687
Registered: 3/24/05
Re: FDPhysODBCDriverLink is missing in Delphi Tokyo
Click to report abuse...   Click to reply to this thread Reply
  Posted: Sep 27, 2017 2:41 AM   in response to: Ian Kirk in response to: Ian Kirk
You can add attachments on the Attachment forum messages:

https://forums.embarcadero.com/forum.jspa?forumID=2
Ian Kirk

Posts: 12
Registered: 10/24/01
Re: FDPhysODBCDriverLink is missing in Delphi Tokyo
Click to report abuse...   Click to reply to this thread Reply
  Posted: Sep 27, 2017 3:21 AM   in response to: Robert Triest in response to: Robert Triest
Ah - thanks Robert, and Lajos...screenshot now uploaded!

Regards,
Ian

Robert Triest wrote:
You can add attachments on the Attachment forum messages:

https://forums.embarcadero.com/forum.jspa?forumID=2

Edited by: Ian Kirk on Sep 27, 2017 11:24 AM
Lajos Juhasz

Posts: 801
Registered: 3/14/14
Re: FDPhysODBCDriverLink is missing in Delphi Tokyo [Edit]
Click to report abuse...   Click to reply to this thread Reply
  Posted: Sep 27, 2017 3:45 AM   in response to: Ian Kirk in response to: Ian Kirk
Ian Kirk wrote:

Ah - thanks Robert, and Lajos...screenshot now uploaded!

Regards,
Ian

Robert Triest wrote:
You can add attachments on the Attachment forum messages:

https://forums.embarcadero.com/forum.jspa?forumID=2

Edited by: Ian Kirk on Sep 27, 2017 11:24 AM

Maybe it's listed in Installed products. Also you can check out the
LicenseManager.exe from the bin folder there should be an entry.
Ian Kirk

Posts: 12
Registered: 10/24/01
Re: FDPhysODBCDriverLink is missing in Delphi Tokyo [Edit]
Click to report abuse...   Click to reply to this thread Reply
  Posted: Sep 27, 2017 6:51 AM   in response to: Lajos Juhasz in response to: Lajos Juhasz
Thanks - used, and info on display in attachments.

It turns out we have got the Mobile add-on present (if memory serves it was free as a special offer at the time...never actually used it!). I guess it's possible that introduced the ODBC link, although from my limited understanding ODBC does seem like a very un-mobile thing.

Lajos Juhasz wrote:
Ian Kirk wrote:

Ah - thanks Robert, and Lajos...screenshot now uploaded!

Regards,
Ian

Robert Triest wrote:
You can add attachments on the Attachment forum messages:

https://forums.embarcadero.com/forum.jspa?forumID=2

Edited by: Ian Kirk on Sep 27, 2017 11:24 AM

Maybe it's listed in Installed products. Also you can check out the
LicenseManager.exe from the bin folder there should be an entry.
Lajos Juhasz

Posts: 801
Registered: 3/14/14
Re: FDPhysODBCDriverLink is missing in Delphi Tokyo
Click to report abuse...   Click to reply to this thread Reply
  Posted: Sep 27, 2017 2:50 AM   in response to: Ian Kirk in response to: Ian Kirk
Ian Kirk wrote:

[snip]

can't immediately see how that could be uploaded to here, though.

It's a bit tricky on the server only the forum Attachments
(https://forums.embarcadero.com/forum.jspa?forumID=2) allows
attachments. You should upload there the screen shot and post a message
here containing the link or the caption of the thread in the attachment
forum.
Robert Triest

Posts: 687
Registered: 3/24/05
Re: FDPhysODBCDriverLink is missing in Delphi Tokyo
Click to report abuse...   Click to reply to this thread Reply
  Posted: Sep 27, 2017 2:52 AM   in response to: MA Y in response to: MA Y
What we are trying to do is to migrate from old friend paradox to some other database like SQLite or etc.
Can't you do this job by using DBGo or DBExpress components?
Legend
Helpful Answer (5 pts)
Correct Answer (10 pts)

Server Response from: ETNAJIVE02