VB6 / SQL Server 2008 R2

I need a connection string between an old but necessary VB6 (current Service Pack) program and SQL Server 2008 R2. Since the VB6 program will not run on W7, it runs on an XP box, SQL Server is running on a Windows 7 x86 box. These are home development machines so the network has a Workgroup configuration.

The machines can ping each other and see each other in Windows Explorer.

The VB6 program is coded using AD0. I recently had this configuration running like a champ using OLE DB and this is preferred, but an ODBC connection would should also work. I have thrashed around on connection strings and have lost the string I was using...

For clarity, it would help if you could direct me to the recommended SQL Server client software for the XP box.

Thanks.

1 answer