|
Home > Archive > WebSphere Portal Server > March 2004 > new SQL Server problem
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
new SQL Server problem
|
|
|
| Ok I got my previuos path problems worked out. now all of my validate
actions are successfull. Now when I do database-transfer-export-linux I get:
action-gather-utilities-wps:
[java] prefix is: cswps.
[java] Level.SEVERE, Error loading JDBC Driver :
com.microsoft.jdbc.sqlserver.SQLServerDriver
[java] Level.SEVERE, Error Connecting db
[java] java.sql.SQLException: No suitable driver
[java] at
java.sql.DriverManager.getConnection(DriverManager.java:563)
[java] at
java.sql.DriverManager.getConnection(DriverManager.java:194)
[java] at com.ibm.wps.config.db.Database.init(Database.java:104)
[java] at
com.ibm.wps.config.db.transfer.CSTextProcessor.main(CSTextProcessor.java:97)
Any thoughts?
| |
|
| Well, this is typical IBM.
The script checked for DB Drivers in <WPS>/config/DBTransfer/dist/lib.
By default db2java.jar is there. Even though I've already specified the
path to the SQLServer JDBC libs in wpsconfig.properties, I had to copy
them to that directory.
Thanks IBM for ommiting that step!
Rob wrote:
> Ok I got my previuos path problems worked out. now all of my validate
> actions are successfull. Now when I do database-transfer-export-linux I
> get:
>
>
> action-gather-utilities-wps:
> [java] prefix is: cswps.
> [java] Level.SEVERE, Error loading JDBC Driver :
> com.microsoft.jdbc.sqlserver.SQLServerDriver
> [java] Level.SEVERE, Error Connecting db
> [java] java.sql.SQLException: No suitable driver
> [java] at
> java.sql.DriverManager.getConnection(DriverManager.java:563)
> [java] at
> java.sql.DriverManager.getConnection(DriverManager.java:194)
> [java] at com.ibm.wps.config.db.Database.init(Database.java:104)
> [java] at
> com.ibm.wps.config.db.transfer.CSTextProcessor.main(CSTextProcessor.java:97)
>
>
>
>
> Any thoughts?
|
|
|
|
|