Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Interfacing with Oracle 8i
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 -- prepotency ------------------------------------------------------------------------ prepotency's Profile: http://www.excelforum.com/member.php...o&userid=24155 View this thread: http://www.excelforum.com/showthread...hreadid=387510 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Interfacing with Oracle 8i
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Interfacing with Oracle 8i
Try opening a command prompt and typing "tnsping {yourTNSname}" (without the
braces) That should tell you if your machine is set up correctly and will also show you which parameter files are being used. Check your files have the required entry. Tim. -- Tim Williams Palo Alto, CA "prepotency" wrote in message ... 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 -- prepotency ------------------------------------------------------------------------ prepotency's Profile: http://www.excelforum.com/member.php...o&userid=24155 View this thread: http://www.excelforum.com/showthread...hreadid=387510 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SQL for Oracle | Excel Discussion (Misc queries) | |||
Interfacing USB port and MS Excel | Excel Discussion (Misc queries) | |||
Excel interfacing with graphic software | New Users to Excel | |||
Interfacing with web site | Excel Programming | |||
Interfacing OL2002 Cal and Excel Userforms | Excel Programming |