.NET or OLE DB Connectivity to MySql, Sqlite, Firebird etc.

Discussion forum about all things Gupta, OpenText and the community.
gerSchub
Germany
Posts: 7
Joined: 07 May 2018, 09:48
Location: Munich, Germany

.NET or OLE DB Connectivity to MySql, Sqlite, Firebird etc.

Post by gerSchub » 10 May 2018, 10:03

Hi All,

I wanted to establish a database Connection via .NET Provider or via OLE DB to one of the above named databases from a TD6/7 .NET application.
Unfortunately with no success.
Everyone of OpenText/Gupta and Partners told me: "Yes, of course it works, no Problem". But after some days of trying I can't believe this.
My question is:

Has someone successfully established a connection to one of these databases via .NET Provider or via OLE DB using 'SqlConnectDotNet' or 'SqlCreateSession' (not via ODBC and not to the predefined Oracle, SqlServer and Sqlbase database connections)?

If yes, please tell me to which database using which provider. Registered provider or not registered? Which location has the Driver dll? Which connection string has been used?
I would appreciate any help.

Thanks,
Gerhard

Harald
Germany
Posts: 175
Joined: 30 Mar 2017, 06:16
Location: Rosenheim, Germany

Re: .NET or OLE DB Connectivity to MySql, Sqlite, Firebird etc.

Post by Harald » 13 May 2018, 17:35

Hi Gerhard,

you are right! I tried to connect to DB2 with a connect string which works in Win32, but it didn't work in a .NET application. But I found several other bugs in TD 7.04 .NET in only a few lines of code (message box with IDOK shows okay and cancel button ...). Seems that TD .NET is still unusable.

Kind regards
Harald

Return to “General Discussion”

Who is online

Users browsing this forum: [Ccbot] and 2 guests