Chad Crawford (1/20/2010)

---

Do I get a certificate of accomplishment for helping Lynn? Stuff like that doesn't happen every day and I'd like to have something to hang up...

Chad Crawford (1/20/2010)

---

Wow... it actually worked?!?!

I can't claim credit for the settings - I copied them from a website/blog/forum somewhere I can't now find and luckly it worked for...

I'm wondering if you are comparing apples to oranges.

How are you determining the first values (21 GB, 4 GB).

How are you determining the second value ~ 9 GB.

I see how...

uhhhh, well, that does happen sometimes around the water cooler... 😉

David Korb (1/20/2010)

---

"...when you spend time helping others, you also improve your own skills."

To go off on a bit of a tangent:

This is why the one-room schoolhouse is a superior...

Fatal Exception Error (1/20/2010)

---

Lynn Pettis (1/20/2010)

---

It isn't just the QotD that you can learn from, but also the discussion that may follow (as long as you ignore the complaints).

Does SSC...

But you...

I'll agree with restarting the server (or the instance of SQL Server, could be faster and work just as well).

Okay Chad, copied your post to the thread I had started that...

Chad,

Thank you. Turned out I needed to make a couple of changes to the properties for the MSDASQL provider. Didn't have to do that on the x32 linked...

Chad Crawford (1/20/2010)

---

Lynn Pettis (1/20/2010)

---

Have to ask, are you running SQL Server 2005 x64 or SQL Server 2005 x32? If you got the linked server to work using...

Thinking about it, all this MySQL stuff belongs over here.

Should get this techie stuff off The Thread.

Chad, Can you also get me the settings for the ODBC Driver?

GilaMonster (1/20/2010)

---

True, but in general I...

John Rowan (1/20/2010)

---

Huh, kind of ironic, but this was your 420th post......

For the record, I am not pointing this out to promote 420 logic...just thought it was interesting...