connect-problems abap -> ms sql server

[Former Member]

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

[Former Member]

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

[Former Member]

Hi,

Check this it may help you.

Regards

vijay

[Former Member]

Hi vijay,

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

[Former Member]

Hi,

you are giving samll letters, give the upper case.

That might be the reason..

Regards

vijay

[Former Member]

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!

[Former Member]

Hi Ingo,

You should have the dll file on your crm server.

Regards,

Raj

[Former Member]

...