database connection - Visual Basic .NET

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

Nov 21 '05 #1

Subscribe Post Reply

1881

Robert Berman

" -00Eric Clapton" <a@b.com> wrote in message
news:uz*************@TK2MSFTNGP10.phx.gbl...

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.

Nov 21 '05 #2

-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.
"Robert Berman" <Be******@NOSPAM.earthlink.net> wrote in message
news:zD*****************@newsread1.news.pas.earthl ink.net...

" -00Eric Clapton" <a@b.com> wrote in message
news:uz*************@TK2MSFTNGP10.phx.gbl...
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.

Nov 21 '05 #3

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
--
" -00Eric Clapton" <a@b.com> wrote in message
news:Oi*************@tk2msftngp13.phx.gbl...

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.
"Robert Berman" <Be******@NOSPAM.earthlink.net> wrote in message
news:zD*****************@newsread1.news.pas.earthl ink.net...

" -00Eric Clapton" <a@b.com> wrote in message
news:uz*************@TK2MSFTNGP10.phx.gbl...
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.

Nov 21 '05 #4

Joe O

Check
http://www.connectionstrings.com/

or
http://www.carlprothman.net/Default.aspx?tabid=81
" -00Eric Clapton" <a@b.com> wrote in message
news:Oi*************@tk2msftngp13.phx.gbl...

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.
"Robert Berman" <Be******@NOSPAM.earthlink.net> wrote in message
news:zD*****************@newsread1.news.pas.earthl ink.net...

" -00Eric Clapton" <a@b.com> wrote in message
news:uz*************@TK2MSFTNGP10.phx.gbl...
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.

Nov 21 '05 #5

MikeD

" -00Eric Clapton" <a@b.com> wrote in message
news:uz*************@TK2MSFTNGP10.phx.gbl...

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.
--
Mike
Microsoft MVP Visual Basic

Nov 21 '05 #6

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

Nov 21 '05 #7

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

Nov 21 '05 #8

Similar topics

Question about database connections

by: Mudge | last post by:

Hi, My hosting provider only allows me to use 50 connections to my MySQL database that my Web site will use. I don't know what this 50 connections means exactly. Does this mean that only 50...

PHP

Database Connection questions.

by: pradeep_TP | last post by:

Hi all, I have a few questions that I have been wanting to ask for long. These are all related to ADO.net and specifically to conenction to database. 1) If I have opened a connection to a...

C# / C Sharp

Database connection advice

by: R Reyes | last post by:

Hi, I'm trying to modularize my database connections a little better and get more out of my project with less code. First check out this common dbOpen() function inside class clsDatabase. I...

C# / C Sharp

ConnectionState problem - managing connections to an Access database

by: Nick Gilbert | last post by:

Hi, I have an asp.net application which runs from a CD-ROM using Cassini. As such, it is single user only. The application connects to an Access database when it is loaded, and keeps the same...

ASP.NET

Basic question about database connection in ASP.NET

by: Lau Lei Cheong | last post by:

Hello, Actually I think I should have had asked it long before, but somehow I haven't. Here's the scenerio: Say we have a few pages in an ASP.NET project, each of them needs to connect to...

ASP.NET

database connection loss

by: Martin B | last post by:

Hallo! I'm working with C# .NET 2.0, implementing Client/Server Applications which are connecting via Network to SQL-Server or Oracle Databases. To stay independent from the underlaying Database...

C# / C Sharp

Making a database connection global

by: Terry Jolly | last post by:

Web Solution Goal: Have a global database connection Why: (There will be 30+ tables, represented by 30+ classes) I only want to reference the database connection once. I put the connection...

ASP.NET

How to use one database connection object per page request

by: Arsalan Ahmad | last post by:

Hi all, I am creating a website in which in an Item detail page there are a number of web controls (7 or 8) and what is happening that inside each of control's Page_Load() function I am creating...

ASP.NET

How To Use A Database In Your Program

by: Frinavale | last post by:

How To Use A Database In Your Program Many .NET solutions are database driven and so many of us often wonder how to access the database. To help you understand the answer to this question I've...

.NET Framework

How To Use A Database In Your Program Part II

by: Curtis Rutland | last post by:

How To Use A Database In Your Program Part II This article is intended to extend Frinny’s excellent article: How to Use a Database in Your Program. Frinny’s article defines the basic concepts...

.NET Framework

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++