[Webinar] Streamline your web hosting managementRegister Today


SQL Server connection

Posted on 1999-11-23
Medium Priority
Last Modified: 2013-11-23
Can anyone suggest a good set of components that will allow me to connect to SQL Server without using the BDE or ODBC ? I have tried SQLQuery and find that I have reliabiltiy issues.

Question by:MarciusP
  • 2
  • 2
  • 2
  • +1

Expert Comment

ID: 2230307
 Perhaps you can use "ADO"+"OLEDB" to do this.
  You Create a connection string with ADO and OLEDB for SQLServer.

Expert Comment

ID: 2232324
I also suggest ADO&OLEDB
We are thinking about converting all our applications because the BDE smells like (Edited by Copmuter101):)
We don't wanna use 3rd party components because we think you will always encounter problems.
Good luck

Author Comment

ID: 2232762
Hmm... Can either of you provide me some information about how to implement your suggestions?
[Webinar] Improve your customer journey

A positive customer journey is important in attracting and retaining business. To improve this experience, you can use Google Maps APIs to increase checkout conversions, boost user engagement, and optimize order fulfillment. Learn how in this webinar presented by Dito.


Expert Comment

ID: 2233113
Has you have a D5?
If this ,you can use the ADO compenent from compenent Page "ADO" .And D5 have some demo with this.I didn't know how to finish this if you have no D5.

Expert Comment

ID: 2235041
Diamond ADO is a good solution or use the ADO typelib directly

Author Comment

ID: 2242040
Could you provide more information about implementing this solution? Also, what are the performance implications of using ADO (which I believe sits ontop of ODBC) ?

Accepted Solution

accman99 earned 200 total points
ID: 2242106
I find Diamond ADO performs well with
SQL 7.0, it's native interface is through OLEDB so ODBC DSN's are not required. Also many update issues are fixed i.e. updating members of joined queries.

Performance is not quite as good with 6.5 though.

With careful selection of cursor locations and types I find that ADO "can" outperform ODBC. Though that may not always be the case when using default values. Other considerations are the selection of cache sizes (rowset counts) and use of multi-record databound controls (grids).

I do recommend it.


Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Objective: - This article will help user in how to convert their numeric value become words. How to use 1. You can copy this code in your Unit as function 2. than you can perform your function by type this code The Code   (CODE) The Im…
Hello everybody This Article will show you how to validate number with TEdit control, What's the TEdit control? TEdit is a standard Windows edit control on a form, it allows to user to write, read and copy/paste single line of text. Usua…
The Relationships Diagram is a good way to get an overall view of what a database is keeping track of. It is also where relationships are defined. A relationship specifies how two tables connect to each other. As you build tables in Microsoft Ac…
Hi, this video explains a free download that you can incorporate into your Access databases, or use stand-alone for contact management. Contacts -- Names, Addresses, Phone Numbers, eMail Addresses, Websites, Lists, Projects, Notes, Attachments…
Suggested Courses
Course of the Month7 days, 23 hours left to enroll

607 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question