Please coudl you help

Results 1 to 3 of 3

Thread: Please coudl you help

  1. #1
    Join Date
    Dec 1969

    Default Please coudl you help

    Could someone let me know whats wrong with this code?<BR><BR>&#060;% <BR> <BR>&#039 Establish Database Connection<BR> Set conn = Server.CreateObject("ADODB.Connection")<BR> connStr = "DRIVER={SQL Server}; Server=tech; Database=tdplc; UID=sa"<BR> Conn.Open connStr <BR><BR><BR><BR>strSQLQuery = "SELECT SOP10100.CUSTNMBR, SOP10100.SOPNUMBE, SOP10100.DOCAMNT, SOP10100.FUFILDAT, SOP10103.RCTNCCRD, SOP10103.AUTHCODE FROM SOP10100, SOP10103 WHERE SOP10100.FUFILDAT =&#039" & Replace(Request("to"),"&#039","&#039&#039") & "&#039"<BR> Set rs = Server.CreateObject("ADODB.Recordset")<BR> rs.Open strSQLQuery, conn, 3, 3<BR><BR>%&#062;<BR><BR>it just when i run the page I just get<BR><BR>Microsoft OLE DB Provider for ODBC Drivers error &#039 80040e31&#039 <BR><BR>[Microsoft][ODBC SQL Server Driver]Timeout expired <BR><BR>/accounts/date3.asp, line 12 <BR><BR><BR>any ideas?<BR><BR>thanks alot.<BR><BR>Sal

  2. #2
    Mike B Guest

    Default RE: Please coudl you help

    Try removing all of the spaces after the semicolons in the connection string. I read somewhere that this may cause a problem.<BR><BR>Hope this helps.<BR><BR>Mike

  3. #3
    Join Date
    Dec 1969

    Default RE: Please coudl you help

    it seems as though you are not passing a PSW in you ConnStr. You may want to try using a DSN (Data Source Name).

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts