Hello,
We share our Excel Macro - MS Access project with our client. They don't know to select the 'Microsoft ActiveX Data Objects x.x Library' from the Tools - References. Assume that you develop an ActiveX Data Objects (ADO)-based data access application on a computer that is running Windows 7 Service Pack 1 (SP1) or Windows Server 2008 R2 Service Pack 1 (SP1). However, the application does not run on a computer that is running an earlier version of Windows.
I use the Microsoft ActiveX Data Objects Library to connect to our SQL server to run queries against tables and return the desired results for reporting.
Issue I am running into is this. I primarily use the 2.8 Library, but need to create a 2.7 Library version of the xlsm since some users will get an error message on the 2.8 Library version of the xlsm. On the PCs that have issues, I have run the MDAC_Type.exe for the 2.8 update and that has NOT corrected the problem and on some PCs, it will not run (Not compatible). Our environment is XP Pro and WIn 7 Pro, and I will get errors on both OS for both Libraries.
It is very frustrating to maintain 2 versions of a xlsm just to ensure that all of the users can use one or the other to avoid an error message.
This is the basic code I use to setup my connection and run my query. The error always occurs at the dbConn.Open myConn line in the code.
'ADD ADO Reference
myServer = 'SERVERXX'
myDB = 'XXXX'
Set dbConn = New ADODB.Connection
myConn = 'PROVIDER=SQLOLEDB;Integrated Security=SSPI;Persist Security Info=False;' myConn = myConn & 'DATA SOURCE=' & myServer & ';INITIAL CATALOG=' & myDB & ';' dbConn.Open myConn myQuery = 'select * from Table' Set myRS = New ADODB.Recordset With myRS .ActiveConnection = dbConn .Open myQuery End With Do Until myRS.EOF userID = myRS.Fields(0).Value myRS.MoveNext Loop myRS.Close dbConn.Close
The ADO Reference that I use will be either the Microsoft ActiveX Data Object 2.8 Library or the Microsoft ActiveX Data Object 2.7 Library and append the file names with either (2.8).xlsm or (2.7).xlsm to distinguish between the two.
Any help in getting this issue resolved will be GREATLY appreciated. I would like to use the 2.8 library all the time and need to know what needs to be done on the PCs that get an error with that library.
Toast titanium for mac free. The error message for those that get the error:
Title: Microsoft Visual Basic for Applications
Message: Class does not support Automation or does not support expected interface.
![]()
AGAIN, I have run the latest MDAC update on those PCs that get the error and it either has not worked, or will error out with a message stating it is not supported.
Please help me.. THANKS!!
Microsoft Activex Data Objects Versions Free
PS - I am sorry if I missed including any vital information. I did my best to include all relevant facts.
-->
This topic lists the new features introduced by each release of ADO, ADO MD, and ADOX.
ADO 6.0
ADO 6.0 is included in Windows Vista, as a part of the Windows Data Access Components (Windows DAC) 6.0. ADO 6.0 is functionally equivalent to ADO 2.8.
ADO 2.8
ADO 2.8 was included in Windows XP and Windows Server 2003, as part of the Microsoft Data Access Components (MDAC) 2.8. A redistributable version of MDAC 2.8 is also available; note that this redistributable version should only be installed on Windows 2000. ADO 2.8 addresses several security-related concerns:
Hard drive access is not allowed outside a trusted zone.In cross-domain scripting involving nontrusted sites, the following operations are disabled: Stream.SaveToFile, Stream.LoadFromFile, Recordset.Save, and Recordset.Open, used in conjunction with the adCmdFile flag or with the Microsoft OLE DB Persistence Provider (MSPersist).
Recordset.Open,Recordset.Save,Stream.SaveToFile, andStream.LoadFromFileoperate on physical files only.These methods now verify that file handles point to physical files only.
![]()
Recordset.ActiveCommandreturns an error when invoked from an HTML/ASP page.This prevents the Command object from being misused.
The number ofRecordsetsreturned by a nestedShapecommand has an upper bound.A nested shape command now returns a maximum of 512 Recordsets. This means that a Shape command can no longer be nested at any depth. Instead, the maximum level depth is 512, if each command results in a single (child) Recordset. If, at any level, a Shape command returns multiple Recordsets, the maximum level of depth will be less than 512.
ADO 2.7
64-bit platform supportADO 2.7 introduces support for 64-bit processors.
Ben ten omniverse games to play. Ben 10 Omniverse Beating the bad guys is just part of the superhero gig. With a little help from his new, by-the-book rookie partner, Ben explores the quirkier side of things in the alien underground and discovers enemies from his past looking for a re-match, all while a mysterious hunter is hot on his trail! Play Ben 10 Omniverse For Free! - It's a good game where you have to kill all the robot, help ben 10 because he is alone gain this monsters. Play Ben 10 Omniverse online For Free! - uFreeGames.Com. Here are few amazing ben 10 omniverse games to play online: Ben 10 Galactic Champions. Ben 10 Omniverse Collection. Ben 10 Omnitrix Attack. Ben 10 Alien Unlock. Ben 10 Power Surge.
ADO 2.6
CubDef.GetSchemaObjectMethodStarting with ADO 2.6, ADO MD objects can be retrieved using unique names, as specified by the UniqueName property (ADO MD). The names of parent objects do not need to be known, and parent collections do not need to be populated to retrieve a schema object. See GetSchemaObject method (ADO MD).
Command streamsThe Command object supports commands in stream format as an alternative to using the CommandText property. The CommandStream property (ADO) can be used to specify XML Templates or updategrams as the Command input with the Microsoft OLE DB Provider for SQL Server.
DialectpropertyDialect is a new property that defines the syntax and general rules that the provider uses to parse the string or stream.
Microsoft Activex Data Objects Versions For Windows 10
Command.ExecutemethodThe Execute method of the ADO Command object has been enhanced to use streams for input and output.
Field statusvaluesIf the user encounters a DB_E_ERRORSOCCURRED error when modifying a Field of a Recordset, ADO will now fill the Field.Status property with the appropriate status information so that the user will have more information about what went wrong. See Status Property (ADO Field).
NamedParameterspropertyNamedParameters is a new property of the Command object that indicates that the provider should use named parameters.
Resultsets in streamsADO can return resultsets from a data source in a Stream, rather than a Recordset object. Using the latest version of the Microsoft OLE DB Provider for SQL Server, you can get XML results from the provider by executing a 'For XML' query. A Stream that receives the resultset can be opened with a 'For XML' command as the source. See Retrieving Resultsets into Streams.
Single row resultsetThe ADO Record object can now be opened on a command string or Command object that returns one row of data from the provider. This results in improved performance with MDAC 2.6 providers. See Open Method (ADO Record).
ADO 2.5
RecordobjectADO 2.5 introduces the Record object to represent and manage a row from a Recordset or a data provider, or an object encapsulating a semi-structured data, such as a file or directory.
StreamobjectADO 2.5 also introduces the Stream object to represent a stream of binary or text data.
URL bindingADO 2.5 introduces the use of a URL, as an alternative to a connection string and command text, to name data store objects. A URL can be used with the existing Connection and Recordset objects, as well as with the new Record and Stream objects.
Data providers supporting URL bindingADO 2.5 supports OLE DB providers that recognize the URL schemes. This includes OLE DB Provider for Internet Publishing, which accesses the Windows 2000 file system and recognizes the existing HTTP scheme.
Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |