I want to connect my .net application with D3 pick database 9.0 (Windows version). In Earlier days, people used ODBC driver from Pick to write VB6 applications connecting with D3. Can I use same driver for .NET application? Pick also provides .NET API for .NET and D3 connectivity.
What confuses me is what's the difference between ODBC driver and .NET API? Is .NET API a replacement of ODBC driver for .NET or it is a further abstraction over ODBC for .NET?
Here is something you are missing. With the ODBC Driver D3 comes with something called the Class Library that are compiled in Visual Basic 6. You can still use those with no problems, but you will have to use COM Interop that adds a tier and then ODBC that does add another tier itself.
As noted before I recommend using the .NET API. I have used it and the only thing I have found is that is a little bit messy, so I just created a library from that to have dynamic matrices like m[2,3,2] and retrieve the actual value of the 'sub value'.