Ureader.com  
Microsoft software help and Community
   home   |   control panel login   |   archive   |  
 
tools
vsnet.act
vsnet.debugging
vsnet.documentation
vsnet.enterprise.tools
vsnet.general
vsnet.ide
vsnet.jlca
vsnet.servicepacks
vsnet.setup
vsnet.vsip
vsnet.vss
vsnet.vstools.office
vstudio.development
vstudio.extensibility
vstudio.general
vstudio.helpauthoring
vstudio.setup
vstudio.sourcesafe
  
 
date: Wed, 2 Apr 2008 16:28:26 +0200,    group: microsoft.public.vstudio.development        back       


Error 0x80004005 VB6 Access using ADO   
I have a project in VB6 that opens Access 97 database to create tabledefs and transfer data.
It has been tested in Windows XP SP2 + MDAC 2.7 successfull. I need to install it in Windows Vista.
I can create a connection to database and open it sucessfully, but when I try to open a Recordset
referencing a tabledef I get the 0x80004005 error, 'Error in method ~ of object ~'.

Following the code I used to open the connection and the recordset:
Set cnn = New ADODB.Connection
cnn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=xxxxxx;"

Dim rs As ADODB.Recordset
Set rs = New ADODB.Recordset
rs.Open "xxxxxxx", cnn, adOpenDynamic, adLockOptimistic, adCmdTableDirect

The object computer have MsAccess 2k and MsAccess 2k7, and of course MDAC >2.7
I have installed Microsoft Jet Engine SP3, Jet 2.5 3.5 Support, Jet 3.5 Support and loaded Jet Registry all
as solutions in Microsoft answers to this issue.

I can't get further information due to LastDLLError returns 0.

Can anyone help me, please?

Thanks
date: Wed, 2 Apr 2008 16:28:26 +0200   author:   Albert

Google
 
Web ureader.com


    COPYRIGHT 2007, YARDI TECHNOLOGY LIMITED, ALL RIGHT RESERVE  |   contact us