Re: Connecting to SQL Server 2005

Max wrote:
Is it possible to connect to SQL Server 2005 using VB6?

Yes

If it is possible would anyone share the code?

Have you tried looking?

http://www.google.com.au/search?sourceid=navclient&aq=t&ie=UTF-8&rls=GGLG,GGLG:2006-29,GGLG:en&q=vb+sql+server+connection

There are plenty of methods out there, but it depends on what form of
connection you want. DAO? ADO? OLE? Its not just a simple piece of
code - this sort of topic is the subject of books, and perhaps an investment
in a book would be what's best for you. Go and have a look in a Technical
Bookshop or on Amazon.

Sorry to be so negative, but it is a rather big topic. If you have a
specific question, then feel free to ask, but for such a broad question...


--
Regards,

Michael Cole


.

Relevant Pages

  • Databases - DAO and ADO
    ... A couple programmers here suggested that I use a database instead and SQL to ... For example, there is talk of using Jet, data controls, DAO or ADO, etc. ... Because most of the books on VB6 are old now, ...
    (microsoft.public.vb.general.discussion)
  • Re: Module / Class to access database
    ... Rather than using ADO and DAO components. ... >>> ADO data object libraries do exactly what you are requesting. ... When it came down to our nifty OLE DB ...
    (microsoft.public.vb.database)
  • Re: Favorisierter Zugriff auf Access DB
    ... > Wenn du schon mit DAO gearbeitet hast sollte dir die Umstellung auf ADO ... ähm bei welchem Typ muss ich mich mit den Variant Typen herumschlagen? ... OLE oder? ... Ich nehme an, den Klassenassi zum Erstellen von "RecordSet" Klassen (wie bei ODBC, DAO) kann ich nicht nutzen. ...
    (microsoft.public.de.vc)
  • Re: Word Form Fields - Can you Export to Excel Spreadsheet?
    ... supply an "OLE DB provider". ... The other possibility is a DAO connection. ... with Excel than ADO, IMO. ...
    (microsoft.public.word.docmanagement)
  • Microsoft database technologies
    ... And what are all the DB programming paradigms available? ... Like DAO, ADO and OLE DB. ...
    (microsoft.public.data.oledb)