Upgrade 8.12 Tools Release 8.97 - connection problem

Pam

Member
The cnc is working on upgrading to 8.12 with tools release 8.97. I am a developer trying to view a power form.
When I try to run a power form from omw I get the error "No suitable driver" (see the jas.log at bottom).

We set up a JDBC provider in websphere to the SQLJDBC.jar with a class path of com.microsoft.sqlserver.jdbc.SQLServerDriver

Does anyone know what might be wrong?

We believe the jdbc.ini is correct:

[JDBj-BOOTSTRAP SESSION]
user=JDE
password=
environment=DV812
role=*ALL

[JDBj-BOOTSTRAP DATA SOURCE]
name=System - 812
databaseType=O
server=amefird2
serverPort=
database=jde812d
physicalDatabase=
owner=SY812
lob=false
unicode=true
#databaseInstance=


[JDBj-SPEC DATA SOURCE]
name=Local - DV812
databaseType=M
server=localhost
serverPort=3372
database=JDELocal_DV812
physicalDatabase=JDELocal_DV812
owner=dbo
lob=false
unicode=true
databaseInstance=JDELocal
user=sa
password=

[JDBj-JDBC DRIVERS]
ORACLE=oracle.jdbc.driver.OracleDriver
#AS400=com.ibm.as400.access.AS400JDBCDriver
#SQLSERVER=com.microsoft.jdbc.sqlserver.SQLServerDriver
SQLSERVER=com.microsoft.sqlserver.jdbc.SQLServerDriver
#UDB=COM.ibm.db2.jdbc.app.DB2Driver

[JDBj-ORACLE]
tns=c:\e812\JAS\EA_JAS_80.ear\webclient.war\WEB-INF\tnsnames.ora

[JDBj-LOGS]
jdbcTrace=false

[JDBj-SERVER]
dbcsConversionTolerant=true







JAS.LOG FILE:
12 Mar 2009 10:14:10,609 [APP ] - [JDBJ] SpecGenOnDemandFlag: returning cached value [true].
12 Mar 2009 10:14:10,609 [SEVERE] - [JDBJ] This server will not detect package deployments.
12 Mar 2009 10:14:10,609 [SEVERE] - [JDBJ] The administrator must manually regererate the serialized object database for deployed packages to take effect.
12 Mar 2009 10:14:10,641 [SEVERE] - [JDBJ] com.jdedwards.database.base.JDBException: [DATABASE_CONNECT_FAILED] Database Connection failed for DataSource Local - DV812. java.sql.SQLException: No suitable driver
12 Mar 2009 10:14:10,641 [SEVERE] - [JDBJ] com.jdedwards.database.base.JDBException: [DATABASE_CONNECT_FAILED] Database Connection failed for DataSource Local - DV812. com.jdedwards.database.base.JDBException: [DATABASE_CONNECT_FAILED] Database Connection failed for DataSource Local - DV812.
 
Back
Top