View Single Post

  #1 (permalink)  
Old 04-14-2003
Jade Jade is offline
Junior Member
Yellow Belt
 
Join Date: Mar 2003
Posts: 18
access Oracle db

Hello, I am writing an application in VB 6.0.
I have to plot information from an Oracle database on a map.
I' ve read that it is possible to do this with an udl-file, like this:

Code:
 
zDataSource = "\\mozart\vab\stagairs\VB\connectie.udl"
 Set pechgevalDataSet = mainMap.DataSets.ImportData(zDataSource, , geoCountryBelgium)
I would like to know whether it is possible to access only one view.
And if this is possible.. I also would like to know if it is possible to run SQL-statement from my VB-application.

Would you be so kind to help me with a code-example. Any comments are more than welcome..

Regards,

Jade
Reply With Quote