I have not connected to SQL Server 2000 yet, but to SQL Server 7. To
connect to SQL Server 2000 SHOULD be the same as SQL Server 7, depending on
the JDBC drivers. The detailed instructions for connecting to the database
are dependent upon what JDBC driver you use. I did a fairly extensive search
and ended up choosing JSQLConnect as it has a Type 4 (Pure Java) JDBC
driver. The detailed instructions for connecting to the database are
dependent upon what JDBC driver you use. In general, you load a driver
which "registers" it. Then you create a connection to the database. The
JDBC functionality will search for valid drivers and return a connection
object. Once you have a connection object, you can perform SQL against it
in a straight forward way. One of the things I found a bit frustrating is
the difference in syntax and data types supported between MS Access and MS
SQL Server. You would think that there would be a better compatibility, but
what can I say. I found the driver I use at:
http://www.j-netdirect.com/Products.htm . On their home page is a link to a
tutorial of sorts. Sun maintains on line documentation. Optional packages,
such as Servlet support, can be found at
http://java.sun.com/products/OV_stdExt.html. The class library
documentation for the JDBC functionality is found in java.sql.*. The class
library documentation for this can be found at
http://java.sun.com/j2se/1.3/docs/api/index.html. You may also want to check
out Sun's tutorials at http://java.sun.com/. There are links to lots of
useful info here including links to a tutorial for database access.
I hope this helps.
Frank Hill
-----Original Message-----
From: Eric Cheng [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 22, 2001 2:59 AM
To: JRun-Talk
Subject: how to connect to SQL Server 2000
Hi,
Would anyone show me how to connect to SQL Server 2000
Thanks
Hogi
----- Original Message -----
From: Jay Walters <[EMAIL PROTECTED]>
To: JRun-Talk <[EMAIL PROTECTED]>
Sent: Monday, May 21, 2001 11:39 PM
Subject: RE: send e-mail from a javaBean
> There is a really nice example program included with the JavaMail download
> from the sun site that shows sending a simple mail message from a command
> line program. You should be able to cut and paste from this to include it
> into your JavaBean.
>
> Cheers
>
> -----Original Message-----
> From: Mark Phelps [mailto:[EMAIL PROTECTED]]
> Sent: Monday, May 21, 2001 11:27 AM
> To: JRun-Talk
> Subject: RE: send e-mail from a javaBean
>
>
> Sending an email message is very simple using the JavaMail interface. If
> anything goes wrong during the communication with your mail server, it
will
> be reflected in an exception. I don't know of any way to know when the
> message is successfully forwarded by the mail server. During testing you
> can send messages to yourself to verify that your code is working.
>
> If you need to see code that sends a message, let me know. I assume that
> you are just asking about confirmation of the send.
>
> -----Original Message-----
> From: Giang Nguyen [mailto:[EMAIL PROTECTED]]
> Sent: Friday, April 20, 2001 6:46 PM
> To: JRun-Talk
> Subject: send e-mail from a javaBean
>
>
>
> Hi, list
>
> I want to send e-mail from a javaBean for experiment. How can I know that
> the e-mail had been sent?
> Because I have only ONE computer so can this work be done? If it can be,
> please tell me how to do so or where to find documentations to read more.
> Thank you very much.
> I look forward for your reply.
> Giang Nguyen.
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
