Why i can not use dbco to connect sql server 2008?

[Former Member]

Dear Experts,

i use this mehtod to link sql server 2005 :MSSQL_SERVER=tcp:mysqlserver IP MSSQL_DBNAME=SubConPayment,

it is ok,when i use this method to link sql server 2008 with dbco,it is not ok,can you tell me why i can not link to sql server2008 in sap with dbco?

looking forward to your reply.

Best regards,

Merry

[former_member848108]

Hi Merry,

Seems that you have to add the "provider" attribute to the connectionstring. Please have a look at the following link: [http://www.connectionstrings.com/sql-server-2008#p2]

Regards,

Ozcan.

[Former Member]

Many thanks .