Skip to Content
0
Former Member
Dec 02, 2008 at 10:52 PM

Changes required to switch from SQL Server 2000 to SQL Server 2005?

27 Views

I'm converting a legacy app from SQL Server 2000 to SQL Server 2005. The app is written in VB6 and utilizes CR 8 OCX. When I invoke a report from VB I'm getting Error# 20599 Cannot open SQL server. I redefined the ODBC DSN specifying Windows Authentication, and the SQL Server instance supports mixed mode.

Searching for the error, I found an article that suggests I need p2sodbc8.zip, but I can't find a link to it in the Downloads area.

Would greatly appreciate any help at all - including a link to p2sodbc8.zip if that's the likely resolution.

Thanks in advance,

Pete