Per Scott's suggestion to David in an earlier post, I'm trying out the D2RQ/jTDS/SQLServer config. The import seems to go well. I see the proper d2rq, mapping, schema, and test files; they contain proper ontologies for the database that I'm connecting to. However, an xxx- Test.owl.owlinf is never generated and it doesn't appear to be querying the database for instances of the classes when I go look for those.
Just to test the data, I exported everything to MySQL using the MySQL Migration Tool which works like a charm, BTW. Highly recommended. Found that at http://stackoverflow.com/questions/129/how-to-export-data-from-sql-server-2005-to-mysql. I ran the D2RQ import on that with JDBC and all is well. So I have a working solution, but I'd really like to figure out how to talk to that native SQL Server DB. I realize this is very likely not a TBC problem, per se, but the experts seem to be here, so I thought I'd post the issue. Any suggestions on where I could troubleshoot? User/passwd that I'm using is the database owner, and it's getting the database tables info, so it doesn't seem to be a connection problem. Could it just be a SQL Server glitch? An issue with the jTDS driver? Thanks, Chris --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "TopBraid Composer Users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/topbraid-composer-users?hl=en -~----------~----~----~----~------~----~------~--~---
