ADODB & Win 7

[LPP]

Hi, I´m trying to use an ADODB Recordset.

If I´m running my script under Windows XP everything is ok.

If I´m using Windows 7 I get the following error:

The content of the line is "$value=$rs.Fields($Row).Value".

After removing the ".Value" the error disapears, but I don´t get the value...

[99ojo]

Hi,

if you have 32 Bit XP and 64 Bit Win 7 this link could be helpful:

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

;-))

Stefan

[zorphnog]

I think I remember running into a similar issue. Try this:

$value=$rs.Fields.Item($Row).Value

Edited May 5, 2010 by zorphnog

[GEOSoft]

Also, if you have changed the version of office you are using it will break things like that.

[LPP]

I think I remember running into a similar issue. Try this:

$value=$rs.Fields.Item($Row).Value

Hey, it didn´t work...

I get the error on 32- & 64-bit Windows 7...

[LPP]

Hey there, just tried $recordset.getrows()

Same Error, in this way, any idea?

The interesting thing is that the error only occures on some win7 machines...

[LPP]

This is the error again:

The requested action with the object has failed.

[GEOSoft]

What version of Office?

Did you make sure to also put the AccessConstants.au3 file in your include folder?

Also, run your script from Scite and then post the error returned. I want to see exactly where it's failing and that should give a better indication of what's happening.

Edited June 28, 2010 by GEOSoft

[PsaltyDS]

Add a COM Error handler (see OBJ/COM Reference in help file). That should give you more detailed information on exactly what went wrong.

[LPP]

Just saw that the database alias was not set in the registry. Setting it solved the problem.

(The key is: HKLM\Software\Microsoft\MSSSQLSERVER\Client\ConnectTo)