Hi..All.. I'm doing an application in
VB 6.In this application I've an XML file which has a Provider and Datasource for connecting to Database.The XML file looks like this.
<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<appSettings>
<add key="strConn" value="Provider = Microsoft.Jet.OLEDB.4.0;Data Source=C:\Inetpub\wwwroot\Northwind.mdb;User ID=Admin;Password=;" />
</appSettings>
</configuration>
How can I connect this to my
VB application so that I can connect it to the database.
I know I can connect to my Database directly using DSN or taking the connection string and giving the provider.But I want to connect it through an XML file because when my client chenges the Database path,they can just chenge it in that XML file and they need not face many problem if they replace the database path.
Please help if you know this.
Thanks in advance