Multiconnect to MS SQL

[Former Member]

Hi all,

I want to acces data from a SQL DB on a Windows server.

A connection via DBCO is created. After reading some notes I'm searching for the

dbmssslib.dll ?! My question is where can I found the right one for my System ?

We are at V5R4M0, SAP 46C.

Or is it possible to acces SQL data from SAP 46C(iSeries) somehow ??

Grtz

Thomas

[dorothea_stein · Accepted solution]

Hi Thomas,

you should find the MSS DBSL for Windows on the service market place where the kernels are at "Windows" -> "MS SQL Server". It's the "LIB_DBSL" patch.

And you are right: Unfortuantely, access to SQL server from ABAP only works through Win AppServers...

Best regards,

Dorothea

[Former Member]

Hi Dorothea,

many thx for your reply. So at least one Windows application server must be available on the R/3 system and the DBSL dynamic library (DLL) dbmssslib.dll must be installed on this server !!

But we've 46C EBCDIC codepage installed is that possible with this installation ?

Grtz

Thomas

[Former Member]

Hi Thomas,

NO ;-(((

... but at least you now see one more reason in order to move to ASCII )

Regards

Volker Gueldenpfennig, consolut.gmbh

http://www.consolut.de - http://www.4soi.de - http://www.easymarketplace.de

P.S.: in the current environment, I only do see individual programs with ODBC, RFC or similar ;-(

[dorothea_stein]

Hi Thomas,

Volker was faster...

I just realized that I misread your initial post as "I want to acces data from a SQL DB from a Windows server". That would have worked. But unfortunately, Windows AppServer is only available for ASCII (GLS).

I'm afraid, there is no direct way to access data from SQL Server using EBCDIC...

Some crazy ideas/hacks:

In case you have any SAP system with Win AppServer you could use that system to connect to SQL Server and then use RFC to pass the data to the system in which you need it. RFC would also be able to convert the data to EBCDIC at the same time.

You might be able to do a similar thing with a standalone Windows program in combination with RFC, but I'm not familar enough with RFC to know whether that would work at all. Plus, you'd probably need a Windows Development Environment...

Bad news, I'm sorry...!

Kind regards,

Dorothea

[Former Member]

Hi Volker,

Aaaaarghhhh !!!

It's my special nightmare !!!!

That's what I don't want to hear !! )

many thx Volker