Connecting through JdbcOdbcDriver from Servlets - Mailing list pgsql-admin

From Anuj@mannindia.com
Subject Connecting through JdbcOdbcDriver from Servlets
Date
Msg-id 20001013190701.25284.cpmta@c004.sfo.cp.net
Whole thread Raw
Responses Re: Connecting through JdbcOdbcDriver from Servlets
List pgsql-admin
Hello,

I have written a servlet to connectto a PostgreSQL database on Linux 6.2.

I am using JdbcOdbcDriver. When I am running the servlet from JSWDK on
 Windows NT , it works fine .

But when I try to run it from JSWDK on Linux , it gives an exception "No Suitable Driver".

My code is like this:

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver")
DriverManager.getConnection("jdbc:odbc:cards","anuj","")

the .odbc.ini file is kept in "/" directory and it is:

[ODBC Data Sources]
cards = PostgreSQL

[cards]
Driver = /usr/local/pgsql/lib/libpgsqlodbc.so.1
Database = cards
UID = anuj
Host = localhost
Port = 5432

The error is coming in when I try to do getConnection.

If anybody could help me in this, please. I believe there must be something wrong in Configuration,as the same code
worksfrom JWSDK on NT.  

TIA,
Anuj.

Anuj Paul
_______________________________________
Click here to get your free domain name
and personal portal from NAMEzero(TM):
http://www.namezero.com

pgsql-admin by date:

Previous
From: Alexey Rodriguez Yakushev
Date:
Subject: pg_hba.conf problems with Postgresql 7.0.2
Next
From: David Huttleston Jr
Date:
Subject: Re: Connecting through JdbcOdbcDriver from Servlets