LIB][ConnectionOpen (Connect()).]SQL Server Does Not Exist Or Access Denied.

Okay Ive managed to confuse myself pretty good.

I have an aspx page that attempts to connect to an SQLEXPRESS instance and add data to a table.
Code as follows:
beginning of page
<%@ page aspcompat=true enablesessionstate=false language=javascript %>
<!--#include file="adojavas.inc"-->
<%@ Import Namespace="System.Data.OleDb" %>

I have a toolfunction that when called upon runs this:
if (xco >= -180 && xco <= 180 && yco >= -90 && yco <= 90) {
                        status = "Can't connect to database.";

                        // create connection to database

                        var connection;
                        connection = Server.CreateObject("ADODB.Connection");
                        connection.Open("Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=OutdoorsExp;Data Source=\.pipeMSSQL$SQLEXPRESSsqlquery;");

                        status = "Can't access table.";

                        // create recordset
                        var recordset;
                        recordset = Server.CreateObject("ADODB.Recordset");
               
                        recordset.Open("dbo.FishType", connection, adOpenDynamic);

                        status = "Can't append new record, record set does not support AddNew.";

                        // append record for clicked location
                        if (recordset.Supports(0x01000400)) {
                          status = "Can't append new record.";

                          recordset.AddNew();
                          recordset.Fields("LongitudeI").Value = xco;
                          recordset.Fields("LatitudeI").Value = yco;
                          recordset.Update();
                        }

                        recordset.Close();

                   
                        // release the file
                        connection.Close();

                        status = "Can't propagate changes to drawing.";

                        // refresh drawing
                        var document = mapserver.Document;
                        var componentIndex = document.ComponentSet.ItemByName("FishTable Data Points Drawing");
                        if (componentIndex >= 0) {
                            document.ComponentSet.Item(componentIndex).Refresh();
                        }

                        status = xco.toString() + ", " + yco.toString();
                         
                    }

Unfortunately this gives me an error instead of transferring the value xco,yco to the SQL Tables LatitudeI/LongitudeI column.

Ive tried many different connections strings, and have played myself into a state of confusion now :(.

I get this error:

[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.[COMException (0x80004005): [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.]Ive tried named pipes and using IP to connect, and Im not 100% sure how to use SQL Server via
"System.Data / System.Data.SqlClient".

Any insights would be greatly welcomed!