I'm convinced the list doesn't come from the Registry.  I took John Faus's advice and searched the Registry, and didn't find a list that matches what I see in the database painter.  I struck out with the C:\Windows\SysWOW64 possibility - there isn't an ODBC.ini or an ODBCINST.ini.  I did a search anywhere on my C: drive for an ODBC.INI, but no luck.  The ODBC Admin configuration tool shows the complete list of DSN's - including the one particular database I need but isn't in the database painter list.

It is probably a combination of the local machine and current user ODBC keys from the registry.

Hi Larry,

you may try to use Sysinternals Process Monitor to scan where Powerbuilder searches the OBDC data sources. Maybe you also see here where PowerBuilder finds the datasource you are looking for.

Do you see the DataSource if you use the ODBC Administrator? What type of DataSource is it? (user, system, file?)

Some more places to look:

C:\Windows\SysWOW64\ODBC Drivers\ODBC Data Sources.ini

C:\Windows\ODBC.INI

HTH,

René

Hi, Larry -

Have you tried performing a search from Regedit, say on one of the more unique/uncommon data source names so as to try and minimize the number of hits?

Regards, John

The Registry entry HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Sybase\PowerBuilder\17.0\Vendors contains a list of the different database types (see attached screenshot), not the indisvidual data sources.

Thanks everyone!
I'm familiar with the different Registry locations where DSN's might be listed:

HKEY_CURRENT_USER\Software\ODBC\ODBC.INI\ODBC Data Sources
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources
HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\ODBC\ODBC.INI\ODBC Data Sources

HKEY_CURRENT_USER\Software\Sybase\PowerBuilder\17.0\DatabaseProfiles\PowerBuilder

...and I've checked each, but still don't see the list that matches what I see within PowerBuilder (see the attached screen shot).

As mentioned, I'm trying to export the SQL syntax for the CREATE for a single table so that I can replicate it within a SQL Server database schema.

Hi Larry,

there are different types of ODBC data sources; for users, for machine (system) and in files.

File data sources you find in file system.

System data sources you may find in registry:

HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources

HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\ODBC\ODBC.INI\ODBC Data Sources

User data sources are also in the registry:

HKEY_CURRENT_USER\Software\ODBC\ODBC.INI\ODBC Data Sources

HTH,

René

Here is the location where database profiles are stored:

HKEY_CURRENT_USER\Software\Sybase\PowerBuilder\##.#\DatabaseProfiles\PowerBuilder

Appeon versions of PowerBuilder still use the Sybase key.

If I understand you correctly:

I think you have the correct location, but they will not be displayed until
   1) there's a Data Source Name created for each database you want displayed, and
   2) you have created a profile for the database.


I do not know how to export an entire database. In the past I have exported the synatx and data of each table in the database, one at a time.


Good Luck!