Hi Ash,
For OPTA the :
URL : jdbc:inetdae7:localhost:1433:Database=pramati
replace database with the one that you want to connect to.
Driver Class : com.inet.tds.TdsDriver
If you create a DSN in your machine, you can also connect using
the SUNs JDBC-ODBC bridge driver as suggested by Aruniima.
Regards,
Ritesh
----- Original Message -----
From: Aruniima Chakrabarti <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, July 23, 2002 2:19 PM
Subject: Re: jdbc url for sqlServer
Jdbc url for MS SQL Server "jdbc:odbc:DSNname" ...............
Regards,
aruniima
-----Original Message-----
From: Shahata, Ash [mailto:[EMAIL PROTECTED]]
Sent: 23 Jul,2002 2:02 PM
To: [EMAIL PROTECTED]
Subject: jdbc url for sqlServer
Hi all,
does anyone know what would the jdbc url value be if I'm using Microsoft Sql
Server? I want to use opta2000 as the jdbc driver. I already have a
connection with mySQL :
try{
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
con = DriverManager.getConnection("jdbc:mysql://localhost/test
?user=name&password=pass");
..
..
}
I want to find out which values would I use with forName and getConnection
if I'm using the opta2000 driver to connect to sql Server?
Thanks
Ash
===========================================================================
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://archives.java.sun.com/jsp-interest.html
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.jsp
http://www.jguru.com/faq/index.jsp
http://www.jspinsider.com
----------------------------------------------------------------------------
This message contains privileged and confidential information and is
intended only for the individual named. If you are not the intended
recepient you should not disseminate, distribute, store, print, copy or
deliver this message. Please notify the sender immediately by e-mail if you
have received this e-mail by mistake and immediately delete this e-mail from
your system.
E-mail transmission cannot be guaranteed to be secure or error-free as
information could be intercepted, corrupted, lost, destroyed, arrive late or
incomplete, or contain viruses. The sender therefore does not accept
liability for any errors or omissions in the contents of this message which
arise as a result of e-mail transmission. If verification is required
please request a hard-copy version.
--------------------------------------------------------------------------
===========================================================================
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://archives.java.sun.com/jsp-interest.html
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.jsp
http://www.jguru.com/faq/index.jsp
http://www.jspinsider.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://archives.java.sun.com/jsp-interest.html
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.jsp
http://www.jguru.com/faq/index.jsp
http://www.jspinsider.com
