GSquared (11/30/2012)

---

pdanes (11/30/2012)

---

I'm working on the syntax of dynamic SQL with parameters, but I find myself coming back to the same question that actually started this thread: If I use...

I'm working on the syntax of dynamic SQL with parameters, but I find myself coming back to the same question that actually started this thread: If I use the predicate...

capnhector (11/27/2012)

---

pdanes (11/27/2012)

---

GSquared (11/27/2012)

---

pdanes (11/27/2012)

---

There doesn't seem to be any clear consensus on all this, so I guess I'll have to build a bunch of test cases and see what...

Yes, this is Access talking over an ODBC link to a server running SQL Server. There are many individual machines running this app, and more may be added any time....

Well, apparently it's some sort of a timing or saturation issue. I put a 100 millisecond pause with DoEvents after every call to SQL Server, and it works. Where it...

L' Eomot Inversé (11/29/2012)

---

I carelessly said...

Brandie Tarvin (11/29/2012)

---

How is your environment set up?

For instance, in one environment I worked on, we had a SQL Server, a Citrix Terminal Server, and an application / file server....

No, it varies. It's roughly a minute, and sometimes...

Banana-823045 (11/29/2012)

---

Actually, that's for a different purpose --- the intention with that one check is to log any query that takes too long. Think of it as a client-side performance...

L' Eomot Inversé (11/29/2012)

---

I may be barking up the wrong tree here, but maybe you are running out of sockets? That's what TCP Error 10048 means, and I think...

Banana-823045 (11/29/2012)

---

I don't believe Access manages this directly; it defers to the ODBC Manager & Driver...

Brandie Tarvin (11/29/2012)

---

So you can't find any events that indicate the SQL Server services shut down, recycled, or that a connection got dropped *before* you got the error posted in...

bleroy (11/29/2012)

---

I would go back to basics on this.

If you can, copy your MSAccess app as a new file, zap everything but the code you are interested in - in...

Brandie Tarvin (11/28/2012)

---

pdanes, have you checked your connection pooling properties both in the app and on the server to make sure you can reuse existing connections and that the pool...

Brandie Tarvin (11/28/2012)

---

Bhuvnesh (11/28/2012)

---

WHat if we use SSIS to do this stuff more robust more tracable .. more comfortable to handle heavy volume data. i will welcome suggest on this...