Member Avatar for kehar

Hi,
I would like to replace the ACCESS with SQL Server 2000 enterprise edition. But I have the following problems:
1. While installing SQL should I install as Server or Client.
2. How to connect the SQL with VB 6 for saving,retrieving, modifying data using ADODB connectivity.

Pl help me in detail.

(Kehar Singh)

  • 2 Contributors
  • 1 Reply
  • 107 Views
  • 7 Hours Discussion Span
  • Latest Post Latest Post by vb5prgrmr
Member Avatar for vb5prgrmr

If you want to use SQL "Server" as you back end for a VB6 "Client" then....

You need to install the server

As for connection strings

http://www.connectionstrings.com/

Good Luck

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.