So, I setup it on my XP box with the same installation that I layed out earlier ... and it appears to be working. I still had the same problem...

Gift, I can run DTS on Windows 7 using SSMS (2k5 and 2k8) just fine.

Thanks Nice.

So I started over at this point. I uninstalled and removed. I did a fresh install and installed the following:

- Custom

- C:\Oracle

- Bypassed windows 7 errors

- Oracle Client 11.1.0.6.0

--...

Ok, so I can connect just fine via SQLPLUS ... still at a loss here.

I checked the old environment (SQL2000) and see that there is a oraoledb.oracle provider in the...

We were able to resolve the tnsping problem by copying the network\mesg folder from another user. For some reason, my install only had the nlus.msb file. So the ping works,...

Hey all,

Never before have I felt so dumb trying to do my job, but I'm still struggling on this. So I went through the 11g client install and installed only...

We're running 10g, but wouldn't the 11g be backward compatible? All I need is the client and this is what I'm trying now: http://www.oracle.com/technology/software/products/database/oracle11g/111060_win32soft.html

So I downloaded the lite, and I see no way to install this ... I'm hunting online for some type of documentation, but thus far no luck. How the heck...

Hey all,

I am just now resuming this and I have another question ... Looks like I need the client software from here: http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/winsoft.html, yet I'm not sure which to download....

EdVassie (1/5/2010)

---

If you are trying to use the SQL 2005 BC media for a SQL 2008 instance this may be the reason it is failing. Look for the SQL2005_BC.msi...

Ran the SET command, didn't change anything. As soon as I go to install the BC file, it immediately throws that error.

I also tried to install with troubleshoot compatibility. It...

Thanks Ed, can you stick with me for a bit longer on this?

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager\Environment

- I see no SEE_MASK_NOZONECHECKS on 2008 R2.

What am I missing?

EdVassie (1/5/2010)

---

I have successfully installed DTS Designer on W2008 R2. This needs to be followed with copying the DTS Designer dll files to the SQL 2008 program folders as...

Thanks for the response Mel. That is quite unfortunate to hear ... but thank you.

Well, reinstalling fixed it ... crazy, wish I knew what caused this.