Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM ODBC Driver » View Thread |
Messages 1 to 4 of 4 total |
Connecting with SPSS |
Wed, Feb 4 2009 11:23 AM | Permanent Link |
Mark Shapiro | I have a user who tried to connect to DBISAM 4 tables using SPSS and received the
following error: "Database connection failed. The driver may not be configured properly" Any suggestions on what to look for? Mark Shapiro |
Sat, Feb 7 2009 2:40 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Mark,
<< I have a user who tried to connect to DBISAM 4 tables using SPSS and received the following error: "Database connection failed. The driver may not be configured properly" Any suggestions on what to look for? >> What you should do is enable the ODBC tracing (Tracing tab under the ODBC Administrator), try the connection again, disable the tracing, and then post the trace log (text file) here. I can then see if there's a specific ODBC API call that is causing an issue. -- Tim Young Elevate Software www.elevatesoft.com |
Thu, Feb 12 2009 12:42 PM | Permanent Link |
Mark Shapiro | Tim,
Here is the trace log passed along by my customer. Mark Shapiro Attachments: ODBCtrace.log |
Fri, Feb 13 2009 2:24 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Mark,
<< Here is the trace log passed along by my customer. >> Okay, the issue seems to be that the software is calling the BrowseConnect API function, but is not passing it a valid connection string for the DBISAM ODBC driver. The DBISAM ODBC driver then returns an indication that it needs more data to complete the connection string, after which the software should continue to call BrowseConnect after fixing or adding to the connection string. However, the software does not do this, but rather continues on as if everything is okay. Thus any subsequent calls are rejected because a valid connection never exists. Unfortunately, the trace only indicates that the passed connection string as '***'. I'm not sure where that string is coming from, or why it contains asterisks only, but perhaps you can look to see if you can configure SPSS for ODBC access somewhere in the software. Did you specify an ODBC DSN or something similar in the SPSS software ? -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Thursday, March 28, 2024 at 06:18 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |