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]
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.
--
-- 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.
|
