'Unable to load the requested Database interface' and 'DBMS

[Jason]

'Unable to load the requested Database interface' and 'DBMS
is not supported in your current installation'

These are the errors I am getting when I try and create a
new profile in PB 8.0.1, build 8004 with ASA 7.0 on windows
XP
*OR* try to run from development environment.

We do NOT have this problem with PB 7.0.3 at all.

http://www.sybase.com/detail?id=47750

http://www.sybase.com/detail?id=47631

I have read the above links and tried some of those
suggestions - I have even re-installed PB 8.0 (and 8.0.1)
and was able to create a new profile, but still cannot
connect.

If I go to ODBC I can connect (test connection) with the DSN
no problem. We can connect and run PB 7.0.3

PBODB80.DLL is present in the development folder.

Registry for:
\\HKEY_LOCAL_MACHINE\Software\Microsoft\Windows\Current
Version\App
Paths\pb80.exe

is:

C:\Program Files\Sybase\PowerBuilder 8.0;C:\Program
Files\Sybase\Shared\PowerBuilder;C:\Program Files\Sybase\SQL
Anywhere 7\win32;C:\Program Files\Sybase\PowerBuilder 8.0
\Help;C:\Program Files\Sybase\Shared\Web Targets;

I'm not sure what else to do/try?

My system path:

C:\Program Files\Sybase\Jaguar CTS 3.5\bin;
C:\Program Files\Sybase\Jaguar CTS 3.5\dll;
C:\Program Files\Sybase\Jaguar CTS 3.5\client\dll;
C:\Program Files\Sybase\Shared\Sun\JDK118\bin;
C:\Program Files\Sybase\Shared\PowerBuilder;
%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;
C:\Program Files\Common Files\Roxio Shared\DLLShared;
c:\Program Files\Common Files\Powersoft Shared;
c:\Program Files\Powersoft\PowerBuilder 5.0\Advanced
Developer Toolkit\Foundation Class Library;
c:\SQLANY50\win32;
C:\Program Files\Sybase\Adaptive Server Anywhere 6.0\win32;
C:\Program Files\Sybase\SQL Anywhere 7\win32;
C:\Program Files\Sybase\PowerDynamo\win32;
C:\Program Files\Sybase\Shared\Sun\jdk118\bin;
C:\Program Files\Sybase\Shared\Web Targets;
c:\Program Files\vulcan7;
C:\Program Files\Sybase\Shared\win32;
C:\Program Files\Sybase\Shared\Sybase Central 4.0\java

Thanks

Jason

[Chris Keating (iAnywhere Solutions)]

Are these the EXACT messages that you get? If so, the problem is that the
DBMS entry has not been populated.

However, if these are not EXACTLY what the errors are, please provide the
exact message. Solutions to the second message depend heavily on the exact
message.

When you say DEVELOPMENT folder, what is the exact path?

<Jason> wrote in message news:4278e909.371...@sybase.com...

[Jason]

> Are these the EXACT messages that you get? If so, the
> problem is that the DBMS entry has not been populated.

Those are the EXACT messages.

>
> However, if these are not EXACTLY what the errors are,
> please provide the exact message. Solutions to the second
> message depend heavily on the exact message.
>
> When you say DEVELOPMENT folder, what is the exact path?

The development folder is on a server (K:\)

K:\sybase\development\ebill\pbls & pbds etc

However, I just noticed in recording that exact path for you
that the root folder, K:\sybase has exclusively PB 6.x DLLs

However, all our other apps (7.0.3) are also 'housed' on
development

I.e. K:\sybase\development\app#2
K:\sybase\development\app#3 etc.

Each of the individual folders (i.e. app#3 etc) hanging off
development have the appropriate DLLs for their version of
PB. The ebill application (PB 8.0.1), for instance, has all
the PBxxx80.dlls in the e-bill folder...

Thanks for the reply!
Jason

[Jim O'Neil [Sybase]]

As Chris said: " the [transaction object's] DBMS entry has not been
populated." If you are using an INI file to populate this, it may not
be being found on the path as established by the client application.

[Jason]

> As Chris said: " the [transaction object's] DBMS entry has
> not been populated." If you are using an INI file to
> populate this, it may not be being found on the path as
> established by the client application.
>

I'm not using an .ini file, we use a registry entry.

I checked it (debugger) and SQLCA.DBMS = ODBC

The parm, server name, UID & PWD are all correct...

[Jason]

One thing I just noticed.

In the DB profile painter, for PB 8.0.1 it's not ODBC, it
says ODB ODBC

In the DB profile painter for PB 7.0.3 it's just ODBC

Seems like this is the problem...

[Terry Dykstra]

No, that won't be the problem.
If PB itself is complaining when creating a new profile, then the AppPath
for PBxx does not seem to have the directory where pbodbXX.dll is installed
(typically c:\program files\sybase\shared\powerbuilder). Here is what mine
looks like for PB8:

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\App
Paths\pb80.exe]
"Path"="C:\\Program Files\\Sybase\\PowerBuilder 8.0;C:\\Program

Files\\Sybase\\Shared\\PowerBuilder;C:\\Program Files\\Sybase\\SQL Anywhere
7\\win32;C:\\Program Files\\Sybase\\PowerBuilder 8.0\\Help;C:\\Program
Files\\Sybase\\Shared\\Web Targets;"

@="C:\\Program Files\\Sybase\\PowerBuilder 8.0\\PB80.EXE"

--
Terry Dykstra (TeamSybase)
http://powerbuilder.codeXchange.sybase.com/
http://www.pb9books.com
product enhancement requests:
http://my.isug.com/cgi-bin/1/c/submit_enhancement

<Jason> wrote in message news:427934d7.3ee...@sybase.com...

[Jason]

> No, that won't be the problem.
> If PB itself is complaining when creating a new profile,
> then the AppPath for PBxx does not seem to have the
> directory where pbodbXX.dll is installed (typically
> c:\program files\sybase\shared\powerbuilder). Here is
> what mine looks like for PB8:
>
> [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVers
> ion\App Paths\pb80.exe]
> "Path"="C:\\Program Files\\Sybase\\PowerBuilder 8.0
> ;C:\\Program Files\\Sybase\\Shared\\PowerBuilder
> ;C:\\Program Files\\Sybase\\SQL Anywhere 7\\win32
> ;C:\\Program Files\\Sybase\\PowerBuilder 8.0\\Help
> ;C:\\Program Files\\Sybase\\Shared\\Web Targets;"
> @="C:\\Program Files\\Sybase\\PowerBuilder 8.0\\PB80.EXE"

AHA! My path is missing the very last line, everything else
is the same...

What's the "@" for and is it required?

Thanks for the help!

[Jason]

> No, that won't be the problem.
> If PB itself is complaining when creating a new profile,
> then the AppPath for PBxx does not seem to have the
> directory where pbodbXX.dll is installed (typically
> c:\program files\sybase\shared\powerbuilder). Here is
> what mine looks like for PB8:
>
> [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVers
> ion\App Paths\pb80.exe]
> "Path"="C:\\Program Files\\Sybase\\PowerBuilder 8.0
> ;C:\\Program Files\\Sybase\\Shared\\PowerBuilder
> ;C:\\Program Files\\Sybase\\SQL Anywhere 7\\win32
> ;C:\\Program Files\\Sybase\\PowerBuilder 8.0\\Help
> ;C:\\Program Files\\Sybase\\Shared\\Web Targets;"
> @="C:\\Program Files\\Sybase\\PowerBuilder 8.0\\PB80.EXE"

Rats! I put that last line in, then tried to add a new
profile and got:

"Unable to load the requested Database interface. Please
make sure both the interface and client software are
properly installed."

[Terry Dykstra]

The @ is the (default) option.
Do you have pbodb80.dll in the C:\Program Files\Sybase\Shared\PowerBuilder
directory?

--
Terry Dykstra (TeamSybase)
http://powerbuilder.codeXchange.sybase.com/
http://www.pb9books.com
product enhancement requests:
http://my.isug.com/cgi-bin/1/c/submit_enhancement

<Jason> wrote in message news:427a29b4.733...@sybase.com...

[Jason]

> The @ is the (default) option.
> Do you have pbodb80.dll in the C:\Program
> Files\Sybase\Shared\PowerBuilder directory?
>

Yes indeed, sure do. Should I move that @ entry to the front
of the path? (Does it make a difference?)

Jason

[Jason]

I guess we're all out of ideas?

Jason

[Matthew Chestnut]

Use RegMon from sysinternals.com
http://www.sysinternals.com/ntw2k/source/regmon.shtml to see if the
correct values are being read.