SAVE TRANSLATE and Possible Driver/Windows 7 Problem
Locked
SAVE TRANSLATE and Possible Driver/Windows 7 Problem
 
|
I have a problem I thought might have been resolved, but is not. I cannot use SAVE TRANSLATE to export data from SPSS to an Excel template file. Also problems importing into SPSS from Excel and Access. The problems may have started when we had Windows
7 installed. Here are the error messages:
>Error # 6492
The ODBC subsystem has issued an error which prevents the processing of SAVE
TRANSLATE ODBC request.
Execution of this command stops.
[Microsoft][ODBC Excel Driver] Cannot update. Database or object is read-only.
[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed
[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed
[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed
[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed
Error # 6492
The ODBC subsystem has issued an error which prevents the processing of SAVE
TRANSLATE ODBC request.
[Microsoft][ODBC Excel Driver] Cannot update. Database or object is read-only.
[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed
[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed
[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed
[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed
Traceback (most recent call last):
File "<string>", line 287, in <module>
File "C:\Python26\lib\site-packages\spss190\spss\spss.py", line 1477, in Submit
raise SpssError,error
spss.errMsg.SpssError: [errLevel 3] Serious error.
Can anyone confirm that this is a Driver (and possibly Windows 7) issue and not a problem with SPSS and/or Python? And whether or not, any straightforward resolutions?
Thanks for any assistance, and be well!
Alan
Alan D. Krinsky PhD, MPH
Senior Data Analyst Office of Clinical Integration
UMass Memorial Health Care 306 Belmont Ave. Worcester, MA 01605 E-mail: [hidden email] The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, transmission, re-transmission, dissemination or other use of, or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. |
Re: SAVE TRANSLATE and Possible Driver/Windows 7 Problem
|
|
"Cannot update. Database or object is read-only." Did you check whether this is indeed the case? Do you or perhaps a colleague still have the file open, perhaps after a crash? Regards, Albert-Jan ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ All right, but apart from the sanitation, the medicine, education, wine, public order, irrigation, roads, a fresh water system, and public health, what have the Romans ever done for us? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
|
Re: SAVE TRANSLATE and Possible Driver/Windows 7 Problem
|
|
Aside from file contention, the file itself
may be read-only.
If neither of those is the case, a less obvious cause can be the driver configuration settings. Check the driver settings in the ODBC Data Source Administrator for a "read-only" setting and uncheck this setting if it is checked. Finally, if you are running the 64-bit version of Statistics on Windows 7: "Note: If you are running the Windows 64-bit version of IBM SPSS Statistics, you cannot read Excel, Access, or dBASE database sources, even though they may appear on the list of available database sources. The 32-bit ODBC drivers for these products are not compatible." The same is true for writing to Excel or Access via ODBC. I don't know if Microsoft offers 64-bit versions of these drivers. But if you are using the Database Wizard or the Export to Database Wizard to read or write Excel or Acces files in the 64-bit version of Statistics, you won't get past the step where you select the database source. You would only see an error if you attempted to make the ODBC connection with previously saved SAVE TRANSLATE /TYPE=ODBC command syntax. You can, of course, read and write Excel files directly from Statistics without using ODBC. Rick Oliver Senior Information Developer IBM Business Analytics (SPSS) E-mail: [hidden email] From: Albert-Jan Roskam <[hidden email]> To: [hidden email], Date: 02/28/2014 05:05 PM Subject: Re: SAVE TRANSLATE and Possible Driver/Windows 7 Problem Sent by: "SPSSX(r) Discussion" <[hidden email]> "Cannot update. Database or object is read-only." Did you check whether this is indeed the case? Do you or perhaps a colleague still have the file open, perhaps after a crash? Regards, Albert-Jan ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ All right, but apart from the sanitation, the medicine, education, wine, public order, irrigation, roads, a fresh water system, and public health, what have the Romans ever done for us? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ From: "Krinsky, Alan" <[hidden email]> To: [hidden email] Sent: Friday, February 28, 2014 10:35 PM Subject: [SPSSX-L] SAVE TRANSLATE and Possible Driver/Windows 7 Problem I have a problem I thought might have been resolved, but is not. I cannot use SAVE TRANSLATE to export data from SPSS to an Excel template file. Also problems importing into SPSS from Excel and Access. The problems may have started when we had Windows 7 installed. Here are the error messages: >Error # 6492 The ODBC subsystem has issued an error which prevents the processing of SAVE TRANSLATE ODBC request. Execution of this command stops. [Microsoft][ODBC Excel Driver] Cannot update. Database or object is read-only. [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed Error # 6492 The ODBC subsystem has issued an error which prevents the processing of SAVE TRANSLATE ODBC request. [Microsoft][ODBC Excel Driver] Cannot update. Database or object is read-only. [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed Traceback (most recent call last): File "<string>", line 287, in <module> File "C:\Python26\lib\site-packages\spss190\spss\spss.py", line 1477, in Submit raise SpssError,error spss.errMsg.SpssError: [errLevel 3] Serious error. Can anyone confirm that this is a Driver (and possibly Windows 7) issue and not a problem with SPSS and/or Python? And whether or not, any straightforward resolutions? Thanks for any assistance, and be well! Alan Alan D. Krinsky PhD, MPH Senior Data Analyst Office of Clinical Integration UMass Memorial Health Care 306 Belmont Ave. Worcester, MA 01605 E-mail: alan.krinsky@... The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, transmission, re-transmission, dissemination or other use of, or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. |
«
Return to SPSSX Discussion
|
1 view|%1 views
| Free forum by Nabble | Edit this page |