I recently doing a database project, using pb12.5, have not used before is now drawing to a close, encountered a few problems, or confused 1. My database with the one that was ASA, when I was in the development in teaching and research section, have wanted to do, back to the dormitory to continue to copy the results back program cannot connect to the database, checked the baidu, saying is to add a data source, resulting in several times didn't succeed, please help to give directions 2. Yesterday I compile program to generate the executable file, copy other computers are not running, I was using a full compilation, found or suggest lack of DLL, the lack of copy, still unable to connect to the database (3) this project before I have a very similar, I didn't do it, is made of Delphi, I run directly to open, before is not to add and configure ODBC data sources, a bit confused now wants done PB, brothers and sisters to help project is quick acceptance, be obliged!

CodePudding user response:

Only to configure the ODBC data source

CodePudding user response:

Add 1 ODBC data source, add if you don't succeed, may be system problem, try using computer,
If the computer to run the program without PB environment, needs the PB run some basic DLL copied to the directory,
Such as version 9.0: pbodb90. DLL, pblib90. DLL files, such as 12.5 there should be a corresponding DLL file

CodePudding user response:

ODBC data source, at the time of new ASA database, it is best to specify the DB file path for the current path: ". \ "and so, again released, as long as the DB files under the application installation directory, will be able to start the database, otherwise, installing path must follow a development path set,

I use the experience of so,

CodePudding user response:

ASA database that contains two files, one is the db database file, the other is a log file, you will develop in all copied to another machine, may also will copy these two files also came over, but, as far as I know, recorded in the log file or the things that you machine, so, when you connect to the database, will go wrong (this is my past with pb8 had problems, later if use sybase centre to force changes to use), then I have to use the db files, and lay down the log file, this is many years ago, for reference only.

CodePudding user response:

reference 1/f, xiajinxian response:

can only go to configure the ODBC data source

If a computer is not installed on the original concept has no asa database
At this time of the how to configure ODBC?
Thank you

CodePudding user response:

refer to the second floor smilysoft response:

add 1 ODBC data source, add if you don't succeed, may be system problem, try using computer,
If the computer to run the program without PB environment, needs the PB run some basic DLL copied to the directory,
Such as version 9.0: pbodb90. DLL, pblib90. DLL files, such as 12.5 there should be a corresponding DLL file

If the program does not connect to the database should copy some of the dynamic link library DLL can run
Now to connect to the database and in an environment without computer I wouldn't have got
Noon sent some books seem to install the database driver also take an examination of the past but how will not

CodePudding user response:

You in the program - the sybase - pb12 - original concept runtime package run it, and then select the inside of the odbc options, such as the system will generate a installation package (save to your designated place), which will include the odbc driver,

CodePudding user response:

Also, to the registry of development machine, you find the ODBC node, you native database connection configuration, configure these things to the client or dormitory in the machine, you said that need not to ODBC interface configuration, it would be useful for you to release to the client,

CodePudding user response:

Open the ODBC step is:
Start - & gt; Run - & gt; Odbcad32 - & gt; Enter

If you don't have ASA library that unless you connect other database servers

CodePudding user response:

7th floor fm20027 said more comprehensive, can use to the compiled program, there are two conditions required to satisfy, 1, and your other machines must be ASA database, and by the application starts, or ASA database configuration manual startup, 2, the application can run, run requires relevant DLL library file and the corresponding connect to the database, ASA database related test DLL or exe file to come over again through the ODBC configuration, or directly use PB installation disk installation sqlanywhere configuration again, match well and be able to start after database, PB program runs only need some DLL, related with the original concept of PB runtime package can directly generate the required library file installation package,

CodePudding user response:

The registry of the registered odbc code
If profilestring (is_app_path + '\ salesystem ini', 'SYSTEM PROFILE', 'ERGEDIT', '0')='1' then
RegistrySet (" HKEY_LOCAL_MACHINE \ SOFTWARE \ ODBC \ ODBCINST SQL Anywhere INI \ 11.0 "and" Driver ", RegString! , is_app_path + "\ \ dbodbc11 DBMS DLL")
RegistrySet (" HKEY_LOCAL_MACHINE \ SOFTWARE \ ODBC \ ODBCINST SQL Anywhere INI \ 11.0 ", "Setup", RegString! , is_app_path + "\ \ dbodbc11 DBMS DLL")
RegistrySet (" HKEY_LOCAL_MACHINE \ SOFTWARE \ ODBC \ ODBCINST SQL Anywhere INI \ 11.0 the Translator "and" Driver ", RegString! , is_app_path + "\ \ dbctrs11 DBMS DLL")
RegistrySet (" HKEY_LOCAL_MACHINE \ SOFTWARE \ ODBC \ ODBCINST SQL Anywhere INI \ 11.0 the Translator ", "Setup", RegString! , is_app_path + "\ \ dbctrs11 DBMS DLL")
RegistrySet (" HKEY_LOCAL_MACHINE \ SOFTWARE \ ODBC \ ODBCINST SQL Anywhere INI \ 11.0 the Translator ", "the Translator", RegString! , is_app_path + "\ \ dbctrs11 DBMS DLL")
RegistrySet (" HKEY_LOCAL_MACHINE \ SOFTWARE \ ODBC \ ODBCINST INI \ ODBC Drivers ", "11.0" SQL Anywhere, RegString! , "Installed")
RegistrySet (" HKEY_LOCAL_MACHINE \ SOFTWARE \ ODBC \ ODBCINST INI \ ODBC Translator ", "11.0 the Translator SQL Anywhere," RegString! , "Installed")
RegistrySet (" HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft \ Windows \ CurrentVersion \ App Paths \ dbeng11 exe ", "path", RegString! , is_app_path)
RegistrySet (" HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft \ Windows \ CurrentVersion \ App Paths \ dbeng11 exe ", "", RegString! , is_app_path + "\ \ dbeng11 DBMS exe")
RegistrySet (" HKEY_CURRENT_USER \ Software \ ODBC \ ODBC.ini \ ODBC Data Sources ", "WRM," RegString! SQL Anywhere, "11.0")
RegistrySet (" HKEY_CURRENT_USER \ Software \ ODBC \ ODBC.ini \ WRM ", "AutoStop," RegString! , "yes")
RegistrySet (" HKEY_CURRENT_USER \ Software \ ODBC \ ODBC.ini \ WRM ", "DatabaseFile", RegString! , is_app_path + "\ \ sale DBMS db")
RegistrySet (" HKEY_CURRENT_USER \ Software \ ODBC \ ODBC.ini \ WRM ", "DatabaseName", RegString! The "Sale")
RegistrySet (" HKEY_CURRENT_USER \ Software \ ODBC \ ODBC.ini \ WRM "and" Driver ", RegString! , is_app_path + "\ \ dbodbc11 DBMS DLL")
RegistrySet (" HKEY_CURRENT_USER \ Software \ ODBC \ ODBC.ini \ WRM ", "PWD", RegString! , "SQL")
RegistrySet (" HKEY_CURRENT_USER \ Software \ ODBC \ ODBC.ini \ WRM ", "Start", RegString! , is_app_path + "\ \ dbeng11 DBMS exe")
RegistrySet (" HKEY_CURRENT_USER \ Software \ ODBC \ ODBC.ini \ WRM ", "UID", RegString! , "dba")
Setprofilestring (is_app_path + '\ salesystem ini', 'SYSTEM PROFILE', 'ERGEDIT', '0')
end if

CodePudding user response:

nullnull