Y yedixifeng Unregistered / Unconfirmed GUEST, unregistred user! 2007-12-04 #1 做了一个软件，用的是access，开始运行得不错，但随着数据添加越来越多，运行十分缓慢。现在想改变用sql，需要在哪些地方注意，怎样修改连接数据库代码等。谢谢。
A andrew57 Unregistered / Unconfirmed GUEST, unregistred user! 2007-12-04 #2 把access导入mssql里面，改变下驱动方式就行了
Y yedixifeng Unregistered / Unconfirmed GUEST, unregistred user! 2007-12-04 #3 谢谢。我用的是sql2000企业版。导入后，要在程序就是连接数据库的文件上如何写代码呢？
L lovenj2008 Unregistered / Unconfirmed GUEST, unregistred user! 2007-12-04 #4 adoconnectionpacs.Connected := false; adoconnectionpacs.ConnectionString :='FILE NAME='+Extractfilepath(application.exename)+'config/nlpacsdbc.udl'; adoconnectionpacs.Connected := true; 用外部ＵＤＬ连接
adoconnectionpacs.Connected := false; adoconnectionpacs.ConnectionString :='FILE NAME='+Extractfilepath(application.exename)+'config/nlpacsdbc.udl'; adoconnectionpacs.Connected := true; 用外部ＵＤＬ连接
L lovenj2008 Unregistered / Unconfirmed GUEST, unregistred user! 2007-12-04 #5 或者将adoconnectionpacs.ConnectionString ＝'Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=health_GB;Data Source=192.168.0.187'
或者将adoconnectionpacs.ConnectionString ＝'Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=health_GB;Data Source=192.168.0.187'
Y yedixifeng Unregistered / Unconfirmed GUEST, unregistred user! 2007-12-06 #6 procedure TDM.DataModuleCreate(Sender: TObject); var flnm:string; begin cnn.Connected := false; cnn.ConnectionString :='FILE NAME='+Extractfilepath(application.exename)+'ABC.udl'; cnn.Connected := true; end; 运行时，光标总是停在application后，说有致命错误。 请高手指点，谢谢。
procedure TDM.DataModuleCreate(Sender: TObject); var flnm:string; begin cnn.Connected := false; cnn.ConnectionString :='FILE NAME='+Extractfilepath(application.exename)+'ABC.udl'; cnn.Connected := true; end; 运行时，光标总是停在application后，说有致命错误。 请高手指点，谢谢。
