sql server connect: For some reason i want to use visual c++ 6.0 , and i need to connect to sql
server! (most probably 2005)

can this be done? if yes please provide me with a sample on how to connect
(e.g. how to create connection, data adapter , data set.... , the whole deal)

thank you in advance, i really appreciate it.

by the way, in an unrelated matter, is visual c++ 6.0 faster than visual c++
8 (.net 2005)?

Regards,

Since you are using VC6 you are not going to have a DataSet and DataAdapter
since these are managed code concepts; you can use one of three options:

ODBC
OLE-DB
ADO (using the SQL Server OLE DB provider)

Depending on what you want to do and what you feel comfortable with you can
use one of these to connect to SQL Server, including SQL Server 2005. On
http://msdn.microsoft.com you will find samples for each of these
technologies to use with SQL Server.

I have no idea if VC 6.0 is faster then VC 2005 (8.0), in general the
compilers get faster because of better optimization, however they also stuff
more stuff in libraries, so it depends on what you use. Plain C/C++ my guess
will be faster.

GertD@SQLDev.Net

[quoted text, click to view]