Timberline ODBC Connection Error in ASP.NET

[PhilZuc]

Hello,

I'm work on a project for a company that uses Timberline. I'm writing a web interface that needs to use their current Timberline. This is my first experience with this software. What I have done is used the Server Explorer in my Visual Studio project to connect to Timberline with the ODBC I created. This works GREAT and I'm able to view the data with no issues. The problem happens when I add a DropDownList or DataGrid and try to bind it to a DataSet or DataReader I get the following Error:

ERROR [S1000] [TimberlineODBC][TimberlineODBCEngine ODBC Driver][DRM File Library]Drive or directory unavailable [IO-WIN 3] Screen\OD.scr
ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed
ERROR [01S00] [TimberlineODBC][TimberlineODBCEngine ODBC Driver]Invalid connection string attribute.
ERROR [01000] [Microsoft][ODBC Driver Manager] The driver doesn't support the version of ODBC behavior that the application requested (see SQLSetEnvAttr).

I have spent allot of time researching this issue and have still not solved it. I did find in my research that Timberline uses a Pervasive Database and I can connect using their driver, but again I'm not sure where to start with this driver. What is my best way solution to connect to Timberline data?

Please bear with me I'm an Old VB development and have only been using .NET for 6 months or so. I have exhausted all my ideas.

Please someone point me in the right direction.

Phil
PZuccala@saiia.com

 

[jibberski]

OD.scr is the ODBC security file.


Looks like you've got a limited ODBC driver. Check the install of your Timberline software for the proper activations on the ODBC module (yes you pay for it).

Here's the Timberline Knowledgebase article:

# Use Windows Explorer to search for and delete the following files:

* Od.scr
* Tssimba.dll
* Tsodbc*.dll

# Use the Registry Editor to find and delete the following: HKEY_LOCAL_MACHINE\SOFTWARE\TIMBERLINE\ODBC
# Reinstall ODBC from the current Timberline Estimating CD.

 

[frankizza]

This doesnt appear to be a limited driver situation (although a similar error is related) as I am able to use the same driver in other environments on the same machine. I am having the same issue with asp.net. It definitely appears to be a security context situation. I have tried impersonating various users (impersonating the user that IIS worker process runs as) that have network access to the timberline data folders to no avail. Anyone else have any leads?

 

[jibberski]

Did you pay Timberline for ODBC access?

 

[frankizza]

Yes, we have paid for it. We use it to access timberline through Excel, Access. I can run DTS sql server packages manually in Enterprise Manager. I can also view the tables and data through Visual Studio 2005 server explorer. I also just recently gave temporary access to Everyone for those folders. That didnt work. From what I have read people have been able to connect through ASP and PHP but I havent seen anything about ASP.NET (ADO.NET) yet.

Here is my connection string:
Driver=Timberline Data;DBQ=//server/ts-apps/timberline/company;UID=XX;PWD=XXXX". I have tried it with a mapped drive as well but have read elsewhere that mapped drives arent the way to go.

I really appreciate your help.
Do you happen to have the KB number of the article you sited above? Also, I have reinstalled on my dev machine after clearing out everthing including the registry. My installation is a client install off a network drive so I dont actually have the OD.scr file on my computer. I can create and delete files in the Screen folder as well in the same code.

 

[tomweaver]

For the instance of SQL Server that contains the linked server, set the "Startup service account" on the "Security" tab for the "SQL Server Properties" dialog to an account that has access to the Timberline folder on the server.

 

[FSFSFS]

I have the same problem, and anyone could help?