VB, Issue 5 after database connection

Try it this way. = "provider=;" _" data source=" + "Information. mdb; "(is the file path, and your database should be placed in the same folder as your program).

set = access 'Set the activeconnection property of rs1 to specify the database connection associated with rs1.

aduseclient 'Set the cursor type.

adopendynamic 'Set up a dynamic cursor.

select * from ziliao order by ISBN", access, 1, 3

Do you test the ** realization or do you rely on space to achieve? If it's a control, set the three properties of the control. If so, check that the database has been called correctly.

1. Configure the ODBC data source.

1. In the Control Panel, double-click the management tools and open the ODBC Data Source Manager.

2. In the System DSN tab, click Add to open the Create New Data Source dialog box, and select SQL Server in the Name list box. Select and click Done.

3. In the "Create a new data source to SQL Server" dialog box, enter the name of the new data source in the "Name" text box, and describe the data source as you understand it (optional). "Server" selects the server you want to connect to.

4. Select SQL authentication using the ID and password entered by the user.

Select the default settings for connecting to SQL statements.

5. Then the next step, the next step, finish. Just test the data source to see if the connection is successful. Press OK upon success.

2. Set the connection in VB.

1. Add the widget Mircrosoft Ado Data Control and drag the widget to the form.

2. Right-click on the ADO part to select the attributes, select Use Connection String, and press Generate.

3. Select Mircosoft OLE DB Providar for SQL Server

Press Next. 4. 1. Enter the name of the server.

2. Use the specified server information.

3. Select the database on the server.

In this case, just select the database you have built in SQL Server.

5. Test the connection to see if the connection is successful!