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!
  • Students Click Here

*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


Externall access via VS 2005 or an commercial SQL Querry Klient

Externall access via VS 2005 or an commercial SQL Querry Klient

Externall access via VS 2005 or an commercial SQL Querry Klient


Hallo Friends,

I'm stuck a time now to get the right text data from an 4D SQL Server v11.5 from a TEXT type field via a client created with visual Studio 2005 and C# or a Commercial one with ODBC ability.

The problem is:

If the Field on the 4D SQL Server has more than 2046 Characters then the text arrived on my client(visual studio 2005) has the strukture of 2046 Character blocks that each block contains allways the first

2046 characters from textfield (the rest characters are ignored).

Im accesing the data with the OdbcDataReader Object. Worth to say is that if I try the shema data with the GetSchemaTable OdbcDataReader method,
all "TEXT" types in 4D identified as System.String with a length of 256 from  OdbcDataReader Object(false idendification?).
Meyby i can change the way that  OdbcDataReader idendifies the types.

The Problem occurs in each other comercial SQL Query tool too, but here with other apearence. In this case mutch more characters from text are cuted out and there are no doubled text blocks at all.
I have tried a lot comercial SQL query tools and no one of them can get the right text data.

But back to my enviroment and parameters.

Visual Studio:
Connectin string via odbcConnection = "DRIVER={4D v11 ODBC Driver};Description={4D v11 SQL datasource.};Server=xxx.xxx.xxx.xxx;Port=1919;UID=x;pwd=y;SSL=false;PhysicalConnectionTimeout=30;LoginTimeout=30;QueryTimeout=240;DefaultPageSize=100;NetworkCacheSize=128;CharsEncoding=UTF-8" with OdbcDataReader

win enwiroment for the client:  Win XP, Dual Core. ODBC Version:
Mac enviroment for the server: 4d SQL Server v11.5, Mac OSX Server 10.5.8, Xeon

I have used "ethereal" an Network Protokol Analyser to show the data interrogate from the ODBC driver. The Text Character are complete over the network and not Cuted out.

So the Question is who part could make this complication and how can get rid of this?

I'm very appreciate of your answers..

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!

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