Re: Interfacing with Oracle 8i
- From: Gareth <msng@xxxxxxxxxxxxxxxxxx>
- Date: Fri, 15 Jul 2005 11:18:42 -0500
Doesn't sound like the problem is VBA related - you might be better off trying an Oracle newsgroup. I can let you have example VBA connection code for 8i if you like though.
SOunds to me though this is a problem of the machine being incorrectly configured. Can you connect with SQLplus? It's probably easier to troubleshoot from there if you can't rather than complicate things further with MS on top of it.
prepotency wrote:
I'm dealing with updating some old programs (vba) from an oracle server
and then getting them to run and interface with our new mysql server. The problem is, I just can't get excel and access to interface with
this oracle 8i service. Does anyone know anything about 8i or oracle
in general when it comes to connecting to their odbc services? How can
I get Oracle 8i ODBC Drivers working and connecting to the "CMSP"
service on my network? It is not working and just says that "TNS could
not resolve the connect identifier specified". However I now all the
info is correct because we have other computers on the network that can
connect to this service... help!
G
.
- References:
- Interfacing with Oracle 8i
- From: prepotency
- Interfacing with Oracle 8i
- Prev by Date: Re: Seting a Constant (via code) when creating a new file based on a template
- Next by Date: Re: Web query on Open
- Previous by thread: Interfacing with Oracle 8i
- Next by thread: Re: Interfacing with Oracle 8i
- Index(es):
Relevant Pages
|
