OK. I have searched around and found a lot of code that is so compiled with a bunch of other code that it is hard for a newby to understand.
So, for this post, I am asking for the following.
#1: Connection String for Access Database (2000 & 2007)
#2: Connection String for SQL Server 2005
Basically like in ASP Classic where you can use this.
How would this be written for C# ASP.NET.
(I am using C#, as it is used in the Upload script that I am currectly using, so I am sticking with it for the moment)
Set objConn = CreateObject("ADODB.Connection")
'objConn.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & _
'Server.MapPath ("database1.accdb") & ";"
objConn.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=G:\InetPub\wwwroot\get\database1.accdb;Persist Security Info=False;"