small talk about Database Connections

I had a customer who had this PROBLEM. He said ” My Connection strings have changed! I don’t know how to get the right connectionstring in my application, and with .NET’s automatic garbage collection, I’m never quite sure what’s going on with database connections in my application. ” After my best effort to calm him down…

1

Creating a Linked Server from SQL 2K5 64-bit to SQL 2K5 32-bit

I ran into an issue creating a linked server on SQL 2005 64-bit. I was trying to connect to a 2000 32-bit server. The error I received was: OLE DB provider “SQLNCLI” for linked server “servername” returned message “Unspecified error”. OLE DB provider “SQLNCLI” for linked server “servername” returned message “The stored procedure required to…

1