Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 150
  • Last Modified:

Working with SQL

How can I, without using controls, connect to an sql database and fetch data from there? I'm using vb enterprise edition version 5.0.
Please insert source code.
0
cybernide
Asked:
cybernide
1 Solution
 
fguerreiro_inixCommented:
Give more details
0
 
dishaCommented:
Hi u can use RDO's for remote database like SQL server/Oracle
or user DAO's for jet engine db's like access..
Check VB documentation.Create a rdoconnection and then u can fire queries
queries using rdoqueries. The output of this queries can be
taken into resultsets and which can be operated on.

Regards
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now