[egenix-users] How to connect to a remote oracle/sybase?

[Tim Terlegård]

> >First I tried several different connectionstrings with
> >ODBC.Windows.DriverConnect(), but I suspect that's just for connecting
> >to existing data sources on local computer? I'd like to connect to
> >remote databases without having the data sources specified.

> I made the same mistake, but in fact DriverConnect is able to connect to
> remote databases, given that they will accept remote connections and
> that you've got the connection string correct.

I got Sybase working now. Finally I got the connection string right. For
sybase this did work:
mx.ODBC.Windows.DriverConnect('DRIVER={Sybase SQL Anywhere
5.0};ENG=serverx;DBN=dbx;UID=kalle;PWD=kalle')

I've tried many combinations for Oracle, but can't get it right. Oracle
help file says it should be like this:
mx.ODBC.Windows.DriverConnect('DRIVER={Oracle ODBC Driver};DBQ=tnsname;
UID=kalle;PWD=kalle')

This fails. Anyone have a connection string that works for Oracle?
(not using installed data sources)

Tim