Welcome Guest | My Membership | Login

D3 ODBC Server Setup - On-Demand


Summary

Why use ODBC?

ODBC (Open Database Connectivity) is an old and mature technology that is used by many tools that need access to external data.

While the API does not provide you speedy access to your data, it does provide you access that programs like Word, Excel, PHP, JDBC, MOYB, .NET, and thousands more other applications.

Pit falls of ODBC and MultiValue.

ODBC is based around the SQL Query and update Language. As we know, MultiValue Data structures generally don't conform to the traditional Normalized data structures.

Make your existing MultiValue data conform to Normalized SQL data structures is usually the greatest challenge, and something you will have to take some time planning.

ODBC Conformance:

ODBC API Versions Support:

  • Core API
  • Level 1 API
  • Level 2 API - Limited

SQL Grammar supported:

  • Create Table, Drop Table
  • Select, Insert, Update Searched, and Delete Searched
  • Simple Expressions

Read More...

Social Media Login

Use your existing social media logins to access your Membership/Subscription information.

Existing Magazine/Newsletter Subscriber (Quick Access)

If you are an existing International Spectrum subscriber, but have not registered with the website, please enter the Reference Code found on the magazine or in the e-mails you receive from us.

Magazine Reference Code location

Spectrum Login

New Subscriber

If you currently do not receive the Magazine or other emails from International Spectrum, select the "Subscribe" button below to create an new membership account.


 

Find out more about the different between the FREE and a Professional Membership at:
Compare Account Options

 

# # #          # # #          # # #

 

Related Articles

  • Using the ODBC server inactivity timeout feature on D3/NT 7.4.4.

    Company: TigerLogic Corporation Database: D3

    A new feature of D3/NT that is introduced in 7.4.4 is the ability to set an inactivity timeout value to the client connections. After a specified period of time, a client ODBC connection will timeout. The port will be logged off, the associated thread will be terminated and the user license will be returned.

  • D3 Triggers Overview-Video

    Database: D3

    This Video will show you how to create a file Trigger in D3. You can use triggers for debugging and audit checking, enforce specific business rules, or data cleansing.

  • Installing and Using UniVerse ODBC: A Quickstart

    Company: Modern MultiValue, LLC Database: UniVerse

    A number of users have reported frustration (or failure) in installing and using UniVerse's ODBC. This might be due to confusing conflicts in terminology or the lack of actual examples. This article strives to provide a clarification of terminology and an end-to-end example in an attempt to provide that "ah-hah!" moment.

  • Introduction to Paragraphs - Video

    Database: D3, OpenQM, PI/Open, Reality, UniData, UniVerse, jBASE, mv*Base, mvEnterpise

    Paragraph is a simple command found in the Master Dictionary or VOC that combine a series of TCL command together. Paragraphs provide a simple macro language that provides you the ability to add loops, input prompts, as well as simple branching.

  • Setup SSL Encryption for UniObjects

    Database: UniData, UniVerse

    This video provides you a step by step directions to implement the SSL Encryption for UniObjects.NET and UniObjects JAVA. The instructions take you through how to create and implement using Self-Signed Certificates that will cause a 1028Bit or larger encryption between the client PC and the UniVerse or UniData Server.


Return to top