Re: JDBC-ODBC-Bridge



Christian Vallant wrote:

Herman Timmermans wrote:

Christian,
a little bit of more detailed information would be helpfull :

1) what database are you connecting to ? What release? (I suspect MS SQL??)
2) how do you connect ? From where, what ( code ?)
3) local or remote ?
4) what is your datasource config you are using under OO
5) how do you connect at the console ?

Maybe we can help you if we get some more meaningfull info,

Rgds,
Herman



Hello!

I connect from a Linux Client (Ubuntu 5.10) to a Windows Server (Windows 2003). The database on the server is Progress 9.1E.
I connect with an openlink odbc-driver from the linux client.
This connection running fine. I can use query in the console they works fine.
I also tried to connect from openoffice2 with the odbc-connection to the database. This connection works also fine.

So i will connect with the jdbc-odbc-bridge form java on the linux client to the databaseserver trough odbc (installed local on the system)

The java programm to connect to the database:

public class ProConnection {
public ProConnection(){}
public static Connection getConnection(String odbc_con, String user, String password) throws Exception
{

          Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

String URL = "jdbc:odbc:hyplog";
Connection c = DriverManager.getConnection(URL, user, password);
return c;
}
}

I will get the errer from my last posting.

The connection the the console (Test with iodbctest from openlink) works fine, also the connection from openoffice with odbc works fine. I use the ODBC Data source in openoffice to connect to the server.

But the connection from java doen't work. 

Post where we can download the version of the driver you're using.
It should be easy to decompile the specific class that is throwing
the NullPointerException and see what it thinks it has that it's
really missing. Are you sure you aren't passing in a null string
for the user or password? Are you sure the URL is complete?
Joe Weinstein at BEA


Best regards
Christian


.

Relevant Pages

  • Re: Changing Connection String programmatically
    ... Connection strings of different years can be stored in app.config ... is declared in MyDataset.Designer.cs as private, ... every year we will create new database. ... If you are storing connnection string information related to additional ...
    (microsoft.public.sqlserver.connect)
  • Re: MS Access looks for .mdb rather than Progress schema
    ... # Same query previously worked in Progress 8.x using SQL89. ... This entry allows you to keep your existing code written with the ODBC ... BTW, if you put all of the connect information into the connect string, ... I also tried putting the whole thing in the connection string: ...
    (microsoft.public.access.modulesdaovba)
  • Send Form results to database error
    ... ' Send results to the database. ... ' myConnString = Connection string to database. ... ' myConnection = The database connection object. ...
    (microsoft.public.access.forms)
  • Re: User count
    ... Dim colUsers as New Collection ... Dim sCompName as string ... or back it up, or something, then take a look at the use of the "Connection ... Create a table in the front-end database, ...
    (microsoft.public.access.formscoding)
  • Re: [VW 7.3.1] ODBCConnection
    ... I played around with a few combinations on the connection string and ... with a trusted SQL Server connection. ... there are differences for database connects. ... > any database specific odbc drivers. ...
    (comp.lang.smalltalk)