great! thats the info i was looking for.

now i know where to start.

many thanks!

ahh... i understand.

however; for the moment MSDAORA is installed with SQL Server 2005, so do

you have any ideas about my original inquiry about why i can't see it...

"...Oracle and MS has stated that they're out of the Oracle driver business... there will not be updated or 64 bit versions of that driver..."

do what now? i'm hard...

here's something interesting...

when looking at the registry i can see MSDAORA

'hkey_local_machine', 'software\microsoft\microsoft sql server\mssql.l\providers'

why does Management Studio not reflect it under the Providers list???

any ideas?

it's an SQL 2005 64bit environment, but as to the Oracle environment i'm unaware of

what bit it it.

wow... what a great post!

thanks !

here is a good link on how to resolve this issue.

http://sqlforums.windowsitpro.com/web/forum/messageview.aspx?catid=60&threadid=84680&highlight_key=y&keyword1=sspi

this guy made it real comprehensive.

i'm sure there is something in there that will help you out.

i've used it in...

interesting... i might not be patched up completely. i'll look things over this afternoon. would be nice to edit completely.

well put...

"...like trying to upgrade a GIF of a hand written note to a Word document."

that puts it in perspective. not worth the trouble.

i'll see about rebuilding in pure 2005...

true... true...

never hurts to ask though.

who knows... maybe someone came up with a way you can simply move them over.

ahh well.

thanks for the feed back.

just a quick reminder here.

remember that you can only 'see' the dts packages (that is they are read-only)

even though you have the designer components, and can view...

i'm compelled at this point to reiterate about how sql will do the same when

looking into adjusting the affinity mask, or maxdop in sql.... however; i'm

not going to get hung...

nuts!

so basically if you migrate your DTS packages from a 2000 server to 2005 server,

you are essentially unable to edit the connection properties to point to your

NEW 2005 server....

so... my question is this...

kevin, were you able to edit after all this??

i too am having extreme frustration with this process.

nuts!

well... thanks for answering my question