I
i_j_hutch
Hey all--
At work, we recently upgraded the Terminal Server from the 2000 version to
Windows Server 2003 R2 Enterprise Edition SP1. Actually, the 2000 box had a
catastrophic disc failure and is DEAD.
Anyways, a vb6 application that connects to an Access database is now
throwing an error on this new Terminal Server, specifically:
-2147024769 Automation Error The specified procedure could not be found
The form of the connection is:
Global gconn as New ADODB.Connection
gconn.open Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:MyDB.mdb;Mode=ReadWrite;Persist Security Info=False;Jet
OLEDB
atabase Password=abcDEF!@#
I even tried reducing the connection string by removing the password (as
well as from the database), not specifying the Persist Security Info, and not
specifying the Mode.
I have seen the kb articles that reference this (like kb: 839428), but as I
said, we already have MDAC 2.8 SP2 On Windows Server 2003 SP1 (using
ComponentChecker 2.0)--mostly version 2.82.1830.0.
We have uninstalled and re-installed every MDAC between 2.5 and 2.8 (with
reboots, shutting off virus protection during the install, etc.). We have
done numerous searches on the web, most of which point to a bad MDAC install.
The server is completely up-to-date as far as the software version is
concerned. The MDAC 2.8 is also the latest/greatest for the server.
Furthermore, we have tried simplifying the connection string by removing the
password, removing the persist security info, removing even the
mode=Read/Write part, ensuring no spaces in the path, changing the path back
to the C:\ (to rule out network drive mapping), etc.
References in the app include:
Visual Basic for Applications
Visual Basic runtime objects and procedures
Visual Basic objects and procedures
OLE Automation
Microsoft Data Binding Collection VB6.0 (SP4)
Microsoft ActiveX Data Objects 2.8 Library
Microsoft ADO Ext. 2.8 for DDL and Security
Microsoft Jet and Replication Objects 2.6 Library
Microsoft Scripting Runtime
Microsoft Word 11.0 Object Library
I've regsvr'd the jet 4.0
I've tried installing Service Pack 6 for Visual Basic 6.0: Run-Time
Redistribution Pack (vbrun60sp6.exe) on the server.
I've verified that I can create a lock file on the database by opening it
manually (it opens with no problem).
The same connection string works fine on Windows 2000 and Windows XP PCs,
just not on Windows Server 2003. We even tried it on Windows Server 2003
Standard and got the same error.
Does anyone know what we can do to get this working? I'm at wits end.
Thanks in advance.
*
At work, we recently upgraded the Terminal Server from the 2000 version to
Windows Server 2003 R2 Enterprise Edition SP1. Actually, the 2000 box had a
catastrophic disc failure and is DEAD.
Anyways, a vb6 application that connects to an Access database is now
throwing an error on this new Terminal Server, specifically:
-2147024769 Automation Error The specified procedure could not be found
The form of the connection is:
Global gconn as New ADODB.Connection
gconn.open Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:MyDB.mdb;Mode=ReadWrite;Persist Security Info=False;Jet
OLEDB
atabase Password=abcDEF!@#I even tried reducing the connection string by removing the password (as
well as from the database), not specifying the Persist Security Info, and not
specifying the Mode.
I have seen the kb articles that reference this (like kb: 839428), but as I
said, we already have MDAC 2.8 SP2 On Windows Server 2003 SP1 (using
ComponentChecker 2.0)--mostly version 2.82.1830.0.
We have uninstalled and re-installed every MDAC between 2.5 and 2.8 (with
reboots, shutting off virus protection during the install, etc.). We have
done numerous searches on the web, most of which point to a bad MDAC install.
The server is completely up-to-date as far as the software version is
concerned. The MDAC 2.8 is also the latest/greatest for the server.
Furthermore, we have tried simplifying the connection string by removing the
password, removing the persist security info, removing even the
mode=Read/Write part, ensuring no spaces in the path, changing the path back
to the C:\ (to rule out network drive mapping), etc.
References in the app include:
Visual Basic for Applications
Visual Basic runtime objects and procedures
Visual Basic objects and procedures
OLE Automation
Microsoft Data Binding Collection VB6.0 (SP4)
Microsoft ActiveX Data Objects 2.8 Library
Microsoft ADO Ext. 2.8 for DDL and Security
Microsoft Jet and Replication Objects 2.6 Library
Microsoft Scripting Runtime
Microsoft Word 11.0 Object Library
I've regsvr'd the jet 4.0
I've tried installing Service Pack 6 for Visual Basic 6.0: Run-Time
Redistribution Pack (vbrun60sp6.exe) on the server.
I've verified that I can create a lock file on the database by opening it
manually (it opens with no problem).
The same connection string works fine on Windows 2000 and Windows XP PCs,
just not on Windows Server 2003. We even tried it on Windows Server 2003
Standard and got the same error.
Does anyone know what we can do to get this working? I'm at wits end.
Thanks in advance.
*