Using ADO/SQLServer for MDI application

Hi,

I am just starting a new project using Delphi 7 and SQL Server 2005. Up until now I have been using paradox as my db in SDI applications. Can anybody suggest a good book to get me started, and any other information resources that may be available? 

Maggie
0
Maggie
10/1/2008 12:47:17 AM
embarcadero.delphi.ado 597 articles. 1 followers. Follow

1 Replies
521 Views

Similar Articles

[PageSpeed] 29

Maggie Clark wrote:
> Hi,
> 
> I am just starting a new project using Delphi 7 and SQL Server 2005. Up until now I have been using paradox as my db in SDI applications. Can anybody suggest a good book to get me started, and any other information resources that may be available? 
> 
> Maggie


Hi Maggie,

I found the database section in Marco Cantu's mastering Delphi 7 was 
quite useful, you could do a web search for delphi pages like 
Delphi3000.com and the about.com delphi pages

best regards

Richard
0
Richard
10/3/2008 3:50:02 PM
Reply:

Similar Artilces:

ASA7 ADO & Delphi ADO ?? Anyone is using it?
Any comments? Is it working? Any Problems? Thanks Hi, PR <noemail@no.com> schrieb in im Newsbeitrag: BoTThJaq$GA.89@forums.sybase.com... > Any comments? Is it working? Any Problems? I tried to connect to ASA7 via the new OLE DB - Provider and ADOExpress from Delphi 5.01. No chance. Only the error message 'Invalid Enum Value'. About the new provider I haven't heard anything good until now... Regards Frank Frank, I've experienced the same problem with the ASA 7 OLEDB Provider. I'm not sure if this is a bug in the AsaProvider or Delp...

Convert Delphi 5 ADO App to Delphi 2007 ADO.NET
I have an appliction tha that is writen in Delphi 5 with ADOConnetion, ADOTable, and ADOQuery components. I need to upgrade to Delphi 2007 and use ADO.NET. I have the program building in with Delphi 2007. Is there anything I need to do to convert the ADO to ADO.NET? > I need to upgrade to Delphi 2007 and use ADO.NET. Why ? -- With best regards, Dmitry Arefiev AnyDAC (www.anydac.com) - Oracle, MS SQL Server, IBM DB2, MySQL, Firebird, Interbase, PostgreSQL, Sybase ASA, SQLite, MS Access, DBX, ODBC, InMem - universal high-speed native data access engine Reasons for ...

ADO to ADO.NET
I'm an ASP programmer (VBScript) moving on to ASP.NET. So far I'm using:Microsoft Visual Studio 2003ASP.NET with C#I'm working on converting my code over to C#, from VBScript. Now, here is my code in VBScript (modified to better understand it, this is a edited ugly version):Function ExecuteSQL(sqlStatement)    ConnDriver = "Provider=SQLOLEDB; Data Source = " & dbIP & "; Initial Catalog = " & dbName & "; User Id = " & dbUser & "; Password=" & dbPassword     Set connTemp = Server.CreateObject("ADODB.Connection")    c...

What are the diff. ADO and ADO.NET and which is use full and easy ?
What are the diff. ADO and ADO.NET and which is use full and easy ? You use ADO with ASP and ADO.NET with ASP.NET. Both are useful in their own environments and can get the job done. Both can be easy or difficult, it depends on your background, training, available resources, and a host of other factors. There are lots and lots of articles on the net on this topic. Search Google for: ADO "ADO.NET" comparison E.g. MSDN article Comparison of ADO.NET and ADO DevArticles article A Practical Comparison of ADO and ADO.NET TerriTerri MortonEngagement Manager, Neud...

ADO not ADO.NET
Hi, I have to connect to a db using adodb (which i select from the references). I have to retrieve the car models from the database and bind them to a listbox. I am not sure how to proceed and I can't find any articles on ADO with .net and data binding. Here is the code that i tried but it only retrieves the car model for the specified id. If I delete the id it doesn't work. Also it writes the car model in the listbox vertically such as: B M W CODE: Imports System.Data Imports ADODB Imports System.Data.OleDb Public Class listboxADO Inherits System.Web.UI...

We Need ADO Wrapper Class Methods using Ado.net
We Need clue / suggesion for writing the ADO Wrapper Class Methods below using Ado.netAny one example for any method will help1) getBookmark()2) setBookmark(currentBM)3) Delete ()4) close ()5) getStatus()6) getDataSource()7) DataMember()8) Update(Fields,Values)9) ActiveConnection()Thanks in Advance. You don't say what language you are using (VB or C#), but all you have to do is to create a Function or method and put your ADO.NET code in it.For example, Delete() will obviously have to take a parameter, such as an integer, or array of integers, and the code within it will loop through t...

Deploying Delphi software which uses ADO
Hi what needs to deployed and provided by Installaware type packages to get Delphi-based programs that use ADO to install on Windows 7 32 bit and 64 bit computers? When Googling for stuff I keep getting older information plus some comments that the Jet Engine is no longer fully supported for Windows 7 environments. Suggestions or links to good descriptions would be appreciated. Bruce On 2012-09-19 16:13:51, Bruce Eglington wrote: > what needs to deployed and provided by Installaware type packages > to get Delphi-based programs that use ADO to install on Windows 7 32...

Help TeamSybase: Cannot use ASA with Delphi via ADO
Hello, I just installed ASA 60 days trial and I am testing with Delphi 6 and ADO, using TADODataset components. I am getting the following problems: when I post any record, trailing blanks are inserted in every TStringField (VARCHAR in ASA). When I post records with TMemoField or TBlobField (LONG VARCHAR), it raises a "Count field incorrect". I did't see this behaviour in other servers. Regards, Frank What are the version and build number of your server? Are you using the sample database or a database you created? If you created it, did you use the BLANK...

Warning for those using Cursors in Microsoft SqlServer with ODBC or ADO
Hi all Just thought I'd let you know about a gotcha when using ODBC (and ADO I think) to connect to Microsoft Sqlserver. I now highly recommend having: SET NOCOUNT ON as the first statement in all your stored procedures. I had a cursor inside a stored procedure that ran correctly from isqlw but would not run correctly when called from ODBC. I thought the problem may be something to do with DBI but thankfully it is not. Unfortunately DBI does not pick up the error message (if any ) that is generated. The Cursor would fail after a fixed number of rows , any changes to the...

Oracle NCLOB data getting truncated when using delphi ADO
I am using Delphi2007 and using ADO for data access. When trying to select nclob data from an Oracle database it generally works, but I have one query that is consitantly truncating the data at 12 characters. I have already been in touch with Oracle and they have confirmed that the OLEDB provider that is being used is correctly returning the data. Here is the query select ACT_KEY, COALESCE((SELECT LTX_TEXT FROM TEXT_TABLE WHERE LTX_TABLE='SOURCE_TABLE' AND LTX_TEXT_ID = 'ACT_DESC' AND LTX_TABLE_KEY = CAST(SOURCE_TABLE.ACT_KEY AS NVARCHAR2(10))),TO_NCLOB(ACT_DESC)) as A...

Opinions about ADO and ADO.NET
Hi everyone again!!! I´m used to develope applications with ADO, but now with .NET to develope a Web Application and a Mobile Web Application, I don't know if I have to use ADO.NET or continue using ADO. What Disadvantages has ADO to built Mobile Applications? In ADO I use ACCESS to create the .mdb files, Can I use .mdb files with ADO.NET? Thanks for all!! Go to ADO.NET NOW ! don't be late and you can use access in ado.net ADO.NET VB.NET/C#/ASP.NET/Oracle Designer 6i DotNet4Arab.com Building a custom web control(vb.net) Well, Thanks for your opinion, but I have...

ADO.NET VS ADO
Hi I am having ADO.NET course these days. I asked the instructor that developing online system like airline reservation system needs to a connected environment to lock/Unlock the table when u read/write to it Can that be acomplished using ado.net. His answer was no ADO.NET is only for disconnected environment and it will not work with online system and i still should use the old ADO. ADO.NET is not a replacment for ADO and both will continue in paralell. IS his answer true that ADO.NET will not replace ADO and both will continue Regards Check this link. Well ADO.NET is pa...

Converting ADO to ADO.NET
Hi, I am trying to convert this code from ADO to ADO.NET I am very new to ADO.NET and am a bit confused on how I would convert this. Basically what I am trying to do is capture the name of the fields of a table to populate a dropdownlistbox. The table name will change every time the program is run. This is not a problem and I can code for that. Here is what I have in ADO (I have tried the wizard but it did not change the code) Dim tblFields As Object Dim myRst As New ADODB.Recordset Dim myField As ADODB.Field Dim myCnn As New ADODB.C...

Help TeamSybase: Cannot use ASA with Delphi via ADO #2
Hello, I just installed ASA 60 days trial and I am testing with Delphi 6 and ADO, using TADODataset components. I am getting the following problems: when I post any record, trailing blanks are inserted in every TStringField (VARCHAR in ASA). When I post records with TMemoField or TBlobField (LONG VARCHAR), it raises a "Count field incorrect". I did't see this behaviour in other servers. Regards, Frank ...

Web resources about - Using ADO/SQLServer for MDI application - embarcadero.delphi.ado

Application - Wikipedia, the free encyclopedia
Text is available under the Creative Commons Attribution-ShareAlike License ;additional terms may apply. By using this site, you agree to the ...

Pre-Christmas job application rush hits Australian public service
Speed required for pre-Christmas job window opening for public servants. Check out who is hiring.

Cloud application adoption increases 71 percent in 2015
The adoption of cloud applications is soaring, up by 71 percent in the last year according to the results of a new survey. The latest Cloud ...

NASA is accepting astronaut applications, and this quiz will tell you if you qualify
... gone before, then you might want to sign up to be a NASA astronaut. On Dec. 14, for the first time in four years, NASA began accepting applications. ...

MBA: Mortgage Applications Decrease in Latest MBA Weekly Survey, Purchase Applications up 34% YoY
From the MBA: Mortgage Applications Decrease in Latest MBA Weekly Survey Mortgage applications decreased 1.1 percent from one week earlier, ...

German-Based Spirea Promotes Decentralized PV Applications In Uruguay
... Its technical operations specialist, Laurie Lawrence, pointed out that Uruguay [&hellip German-Based Spirea Promotes Decentralized PV Applications ...

SMIC and M31 introduce differentiated IP solutions for storage controller applications
China-based IC foundry Semiconductor Manufacturing International (SMIC) has announced the company will expand its IP portfolio with M31 Technology's ...

Pre-K Applications Begin Jan 25, a Month Earlier Than Last Year, City Says
The DOE has moved the process up to Jan. 25 on the heels of a similar schedule shift for kindergarten. MANHATTAN — The application period for ...

NASA accepting applications for the position of 'astronaut'
Wanted ads aren't usually newsworthy, unless the company is NASA and the job is "going to space." The US space agency has started recruiting ...

Apple Patent Application Hints at Waterproof iPhone
The patent application describes special rubber ports over headphone and other openings to protect them from water coming in.

Resources last updated: 12/22/2015 8:41:20 PM