I am not able to connect to my SQL Server 2008 from the SQL Developer Data Modeler. Although I do have jtds-1.2.jar on my machine and I can connect the SQL server through the SQL Developer, but still i'm not able to connect through the data modeler. I need to re-engineer and generate data model for some existing schemas.
Here is what I'm following:-
File->Data Modeler -> import -> Data Dictionary -> Add new connection -> JDBC ODBC Bridge -> Other Third Party Driver
now when I'm giving the JDBC URL and the Driver, It throws an error message stating that the driver could not be found.
Please let me know what I can do to solve this, any help would be appreciated.
I'd try 1st to connect to the db from sqldeveloper (through jtds - no ODBC involved) and see if you can browse your db and issue sql statements in a worksheet. Then export that connection in xml format and import that from the modeler.