Timberline (Pervasive) ODBC Access

Robert Porter

unread,

Jan 23, 2005, 7:18:27 PM1/23/05

to microsoft.public.dotnet.framework.adonet, microsoft.public.dotnet.framework.odbcnet

Is anyone else out here working with Timberline version 7.x,8.x or 9.x and ODBC and .NET? If so any advice to offer? I am working with a number of older VB 6 applications that interface (mostly just read) Timberline data stored in a Pervasive SQL database that I am porting to VB.NET.

Experimentation has shown me that I apparently need to use Timberlines own driver, I have had limited success with the Pervasive native drivers. I am trying to stay in an all managed solution so I have been using the System.Data.ODBC namespace but that appears to cripple my access to things like Schema info etc.

Any suggestions or pointers to online resources would be appreciated. I am already aware of Event!'s web site.

Thanks in advance.

Bob Porter

Steven Cheng[MSFT]

unread,

Jan 24, 2005, 2:50:37 AM1/24/05

to

Hi James,

Thank you for your posting. Regarding on the issue, I am
finding proper resource to assist you and we will update as soon as posible.

Regards,

Steven Cheng
Microsoft Online Support

Get Secure! www.microsoft.com/security(This posting is provided "AS IS",
with no warranties, and confers no rights.)

Robert Porter

unread,

Jan 24, 2005, 11:45:12 AM1/24/05

to microsoft.public.dotnet.framework.odbcnet

Hi Steven,

My name is Bob not James, but thanks for the reply. We can discuss in this forum, I posted to this one and the ADO forum because I was not sure which was correct.

Cheers,

Bob

nntp://msnews.microsoft.com/microsoft.public.dotnet.framework.odbcnet/<d4pKwleA...@cpmsftngxa10.phx.gbl>

Hi James,

Thank you for your posting. Regarding on the issue, I am

finding proper resource to assist you and we will update as soon as possible.

Regards,

Steven Cheng
Microsoft Online Support

Get Secure! www.microsoft.com/security(This posting is provided "AS IS",
with no warranties, and confers no rights.)

[microsoft.public.dotnet.framework.odbcnet]

Kevin Yu [MSFT]

unread,

Jan 26, 2005, 12:59:36 AM1/26/05

to

Hi Bob,

I have posted a reply to the SQLSetConnectAttr Woes issue. Currently I
don't have any experience on the Timberline system. But we can stay here to
see if any community member can share some light on this issue.

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."

Mike Stoltzfus

unread,

Apr 14, 2005, 9:21:49 AM4/14/05

to

Bob - have you found any information about this issue? I
am trying to develop a website that will pull some
information from Timberline. I have successfully
connected to the database using the following connection
string:
"Driver={Pervasive ODBC Client
Interface};DBQ=D:\Timberline Office\TSDATA"

So far everything is working fine EXCEPT I can't query
based on job number (MASTER_JCM_R1.Job). For instance, if
I run the following query:
SELECT * FROM MASTER_JCM_R1

I get results. The Job column is returned as a value such
as 01101. (If I run this same query in MS Access, that
Job column value is formatted as 01-101). I then try the
following queries:
select * from MASTER_JCM_R1 where Job = ?'
select * from MASTER_JCM_R1 where Job = ༽-101'
select * from MASTER_JCM_R1 where Job = ' 1101'
select * from MASTER_JCM_R1 where Job = ' 1-101'

None of these queries return any results, nor do they
return errors. So, for some reason, I can't query using
the Job column in the WHERE clause.

I spoke with Timberline support, and they said it was
because I'm using the Pervasive driver, rather than the
Timberline ODBC driver. However, I haven't been able to
get the Timberline ODBC driver to work in a connection
string at all. If I use the following connection string:
"Driver=Timberline Data;dns=tl;uid=(user);pwd=
(password);DBQ=D:\Timberline Office\TSDATA"

And execute the following SQL statement:
SELECT * FROM MASTER_JCM_JOB

I always receive the following error:
[TimberlineODBC][TimberlineODBCEngine ODBC Driver][DRM
File Library]No such table or object.

(I understand that if I use the Timberline driver, the
table name is MASTER_JCM_JOB, and if I use the Pervasive
driver, the table name is MASTER_JCM_R1.)

Any ideas?
Mike

>.
>

Unknown

unread,

Apr 20, 2005, 2:11:53 PM4/20/05

to

Gentlemen:

We have opened this topic here http://www.tl-source.com under the TL Developer forum. We would very much value your input...

Thanks!

Kevin

**********************************************************************
Sent via Fuzzy Software @ http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...