×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Timberline, Crystal Reports, IIS, and ASP.NET

Timberline, Crystal Reports, IIS, and ASP.NET

Timberline, Crystal Reports, IIS, and ASP.NET

(OP)
I have an ASP.NET website that I've created using VS 2008 and the .NET 2.0 Framework. The site takes a Crystal Report developed in Crystal 9 and loads it onto the website.

The ODBC connection that the report is using is a Timberline Data connection, and it all works fine. As long as I run the project from my local computer, it all works just fine. However, as soon as I publish it to our IIS server, it breaks.

Here is the error message

Logon failed. Details: 01000:[Microsoft][ODBC Driver Manager] The driver doesn't support the version of ODBC behavior that the application requested (see SQLSetEnvAttr).
Query Engine Error: 'S1000:[TimberlineODBC][TimberlineODBCEngine ODBC Driver][DRM File Library]Drive or directory unavailable [IO-WIN 3] Screen\OD.scr'
Logon failed. Error in File C:\WINDOWS\TEMP\TimeRequest {BE81D3F5-C2CB-48F6-A2BE-412E4FB26540}.rpt: Unable to connect: incorrect log on parameters.

The ODBC connection is the exact same on the IIS server as on my local machine, and the website is set to run under a domain admin account. Any help would be appreciated.

RE: Timberline, Crystal Reports, IIS, and ASP.NET

I googled the first erorr in your post and found numerous results and varying in is specific solutions but all pertaining to IIS/ASP.NET (app) rights on the OBDC driver and Database

-- Jason
"It's Just Ones and Zeros"

RE: Timberline, Crystal Reports, IIS, and ASP.NET

I had a similar error and it turned out that the ODBC connection on the server was an older version than the same ODBC Driver on my local machine.  After updating the server to the more recent version it worked fine.

RE: Timberline, Crystal Reports, IIS, and ASP.NET

(OP)
Does anyone know where I can get the updated ODBC driver?

RE: Timberline, Crystal Reports, IIS, and ASP.NET

(OP)
I looked into, and the ODBC driver is the same on both machines. I've heard in other forums that there might be a rights issue involved with the IIS server. Does anyone know what they might be talking about?

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close