Data source name to long ??

[bukettt]

Microsoft OLE DB Provider for ODBC Drivers error '80004005' <BR><BR>[Microsoft][ODBC Driver Manager] Data source name too long <BR><BR>/guestbook/add_to_guestbook.asp, line 16<BR><BR><BR>Shorten your Data Source Name.This is my code i did. the error is show on the <BR>"check.Open strSQL, strCon" line. Name too long ?? <BR><BR>Set check = Server.CreateObject("ADODB.Connection")<BR>strSQL = "SELECT tblMembres.surnom FROM tblMembres;"<BR>check.Open strSQL, strCon<BR>Do While NOT check.EOF <BR> If LCase(strSurnom) = LCase(check("surnom")) Then blnUsernameOK = False <BR> check.MoveNext<BR>LoopASP.NET code?<BR><BR>BTW...You're trying to use check as a Connection object, and a Recordset object. Therein, lies your difficulty. <BR><BR>However....If you still can't figure it out, take it to another fourm. This one *isn't* for classic ASP questions.Hey body Xanderno... Seriously do you like your job or not ??<BR><BR> I though the site was for helping and not saying bad thing to then. <BR><BR>thank you...I do like my job. This site, however, is not my job. I do this for free.<BR><BR>And what did I say to you that was bad? Nothing...That I see. <BR><BR>Care to enlighten me?