ODBC driver failed to creat DSN
Dear All,
I wanted to create a DSN to use with Crystal report XI prof for testing advanced reporting options.
I created teh DSN following the sample DSN provided for the Southwind DB unfortunately it is not connecting to my DB. Below is the lianja ODBC diagnostic:
testing DSN 'lianja_gesavoc'
SQLAllochadle(SQL_HANDLE_ENV) : successful completion
SQLSetEnvAttr(SQL_ATTR_ODBC_VRSION,SQL_OV_ODBC3) :successful completion
SQLQllocHandle(SQL_HANDEL_DBC) : successful completion
SQLSetConnectAttr(SQL_LOGIN_TIMEOUT,5): successful completion
SQLDriverConnect(lianja_gesavoc) : SQL_Error Database 'gesavoc' The system cannot find the file specified.
But when I use the southwind odbc it can connect properly.
Parameters used to create the DSN are:
DSN Name: lianja_gesavoc
server: localhost
user: ?
passw: ?
DATABASE : gesavoc (name of the db)
Thank you for your help
Esperant