Upgrade to 5.2 on Windows 7 and Oracle database

General discussion forum about all databases other than SqlBase.
gliddle

Upgrade to 5.2 on Windows 7 and Oracle database

Post by gliddle » 02 Mar 2011, 19:58

Hi, I installed TD5.2 on my new Windows 7 computer and I'm having problem accessing our Team Object Manager and running our applications compiled in TD5.2

Both will give the "Cannot load any communication DLLs, network may not be installed"

I have the 11.2.0 Oracle client installed on my computer
TD 5.2 SP2 Build 21679

My sql.ini file contains the following :
[win32client]
clientname=GUILLAUME-i5
clientruntimedir="C:\Program Files (x86)\Unify\Team Developer 5.2"

[win32client.dll]
comdll=sqlora32
;comdll=sqlodb32
;comdll=sqlws32

[oragtwy]
;remotedbname=oracle7,@x:orasrv
remotedbname=test,@TEST
remotedbname=cdc,@CDC
remotedbname=team,@TEAM
longbuffer=32767
fetchrow=20
substitute=SYSSQL.,


If I look at the Help->About SqlWindows... it shows that the sql.ini file being used is indeed the one I have in the installation folder

My computers PATH contains : C:\Program Files (x86)\Unify\Team Developer 5.2\axis2c\lib;C:\Program Files (x86)\Unify\Team Developer 5.2;C:\oracle\product\11.2.0\client_1\bin;%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;%SYSTEMROOT%\System32\WindowsPowerShell\v1.0\

I ran a search on my computer for any other sql.ini files that might exist and only the ones in the TD5.2 folder and in our applications folder come up
I checked the other forum posts that refer to this error and none of the solutions seem to work/apply to my case...

Any thoughts at what I could try to fix this issue?

jmcnamara

Re: Upgrade to 5.2 on Windows 7 and Oracle database

Post by jmcnamara » 03 Mar 2011, 15:11

From the name of the install folder, I can assume that you have Win7 64 bit. You aren't trying to run a 64 bit Oracle client are you? If yes, you must install the 32 bit client to use with 32 bit apps.

gliddle

Re: Upgrade to 5.2 on Windows 7 and Oracle database

Post by gliddle » 03 Mar 2011, 19:26

That's exactly what the problem was... We figured it out about 15 minutes after sending the post :)
It's working fine now. Thanks for the reply!

The only problem we are having now is with wsock32.dll . The SMTP class we use does seem to be able to create the connection and send the HELO command but the reply from the server is read as gibberish asian characters. (I actually did ask a Chinese colleague and the text doesn't mean anything hehe). Im guessing it has to do with unicode but I'm not too sure where to start to fix this...

Did you guys encounter any issues like this one?

sirjo
Italy
Posts: 3
Joined: 10 Jul 2018, 06:56
Location: Torino, Italy

Re: Upgrade to 5.2 on Windows 7 and Oracle database

Post by sirjo » 19 Mar 2013, 12:10

I have the same problem in my app that use wsock32.dll to send email.
My application written in TD31 works fine but when I've migrated to TD52 I've encountered the same problem when send HELO command.
Any suggestions??

Thanks
Emanuele

sirjo
Italy
Posts: 3
Joined: 10 Jul 2018, 06:56
Location: Torino, Italy

Re: Upgrade to 5.2 on Windows 7 and Oracle database

Post by sirjo » 19 Mar 2013, 17:04

I've the same problem!
My application in TD3.1 sends mail using SMTP (wsock32.dll) without any problem.
When I've migrated to TD5.2, when I send HELO command to SMPT server I don't receive answer.

Any suggestion?
Thanks.
Emanuele

sirjo
Italy
Posts: 3
Joined: 10 Jul 2018, 06:56
Location: Torino, Italy

Re: Upgrade to 5.2 on Windows 7 and Oracle database

Post by sirjo » 20 Mar 2013, 15:10

Hi,
Here you can see how smtp.app works on TD52.
Connection to SMTP Server works fine but when I send HELO comand using send command,
SMTP Server doesn't receive my string and after some minutes I receive a timeout notification.
I think the problem is on send command.
smtp image.png
This is part of interested source:

Code: Select all

!!CB!! 145
Function: send   ! (WSOCK32.DLL api)
   Description:
   Export Ordinal: 0
   Returns
      Number: INT
   Parameters
      Number: INT
      String: LPVOID
      Number: INT
      Number: INT

!!CB!! 278
Function: Send   ! (Function that call "send" on WSOCK32.DLL)
   Description:
   Returns
      Boolean:
   Parameters
      Number: nSocket
      String: sString  ! my revision
   Static Variables
   Local variables
      Number: nReturn
      String: sStringANSI
      Number: nLen
   Actions
      Call SalStrToMultiByte ( sString, sStringANSI, ENC_ANSI )   ! my revision
      ! Set nReturn = send( nSocket, sString, SalStrGetBufferLength ( sString ), 0 )  ! my revision
      Set nReturn = send( nSocket, sString, SalGetBufferLength ( sStringANSI ), 0 )
      If nReturn = -1
         Return FALSE
      Return TRUE
I've added SalStrToMultiByte and SalGetBufferLength but also with these revisions the application doesn't work on TD52.
Emanuele
You do not have the required permissions to view the files attached to this post.

chelonet
Argentina
Posts: 79
Joined: 19 Apr 2017, 15:28
Location: Argentina

Re: Upgrade to 5.2 on Windows 7 and Oracle database

Post by chelonet » 24 Sep 2013, 21:42

Hi,
Someone could solve the sending SMTP mails via winsock? (which works well with ANSI)

Return to “General Discussion”

Who is online

Users browsing this forum: [Ccbot] and 0 guests