This content has been marked as final. Show 3 replies
Data Source Name - fill in whatever you want.
Server- fill in SMDSP1
User Name is optional, but would be your Oracle database login.
Thanks for your reply. I created the ODBC connection and tried to connect to DB, I got the following error:
Connection Test Failed
SQL##f - SqlState: 08001, ErrorCode: 12154, ErrorMsg: [Microsoft][ODBC driver for Oracle][Oracle]ORA-12154: TNS:could not resolve the connect identifier specified
Please provide info, why I am getting this error.
Thanks & Regards,
My assumption was that you are able to connect WITHOUT odbc (from sqlplus for example). Are you?
My guess is that it may be a formatting problem with your tnsnames.ora, as I get 12154 when I try to use your entry as well. Try formatting it as per the docs (with leading white space) and see if that helps.