topic Re: connect-problems abap -> ms sql server in Application Development and Automation Discussions

connect-problems abap -> ms sql server

Former Member — Tue, 10 Jan 2006 08:03:57 GMT

Hello!

I've problems getting contact to a workgroup-server (ms sql server) from my abap (crm 4.0).

I've made these entries in table dbcon:

DB-Verbindung WG-SERVER

DBMS MSS

Benutzername ides

DB-Passwort ****************************** / ******************************

Verb.Info MSSQL_SERVER=tcp:webrmcmc;MSSQL_DBNAME=ides;

...and this is my code:

REPORT ZCRM_WGSERVER_ABGLEICH.

exec sql.

connect to 'WG-SERVER' as 'WGS'

endexec.

exec sql.

set connection 'WGS'

endexec.

While connecting at "...connect to 'WG-SERVER' as 'WGS'..."

This error raises:

Runtime error DBIF_DSQL2_CONNECTERR

Exception CX_SY_NATIVE_SQL_ERROR

From my SQL Query Analyzer i've no problems to connect to

webrmcmc to make my selections on the smokna1. In the dbcon

i've tried with "tcp:" and without "tcp:" ... nothing helps.

Perhaps there's someone out there with a hint or an advice for me?

Thanks in advance!!!

Best regards,

Ingo

Re: connect-problems abap -> ms sql server

Former Member — Tue, 10 Jan 2006 08:09:07 GMT

Hi,

Check this it may help you.

Regards

vijay

Re: connect-problems abap -> ms sql server

Former Member — Tue, 10 Jan 2006 08:14:07 GMT

Hi vijay,

i've read this already yesterday but it can't resolve my problems. Perhaps another one can help?

Re: connect-problems abap -> ms sql server

Former Member — Tue, 10 Jan 2006 08:42:26 GMT

Hi,

you are giving samll letters, give the upper case.

That might be the reason..

Regards

vijay

Re: connect-problems abap -> ms sql server

Former Member — Tue, 10 Jan 2006 08:58:32 GMT

Hi again

Perhaps i've found something interesting...

Transaction sm21 tells me:

"no shared library for the database which is described at WG-Server".

Do i need the dbmssslib.dll? Where should the dll be installed? Local on my workstation or on the relevant crm-server?

Thanks for your efforts!

Re: connect-problems abap -> ms sql server

Former Member — Tue, 10 Jan 2006 09:27:28 GMT

Hi Ingo,

You should have the dll file on your crm server.

Regards,

Raj

Re: connect-problems abap -> ms sql server

Former Member — Tue, 10 Jan 2006 09:37:10 GMT

...