This week's book giveaway is in the Design forum.
We're giving away four copies of Design for the Mind and have Victor S. Yocco on-line!
See this thread for details.
Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Configuration of SQL Server 7.0 in Websphere 4.0

 
Ather Naqvi
Greenhorn
Posts: 11
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I would be thankful to anybody telling me how to configure SQL Server 7.0 in webSphere 4.0. I have been trying this for two days but reamin unsuccesful.
 
xavirm
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi, have you solved it ?
I have WAS 3.5 but I cannot have it working SQL Server 7.0.
In VAJ 3.5 everything works fine.
I really appreciate yopur help.
Thanks in advance.
 
Simon Song
Ranch Hand
Posts: 217
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Don't understand your problem, you neeed a JDBC driver for SQLServer 7. WAS comes with merant driver, just use that to configure the datasource.
 
xavirm
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Excuse me,Simon Song.
Are you telling that WAS 3.5 comes with a Merant (Data Direct) jdbc driver for SQL Server 7.0 ?
I'm experiencing problems when I try to use the jdbc/odbc bridge.
Kile Brown said in another post that jdbc/odbc bridge is not supported by WAS 3.5 AND VAJ 3.5, but I have my VAJ 3.5 Application running smoothly.
The problem comes when I try to run it on WAS 3.5.
I got the following message :
"Unrecognized database or driver
"sun.jdbc.odbc.JdbcOdbcDriver"; using generic settings"
I don't know how to resolve this. I tough I had to buy a jdbc driver for SQL Server 7.0 if I had received a way to fix this up, but if you know that WAS comes woth a Merant JDBC driver for SQL Server 7.0 this would be great!!
Can you help me telling me where in the setup disks can I find this driver ?
Thanks in advance.
[ June 24, 2002: Message edited by: xavirm ]
 
xavirm
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Excuse me,Simon Song.
Are you telling that WAS 3.5 comes with a Merant (Data Direct) jdbc driver for SQL Server 7.0 ?
I'm experiencing problems when I try to use the jdbc/odbc bridge.
Kile Brown said in another post that jdbc/odbc bridge is not supported by WAS 3.5 AND VAJ 3.5, but I have my VAJ 3.5 Application running smoothly.
The problem comes when I try to run it on WAS 3.5.
I got the following message :
"Unrecognized database or driver
"sun.jdbc.odbc.JdbcOdbcDriver"; using generic settings"
I don't know how to resolve this. I though I had to buy a jdbc driver for SQL Server 7.0 if I had received a way to fix this up, but if you know that WAS comes woth a Merant JDBC driver for SQL Server 7.0 this would be great!!
Can you help me telling me where in the setup disks can I find this driver ?
Thanks in advance.
 
Simon Song
Ranch Hand
Posts: 217
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Yeah, Merant's SequeLink(Type 3) definitely comes with WAS3.5. You should be able to download it from IBM support website.
I don't know where to dl DataDirect(Type 4) driver, but you can try IBM tech support.
JDBC-ODBC bridge has many issues, try avoid it in production environment.
 
xavirm
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
OK, thanks.
I'll try it.
 
xavirm
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Simon.
I installed the Merant JDBC driver.
But now, I don't get the "Unrecognized database or driver .." message.
I just get a "null:init" message and my browser shows a blank screen.
Do you know waht's happening ?
Best regards.
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic