Skip to Content
0
Oct 09, 2012 at 09:37 PM

ODBC connection to MS SQL database

62 Views

Hi

I have successully installed Microsoft's native ODBC driver to connect to an external MS SQL database as per the documentation below.

http://msdn.microsoft.com/en-us/library/hh568454.aspx

http://www.microsoft.com/en-us/download/details.aspx?id=28160

It works when I use isql.

I am trying to create an entry in table DBCON to connect to this database via ABAP but it is not working.


I have read that you need a Window's based app server to do this, but since this ODBC driver exist, I was wondering why a connection cannot be establised in t-code DBCO.

We are on ECC 6.0, Oracle database, Red Hat 5.0 Linux server.

Any ideas?

Thanks

Stephen