Unknown Error

Results 1 to 2 of 2

Thread: Unknown Error

  1. #1
    Join Date
    Dec 1969

    Default Unknown Error

    Hi guys, I&#039;m trying to connect with a ODBC database throught SQL SERVER (this ODBC database is linked onto SQL SERVER) and I´m getting this error:<BR>Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)<BR>[Microsoft][ODBC SQL Server Driver][SQL Server][OLE/DB provider returned message: [Microsoft][ODBC Driver Manager] Driver&#039;s SQLSetConnectAttr failed]<BR>xmlgenerator.asp, line 114<BR><BR>In 114 this line I wrote:<BR>rs.Open sql,objconn, 2, 1<BR><BR>Can some one help me?

  2. #2
    Join Date
    Dec 1969

    Default Pure guess!

    I presume that the query you are trying to run works fine from Query Analyzer? And only does not work when invoked from ASP?<BR><BR>Then could it be a permissions problem? When you run from Query Analyzer, you are running under your own (presumably administrator) account. When you run from ASP, you are running under the IUSR_xxx account.<BR><BR>If you haven&#039;t yet tested the query from Query Analyzer, time to do so.<BR><BR>

Posting Permissions

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