database connection

  • Thread starter Thread starter -00Eric Clapton
  • Start date Start date
0

-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.
 
-00Eric Clapton said:
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.
Click to expand...
Use ADO.
 
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.
 
-00Eric Clapton said:
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.
Click to expand...


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.
 
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..
 
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
 
Back
Top