Hello Scott, Yes, I've done that already To connect to Microsoft SQL Server databases, you need to prepare Microsoft's JDBC Driver for SQL Server<http://msdn.microsoft.com/en-us/sqlserver/aa937724.aspx> for use with the Eclipse environment using the bnd utility available here<http://www.topquadrant.com/resources/bnd.zip> or from TopQuadrant's Resources<http://www.topquadrant.com/resources/resources_overview.html> page. The download is a zip file that includes the biz.aQute.bnd.jar utility. To use it, the following command creates a file called sqljdbc4.bar: java -jar biz.aQute.bnd.jar wrap sqljdbc4.jar Rename the sqljdbc4.bar file to have a .jar extension (for example, sqljdbc4_equinox.jar) and put it in the dropins folder of your TopBraid installation Additionally, I thought I may have screwed the .bar file up, so I found one in this thread from June 17th.
To let you know, the Studio did not give the option for the connection type: jdbc:jtds:sqlserver:<server......> until I added the modified jar file. I've tried different driver classes also. -Rocky From: [email protected] [mailto:[email protected]] On Behalf Of Scott Henninger Sent: Monday, December 23, 2013 10:41 AM To: [email protected] Subject: Re: [topbraid-users] Re: trying to connect to MSSQL DB using D2RQ Rocky, please take a look at the Composer Help file at > Working with Data Back Ends > Working with Relational Databases > Importing Relational Databases with D2RQ, and follow the link for working with MySQl and SQL server databases. You will need to install the driver jar for these databases, and the SQL Server jar requires an Equinox wrapper. There are instructions and pointers for downloads in the instructions. -- Scott On 12/23/2013, 8:28 AM, R Wiethorn wrote: Hello, I'm trying to connect also to a local Instance of MS SQL 2008. Has anyone been able to do so? I'm getting the error: An error has occurred. See error log for more details. Cannot instantiate SQL Driver net.sourceforge.jtds.jdbc.Driver: please place driver file jtds.jar into folder C:\tbcme-win32.win32.x86_64-4.3.1.v20131101-1317R\tbcme\dropins\ and restart TopBraid Database connection to jdbc:jtds:sqlserver://6LJV9T1-X7:1433/Movie failed (user: tbc): No suitable driver found for jdbc:jtds:sqlserver://6LJV9T1-X7:1433/Movie (E54) I'm attaching the screen shot of my connection object. I've made my own sqljdbc4.bar file using the utility, and I've also downloaded the one found in this thread, but it still doesn't work. I've also tried using LocalHost in the connection string versus the PC name (6LJV9T1-X7) My Version: : 4.3.1.v20131101-1317R Any other suggestions? Thanks, Rocky On Saturday, January 5, 2013 9:41:51 AM UTC-5, Jonas wrote: Dear All, Happy new year everyone, and congratulations on the new release. I'm using the new Topbraid Standard version 4.1 and I try to connect topbraid to a MSSQL Database using the userguide (import -> create connection for RDBMS Source (using d2rq)). As instructed I downloaded the latest version of the jtds sql drivers, renamed it to jtds.jar and put it into my topbraid/dropins folder. I add the remaining connection information (url, username, password) but the following error pops up: An error has occurred. See error log for more details. Cannot instantiate SQL Driver net.sourceforge.jtds.jdbc.Driver: please place driver file jtds.jar into folder [removed folders]\dropins\ and restart TopBraid. Database connection to [removed connection string] failed (user: sa): No suitable driver found for [removed connection string] (E54) The connection string is correct, the database is running, I can access it via my own Java DB test script using the very same jtds drivers from the dropins folder. I'm working with Java 1.6, tried using older sql drivers, tried microsofts sql drivers, tried an old Topbraid version and running topbraid as an administrator with no success. Is there anybody experiencing the same problems? Thanks a lot for your support. kind regards, Jonas -- -- You received this message because you are subscribed to the Google Group "TopBraid Suite Users", the topics of which include Enterprise Vocabulary Network (EVN), TopBraid Composer, TopBraid Live, TopBraid Insight, SPARQLMotion, SPARQL Web Pages and SPIN. To post to this group, send email to [email protected]<mailto:[email protected]> To unsubscribe from this group, send email to [email protected]<mailto:[email protected]> For more options, visit this group at http://groups.google.com/group/topbraid-users?hl=en --- You received this message because you are subscribed to the Google Groups "TopBraid Suite Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. For more options, visit https://groups.google.com/groups/opt_out. -- -- You received this message because you are subscribed to the Google Group "TopBraid Suite Users", the topics of which include Enterprise Vocabulary Network (EVN), TopBraid Composer, TopBraid Live, TopBraid Insight, SPARQLMotion, SPARQL Web Pages and SPIN. To post to this group, send email to [email protected]<mailto:[email protected]> To unsubscribe from this group, send email to [email protected]<mailto:[email protected]> For more options, visit this group at http://groups.google.com/group/topbraid-users?hl=en --- You received this message because you are subscribed to the Google Groups "TopBraid Suite Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. For more options, visit https://groups.google.com/groups/opt_out. -- -- You received this message because you are subscribed to the Google Group "TopBraid Suite Users", the topics of which include Enterprise Vocabulary Network (EVN), TopBraid Composer, TopBraid Live, TopBraid Insight, SPARQLMotion, SPARQL Web Pages and SPIN. 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-users?hl=en --- You received this message because you are subscribed to the Google Groups "TopBraid Suite Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
