Open event program are as follows:

The SQLCA. DBMS="ODBC"
The SQLCA. Dbparm="Connectstring='DSN=Yhxx'"
Connect USING the SQLCA;
If the SQLCA. SQLCode<> 0 then
Messagebox (" database connection failure ", "cannot connect to the database ~ n tip:" + sqlca. Sqlerrtext)
The ELSE
Open (yhdl)
End the if

In the absence of database support computer running on the error message shown

Copied to the computer files on the diagram below

Beg you give a specific solution and steps, thank you

CodePudding user response:

Specified in your application to connect to the database, how to avoid?

CodePudding user response:

Successful GongJian an odbc data source called yhxx
Using a registry function or pb program automatically build a data source. The program self-built takes some skill: you have to know to write what content, can build a hand built before a registry, built by hand after a guide, and then himself than where the registry changes

If the two methods are not very familiar with, the ultimate solution is: using ms SQL database, use the oledb driver, because, this drive with the Windows operating system, happy

CodePudding user response:

The need to establish a data source and database driver, find the registry

CodePudding user response:

refer to the second floor SBKS response:

get GongJian an odbc data source called yhxx
Using a registry function or pb program automatically build a data source. The program self-built takes some skill: you have to know to write what content, can build a hand built before a registry, built by hand after a guide, and then himself than where the registry changes

If of these two methods are not very familiar with, the ultimate solution is: using ms SQL database, use the oledb driver, because, this drive with the Windows operating system, happy

can I use the pb own 11 built the database SQL anywhere, how to do this?

CodePudding user response:

reference jjanus reply: 3/f

the first to establish a data source and database driven, let's search the registry

I'm sorry, I just started, could you please tell me how to establish a data source and data driven? And where to find the registry?

CodePudding user response:

I tried before but since the registered ODBC:

CodePudding user response:

If registryset (" HKEY_CURRENT_USER \ SOFTWARE \ ODBC \ ODBC.ini \ ODBC DATA SOURCES ", "gs", regstring! Sybase SQL anywhere, "5.0")=1 then
Messagebox (" ", "ok")
End the if

CodePudding user response:

refer to 7th floor FrankLiang response:

if registryset (" HKEY_CURRENT_USER \ SOFTWARE \ ODBC \ ODBC.ini \ ODBC DATA SOURCES ", "gs", regstring! Sybase SQL anywhere, "5.0")=1 then
Messagebox (" ", "ok")
End the if

what do you mean? The code to write in where? It is ok to write the code?

CodePudding user response:

Create the ODBC data source is not so simple things, has both 32-bit and 64 - bit Windows, different databases have different clients, recommended to download regular database client, otherwise the application may have a lot of problems,

CodePudding user response:

I recently used a PB oracle database connection (2) a web server, a server can also access speed, another server access speed is very slow, also don't know the reason,

CodePudding user response:

Suggest using a dedicated interface