How the Connect properties work, see the documentation for this class. If the current DSN does not have a valid DatabaseName value, calls to the OpenConnection will cause the ODBCĭriver to display a dialog, prompting for the information, unless the Prompt property has been set to rdDriverNoPrompt. If you don't specify a value for this property, the DatabaseName specified by the current DSN (specified by theĬonnectDSN property) will be used. Before calling the OpenConnection method, set this property to the name of the remoteĭatabase you want to connect to. When the class is initialized, this property has no value. This property represents the name of the remote database. Get the database name in use by the current remote connection.
RDO version 2.0 is the final version of this technology.ĭeclarations and private variables for the CRDOConnection class. RDO wasĭesigned specifically to access remote ODBC relational data sources, and made it easier to use ODBC without complex application code.
#Vb6 sql server connection string example 32 bit
Note that this code is not supported in the 64-bit version of Access 2010 or 2013 due to the use of the 32 bit library MSRDO20.DLL. This class was designed and tested against an ODBC connection using Microsoft SQL Server. See the other classes in the Database category. This class exposes functionality to use RDO against ODBC data sources. Remote Data Control, or program directly against the API.
You can use DAO and Jet, DAO and ODBC Direct, RDO and the When using Visual Basic to deploy client/server applications, you have a variety of development choices. Class: RDOConnection in Category SQL Server : SQL Server from Total Visual SourceBook Class to support client/server operations using the Remote Data Access to set up an ODBC connection to a data source using VB6 and VBA.
0 kommentar(er)
