The LogOnServer method logs on to an SQL server, ODBC or other data source. Once logged on using this method, you will remain logged on until you call LogOffServer or until the Application Object is destroyed and craxdrt.dll is unloaded. This method can be invoked only in formatting Idle mode.SyntaxSub LogOnServer (pDllName As String, pServerName As String, [pDatabaseName], [pUserID], [pPassword])Parameters Parameter Description pDllName Specifies the name of the DLL for the server or password protected non-SQL table you want to log on to, for example "PDSODBC.DLL". Note that the dllName must be enclosed in quotes. DLL names have the following naming convention: PDB*.DLL for standard (non-SQL) databases, PDS*.DLL for SQL/ODBC databases. pServerName Specifies the log on name for the server used to create the report. For ODBC, use the data source name. This value is case-sensitive. See Res below. [pDatabaseName] Specifies the name for the database used to create the report. See Res below. [pUserID] Specifies the User ID number necessary to log on to the server. See Res below. [pPassword] Specifies the password necessary to log on to the server. ResWhen you pass an empty string ("") for this parameter, the program uses the value that's already set in the report. If you want to override a value that's already set in the report, use a non-empty string (for example, "Server A").
Crystol Report有一个ConnectionInfo类。设置当前报表实例对象的ConnectionInfo就行了。
[pDatabaseName], [pUserID], [pPassword])Parameters Parameter Description
pDllName Specifies the name of the DLL for the server or password protected non-SQL table you want to log on to, for example "PDSODBC.DLL". Note that the dllName must be enclosed in quotes. DLL names have the following naming convention: PDB*.DLL for standard (non-SQL) databases, PDS*.DLL for SQL/ODBC databases.
pServerName Specifies the log on name for the server used to create the report. For ODBC, use the data source name. This value is case-sensitive. See Res below.
[pDatabaseName] Specifies the name for the database used to create the report. See Res below.
[pUserID] Specifies the User ID number necessary to log on to the server. See Res below.
[pPassword] Specifies the password necessary to log on to the server.
ResWhen you pass an empty string ("") for this parameter, the program uses the value that's already set in the report. If you want to override a value that's already set in the report, use a non-empty string (for example, "Server A").