[AccessD] ADO code stopped working

MartyConnelly martyconnelly at shaw.ca
Thu Feb 8 17:26:24 CST 2007


Just a thought, could one site be running a higher MDAC 2.8 SP1
where the property version number would be

 Msado15.dll   2.81.1117.0     ADO

Download MDAC 2.8 SP1
http://www.microsoft.com/downloads/details.aspx?familyid=78cac895-efc2-4f8e-a9e0-3a1afbd5922e&displaylang=en

Release manifest for MDAC 2.8 Service Pack 1 (2.81.1117.6)
http://support.microsoft.com/kb/899456
If not sure you  could run

Component Checker: Diagnose problems and reconfigure MDAC installations
Tells you what MDAC's are installed on a machine

http://support.microsoft.com/kb/307255/

Jennifer Gross wrote:

>I am still stumped.  I am moving the code to DAO, since it works fine,
>even with the Eval statement and no change to the way the parameters are
>set up.  It has to be something outside the code, in network or
>security, because the ADO works fine on my system, and worked fine on
>theirs until last week.  Something changed in their setup, but we can't
>identify it.  
>
>Thanks for everyone's help and the wonderful tangential insights.
>
>Jennifer
>
>-----Original Message-----
>From: accessd-bounces at databaseadvisors.com
>[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
>Sent: Wednesday, February 07, 2007 6:58 AM
>To: accessd at databaseadvisors.com
>Subject: Re: [AccessD] ADO code stopped working
>
>
>Hi Marty
>
>That is interesting!
>It appears that - if you specify a parameter by its name - for an
>explicit parameter the brackets must _not_ be specified, while for an
>implicit parameter the brackets _must_ be specified. If you don't, an
>3265 error will be raised but not before you reach the code line where
>you pass the parameter value. So this is not the scenario Jennifer sees,
>as - for her case - the error is raised earlier when you address the
>Procedures' collection.
>
>/gustav
>
>  
>
>>>>martyconnelly at shaw.ca 05-02-2007 21:46:05 >>>
>>>>        
>>>>
>I am just wondering if TheQuery has to be run once to compile it?
>
>or this
>
>ACC2000: How to Use Parameters with ActiveX Data Objects (ADO) and Jet
>http://support.microsoft.com/kb/225897/en-us 
>
>Method 3: Using an Implicit Parameter
>NOTE: Implicit parameter names have brackets ([ ]) around them, and you
>must use the brackets (or the parameter's ordinal position) when
>referring to implicit parameters in the Parameters collection.  If you
>do not use the brackets, you receive the following error message:
>Run-time error '3265':
>
>ADO could not find the object in the collection corresponding  to the
>name or ordinal reference requested by the application.
>
>PRB: Error 3265 When You Access Properties Collection
>http://support.microsoft.com/?kbid=201826 
>
>http://support.microsoft.com/default.aspx?scid=kb;en-us;223212 
>
>Jennifer Gross wrote:
>
>  
>
>>Hi Gustav,
>>
>>I have checked all references.  The code is compiling.  I have created 
>>a test database with one table and one query.  It is failing in the 
>>same spot my original database is failing - Set prc =
>>cat.Procedures("TheQuery") - In the test database I am getting the 
>>error 3265 - Item cannot be found in the collection corresponding to 
>>the requested name or ordinal.  The query does exist - no spelling 
>>errors. The same ADO code is working fine on my home office system.  It
>>    
>>
>
>  
>
>>worked fine at the client's site in January.  Any thoughts?
>>
>>Jennifer
>>
>>-----Original Message-----
>>From: accessd-bounces at databaseadvisors.com
>>[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
>>Sent: Monday, February 05, 2007 1:47 AM
>>To: accessd at databaseadvisors.com 
>>Subject: Re: [AccessD] ADO code stopped working
>>
>>
>>Hi Jennifer
>>
>>You could - for and while debugging - try to separate the connection
>>object:
>>
>>   Dim cnn As ADODB.Connection
>>   Dim cmd As ADODB.Command
>>   Dim rst As ADODB.Recordset
>>   Dim prm As ADODB.Parameter
>>   Dim cat As ADOX.Catalog
>>   Dim prc As ADOX.Procedure
>>
>>   Set cat = New ADOX.Catalog
>>   Set cnn = CurrentProject.Connection
>>   cat.ActiveConnection = cnn
>>
>>I guess you have double-checked the reference:
>> Microsoft ADO Ext. 2.8 for DDL and Security
>>points to
>> ..system32\MSADOX.DLL
>>
>>/gustav
>>
>> 
>>
>>    
>>
>>>>>jengross at gte.net 05-02-2007 05:00 >>>
>>>>>       
>>>>>
>>>>>          
>>>>>
>>Thanks for the suggestions.  I set the references like Marty suggested 
>>and am still getting the problem.  I am using the Getz Developers 
>>Handbook code for looping through parameters in a select query:
>>
>>   Dim cmd As ADODB.Command
>>   Dim rst As ADODB.Recordset
>>   Dim prm As ADODB.Parameter
>>   Dim cat As ADOX.Catalog
>>   Dim prc As ADOX.Procedure
>>
>>   Set cat = New ADOX.Catalog
>>*   cat.ActiveConnection = CurrentProject.Connection
>>*   Set prc = cat.Procedures("TheQuery")
>>   Set cmd = prc.Command
>>   For Each prm In cmd.Parameters
>>       prm.Value = Eval(prm.Name)
>>   Next prm
>>   Set rst = cmd.Execute
>>
>>If I don't use the query with parameters, but instead base the 
>>recordset on the table, then it works fine:
>>
>>   Set rst = New ADODB.Recordset
>>   Set rst.ActiveConnection = CurrentProject.Connection
>>   rst.CursorType = adOpenForwardOnly
>>   rst.LockType = adLockReadOnly
>>   rst.Open "TheTable"
>>
>>I am getting the same results whether the code is in the existing FE or
>>    
>>
>
>  
>
>>if I create a new db with the ADO code as Rocky suggested.
>>
>>Any thoughts?
>>
>>Jennifer
>>
>>-----Original Message-----
>>From: accessd-bounces at databaseadvisors.com
>>[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
>>at Beach Access Software
>>Sent: Sunday, February 04, 2007 4:55 PM
>>To: 'Access Developers discussion and problem solving'
>>Subject: Re: [AccessD] ADO code stopped working
>>
>>
>>I would whip up a small app with some ado code to see if the problem is
>>    
>>
>
>  
>
>>inside your app or outside of it.  Does your app compile?
>>
>>Rocky
>>
>>
>>-----Original Message-----
>>From: accessd-bounces at databaseadvisors.com
>>[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jennifer
>>Gross
>>Sent: Sunday, February 04, 2007 2:05 PM
>>To: AccessD List
>>Subject: [AccessD] ADO code stopped working
>>
>>Hi Everyone,
>>
>>W2K SP4 / A2K SP3 / terminal server
>>
>>I have a database that has some DAO and some ADO code.  Recently all 
>>ADO stopped working.  DAO is still working fine.  Anytime code 
>>utilizing ADO runs it shuts down the database abruptly, leaving the LDB
>>    
>>
>
>  
>
>>file.  We were also having problems with the Windows Management 
>>databases locking up and a reinstall of the latest MDAC took care of 
>>that problem, but did not solve the ADO problem.  ADO was working fine 
>>for end of year reporting.  There are no missing references.  After the
>>    
>>
>
>  
>
>>MDAC reinstall I unchecked references, closed down, opened up and 
>>rechecked references.
>>
>>Any help would be greatly appreciated.
>>
>>Thank you,
>>
>>Jennifer Gross
>>databasics
>>2839 Shirley Drive
>>Newbury Park, CA 91320-3068
>>office:  (805) 480-1921
>>fax:	   (805) 499-0467 
>>
>> 
>>
>>    
>>
>
>  
>

-- 
Marty Connelly
Victoria, B.C.
Canada




More information about the AccessD mailing list