 |
|
| Computers Forum Index » Computer - Databases - Oracle (Tools) » Connecting through ODBC or OLE DB... |
|
Page 1 of 1 |
|
| Author |
Message |
| rodrigo... |
 Posted: Tue Oct 20, 2009 10:57 am |
|
|
|
Guest
|
I'm trying to connect to my databases from a XP box to a HP-UX server
with Oracle 10g, either through ODBC or OLE DB. I've tried almost
everything and still can't connect to it.
I have both the Microsoft driver and the Oracle driver, and also the
Oracle Instant client installed in the XP box, with a tnsnames.ora
file that points to the server, ORACLE_HOME variable set up, etc.
I know that it's accesible because I can connect from this same
machine with JDBC Oracle Thin Client (ojdbc6.jar). This driver deesn't
even need the Oracle client installed in the local machine. I just
specified IP, port, SID, user, pass and it works. But the programs I
need to use don't support JDBC.
Do you have any connection string that works for you? I've tried the
ones in connectionstrings.com and carlprothman.net but I think they're
not intended for connecting to a remote server... |
|
|
| Back to top |
|
|
|
| fitzjarrell at (no spam) cox.net... |
| Posted: Sat Oct 24, 2009 9:23 pm |
|
|
|
Guest
|
On Oct 20, 5:57 am, rodrigo <rodrigo.ol... at (no spam) gmail.com> wrote:
Quote: I'm trying to connect to my databases from a XP box to a HP-UX server
with Oracle 10g, either through ODBC or OLE DB. I've tried almost
everything and still can't connect to it.
I have both the Microsoft driver and the Oracle driver, and also the
Oracle Instant client installed in the XP box, with a tnsnames.ora
file that points to the server, ORACLE_HOME variable set up, etc.
I know that it's accesible because I can connect from this same
machine with JDBC Oracle Thin Client (ojdbc6.jar). This driver deesn't
even need the Oracle client installed in the local machine. I just
specified IP, port, SID, user, pass and it works. But the programs I
need to use don't support JDBC.
Do you have any connection string that works for you? I've tried the
ones in connectionstrings.com and carlprothman.net but I think they're
not intended for connecting to a remote server...
You failed to post the error code and message; was there a good reason
for not doing so? Absent such information no one can tell you why the
ODBC/OLEDB connection won't work.
David Fitzjarrell |
|
|
| Back to top |
|
|
|
| Mark D Powell... |
| Posted: Sat Oct 24, 2009 9:34 pm |
|
|
|
Guest
|
On Oct 24, 5:23 pm, "fitzjarr... at (no spam) cox.net" <orat... at (no spam) msn.com> wrote:
Quote: On Oct 20, 5:57 am, rodrigo <rodrigo.ol... at (no spam) gmail.com> wrote:
I'm trying to connect to my databases from a XP box to a HP-UX server
with Oracle 10g, either through ODBC or OLE DB. I've tried almost
everything and still can't connect to it.
I have both the Microsoft driver and the Oracle driver, and also the
Oracle Instant client installed in the XP box, with a tnsnames.ora
file that points to the server, ORACLE_HOME variable set up, etc.
I know that it's accesible because I can connect from this same
machine with JDBC Oracle Thin Client (ojdbc6.jar). This driver deesn't
even need the Oracle client installed in the local machine. I just
specified IP, port, SID, user, pass and it works. But the programs I
need to use don't support JDBC.
Do you have any connection string that works for you? I've tried the
ones in connectionstrings.com and carlprothman.net but I think they're
not intended for connecting to a remote server...
You failed to post the error code and message; was there a good reason
for not doing so? Absent such information no one can tell you why the
ODBC/OLEDB connection won't work.
David Fitzjarrell- Hide quoted text -
- Show quoted text -
rodrigo, the full exact version of Oracle on both boxes and the bit
factor, 32 vs 64, would also be useful information.
HTH -- Mark D Powell -- |
|
|
| Back to top |
|
|
|
|
|
All times are GMT
The time now is Tue Dec 08, 2009 2:27 am
|
|