Embarcadero / IB.NETDataProvider

InterBase database .NET Data Provider
Other
12 stars 7 forks source link

DDEX not installing with package. #3

Closed GirusVirus closed 3 years ago

GirusVirus commented 3 years ago

After installing the github package, I was able to successfully access the db. However the I was not able to create a data connection as the ADO support was not installed in the DDEX for VS 2019

jeffovercash commented 3 years ago

The ADO driver is a separate install. The readme for the DDEX driver recommends using the installer to install it. The ADO.NET driver installer properly sets up the machine.config changes outlined in the readme for you.

GirusVirus commented 3 years ago

Jeff,

Thank you for responding. But I looked everywhere for the installer. No where to be found. I tried to compile from GitHub but had many errors. If you can point me to the installer I would appreciate it.

Best Regards

On Fri, May 21, 2021 at 11:19 PM jeffovercash @.***> wrote:

The ADO driver is a separate install. The readme for the DDEX driver recommends using the installer to install it. The ADO.NET driver installer properly sets up the machine.config changes outlined in the readme for you.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/Embarcadero/IB.NETDataProvider/issues/3#issuecomment-846358418, or unsubscribe https://github.com/notifications/unsubscribe-auth/ARTBRAL3UM7VJHA7ETOB3MDTO5EH3ANCNFSM45J6CACA .

-- Kind Regards

Ricardo Casillas

jeffovercash commented 3 years ago

Look at the releases https://github.com/Embarcadero/IB.NETDataProvider/releases/tag/v7.10.2 There are two msi installers, one for the ADO driver and one for the DDEX driver. The DDEX has manual steps to get installed into VS 2019, look at the docx included in both installers or as a separate download in the releases for detailed instructions on installing the DDEX driver into VS itself.

GirusVirus commented 3 years ago

Hi Jeff, thank you I got it to work and I was able to create a connection. Now the only issue I have is that every time I update VS2019, the private registry reverts back and erases the edits. Is there a way to make the changes persistent?

jeffovercash commented 3 years ago

Unfortunately, no. The same issue was reported on the Firebird DDEX forums that this one is highly based on. I found that annoying myself during development and testing.

Glad it is working for you now. The installers make it much easier to have everything in its right place and the right config files updated. Unfortunately once Visual Studio went to private registries as of VS 2017 the whole DDEX automatic installer becomes impossible.

GirusVirus commented 3 years ago

Jeff, that is what I thought. However, it is possible as IBProvider was able to do it. I have been using IBProvider for some time and it seems to be able to keep the configuration alive after updates. He might be implementing a different tech, as those ADO.NET drivers and also connects to system global OLE DB, which can be used from excel, and other applications that support OLE DB. Thanks.

jeffovercash commented 3 years ago

I found that the DDEX changes in Microsoft's docs is spread out and not that easy to follow. If you run across anything on this subject add a link in this comment chain and I'll see it and investigate further. Just figuring out where all the pieces went (machine.config, etc) was troublesome.

GirusVirus commented 3 years ago

Thank you, will do.

jeffovercash commented 3 years ago

The IBProvider is installing it through VSIX. The code we based the IB DDEX on is the older style installation. That is probably the difference and why it gets lost after updates.

GirusVirus commented 3 years ago

Jeff, thanks for the update. Good to know.

On Sat, May 22, 2021 at 8:05 PM jeffovercash @.***> wrote:

The IBProvider is installing it through VSIX. The code we based the IB DDEX on is the older style installation. That is probably the difference and why it gets lost after updates.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/Embarcadero/IB.NETDataProvider/issues/3#issuecomment-846494074, or unsubscribe https://github.com/notifications/unsubscribe-auth/ARTBRANGL7XVICSOBLR6IRTTPBWIBANCNFSM45J6CACA .

-- Kind Regards

Ricardo Casillas