Contact US

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!

*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

tdbc::odbc problem

tdbc::odbc problem

tdbc::odbc problem

Does or has anyone used the tdbc odbc library? I had never used this up until a couple of days ago .. I'm connecting to a commercial Pervasive SQL database, I establish the connection just fine .. I did a very simple SELECT query where all of the input was just hard coded stuff that returned only one row of one table, and that went just fine, this was using a foreach command on the resultset of the statement. So within the foreach loop I did some trimming and formatting of the returned values, everything's working peach, so I think I've got the hang of how things work and am ready to move on to building some real world SQL commands. So I build a SELECT query that pulls in the neighborhood of several hundred rows, and the foreach loop shows me the first two rows, then errs with a "number out of range" message. No matter what I do, if a SELECT line pulls two or less rows, things work, anything more than two rows, and I get crapped on.

This is at work, so it's Activestate TCL 8.6 on windows ten. I'd try it from here on a linux box to see if it's just a big in the windows version, but I can't access the database server. Although it just occurred to me that I could load up something on a VM at work. In any case, I'm hoping that someone out there might have been through this, and can shed some light on what I'm doing wrong.

RE: tdbc::odbc problem

Maybe you should post a minimal example to show what's not working for you.
I never used tdbc, but tcom and ADO worked well for me on windows.
Long time ago I posted an example here: https://www.tek-tips.com/viewthread.cfm?qid=166536...

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