Provider not found
From: Bernie Adams (bernie_at_amc-hln.com)
Date: 07/17/04
- Next message: Michael C: "ODBC and XML"
- Previous message: Sidney Mark Croy: "Invalid Object Name"
- Messages sorted by: [ date ] [ thread ]
Date: 17 Jul 2004 08:14:13 -0700
Since I just went through the effort of finding out the solution to
this problem, thought I would pass on my solution. This error can
occur with any ODBC or SQL based database, not just MS SQL Server. I
first got it while working with a Visual Basic 6 program with ADO
controls connected to a Sybase database.
I re-applied the SQL server SP 3 - no luck
I reapplied the MDAC 2.7 - no luck
I reapplied the Jet sp - no luck
Anyway - this applies to my XP Pro machine.
I had to 'replace' two file in the 'Windows\System32' folder
MSDASQL.DLL and MSDATL3.dll
MSDASQL.DLL was an old copy and MSDATL3.dll was missing altogether.
I found these in my i386 folder. Basically, search for these files on
your machine and copy to the 'c:\Windows\System32' folder (this may be
'C:\Winnt\system32' on a Win2k machine).
- Next message: Michael C: "ODBC and XML"
- Previous message: Sidney Mark Croy: "Invalid Object Name"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
