The default packet size is set at the server, and is 4K. ' Applications running against SQL Server 6.0 or 6.5 can sometimes improve their performance by resetting the TDS network packet size. (Doing so will prevent completion of connection protocol handshaking procedure.) ' MS Note Do not enable the Force Protocol Encryption option on both the client and the SVR. Private Function connection_string(db_servername As String, db_databasename As String, db_username As String, db_password As String, Optional odbc_drivername As String = "SQL Server") As String Private Const DBCONNECTION_PASSWORD As String = "" Private Const DBCONNECTION_USERNAME As String = "" Public Const DBCONNECTION_DATABASE As String = "" Public Const DBCONNECTION_SERVER As String = "\" I've shared some code here that might be useful to you (code has been tested with Access 2007):
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |