![]() ![]() If CBool(conn.State And adStateOpen) Then conn. Execute recordsAffected 'Includes a return parameter to capture the number of records affectedÄebug.Print recordsAffected 'Check whether any records were inserted SConnString = "Provider=sqloledb Server=LAPTOPX Database=HomeSQL Trusted_Connection=True " Provider=SQLNCLI10 Server=myServerName\theInstanceName Database=myDataBase The syntax of specifying the server instance in the value of the server key is the same for all connection strings for SQL Server. Through this connection, you can access and manipulate a database. Trusted connection Provider=SQLNCLI10 Server=myServerAddress Database=myDataBase The ADO Connection Object is used to create an open connection to a data source. Standard security Provider=SQLNCLI10 Server=myServerAddress Database=myDataBase Uid=myUsername First, you need to make sure SQL Native Client is instaled. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |