• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Help needed

 
shailendra vasale
Ranch Hand
Posts: 38
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hi,
I want to connect XML with MS-Access.Can anyone plz help me out or else plz suggest sites.
Thanks in advence.
Shailendra.
 
Ajith Kallambella
Sheriff
Posts: 5782
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Can you be more clear in your spec? XML is not a tool for managing database connections. Do you want to represent the MSAccess query resultset as an XML?

------------------
Ajith Kallambella M.
Sun Certified Programmer for the Java�2 Platform.
 
shailendra vasale
Ranch Hand
Posts: 38
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hi Ajith,
I want to insert my XML file's content in database(MS-ACCESS) and again want to retrieve them back and display them to the user.How it can be done by firing queries in XML file,i need help in this respect.In XML I'm just at beginers level,so can you help me out or suggest some sites to clear my doubt?
Thanks.
Shailendra.
 
Ajith Kallambella
Sheriff
Posts: 5782
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
XML is so new, it is hard to find seamless integration support with databases. As far as I know, only Oracle 8i supports actual XML based columns and XML based queries that can be combined with standard SQL.
It is not uncommon to see people writing small utility frameworks that format the resultset of an SQL query into an XML document and vice-versa. That way this utility "patch" will help you achieve some level of transparency. I suggest you give it a shot and write some such thing.
You might want to take a look at XML Databases by Kevin Williams. It has some very interesting and stuff.
Good luck,
------------------
Ajith Kallambella M.
Sun Certified Programmer for the Java�2 Platform.
 
shailendra vasale
Ranch Hand
Posts: 38
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hi Ajith,
Thanks for the information.
I'm reading the oracle site where there is integration of oracle and xml.
Thanks.
Shailendra.
 
Ajith Kallambella
Sheriff
Posts: 5782
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
While you're there, checkout Oracle XML utilities and Oracle XDK from Oracle technet.
------------------
Ajith Kallambella M.
Sun Certified Programmer for the Java�2 Platform.
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic