cancel
Showing results for 
Search instead for 
Did you mean: 

SSL connection failed

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

0 Kudos

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

Former Member
0 Kudos

I think its was an issue with visual studio because i open it up in their and it stops giving the error. Also, i changed connection types and it worked.

Answers (0)