connecting to a remote server using vb+sql server using ADO

connecting to a remote server using vb+sql server using ADO

Post by suni » Thu, 21 Mar 2002 15:15:54



hi,

i want to develop a database application using visual basic and ms-sql
server. i will be using front end application from different systems
on a network and the database resides on a Windows 200 Advanced Server
in the same network(in the same location).

i want to know which way i can connect to the server for accessing the
database.  i want to connect using ADO.

also i want to know the connection properties if the database resides
on a different location.

somebody can plz email me the connection properties at

regards,

sunil.

 
 
 

connecting to a remote server using vb+sql server using ADO

Post by Alberto » Thu, 21 Mar 2002 17:13:27


The best way is to insert an Ado DataControl on your Form, then click on
properties and select "Generate Connection String".
Through a Wizard, it creates a connection string that you can copy and paste
into your Adodb.Connection.ConnectionString property value (you can later
remove the AdoDataControl from the form, if you don't need it).

Then, depending on your application functioning, you have to set
CursorLocation, IsolationLevel, and all other parameters for Adodb.Command
and Adodb.Recordset objects.

Bye

Alberto