orionbrock32
04-23-2007, 01:35 PM
I am wondering if anyone can provide help in being able to access an xml file like I would any other db.
This is an example of my current method and for ease of coding I was wondering if XML could be accessed in the same manner.
'Set Database Folder
CONST DatabaseFolder2 = "\hbl\fpdb\dbHBL.mdb"
'Open connection with database DSNless connection string.
Set oCmd = Server.CreateObject("ADODB.Connection")
oCmd.open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.Mappath(DatabaseFolder2)
descSQL="SOME SQL STRING"
set temp=oCmd.execute(descSQL)
This is an example of my current method and for ease of coding I was wondering if XML could be accessed in the same manner.
'Set Database Folder
CONST DatabaseFolder2 = "\hbl\fpdb\dbHBL.mdb"
'Open connection with database DSNless connection string.
Set oCmd = Server.CreateObject("ADODB.Connection")
oCmd.open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.Mappath(DatabaseFolder2)
descSQL="SOME SQL STRING"
set temp=oCmd.execute(descSQL)