Delphi 7 and SQL Server 2005 - what is the best method to connect...

[topcat01]

Hi,

I have searched the forum but cannot find an answer. I have D7, D6pro and SQL Server 2005. What method would you recommend overall for database connection & access?

I have done db software dev many years ago and remembered spending a great deal of time learning the methods not to use (would like to avoid again if possible). I've been told ADO? Time has passed and I'm sure techniques will have changed...

Any pointers, advice, limitations I would be very grateful for your help.

Thank you

 

[whosrdaddy]

ADO is still the way to go.

I have apps that support ms Access, SQL server and MySQL as a possible database backend, all possible through the ADO components.

/Daddy

-----------------------------------------------------
What You See Is What You Get
Never underestimate tha powah of tha google!

 

[topcat01]

Thanks, I'm glad you said that

 

[Opieo]

Amen to that.
I am a large fan of the ADO.
The little database app that I have built for the business here used Access to start with, while it was small.
Now that it has grown so that the database is being used by more than 4 people, it will be moved to SQL Server here very shortly.
The actual company database guy who already has tools that will automate the data moving ran a test with me and the only thing I need to change in the whole program is the table creation process.
Other than that all ADO connections and operations are exactly the same without me changing a thing (other than of course the connection string's target).
I love it.

~
“Your request is not unlike your lower intestine: stinky, and loaded with danger.” — Ace Ventura.