Installing IPyStata for Stata 14 64-bit on Windows 10 & Anaconda3 (64-bit)

[dfdthor]

%%stata
display "Hello, I am printed in Stata."

produces

---

com_error Traceback (most recent call last)
C:\Users\Public\Anaconda3\lib\site-packages\win32com\client\dynamic.py in _GetGoodDispatch(IDispatch, clsctx)
88 try:
---> 89 IDispatch = pythoncom.connect(IDispatch)
90 except pythoncom.ole_error:

com_error: (-2147221005, 'Invalid class string', None, None)

During handling of the above exception, another exception occurred:

com_error Traceback (most recent call last)
in
----> 1 get_ipython().run_cell_magic('stata', ' ', 'display "Hello, I am printed in Stata." \n')

C:\Users\Public\Anaconda3\lib\site-packages\IPython\core\interactiveshell.py in run_cell_magic(self, magic_name, line, cell)
2356 with self.builtin_trap:
2357 args = (magic_arg_s, cell)
-> 2358 result = fn(*args, **kwargs)
2359 return result
2360

<C:\Users\Public\Anaconda3\lib\site-packages\decorator.py:decorator-gen-127> in stata(self, line, cell, local_ns)

C:\Users\Public\Anaconda3\lib\site-packages\IPython\core\magic.py in (f, *a, **k)
185 # but it's overkill for just that one bit of state.
186 def magic_deco(arg):
--> 187 call = lambda f, *a, **k: f(*a, **k)
188
189 if callable(arg):

C:\Users\Public\Anaconda3\lib\site-packages\ipystata\ipystata_magic.py in stata(self, line, cell, local_ns)
318 time.sleep(0.5)
319 self.log_dict[session_id] = os.path.join(self.lib_dir, 'log%s.txt' % session_id)
--> 320 self.session_dict[session_id] = win32com.client.Dispatch("stata.StataOLEApp")
321 self.do_dict[session_id] = self.session_dict[session_id].DoCommandAsync
322 self.session_dict[session_id].UtilShowStata(1)

C:\Users\Public\Anaconda3\lib\site-packages\win32com\client_init_.py in Dispatch(dispatch, userName, resultCLSID, typeinfo, UnicodeToString, clsctx)
93 """
94 assert UnicodeToString is None, "this is deprecated and will go away"
---> 95 dispatch, userName = dynamic._GetGoodDispatchAndUserName(dispatch,userName,clsctx)
96 return __WrapDispatch(dispatch, userName, resultCLSID, typeinfo, clsctx=clsctx)
97

C:\Users\Public\Anaconda3\lib\site-packages\win32com\client\dynamic.py in _GetGoodDispatchAndUserName(IDispatch, userName, clsctx)
112 else:
113 userName = str(userName)
--> 114 return (_GetGoodDispatch(IDispatch, clsctx), userName)
115
116 def _GetDescInvokeType(entry, invoke_type):

C:\Users\Public\Anaconda3\lib\site-packages\win32com\client\dynamic.py in _GetGoodDispatch(IDispatch, clsctx)
89 IDispatch = pythoncom.connect(IDispatch)
90 except pythoncom.ole_error:
---> 91 IDispatch = pythoncom.CoCreateInstance(IDispatch, None, clsctx, pythoncom.IID_IDispatch)
92 else:
93 # may already be a wrapped class.

com_error: (-2147221005, 'Invalid class string', None, None)

[dfdthor]

import ipystata
from ipystata.config import config_stata
config_stata('C:/Program Files (x86)/Stata14')

executes without error and the above error occurs after restarting the kernel

[dfdthor]

C:\Program Files (x86)\Stata14>ls
ado docs STATA.LIC vcomp100.dll
auto.dta isstata.140 StataMP-64.exe
DLXAPI32.DLL Microsoft.VC90.OPENMP StataMP-64_old.exe
DLXAPI64.DLL stata.html utilities

C:\Program Files (x86)\Stata14>StataMP-64.exe /Register

C:\Program Files (x86)\Stata14>

ran without error as the the import ipystata bit and restarting the kernel.

get_ipython().run_cell_magic('stata', '-o car_df', 'sysuse auto.dta')

still gives

UsageError: Cell magic %%stata not found.

[huozi07]

the same for me, anyone dealt with it?

[TiesdeKok]

@huozi07 let's see if we can figure out what is wrong. Some questions:

1. Are you running this in a jupyter notebook / lab session?
2. What is the exact code that you are executing in the notebook? A screenshot would be helpful here.
3. Do you have Stata installed on your computer or are just running it directly via the exe?
4. Does the batch mode work?

[karajimys]

The same for me, any ideas?

[karajimys]

stata installed, batch mode works

[TiesdeKok]

@karajimys this is not necessarily a problem with ipystata, it is more likely a problem with win32 not being able to run/find Stata.

I assume you get the same error if you run the below in a Jupyter Notebook?

import win32com.client as win32
win32.Dispatch("stata.StataOLEApp")

[karajimys]

@TiesdeKok thank you for the answer. Yes exactly the same error.
Any ideas on how could this be solved?

[TiesdeKok]

Ok, that implies that the register step wasn't successful. Did you try to follow the registration steps (https://www.stata.com/automation/#createmsapp) but with an elevated command prompt (i.e. right click on CMD and click "run as administrator")?

[Gehrmanm]

help！this question ，how can i deal it

[XksA-me]

This method solves my problem. It should be a user permission problem, and /Register operation should be performed with administrator permission. I hope it will be helpful to the people behind.

• Method 1: Create a new cmd/powershell with administrator privileges, and then execute: "C:\Program Files (x86)\Stata15\StataSE-64.exe" /Register .

• Method 2: Create a StataSE-64.exe shortcut, right-click-properties-target set "C:\Program Files (x86)\Stata15\StataSE-64.exe" /Register, and then right-click to run with administrator privileges.

thanks @TiesdeKok https://www.stata.com/automation/#createmsapp