RE: Help With ODBC Setup

Lee, Hitae Wed, 08 Nov 2000 17:22:28 -0800

Title: RE: Help With ODBC Setup

Hi Avi,

Unfortunately, I have WINDOWS2000 Server and Workstation installed
at my home computer so I have to get back to you tomorrow with details
...

Just know that they hide ODBC32 layer fairly good (Somewhere under WIndows Services)
for WINDOWS2000.

By the way, You may choose Java's ODBC-JDBC layer as shown below
as a sample code

import java.sql.*;

public class Db

{
        public static void main(String[] args) throws Exception
        {
                Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
                Connection c = DriverManager.getConnection("jdbc:odbc:biblio");

                Statement s = c.createStatement();
                String sql = "SELECT author FROM authors";
                ResultSet rs = s.executeQuery(sql);

                while (rs.next()) {
                        System.out.println(rs.getString(1));
                }

                s.close();
                c.close();
        }
}

for your testing ONLY!!!

It is prone to problem along with very poor performance if you choose
JDBC-ODBC layer. For the production, please spend some money
and purchase 3rd party JDBC for SQL server such as INet.

I will get back to you as soon as I get the information from my home computer...

Thx.
Hitae Lee.

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 08, 2000 9:15 AM
To: JRun-Talk
Subject: RE: Help With ODBC Setup

hi Lee and thank you for responding to my question.

im using a windows 2000 professional platform with IIS server and a
Microsoft SQL Server 7.0 DB.
im using JDK1.3

i am new to the java language so i dont know how to get the databse working.
im not sure if i need the jdbc or a driver, and how to hook it all up.

if you can help me it would be much appreciated.

Thank You
Avi Shechter
[EMAIL PROTECTED]

-----Original Message-----
From: Lee, Hitae [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 08, 2000 9:37 AM
To: JRun-Talk
Subject: RE: Help With ODBC Setup

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------_=_NextPart_001_01C04999.CE154BE0
Content-Type: text/plain;
charset="iso-8859-1"

Are you sure about ODBC not JDBC?

ODBC is a part of Windows package while JDC you must
purchase from vendor.... (Sun has list of vendors for
database such as SQL, Oracle, FoxPro, InfoMix and etc.)

If you really mean ODBC for SQL, let me know which platform
you are currently using such as WIN NT, WIN95 or WIN2000,
I can direct you how to do it in detail.

Thanks.
Hitae Lee.

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 07, 2000 8:19 AM
To: JRun-Talk
Subject: Help With ODBC Setup

Hi Im trying to set up a SQL Server datbase and im having trouble setting up
the drivers.

can anyone help me with what driver i need and where to get it, and how to
set it up.

I have been going crazy for 3 days now and my boss is breathing down my
neck.

Thank You in Advance For Your Help

Avi Shechter
[EMAIL PROTECTED]

----------------------------------------------------------------------------
--
Archives: http://www.egroups.com/group/jrun-interest/
Unsubscribe:
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/jrun_talk
or send a message to [EMAIL PROTECTED] with 'unsubscribe'
in the body.

------_=_NextPart_001_01C04999.CE154BE0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2448.0">
<TITLE>RE: Help With ODBC Setup</TITLE>
</HEAD>
<BODY>

Are you sure about ODBC not JDBC?

ODBC is a part of Windows package while JDC you must =

 purchase from vendor.... (Sun has list of vendors =
for 
 database such as SQL, Oracle, FoxPro, InfoMix and =
etc.)

If you really mean ODBC for SQL, let me know which =
platform
 you are currently using such as WIN NT, WIN95 or =
WIN2000,
 I can direct you how to do it in detail.

Thanks.
 Hitae Lee.

-----Original Message-----
 From: [EMAIL PROTECTED] [<A =
HREF=3D"mailto:[EMAIL PROTECTED]">mailto:[EMAIL PROTECTED]=
</A>]
 Sent: Tuesday, November 07, 2000 8:19 AM
 To: JRun-Talk
 Subject: Help With ODBC Setup

Hi Im trying to set up a SQL Server datbase and im =
having trouble setting up
 the drivers.

can anyone help me with what driver i need and where =
to get it, and how to
 set it up.

I have been going crazy for 3 days now and my boss is =
breathing down my
 neck.

Thank You in Advance For Your Help

Avi Shechter
 [EMAIL PROTECTED]

---------------------------------------------------------------=
---------------
 Archives: <A =
HREF=3D"http://www.egroups.com/group/jrun-interest/" =
TARGET=3D"_blank">http://www.egroups.com/group/jrun-interest/</A>=

Unsubscribe: <A =
HREF=3D"http://www.houseoffusion.com/index.cfm?sidebar=3Dlists&body=3Dli=
sts/jrun_talk" =
TARGET=3D"_blank">http://www.houseoffusion.com/index.cfm?sidebar=3Dlists=
&body=3Dlists/jrun_talk</A>
 or send a message to =
[EMAIL PROTECTED] with 'unsubscribe' in the =
body.

</BODY>
</HTML>
------_=_NextPart_001_01C04999.CE154BE0--
----------------------------------------------------------------------------
--
Archives: http://www.egroups.com/group/jrun-interest/
Unsubscribe:
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/jrun_talk
or send a message to [EMAIL PROTECTED] with 'unsubscribe'
in the body.

------------------------------------------------------------------------------
Archives: http://www.egroups.com/group/jrun-interest/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/jrun_talk
or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: Help With ODBC Setup

Reply via email to