10.9 automatically register DSN and Create Table
When writing your own database applications, readers will soon encounter two headaches. First, you must manually register the DSN (Data Source Name) in the ODBC manager before accessing the ODBC data
64-bit Machine ODBC operation method and 32-bit machine is not the same, if directly from the Control Panel-Administrator tool-ODBC into the user DSN and the System DSN is empty, add when even ODBC driver can not be found, the correct method should
The Windows DSN File (data source name) is used to store database connection information. If you have a lot of webpages that need to transmit data, you can simply use the DNS file path without transmitting data to each page.
For security reasons,
Odbc
ODBC File DSN's little secret
1. Use the attached WordPad text editor to create a suffix named. The file for the DSN, formatted as follows, and then saved in text format:
Note: The format is important and must be saved as ' text format ',
Premise:(1) Create a new controller file named connect.php under the App\index\controller file(2) Create a database named User_curd, which has a user table with the following table: Connect to a database with global configuration ( recommended )1.
First, prefaceWe may encounter this need at work: Query the information in the database and export the results to an Excel file. This would have been nothing, but when the amount of data is large, using Plsql, Toad Export Excel will be out of memory,
This problem occurs when you use ASP to connect to the MySQL database.One afternoon, it was an ODBC data source problem.Record it:Cause of error: The 64-bit system uses 32-bit ODBC.Workaround: Use 64-bit ODBC for no problem.32-bit ODBC in the
Data | database | statement
When using ASP to manipulate the database, many people use the recordset, but I feel better with the SQL statement, so I wrote this article, I hope it will help you.
''''''''''''''''''''''''''''''''''''''''''''''''''''''''
The company's old CRM system is based on FLEAPHP, which is not updated for a long time. When php is upgraded to 5.5, the system will prompt that the mysql_connect function is about to be discarded. It is recommended to change to mysqli or pdo, does
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.