mkamoski wrote:
All--
Please help clear something up regarding the use of OLEDB and ODBC in LLBLGen.
I have searched this site a bit and have looked at the LLBLGen Help File, "Concepts - Database drivers" and I am still unclear.
Here are my questions...
(A). From what I gather in the Help File, "Concepts - Database Drivers", it is possible to Access and Oracle and some other databases. Am I reading this correctly? Is this right?
Could you please re-formulate that question? But if you mean: can I access oracle through odbc or oledb in llblgen pro, the answer is no. OleDB is only used for MS Access. To connect and use a given database type, use the specified provider
(B). If Access-based code generation is available, then what should one select in the "Generate" process for the "Template Set To Use"? That is, how does one actually generate code for Access's driver given that it looks like the shipped templates are for SqlServer and SqlServerCe only?
You create a project from an MS Access mdb file, then generate code from there, as you can then select the access templatesets.
(C). If Oracle-based code generation is available, then what should one select in the "Generate" process for the "Template Set To Use"? That is, how does one actually generate code for Oracle's driver given that it looks like the shipped templates are for SqlServer and SqlServerCe only?
Create a project from your oracle database, and select the oracle templates then. You have to create a project from the original db, because types are often very different from db to db, so using an MS Access project to generate oracle code isn't possible.
(D). Is it possible to use LLBLGen with any OLEDB driver?
No, only for MS Access
(E). From what I gathered in another post, http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=2836&HighLight=1 , it looks like using an ODBC driver is not possible with LLBLGen. Fine. No issue. I think that I understand why. Am I reading this right? Is it, in fact, the case that LLBLGen cannot be used with an ODBC driver?
Correct.
