Re: [python-win32] Trouble finding MSOLAP provider with adodbapi

2022-12-09 Thread savoy 
That's a 32-bit DLL.  Your ODBC driver needs to match your Python 
bittedness, and most of us run 64-bit Python.  Is there a 64-bit 
version of the connector?


Well this is a lapse for me, I entirely misread the download link for
the 64-bit version labeled as "amd64" as "arm64". I'm not very used to
the way Microsoft organizes its documentation. The driver working in
Excel is what threw me off, I was sure I was running the 64-bit Excel.

I'm waiting on someone with admin rights to my machine to install the
64-bit version to verify, but that should hopefully clear it up.

savoy
___
python-win32 mailing list
python-win32@python.org
https://mail.python.org/mailman/listinfo/python-win32

Re: [python-win32] Trouble finding MSOLAP provider with adodbapi

2022-12-06 Thread Tim Roberts 

savoy wrote:


I've downloaded the most up-to-date MSOLAP library from Microsoft's site
(16.0.56.19) and installed it. The location of the library is then saved
as C:\\Program Files (x86)\Microsoft Analysis Services\AS
OLEDB\140\msolap.dll.


That's a 32-bit DLL.  Your ODBC driver needs to match your Python 
bittedness, and most of us run 64-bit Python.  Is there a 64-bit version 
of the connector?


--
Tim Roberts, t...@probo.com
Providenza & Boekelheide, Inc.



smime.p7s
Description: S/MIME Cryptographic Signature
___
python-win32 mailing list
python-win32@python.org
https://mail.python.org/mailman/listinfo/python-win32

[python-win32] Trouble finding MSOLAP provider with adodbapi

2022-12-06 Thread savoy 

I'm trying to use python to connect to a Microsoft Analysis Services
cube for MDX queries due to the phasing out of a SQL server that used to
fill its place as the access point.

I've downloaded the most up-to-date MSOLAP library from Microsoft's site
(16.0.56.19) and installed it. The location of the library is then saved
as C:\\Program Files (x86)\Microsoft Analysis Services\AS
OLEDB\140\msolap.dll.

Using the connection string I've told is the correct to use (and also
verifying it by using it in Microsoft Excel) with adodbapi.connect(),
I get an OperationalError exception in python. Below is the text which
also includes the obfuscated connection string.

(com_error(-2147352567, 'Exception occurred.', (0, 'ADODB.Connection',
'Provider cannot be found. It may not be properly installed.',
'C:\\WINDOWS\\HELP\\AD027.CHM', 1240655, -2146824582), None), 'Error
opening connection to "Provider=MSOLAP.8;Integrated
Security=SSPI;Persist Security Info=True;Initial
Catalog=bi_mdp_SEMANTIC_live_db;Data Source=subdomain.domain.com;MDX
Compatibility=1;Safety Options=2;MDX Missing Member Mode=Error;Update
Isolation Level=2"').

Is there something that I'm missing in order for the connection to work?
I take it that as I can get it working in Excel there isn't anything
wrong with the installation, am I correct in that assumption? And if so,
is there a piece I've left out?

Thank you,
savoy
___
python-win32 mailing list
python-win32@python.org
https://mail.python.org/mailman/listinfo/python-win32