on 06-02-2011 6:58 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.