Craig Gemmill's Blog

There is nothing more secure than an educated user!

March 2011 - Posts

Visual Studio 2010 Service Pack 1 - Test first!

It appears that our run of fairly benign VS SP’s is over…

I've now installed the VS 2010 SP1 in a few simple test environments (x64) and all of them are having issues.

Add-in failures, failed package loading, missing SQL Intellisense, XAML designer failure, etc.

Make sure you test this Service Pack thoroughly before you release it to your production environment.

Microsoft Connect is the official repository for issues with Service Pack 1.

Posted: Mar 10 2011, 04:30 PM by CraigG
Filed under: , , , , , ,
Open Paradox database with Access or as SQL linked server

First and foremost, if you're using Office 2010, Paradox support has been removed (http://technet.microsoft.com/en-us/library/cc179181.aspx). You'll need Access 2007 or earlier.

If you're reading this, then you've probably run in to a cryptic error message and/or inconsistent Paradox functionality with the aforementioned products. The most common error message being: "External Table not in Expected Format"

Here are two of the most common resolutions:

 

- You probably NEED BDE (Borland Database Engine), available here. I know there are articles that talk about it working without BDE, but I’ve never seen it happen.

- You may have to copy the Paradox database files locally. There is sometimes an issue with accessing the files across a network path.

 

That’s it. Try it.

Good luck,

Craig
Posted: Mar 05 2011, 10:32 PM by CraigG | with no comments
Filed under: , , , , ,
More Posts