database connection

[-00Eric Clapton]

Dear All,

I used to connect to SQL server using ADO in vb6 few years ago.
Can anyone please tell me what is the most stable and efficient method to
connect to SQL server with VB nowadays? Thanks.

 

[Robert Berman]

Dear All,

I used to connect to SQL server using ADO in vb6 few years ago.
Can anyone please tell me what is the most stable and efficient method to
connect to SQL server with VB nowadays? Thanks.

Use ADO.

 

[-00Eric Clapton]

I forget the code. Can you please give me some sample of the connection to
SQL server and how to read and modify a table? Thanks.

 

[Veign]

ADO Connection Strings (Carl Prothman):
http://www.carlprothman.net/Default.aspx?tabid=81

Connection Strings:
http://www.connectionstrings.com


--
Chris Hanscom - Microsoft MVP (VB)
Veign's Resource Center
http://www.veign.com/vrc_main.asp
Veign's Blog
http://www.veign.com/blog

 

[Joe O]

Check
http://www.connectionstrings.com/

or
http://www.carlprothman.net/Default.aspx?tabid=81

 

[MikeD]

Dear All,

I used to connect to SQL server using ADO in vb6 few years ago.
Can anyone please tell me what is the most stable and efficient method to
connect to SQL server with VB nowadays? Thanks.

Same as it was a few years ago. <g> It hasn't changed, provided you're
using the same technologies today as you were a few years ago. Why did you
post this to a "dotnet" newsgroup, BTW? Are you using .NET now rather than
VB6? Even office.developer.vba is non-relevant.

 

[jack]

well the method is the same. but may be learning from vb dot net may
help you in understanding the new idea which method should be chosen i
chose disconnected and xml in this case to avoid direct interaction
with database..

 

[Cor Ligthert [MVP]]

Eric,

With VB Net the most stable method for SQL server is the SQLClient as part
of ADONET.

As I have understand is one of the reasons the disconnected approach from
AdoNet is a change on instability in hugh Databases with Ado.

The connectionstring sites you got are as well the ones for ADONET

The newsgroup for that is

microsoft.public.dotnet.framework.adonet

I hope this helps,

Cor