aspose file tools*
The moose likes JDBC and the fly likes Unix/apache/tomcat/JSP using JDBC to SQL Server7.0 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Unix/apache/tomcat/JSP using JDBC to SQL Server7.0" Watch "Unix/apache/tomcat/JSP using JDBC to SQL Server7.0" New topic
Author

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

Sridhar Kilambi
Greenhorn

Joined: Apr 19, 2002
Posts: 23
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

Joined: Oct 09, 2001
Posts: 566
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?


I have seen things you people would not believe, attack ships on fire off the shoulder of Orion, c-beams sparkling in the dark near the Tennhauser Gate. All these moments will be lost in time, like tears in the rain.
Sridhar Kilambi
Greenhorn

Joined: Apr 19, 2002
Posts: 23
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

Joined: Oct 09, 2001
Posts: 566
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

Joined: Apr 19, 2002
Posts: 23
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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Unix/apache/tomcat/JSP using JDBC to SQL Server7.0