is there a 64 bit MSDAORA driver available from MS yet?

i have been struggling with creating a linked server from SQL 2005 64 bit to an Oracle (9.2.0.4) database....

obvious question but i'll ask - can you move to sql 2005 or better, 2008? do you have a test server that you could do a clean install? if you...

does it happen every time or is it sporadic?

after i got the error i would just reboot (iirc i looked at all the logs as you did) and it...

i never got that far in the debugging ...sorry.

i never did pinpoint the problem but we upgraded to a new server in feb 2010 and i have not seen the error since. the new server has all the...

thanks guys.

this is just one thing in a long laundry list of things to check on a development server that is going live in a few weeks. the idea of...

never mind! i'm a dumb@ss who didn't hit refresh in Enterprise Manager. they come with the restore.

:laugh:

thanks Lowell. i didn't know that option even existed. i've been spinning my wheels around with the CAST function without any luck.

I had this same issue years ago (I'm the DBA) when taking the old payroll system (SQL 2000) under responsibility and with the new system and new(er) version of SQL,...

you are truly worthy of your avatar...

IT WORKS!!!!

thanks for the assist!

nice article - yours? thanks for the help...

No backup becasue it's a test server.

i tried the part at the end (create a new db, stop sql, delete files, rename...

i checked and the buffer cache is alway > 99% but the page life expectancy, during a heavy load (report), drops to 110 for a few minutes then ramps back...

i checked Process Explorer and i don't seen anything to reconcile the memory allocated in SQL (6.5GB fixed). i see the working set corresponds to what is show in...

thanks for the info, ed. btw, we're running SQL 2005 x64 on Win 2003 x64 server.

thanks. i'll check.

can someone explain why task manager is wrong?