Perhaps someone else can confirm :



Importing VFP DBC with very latest 1.66:



tables of selected DBC show in picklist. Whether selecting all or some, no tables are imported into DDT schema. Database created, but no tables.



TIA

see attached file please

Keith Chisarik

Well, let's just take out some of the variables and maybe you can determine what the issue is on your side.  Here is what is done within the DDT VFP table import:

1. Connection String = "Provider=VFPOLEDB;Data Source=C:\MyDBC.dbc"
2. An OleDbConnection is created using the above specified connection string
3. We then call the GetOleDbSchemaTable to get the tables within the DBC
   
   
   Dim myTables As DataTable
   myTables = Connection.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, New Object() {Nothing, Nothing, Nothing, "TABLE"})
   
   
4. This will retrieve all of the tables.  You can then get all of the columns for a table using this call on the same connection object:
   
   
   Dim myColumns As DataTable
   myColumns = Connection.GetOleDbSchemaTable(OleDbSchemaGuid.Columns, New Object() {Nothing, Nothing, "TableName",Nothing})
   
   

That's it....so it would appear that one of these two calls are failing in your environments.  You might just want to create a test program and try this yourself to see if you can determine if an exception is being thrown.

Also, this should have abolsutely nothing to do with the latest build as this portion of the import wizard has not changed in a very long time and the import is working for us as well as a number of other users on this same build (even using the DBC provided by Edhy).

Let me know if you have any insight or exceptions thrown with the above code and then we may be able to figure out an all around solution.