Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Unix/apache/tomcat/JSP using JDBC to SQL Server7.0

 
Sridhar Kilambi
Greenhorn
Posts: 23
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hai all,
I have a peculiar issue. I am using OS as Unix, web server as apache, application server as tomcat, and trying to connect to SQL server 7.0 using JSP and a product of datadirect called JDBC Connect for JDBC connectivity.
the problem is that I get this error 'This driver is locked for use with embedded application´┐Ż when I try to run a JSP page trying to access SQLSERVER table.
At there site, i am told to rerun the license utility. When I try to rerun the license utility I get another error 'GUI install not supported. Please check for appropriate command line usage'.
can anyone help me on this.
Secondly can any suggest the best JDBC connector (downloadable, later on buy) for the above requirement. I think data direct maybe the problem too.
Best regards
Sridhar
 
Adam Hardy
Ranch Hand
Posts: 567
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I'm not trying to answer your question here, I'm afraid, but how come Microsoft don't do their own JDBC driver for MSSQL7?
 
Sridhar Kilambi
Greenhorn
Posts: 23
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hai adam
actully i believe MS is a late entrant into JDBC,
it now has a beta for SQL Server 2000 rather than sql server 7
best regards
 
Adam Hardy
Ranch Hand
Posts: 567
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Did you sort out your problem with the installation? It's not clear if you are installing the drivers on the Linux or the NT box. It's also not clear what your problem is with the command line installation procedure.
Thanks for the info.
Adam
 
Sridhar Kilambi
Greenhorn
Posts: 23
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Dear Adam
at the point of writing we are still testing.
we have 'solved' the problem by 'assuming' that we know the problem.
i think when we open a connection to the server, all other jdbc/odbc drives have a inbuilt capacity to close the connection once the conncetion is deactive. we now think that datadirect does not have this in the trail version. so we modifed the code to use the same connection from login to logout.
as of now the problem does not arise. but as said earlier we are still testing.
best regards
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic