01-10-2006 8:03 AM
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
01-10-2006 9:27 AM
Hi Ingo,
You should have the dll file on your crm server.
Regards,
Raj
01-10-2006 8:09 AM
01-10-2006 8:14 AM
Hi vijay,
i've read this already yesterday but it can't resolve my problems. Perhaps another one can help?
01-10-2006 8:42 AM
01-10-2006 8:58 AM
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!
01-10-2006 9:27 AM
Hi Ingo,
You should have the dll file on your crm server.
Regards,
Raj
01-10-2006 9:37 AM