Re: JDBC-ODBC-Bridge

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.

Best regards
Christian
.

Relevant Pages

  • Re: Cannot login as ordinary user to console session on Windows Server 2003 Standard SP1
    ... After connecting and entering correct user name and password I get the dialog box which says "To log on to this remote console session, you must have administrative permissions on this computer." ... RDP to the already logged on session, the connection succeeds. ... "Remote Desktop Users" group, and is not a member of "Administrators" group. ... Default Domain Security Policy / Security Settings / Local Policies / User Rights Assignment / Allow logon through terminal services. ...
    (microsoft.public.windows.server.general)
  • Re: SMS menu options not available on boot?
    ... I'm starting to wonder if the other serial connection that I've got on ... SMS menu options not available on boot? ... That was due to the wrong console ...
    (AIX-L)
  • Mysterious system freeze-ups on my consoles...
    ... I can't get into the debugger, or do anything at all from the console, ... connection, and it has definitely happened when I've been connected ... over dial-in PPP via a serial port, and more recently I believe I've ... regularly viewing Google with lynx going off the top line to the input ...
    (freebsd-hackers)
  • Re: Cableing question
    ... Is the printer connected to the same workstation controller as the ... - Is the CTLD the printer is attached to created and varied on? ... console connection. ... the upper-right when it has a good connection. ...
    (comp.sys.ibm.as400.misc)
  • Sub-items dont load in Admin Console over vpn
    ... I'm trying to administer my Sms2003 server via the admin console on an XP Pro ... sp1 machine while connected remotely. ... The connection to the site db appears to be made ok and the main console tree ...
    (microsoft.public.sms.admin)