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

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.)

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/<d4pKwleAFHA.3176 (AT) cpmsftngxa10 (DOT) 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]

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."

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

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.
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.

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...