OK - well, give us the details of the error you're getting OR please be specific about what question you're asking. That'll help all of us to know what information to give you or lead you toward.XFX nForce 680i LT SLI Socket 775 | Intel Core 2 Duo E6750 OC:1600 FSB @ 3.2 MHz | 2 x OCZ SLI 1024MB PC6400 DDR2 800MHz| XION 600w PSU | CM Stacker 200 ATX/BTX Case | EVGA GeForce 8800 GTS 512 | WD SATA 74 GB Raptor (boot,system), WD SATA 500 GB (storage) | Windows XP Pro, SP2 | Patient and supportive significant other
To: [EMAIL PROTECTED]: [EMAIL PROTECTED]: Tue, 6 May 2008 01:35:47 +0000Subject: [advanced_delphi] Re: Building the installation module is no joke Thanks for the detailed posting. I notice a couple of things different from what I was doing. I was building the connection string without actually reproducing the exact string from the ADOConnection wizard. I do the connect to the database from a button click event not from form activate. I'll try another build with these changes. Here is the code that I use to connect to the database *********************************************************************procedure TFPicWord.ConnectTheDatabase;varconnectionstr, filepathstr, otherinfostr, providerstr, dbpathstr, sqlstr : string;begindbpathstr := 'TFESpeechDatabase\db_speech2.mdb';providerstr := 'Provider=Microsoft.Jet.OLEDB.4.0;Data Source=';filepathstr := ExtractFilePath(Application.ExeName) + dbpathstr;otherinfostr := ';Persist Security Info=False';connectionstr := providerstr + filepathstr + otherinfostr;FPicWord.ADOConnection1.ConnectionString := connectionstr;sqlstr := 'SELECT * FROM Table1';FPicWord.ADOQuery_ALL.SQL.Add(sqlstr);FPicWord.ADOQuery_ALL.Fields.Create(FPicWord.ADODataSet2);FPicWord.ADODataSet1.CommandText := 'SELECT * FROM Table1';FPicWord.ADOTable1.Fields.Create(FPicWord.ADODataset1);FPicWord.BTN_FillGrid.Enabled := false;end;procedure TFPicWord.BTN_FillGridClick(Sender: TObject);beginFPicWord.EnableAllButtons;FPicWord.ConnectTheDatabase;FPicWord.FillGrid;end;********************************************************************RegardsAnu Ranghttp://totallyfreeenergy.freehoxt.com--- In advanced_delphi@yahoogroups.com, Sean Roberts <[EMAIL PROTECTED]> wrote:>> I had to do this exact thing recently, Anu.> > I keep a text file called ADOConnectionString.txt in the same folder as my data.> > I could just as easily just have the entire connection string embedded in my app.> _________________________________________________________________ Windows Live SkyDrive lets you share files with faraway friends. http://www.windowslive.com/skydrive/overview.html?ocid=TXT_TAGLM_WL_Refresh_skydrive_052008
