GilaMonster (9/22/2008)

---

Typically deadlocks are the result of poorly written code or poor indexing, but then so is bad performance in general.

Are the deadlocks recurring? If so, turn traceflag 1222 on...

To expand on this again......

There are 2 things that can really complicate connections to Progress db's.

The fact that reported length on string values is a display value, ...

You should be able to use a linked server, or any application that uses an appropriate ODBC/OleDB/ADO.Net connection. There are options. The kicker here is that this...

Eddy does know something about what he's talking about. I worked for an ODBC driver vendor that supported Progress. It does have some quirks. To re-iterate:

You can't...

You've a datatype problem here. You'll need need to explicitly trim the results to be less than 8000 bytes. Postgres text is similar to MSSQL text. Postgres...

rzoo (8/8/2008)

---

We are getting these errors on and off the past two days.

When we reboot they go away.

Any ideas?

Server object error 'ASP 0228 : 80004005'

Server.Execute Error

xxxxxxx.asp, line 901...

No need for people to get snippy. The take away here is that:

1) If a design is normalized, relational schema, the design can still be valid if the...

Many possibilities here. Most likely issue is how the provider is handling data. I'd try a different provider. If you are using the MS one, it...

I've worked for an ODBC driver vendor before, so I've got some experience here.

You are right that you'll see SetAttr fails in most traces, but it most likely...

What are you using for connectivity? IIRC, the MS provided Oledb and ODBC drivers are built as Oracle 7 API clients, and they have some significant limitations....

First, be careful of your terms. "Identity" means something specific in sql server. In this case, you can't use it directly, since it must be a...