Hi Abdul,
One option would be to use FreeTDS driver as it is known to work with
Sequoia/MS SQL.
Otherwise to get more information about the root cause of the error, you
will have to set the
'org.continuent.sequoia.controller.backend.DatabaseBackend' logger in
log4j.properties to DEBUG.
Replace:
log4j.logger.org.continuent.sequoia.controller.backend.DatabaseBackend=INFO,
Console,Filetrace
by
log4j.logger.org.continuent.sequoia.controller.backend.DatabaseBackend=DEBUG,
Console,Filetrace
Keep us posted with your progress,
Emmanuel
Can any one help me in sorting out this issue?? Still
not able to use Sequoia with SQL Server 2005. I m in a
process to migrate from sql 2000 to sql 2005. Because
of this issue i am not able to migrate.
Regards,
Abdul
Note: forwarded message attached.
____________________________________________________________________________________
Looking for last minute shopping deals?
Find them fast with Yahoo! Search. http://tools.search.yahoo.com/newsearch/category.php?category=shopping
------------------------------------------------------------------------
Subject:
Re: [Sequoia] SQLDriver not compatible with Sequoia
From:
abdul qaiyum <[EMAIL PROTECTED]>
Date:
Tue, 11 Mar 2008 22:38:54 -0700 (PDT)
To:
Sequoia general mailing list <[email protected]>
To:
Sequoia general mailing list <[email protected]>
Hi,
Thanx for your reply. I have done the following
configuration:
<VirtualDatabase name="Livestock">
<Backup>
<Backuper backuperName="Octopus"
className="org.continuent.sequoia.controller.backup.backupers.OctopusBackuper"
options="zip=true"/>
</Backup>
<AuthenticationManager>
<AdminUser username="admin" password=""/>
<VirtualUser vLogin="iboss" vPassword="">
<AccessControl defaultPolicy="denyAll">
<Accept address="127.0.0.1">
</Accept>
</AccessControl>
</VirtualUser>
</AuthenticationManager>
<DatabaseBackend name="LivestockDB"
driver="com.microsoft.jdbc.sqlserver.SQLServerDriver"
url="jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=Livestock;SelectMethod=Cursor;"
connectionTestStatement="Select 1">
<ConnectionManager vLogin="iboss" rLogin="sa"
rPassword="aoLKvVCCwHc=">
<VariablePoolConnectionManager
initPoolSize="10" minPoolSize="5"
maxPoolSize="100" idleTimeout="30"
waitTimeout="10"/>
</ConnectionManager>
</DatabaseBackend>
I tried changing the
driver="com.microsoft.sqlserver.jdbc.SQLServerDriver"
and url="jdbc:sqlserver". In this case it is giving
the error in loading the drivers.
Please let me know,can we use Sequoia with SQL Server
2005. If yes, then what should be the configuration.
Your help will be highly appreciated.
Regards,
Shaikh Abdul Qaiyum.
--- Emmanuel Cecchet <[EMAIL PROTECTED]> wrote:
Hi,
java.sql.SQLException: Driver
com.microsoft.jdbc.sqlserver.SQLServerDriver is
not
Sequoia compliant
at
org.continuent.sequoia.controller.backend.DatabaseBackend.checkDriverCompliance(DatabaseBackend.java:560)
This is probably just a configuration problem in
your connection
definition.
You can get that kind of error if the controller
cannot connect to the
backend.
Do you have other error messages?
How did you configuration your backend?
Thanks for your interest in Sequoia,
Emmanuel
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
--
Emmanuel Cecchet - Research scientist
EPFL - LABOS/DSLAB - IN.N 317
Phone: +41-21-693-7558
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
