Hi Rob
Yes, you're right sql7 and sql2000 have the same logon
distinction. Moreover I am using the JDBC-ODBC bridge
provided by SUN Microsystems in their jdk. I am using a
User DSN in ODBC, with SQL Server logon.
this is a part of the code:
...
Connection con = null;
Driver drv = (Driver)
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
con =
DriverManager.getConnection("jdbc:odbc:IntraDSN",(String)
session.getAttribute("LOG"),(String)
session.getAttribute("PASS"));
...
-IntraDSN: is my User DSN (ODBC) on the machine where the
tomcat server (containing the jsp files) is running
-The LOG attribute and PASS attribute are the login and
password provided by the user on a seperate page to connect
to sql server with its priveledges...
The problem is whatever the user puts as login and password
the server (tomcat3.2) connects to MSSQL with the user that
started it...at least this is what I think, after executing
the sp sp_who on the SQL server
Thanks
Fady
__________________________________________________
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail.
http://personal.mail.yahoo.com/
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
