做了一个非常小的例子
这是Remote data module form:
object wangs: Twangs
OldCreateOrder = False
Left = 310
Top = 209
Height = 150
Width = 215
object Query1: TQuery
Active = True
DatabaseName = 'mydatabase'
SQL.Strings = (
'SELECT BmBh, BmMc, BmZg'
'FROM gsbm Gsbm')
Left = 24
Top = 8
end
object Table1: TTable
Active = True
DatabaseName = 'mydatabase'
TableName = 'gscl'
Left = 64
Top = 8
end
object DCOMConnection1: TDCOMConnection
Left = 104
Top = 8
end
object CorbaConnection1: TCorbaConnection
Left = 144
Top = 8
end
object SocketConnection1: TSocketConnection
Left = 24
Top = 56
end
object DataSetProvider1: TDataSetProvider
DataSet = Table1
Left = 72
Top = 56
end
object DataSetProvider2: TDataSetProvider
DataSet = Query1
Left = 120
Top = 56
end
end
这是单元文件:
unit Unit2;
interface
uses
Windows, Messages, SysUtils, Classes, Graphics, Controls, Forms, Dialogs,
ComServ, ComObj, VCLCom, StdVcl, BdeProv, DataBkr, DBClient, Project2_TLB,
Db, DBTables, MConnect, MidasCon, Provider, SConnect, CorbaCon;
type
Twangs = class(TRemoteDataModule, Iwangs)
Query1: TQuery;
Table1: TTable;
DCOMConnection1: TDCOMConnection;
CorbaConnection1: TCorbaConnection;
SocketConnection1: TSocketConnection;
DataSetProvider1: TDataSetProvider;
DataSetProvider2: TDataSetProvider;
private
{ Private declarations }
public
{ Public declarations }
end;
var
wangs: Twangs;
implementation
uses pdm;
{$R *.DFM}
initialization
TComponentFactory.Create(ComServer, Twangs,
Class_wangs, ciMultiInstance, tmApartment);
end.
这是普通data module的form:
object DataModule3: TDataModule3
OldCreateOrder = False
Left = 436
Top = 111
Height = 150
Width = 215
object Database1: TDatabase
Connected = True
DatabaseName = 'mydatabase'
DriverName = 'MSSQL'
Params.Strings = (
'DATABASE NAME=cores'
'SERVER NAME=msvr'
'OPEN MODE=READ/WRITE'
'SCHEMA CACHE SIZE=8'
'BLOB EDIT LOGGING='
'LANGDRIVER=china'
'SQLQRYMODE='
'SQLPASSTHRU MODE=SHARED AUTOCOMMIT'
'DATE MODE=0'
'SCHEMA CACHE TIME=-1'
'MAX QUERY TIME=300'
'MAX ROWS=-1'
'BATCH COUNT=200'
'ENABLE SCHEMA CACHE=FALSE'
'SCHEMA CACHE DIR='
'HOST NAME=MSVR'
'APPLICATION NAME='
'NATIONAL LANG NAME='
'ENABLE BCD=FALSE'
'TDS PACKET SIZE=4096'
'BLOBS TO CACHE=64'
'BLOB SIZE=32'
'PASSWORD=')
SessionName = 'Default'
Left = 40
Top = 16
end
end
这是其单元文件:
unit pdm;
interface
uses
Windows, Messages, SysUtils, Classes, Graphics, Controls, Forms, Dialogs,
DBTables;
type
TDataModule3 = class(TDataModule)
Database1: TDatabase;
private
{ Private declarations }
public
{ Public declarations }
end;
var
DataModule3: TDataModule3;
implementation
{$R *.DFM}
end.
上面的所有东西是自动生成的
在数据集databasename选择是在下拉框内可以直接选择。
我估计你的database控件的databasename是不是没有设置?
我的数据库连SQL 7.0 数据库,数据库名字cores.
希望对你有所帮助。