Hey can anyone help me with vb6 and sql server 2008 connection

Question

hi im trying to learn the connection between vb6 as frontend and sql as backend . can anyone help me with the code and its working ? i would love to start with the preparation of a simple login page for starters

Answer 1

VB6? I might be able to give you some tips. ADO and ODBC are what you need. From the File... Project menu click the References tab and add a Reference to include ADO (ActiveX Data Objects). In order to do that, it might require Enterprise Edition, though I am uncertain about that. Let me know if you are able to get even that far. If it works then in the controls Toolbox you will see the ADO controls that you can add to your form.

Also see this similar post that I just responded to.
https://www.sololearn.com/Discuss/565482/?ref=app

Alternatively, you can use MS Access as a front end to SQL Server. It is easier than VB6 to connect Access to SQL Server and link tables. Then you have a powerful set of tools to make Queries and table forms, and there is integrated programming support in Access VBA.