Thanks... this is the one I was looking for, it's the opta2000 driver specific.
cheers -----Original Message----- From: Ritesh Gupta [mailto:[EMAIL PROTECTED]] Sent: 23 July 2001 09:54 To: [EMAIL PROTECTED] Subject: Re: jdbc url for sqlServer 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 =========================================================================== 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
