jdbc url for sqlServer

2002-07-23 Thread Shahata, Ash 

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=namepassword=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

Re: jdbc url for sqlServer

2002-07-23 Thread Aruniima Chakrabarti 

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=namepassword=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

Re: jdbc url for sqlServer

2002-07-23 Thread Bhushan_Bhangale 

Hey Ash,

Check the documentation of the driver which you are using. The url is different for 
different drivers. Below are the two examples which I have used earlier in projects:-

jdbc:microsoft:sqlserver://Simple2SVR:1433 for SQLServerDriver

jdbc:JSQLConnect://Simple2SVR:1433 for JSQLDriver

-Original Message-
From: Shahata, Ash [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 23, 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=namepassword=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

==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

Re: jdbc url for sqlServer

2002-07-23 Thread Daniel 

Hi

I think this should work .
I did long before ...,

If you are using the Microsoft driver (i.e.
com.microsoft.jdbc.sqlserver.SQLServerDriver), you'll need to use the
SelectMethod=cursor parameter in the JDBC connection string  Your
databaseUrl would look something like the following:

jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=mydb;SelectMethod
=cursor

Daniel Jayapaul.E

===
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

Re: jdbc url for sqlServer

2002-07-23 Thread Ritesh Gupta 

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=namepassword=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

Re: jdbc url for sqlServer

2002-07-23 Thread Shahata, Ash 

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=namepassword=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