Oracle Connection

[tommyarm]

Hi,

I have installed TD 6.3 UPD2 to start migration from TD 5.2. It's Windows 7 environment and win32. The installation was successful and I have run the migration tool. All seem fine, but my new app can't connect to Oracle. If I run the app from within TD I get the error 9268 (Cannot connect), if I run the exe I get a program crasch. It's no problem to connect using SqlTalk.

Just to check I tried my old app version, and now that one don't work either. Error 9293 (Cannot load any communication DLLs, network may not be installed) in TD and "The ordinal 247 could not be located in the dynamic link library SQLWNTM.DLL". No problem with old SqlTalk.

What may be wrong?

Best regards,
Tommy

[wardies]

Hi,

I'll take bets on your path no longer leading to the correct Oracle Client 32-bit binaries folder. If listed, it needs to be moved to before the x64 Oracle client path if that or a 64-bit Oracle XE service is also installed. (Edit: You mentioned your Win environment is win32 only; if so then it's something else but the following steps will let you find the problem anyway).

You can investigate the problem using Process Monitor from Sysinternals: run it up, add a filter for "Process Name is cbi63.exe (if running from the IDE) then Include". Add and press OK. Monitoring will begin.

Now try launching the IDE in the usual way, open your application source and run it.

Once you see the error connecting (or crash), you can stop monitoring by pressing Ctrl+E in Process Monitor. Then scroll to the time you tried to connect and scroll down; you'll see which DLLs it was searching for (and can also Ctrl+F to find "DLL").

[tommyarm]

Hi,

and thank you for the answer. The monitoring made me aware that TD didn't look for any Oracle DLLs at all. I searched for conflicting SQL.INI and found one in folder SqlBase, removed it and now it works ok!

Thanks again!

Tommy