Trying to connect simple VB6 ADO to SQL Server 2008
- by Henry
We have a VB6 App that -for current purposes - is very basic ADO: Dim a New ADODB.Recorset, set some basic properties like Cursor Location and Lock Type, set a Connection String and a .Source like "Select * from CustomerMaster", and .OPEN - nothing fancy here!
Yet, on a new SBS installation with SQL Server 2008 across 2 Servers (one for Apps, the…