INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

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.

Jobs

ODBC Driver

ODBC Driver

(OP)
Does anyone know of an odbc driver for 4d databases, not 4d server?

Thanks

RE: ODBC Driver

Did you find one?  I installed the ODBC for 4d server but could not work it!

Manny

RE: ODBC Driver

manking,

Did you ever get the ODBC driver to work?  I just installed it as well and cannot create a DSN that connects...and my life is depending on it!

Thanks,
Bill
(aka Linguinut; Ling, for short)

Linguinut
------------------
Bill Cunnien
ConBrio Consulting

RE: ODBC Driver

(OP)
I never had any luck, but would be interested to hear if you find a driver that works.

Are you connecting to a 4d server or just a 4d database??

RE: ODBC Driver

Been working on it for three days now.  No luck.  We have several servers running, each pointing to its own database.  I have not considered accessing the data without the server app running.  I could give it a try whenever I get the DSN to work.  I'll be trying some things out today (day 4).  I'll update you on how it turns out.  Any knowledge I can get about this ODBC thing on 4D, I'd be glad to pass on to you.

Ling

Linguinut
------------------
Bill Cunnien
ConBrio Consulting

RE: ODBC Driver

dan05,

I got the driver to work...but...

I had to download the 2003.1 server demo.  It works fine on that server version (using either the 6.8 or 2003.1 ODBC driver).  

I still have not accessed my 6.0.5/6.0.6 databases, yet.  

The ODBC driver will NOT work unless the server application is running and the database is open on the server.  I just tried connecting to the 4dd file without the server running and the connection and queries fail.  Sorry about that.  At least, we know that much.

Now, back to the testing for the older databases.  It has got to work somehow...4D, Inc. says it will.

They should know.

Linguinut
------------------
Bill Cunnien
ConBrio Consulting

RE: ODBC Driver

To anyone who will listen...
(this forum is really dead...go to 4D iNUG Technical for a better forum)

The 6.8/2003 drivers WILL NOT work on older databases.  You must install the 6.0.x driver.  It will work; however, if you have any blob fields (text datatype, etc.), you WILL have trouble.  Guaranteed.

Fortunately, I have solved my exporting/importing problems by exporting all tables to a flat text file, then importing them into SQL Server 2000.  I exported using the field delimiter 179 (pipe) and the record delimiter 126 (tilde).  Do not add a line feed since it is not necessary.  In SQL, make sure to turn off any text qualifiers..this will mess things up.  You WILL need to edit the vbscript to do some data checking on the date fields (if any).  These could be a problem area, too.  Contact me, if you need help with the scripting.

All in all, I will be VERY glad to be rid of 4D.  It has been nothing but trouble from day one.  I inherited the databases.  When I leave here, I will NOT burden the next person with a system like this.  It is confusing, quirky and substandard.

Maybe because it was started from the Mac world.  It loses a bit in the translation, eh?

Linguinut
------------------
Bill Cunnien
ConBrio Consulting

RE: ODBC Driver


hi
  
 if u have a some problem in 4d ODBC server. i was also some problem in ODBC but before some time i remove that problem

Solution
 firstly i try to make dsn ,write some

data source name :"TCP/IP:Server IP Address"
Example :-"TCP/IP:192.12.1.114"
and username "kdlkkd"
password "jjkjkdjk"

u can make dsn

thanks

RE: ODBC Driver

patel2121,

My last post was nearly TWO YEARS AGO!!

I have long since left 4D and all of its woes behind me.  We are working with .NET applications, now, on a SQL Server.  I no longer worry myself about anything 4D.

Take my advice and get out of that world...get into some serious object-oriented programming with a database that actually adheres to some standards.  

Regards,
Ling

Linguinut
------------------
Bill Cunnien
ConBrio Consulting

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!

Resources

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