Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

SSL connection failed

I had problems connecting to a user dsn under ODBC Data source adminstrator and connecting using OLE DB (ADO) using crystal reports. Initally the connection works then it fails after i update the report by deleting or adding a column from the database. Note: I do not think iam using a SSL connection at all but it gives me an SSL error. Using a SQL server connection to connect to SQL Server

dde 998-e60 EXIT SQLSetConnectAttrW with return code 0 (SQL_SUCCESS)

SQLHDBC 0x0089B678

SQLINTEGER 111 <SQL_ATTR_QUIET_MODE>

SQLPOINTER 0x00000000

SQLINTEGER 0

dde 998-e60 ENTER SQLDriverConnectW

HDBC 0x0089B678

HWND 0x00290294

WCHAR * 0x6B498B34 [ -3] "******\ 0"

SWORD -3

WCHAR * 0x6B498B34

SWORD -3

SWORD * 0x00000000

UWORD 0 <SQL_DRIVER_NOPROMPT>

dde 998-e60 EXIT SQLDriverConnectW with return code -1 (SQL_ERROR)

HDBC 0x0089B678

HWND 0x00290294

WCHAR * 0x6B498B34 [ -3] "******\ 0"

SWORD -3

WCHAR * 0x6B498B34

SWORD -3

SWORD * 0x00000000

UWORD 0 <SQL_DRIVER_NOPROMPT>

DIAG [08001] [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SSL Security error (18)

DIAG [01000] [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen (SECCreateCredentials()). (0)

DIAG [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed (0)

Edited by: jeffman2 on Jun 2, 2011 7:58 PM

Edited by: jeffman2 on Jun 2, 2011 8:00 PM

Former Member
replied

Open the report up and click on Database, Verify....

If you make changes to the database you need to tell CR it changed also by Verifying the DB.

What happens if you create a new report, do you get the error? If so then something wrong with your change in the DB that CR doesn't know how to handle.

Thank you

Don

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question