We help IT Professionals succeed at work.

How to add a sql database to a global application

assaultkitty
assaultkitty used Ask the Experts™
on
I just need to know if is possible to add a sql database to a global application and how do I do it?  if you can provide an example please by all means do so! Thank you very much if you can hurry. :)
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2015

Commented:
You cannot ask for a specific expert on EE. All questions are open to all experts.

Your phrase "add a sql database to a global application" does not compute in my limited understanding of database architecture. I use SQL databases in my web development practice, I know how to create new databases, etc., but "global application", I have no clue what that means.

Author

Commented:
Ok this is open to all experts.  But, I have a lot of problems communicating with them.  The ones I had last weekend were great this weekend they are very "cocky".  I could lie and say this is not homework but I would not get any learning.  

the global application class that I am using in my program.  I have a connection to an access database but I want to be able to understand if it is possible to use the global application class for a SQL connection?  "I hope you understand what I am talking about."
Top Expert 2015
Commented:
possible to use the global application class for a SQL connection

Not without a few changes if it currently only contains a connection setup for Access. Access for the .NET framework uses an OLE DB connection. MS SQL server can use OLE DB but I have only used the System.Data.SqlClient in my work. Here's a reference to the different connection strings.

http://www.sqlstrings.com/

And I'm still not sure what Global Application class means in your situation.

Author

Commented:
that is what I am talking about.  A simple answer.  I just want a yes or no. because I was completely on the wrong track with what I am doing.  When I post the wrong program the experts basically laugh.  So, thanks.  I am going to start over.

Author

Commented:
that is what I am talking about! thanks.