Timberline Data dotnet access code works on XP, not in IIS - Win2k

I am trying to access data from a Timberline Database through .net. Timberline is Construction Accounting Software which uses the Pervasive DataBase Engine. We're on Timberline v9.2.1.

The database access code works correctly from the local web server launched from Visual Studio 2005, but when I view the posted page from IIS (Win2000), I get

ERROR [S1000] [TimberlineODBC][TimberlineODBCEngine ODBC Driver][DRM File Library]Message #6102 [TS 6102]
ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed
ERROR [01000] [Microsoft][ODBC Driver Manager] The driver doesn't support the version of ODBC behavior that the application requested (see SQLSetEnvAttr).

Other info:
- Server has Framework 1.1 and 2.0 installed, with MDAC 2.8 RTM.
- The web process (iusr_machinename) has been given full control access to the HKLM\Software\Timberline and HKLM\Software\ODBC keys, and naturally, has access to the folder/files.
- Classic ASP ADO code fails similarly, but the identical .vbs ADO code executed through wscript.exe on the server under my security context returns data successfully. (My interpretation: ODBC is working, DSNs are properly configured.)


The questions I would have would be to either 1) just tell me you've run into this exact thing and have the quick tips on how to get Timberline data in IIS (I do not know that anyone ever has), or 2) point me in the direction of how to set *any* SQL Connection Attributes (SQLSetConnectAttr) from within VisStudio, or how I can found out the offending ODBC attributes. Other help appreciated, too.

Some probably-not-important details:
- Connection String = 'Dsn=tl_odbc_std;uid=<masked>;pwd=<masked>'
- SQLText = 'SELECT * FROM JCM_MASTER__JOB'


VBS code that works: (and except for the HTML code, this segment is identical to the Classic ASP code that fails in similar fashion to the DotNet code)
Const adUseClient = 3
Set oConn = CreateObject("ADODB.Connection")
Set oRec = CreateObject("ADODB.Recordset")
oConn.open "DSN=tl_odbc_std;UID=<masked>;PWD=<masked>"

oRec.CursorLocation = adUseClient

strConCat = "Dater = " & VbCrLF
oRec.open "Select job as stuff from master_jcm_job_1 where job LIKE '%-4'", oConn

While not oRec.eof
      strConCat = strConCat & oRec("stuff") & VbCrLF
      oRec.movenext
Wend

wscript.echo strConCat
'When using ASP, employ the right method:
'response.write strConCat

oRec.close
oConn.close
LVL 1
goober7Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

JohnDesautelsCommented:
Goober7,

Here are a couple of resources I found.

http://www.tek-tips.com/viewthread.cfm?qid=1043380&page=2

http://dbforums.com/t842704.html which had this comment:  I recieved this error. Apparently Timberline had an issue with Windows 2000 service pack 4. The solution was to upgrade Timberline to 8.31 and to install the ODBC patch from thier website.

I support Yardi Property management software which has a SQL Server back-end. It is much more friendly. :-)

John

0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
JohnDesautelsCommented:
GavinMannion,

I offered possible solutions but have no way to test them to see if they would work.

John
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
ASP.NET

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.