this is my first attempt to working with any database at all with web
the IT set up SQL databases on SQL 2005 Server, and asked me to use OLEDB connection.
Using ASP and hope to use SQL to work with the data.
So far I believe I have connected to the database with this code, because when I access the file, it no longer gives me a page error.
Dim objConn
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.ConnectionString = "Provider=SQLOLEDB; Data Source=ServerName; Initial Catalog=DatabaseName; User ID=User; Password=Password"
question is, how do I know for sure I’ve connected?
also, what software do I need to use to access and open the database, I don’t believe it is set up? Or can I set it up with ASP?
Dont’ really know where to go from here, except that I know I should open the database and set it up because there wouldn’t be any data to access and display.
BTW, what I’m trying to do is to send data from a form to this database, so to eliminate a person having to enter these data themselves.
thanks for any direction or help
Am I way into my head to try to do this myself without any knowledge of a sort? cuz a part of me is thinking, maybe I should hire someone to create instead.
