Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 4 of 4 total
Thread Connecting with SPSS
Wed, Feb 4 2009 11:23 AMPermanent 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 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email 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 PMPermanent 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 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email 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

Image