It could be worse. Here in the NY/NJ we have the privilege of spending $9.50 daily for the George Washington Bride. The traffic to get on the bridge...

If possible try to do the clustering in windows 2008. The 2008 implementation of windows clustering works better and is far more intuitive then the windows 2003 version. Also I...

Not sure if this will help but I once ran itno something similar.

I changed the server name to it's ip address and the unc and is started working.

It might be using named pipes rather then tcpip.

Try shutting down named pipes

David

Try using the Allow inprocess for the oracle olebd provider and then create the linked server.

David Weil

How about simply backing up directly to a UNC file share on the other server?

The problem is not on the excel side but the table not being found on the Oracle side (I assume the table that is being loaded into).

Out of curiosity, why...

Leave out the @ in the tnsping

E:\Oracle\product\10.2.0\client_1\NETWORK\ADMIN>tnsping TMyDB

not

E:\Oracle\product\10.2.0\client_1\NETWORK\ADMIN>tnsping @TMyDB

Do you mean this below in SMSS?

For the linked server in data source use “TMyDB”

Yes but don't change the linked server name.

For the linked server in data source use “TMyDB”

Change any tnsnames files to

TMyDB =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = IPAddress)(PORT = 1535))

)

(CONNECT_DATA =

(SERVICE_NAME = MyDB)

)

)

I put the...

Thank you asdfgh-617842

exec msdb.dbo.sp_send_dbmail @recipients='dweil@jewishhome.org', @body = 'Let keep it simple'

worked like a charm.

My mistake was using syntax that had always worked for xp_sendmail which is SIMILAR to exec...

Actually you can replace the tnsnames in \db_1etwork\admin with the tnsnames in client_1etwork\admin.

The linked server name does not mater but the data source has to be correct, might even be...

I think you are getting closer now that you can connect via sqlplus.

Search the entire computer to see if there is more then one copy of tnsnames on it.

In SMSS,...

simply

exec msdb.dbo.sp_send_dbmail 'dweil@jewishhome.org', @body = 'Let keep it simple'

thanks

David Weil

Try changing “HOST = xxxxxxxxx” to ”HOST = ip address”.

Oracle might not be resolving the host address correctly.

It that does not work you might try

1.renaming the tnsnames...