Cant connect to server

[Former Member]

SAP Business One DI API Version 2005 COM object through a PHP web application.

There is an intermittent problem where I can't establish a connection to SAP database.

Sometimes it works other times it just hangs indefinitely. This has become a real problem

for our company.

I have restarted the webserver but this doesn't fix the problem.

Any ideas?

[Former Member · Accepted solution]

Hi Simon,

I have had a similar problem.

Please, check the date of SAPbobsCOM2005.dll in terminal and in server. in my case the date of terminal isnt equal the date of server. i just reinstal the DI and this works fine now.

Check the date in this folders(terminal/server)

X:\Program File\SAP\SAP Business One DI API\DI API 2005

X:\Program File\SAP\SAP Business One\DIAPI\2005

Hope this could helps

[Former Member · Accepted solution]

Not sure what you mean Rodrigo.

Is this the modified date of the dll file?

I'm not really a windows man. How do I re-install the DI?

I inherited this situation with a new job. Sorry for my lack of knowledge. I am primarily a PHP programmer.

[Former Member · Accepted solution]

Sorry my inglish is not so good.

You have check the dlls date and the lenght. In my case, the dlls is not same, the date and the lenght are not equal. in Server have a date and the client have another date. One is make in 04/06/2006 the other is make in 09/26/2005.

This situation i have to reinstal the DI, you can try to do it.

First step (remove DI)

Go to Panel Control -> add/remove program and remove the SAP DI API

Second step (intall DI)

ps: DI API is a file whos you connect to a database(SAP-BO)

[Eneveux]

Simon,

Is there an error that is produced when you cannot connect that you can share with us?

Eddy

[Former Member]

Hi Eddy,

there is no error message, the web browser just hangs indefinitely. I don't even get a return code, to say that the connection failed.

[Former Member]

One other thing to mention is that a COM exception was thrown when I was testing some code.

This was probably due to me not supplying the correct data to the DI. Thereafter I couldn't make a connection to the SAP server. This resulted in me having to restart the server to get it going again.

I had a look at what services where running under windows. There was something called SAP DI server. Initially I thought that I could restart this service, but then realised it wasn't even running when I was getting a successful connection. Is this service somehow related to what I am doing?

Much appreciated,

Simon.