Jody; Quick answer to your second question. The previous version of Composer used the D2RQ Class.forName approach for specifying the driver class. There were problems with this approach because Eclipse uses its own classloaders to work with the Eclipse plugin architecture.
The jTDS driver (http://jtds.sourceforge.net/) is a general JDBC driver that supports a number of databases, including SQL Server. All that you need in this case is a proper URL to address the database (the "No suitable driver" indicates a problem with the URL). If you are using a localhost connection, you may be able to get away with: jdbc:sqlserver://localhost/<database> ...but you may need to specify a port number: jdbc:sqlserver://127.0.0.1:<port>/<database> Where <port> is the port the database is listening to and <database> is the name of the database. Try some variants of that and let us know what happens... -- Scott On Nov 13, 12:07 pm, Jody <[EMAIL PROTECTED]> wrote: > I tried the jtds driver and got the following error: > rethrew: java.sql.SQLException: No suitable driver > > The driver URL field is not available for me to specify anymore in the > wizard. I'm wondering why that is? > > On Nov 13, 11:48 am, Scott Henninger <[EMAIL PROTECTED]> > wrote: > > > Jody, have you tried using the jTDS Driver class? It should work with > > SQL Server. The syntax for the Database URL would be: > > jdbc:sqlserver://host\instance:port/database > > > -- Scott > > > On Nov 12, 5:25 pm, Jody <[EMAIL PROTECTED]> wrote: > > > > Hello all. > > > > Today I updated my version of TBC-SE from 2.5.x to 2.6.2. I had been > > > testing with the d2rq import and had to use a jdbc driver not included > > > to import from SQLServer: > > > 'com.microsoft.sqlserver.jdbc.SQLServerDriver' > > > > The 2.6.2 release removed the driver URL field from the d2rq wizard. > > > Now I am not able to use arbitrary drivers and the drivers included > > > don't work. Is there a way to add to the driver pulldown list > > > specifying the URL somewhere? > > > > Thanks, > > > Jody- Hide quoted text - > > > - Show quoted text - > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
