Thanks for the tips.  Using the temp tables instead of memory tables and updating the alias helped a lot.  It took it from 5-6 minutes to a second.

  I'm...

We're in the healthcare field and bound by HIPAA as well as some other regulatory rules. While they are a pain and somewhat costly to do, ultimately they are...

We moved to 64-bit SQL 2005 standard edition a little while ago and it was pretty seamless.  We're ramping up additional activity on the server so we've not pushed the performance...

We've used the Cisco PIX 501 and it's been pretty reliable.  We used a networking company to come set it all up since we're not networking experts.

Do you have any specific error messages?  Generally a datasource issue is either configuration setting or a permission problem.

As a pharmacist who is also a software engineer, I guess I've got it pretty good.

Informix is sometimes a bear to work with but with a little troubleshooting, it can work. 

Did you also setup the Informix client software and configure the ODBC on the...

We ran into this issue when the users trying to install the ActiveX control didn't have appropriate rights on their workstation.  We ended up serving reports as pdf or Excel...

We're upgrading our products because we're fairly new in the market for our products and don't have a lot of legacy installs.  This will prevent our new customers from facing a...

I attempted this once and made the determination that is wasn't possible with reporting services.  I ended up coding the report directly as an aspx page.  If someone figures this...

Reporting services uses Windows Authentication as a default.  Having the dialog pop 3 times is not normal.  Usually it pops once and then remembers you for future reports on the...

I doubt it's the service packs.

I found one possible thread http://groups.google.com/groups?hl=en&lr=lang_en&ie=UTF-8&oe=UTF-8&threadm=ucxhJsdIBHA.1340%40tkmsftngp04&rnum=1&prev=/groups%3Fhl%3Den%26lr%3Dlang_en%26ie%3DUTF-8%26oe%3DUTF-8%26q%3DProvider%2B%27Ifxoledbc%27%2BIDBInitialize%253A%253AInitialize%2Breturned%26sa%3DN%26tab%3Dwg

Did you reboot the server after installing and configuring Informix drivers?  I do remember that bit me once although...

Informix is a bit of a beast to work with but I have got it working on Win2K using SQL2K.  We use the Microsoft OLE DB for ODBC drivers on...

I've stuck with the pass-through approach.  That way you can send in the SQL statement best tuned for whatever RDBMS you are querying against.  I use this approach a lot...