Mike Stoltzfus
4/14/2005 1:22:00 PM
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
>-----Original Message-----
>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
>
>
>.
>