data source name too long.

Converting another part of my site 2 ms sql and came across this error, after adjusting the connection. I've imported the db tables into the forum ms sql database and I can read out the data, but cannot write to the database using the sql statement below.

Does anyone know what the issue is here?

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Driver Manager] Data source name too long.

Dim yYellName, yYellArray, tempstr, yYellMessage, yYellDate

yYellName = Trim(Replace(Replace(Replace(request.form("yellname"),"<" ,"["),">","]"),"'","APOS"))
tempstr = Replace(Replace(Replace(request.form("yellmessage"),"<","["),">","]"),"'","APOS")

yYellArray = Split(tempstr, " ")

for x = LBound(yYellArray) to UBound(yYellArray)
yYellMessage = yYellMessage & Excerpt(yYellArray(x),1,20) & ""
next

yYellDate = now()

' compiling SQL statement with variables.

set yYell = Server.CreateObject("ADODB.Connection")
strSQL = "INSERT INTO Yells (YellName,YellMessage,YellDate) VALUES ('" & yYellName & "','" & yYellMessage & "','" & yYellDate & "');"
yYell.Open strSQL, adoCon

I use the connection defined by the ms sql forum itself by including common.asp. It doesn't complain that it can't find tables or anything because a different function with the same connection method works for retrieving data from the database.

It uses

'Enter the details of your SQL server below
strSQLServerName = "x" 'Holds the name of the SQL Server
strSQLDBUserName = "sa" 'Holds the user name (for SQL Server Authentication)
strSQLDBPassword = "x" 'Holds the password (for SQL Server Authentication)
strSQLDBName = "x"     'Holds name of a database on the server

Any suggestions?