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

Using Mimer SQL with iODBC on Mac OS X

Using Mimer SQL with iODBC on Mac OS X

(OP)
I am trying to integrate 4 frameworks, but yet with out success :(
Namely:
MimerSQL 10.0.6J
iODBC Version 3.52.10
osx-cocoa-odbc-master (latest from github)
Core Data on OSX 10.9.5

My first obstacle is integrate Mimer with iODBC; I am following the instructions at
http://developer.mimer.com/howto/howto_69.htm
but they are a bit out of date...
In particular, I cannot configure the Mimer driver at the ODBC administrator; I had try all DYLIBs I found in the installation, but with out success...

Any voice of advice will be VERY welcome.
Sincerely, Dino

RE: Using Mimer SQL with iODBC on Mac OS X

Hi.

Below is described how to create an example program and connect to a Mimer SQL database on MacOSX Mavericks using ODBC.
The iODBC development package and Mimer SQL 10.0.6 are presumed to be installed, with iODBC header files in /usr/local/iODBC/include.

A. Create a Mimer ODBC test-program
1. Go to /opt/MimerSQL-10.0.6J/examples
2. Do "cp ex_makefile makefile"
3. Edit makefile:
a. Add ”-I/usr/local/iODBC/include” to the INCLUDE variable
b. Assign the MYPROG variable to ”dsqlsamp”
c. Assign the MYFUNCS variable to ”osql_dsn.o”
d. Switch setting for SHAREDLIB, uncomment the one with ODBCLIB
4. Do ”make”


B. Create a Mimer SQL database
1. Run ”dbinstall mimserver”, where mimserver is the database name


C. Create odbc.ini file
1. Copy the following into "~/.odbc.ini”, where a DSN is created called ”mimer_dsn” that points out the database server named ”mimserver":

[ODBC Data Sources]
mimer_dsn = Mimer SQL odbc driver

[mimer_dsn]
Driver = /opt/MimerSQL-10.0.6J/lib/libmimodbc.dylib
Port = 1360
Database = mimserver
Host = localhost

2. Set ODBCINI variable as ”export ODBCINI=~/.odbc.ini"

D. Run the example program as follows (using the password given when creating the database, i.e. when using dbinstall):

$ ./dsqlsamp

*** Welcome to Mimer Dynamic SQL Sample Program ***

No DSN
—————
1. MIMER_DSN

DSN no: 1
Data source name [MIMER_DSN]:
Username []: sysadm
Password []:
- End an SQL statement with ’;'
- Exit program by giving an empty command

SQL>
Quit? (y/n) n

SQL>select * from system.onerow;

*** 1 row selected ***

M
=
M

SQL>

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