• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

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

 
Greenhorn
Posts: 23
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
Ranch Hand
Posts: 567
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
reply
    Bookmark Topic Watch Topic
  • New Topic