Connectivity with SQl database
-
Hi all, I want to build an application in which I have an XML files which contains the connection string and credentials to connect to multiple databases. I want to connect to these databases and run a stored procedure on these database and close the connection. Can anyone guide how to proceed on this. I want to have front end which will fetch the data from the XML file for database connection, make the connection, run the stored procedure and Close the connection. Any Idea How can this be implemented. Sankalp
-
Hi all, I want to build an application in which I have an XML files which contains the connection string and credentials to connect to multiple databases. I want to connect to these databases and run a stored procedure on these database and close the connection. Can anyone guide how to proceed on this. I want to have front end which will fetch the data from the XML file for database connection, make the connection, run the stored procedure and Close the connection. Any Idea How can this be implemented. Sankalp
What have you done so far? What exactly is the problem? Can't you read an XML file or connect to a database or execute a stored procedure?
-
Hi all, I want to build an application in which I have an XML files which contains the connection string and credentials to connect to multiple databases. I want to connect to these databases and run a stored procedure on these database and close the connection. Can anyone guide how to proceed on this. I want to have front end which will fetch the data from the XML file for database connection, make the connection, run the stored procedure and Close the connection. Any Idea How can this be implemented. Sankalp
Are you using .Net? Siunce you didn't specify, I'm going to respond as if you are. You should ask google about the connection strings section of the web.config. The web.config is an xml file that is already prepared with the necessary reading functionality, and the connection strings section is built to store connection strings. This is a built in feature of ASP.NET Also ask him about ADO.Net. Ado.NET is a library for connecting to a database. There are many articles on CP about connecting to databases from .NET. This really belongs in a programming board corresponding to the language you are going to write the application in.
Broken Bokken You can't carry out a ninja-style assasination dressed as an astronaut. It's the luminous fabric; too visible. - Tripod http://www.brokenbokken.com