Hi, there.
We had an app runnning on top of WebSphere Application Server 3.0.2.
The database is on SQL Server 7.0 (Yeah, I know, no big deal).
And the connection was driven by an jdbc/odbc bridge (yeah, I know too, deep problem).
But it was working (with some problems).
We migrated the app to WAS 3.5
I upgrade the app using VAJ 3.5 and everything works fine.
The
servlets and
jsp's are working perfectly, the SQL queries have been optimized, and everybody was happy.
(The first question here is .. Kyle (Brown) you say "It's never going to work. We don't support the JDBC/odbc bridge as a datasource in VAJ or WebSphere..." in a message posted in JavaRanch about "Unrecognized database or driver "sun.jdbc.odbc.JdbcOdbcDriver"; using generic settings" but in my VAJ 3.5 it's working just fine, why ?)
Up to this moment everything was fine, but .. when I install my webapp in WAS 3.5 I have the same error that the boy with the message in JavaRanch
Unrecognized database or driver
"sun.jdbc.odbc.JdbcOdbcDriver"; using generic settings
How is this possible ? How I do resolve this ?
I know that when could buy a
jdbc driver for SQL
Server but I would like to know is there is another
option (as few money we expense, the better)?
In VAJ 3.5 my app runs OK and in WAS 3.5 the driver is not supported ?
Please, help us 'cause we don't know what to do and we're slipping from our deadline.
Thanks in advance.