{"id":1980,"date":"2014-11-18T23:19:09","date_gmt":"2014-11-18T23:19:09","guid":{"rendered":"https:\/\/alt2.minisoft.com\/support\/?p=1980"},"modified":"2014-11-18T23:19:09","modified_gmt":"2014-11-18T23:19:09","slug":"odbc-configuring-an-osx-based-system","status":"publish","type":"post","link":"https:\/\/c002.minisoft.com\/support\/odbc-configuring-an-osx-based-system\/","title":{"rendered":"ODBC – Configuring an OSX based system"},"content":{"rendered":"

un-tar the files to the \/opt\/minisoft directory. If you use a different directory, adjust the sample names provided below to match your system.<\/p>\n

Create a copy of mscard.ini (sample.ini in this documentation) that contains a reference to your Image\/Eloquence database.<\/p>\n

white:\/opt\/minisoft root# more \/opt\/minisoft\/sample.ini\r\nDSN             = SAMPLE\r\ndriver          = 3kodbc\r\nImageDatabase0  = MSCARD.MM,DO-ALL,1,1\r\nUser Password   = PASSWORD\r\nUser            = MGR\r\nAccount         = MINISOFT\r\nServer          = 192.168.1.1\r\nServer Port     = 30006\r\n<\/pre>\n
Adding the driver to the list of available ODBC drivers.<\/p>\n
Use the ODBC Administration tool.<\/p>\n
Unlock the configuration.<\/p>\n
\"FM9_001\"<\/a><\/p>\n
Select the Drivers tab. Press Add. Enter a description. Select the lib3kodbc.so file for both the Driver and Setup file.<\/p>\n
\"FM9_002\"<\/a><\/p>\n
 <\/p>\n
\"FM9_003\"<\/a><\/p>\n
Do not create a user or system DSN with the ODBC Administrator. User and database passwords are stored in an encoded format and must be written using the provided config3kodbc.exe utility.<\/p>\n
Go to the shell prompt.<\/p>\n
# export ODBCSYSINI=\/Library\/ODBC\r\n# export ODBCINI=\/Library\/ODBC\/odbc.ini\r\n# .\/config3kodbc.exe -i -s -f sample.ini\r\n<\/pre>\n
To make the DSN visible to FileMaker, add your new DSN to the list of available DSNs.<\/p>\n
# vi \/Library\/ODBC\/odbc.ini<\/p>\n
Add a new line to the [ODBC Data Sources] section. If the DSN name is SAMPLE, then add: “SAMPLE = 3kodbc”.<\/p>\n
white:\/opt\/minisoft root# more \/Library\/ODBC\/odbc.ini\r\n[ODBC Data Sources]\r\nSAMPLE = 3kodbc\r\n\r\n[ODBC]\r\nTrace = 0\r\n\r\n[SAMPLE]\r\ndriver         = \/opt\/minisoft\/lib3kodbc.so\r\nDSN            = SAMPLE\r\nImageDatabase0 = XXXXXXXXXXXXXX\r\nUser Password  = XXXXXXX\r\nUser           = MGR\r\nAccount        = MINISOFT\r\nServer         = 192.168.23.197\r\nServer Port    = 30006\r\n<\/pre>\n
The DSN will now appear in the FileMaker list of available ODBC Data Sources.<\/p>\n","protected":false},"excerpt":{"rendered":"
un-tar the files to the \/opt\/minisoft directory. If you use a different directory, adjust the sample names provided below to match your system. Create a copy of mscard.ini (sample.ini in this documentation) that contains a reference to your Image\/Eloquence database. white:\/opt\/minisoft root# more \/opt\/minisoft\/sample.ini DSN = SAMPLE driver = 3kodbc ImageDatabase0 = MSCARD.MM,DO-ALL,1,1 User Password […]<\/p>\n","protected":false},"author":75,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[54,63],"tags":[],"_links":{"self":[{"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/posts\/1980"}],"collection":[{"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/users\/75"}],"replies":[{"embeddable":true,"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/comments?post=1980"}],"version-history":[{"count":1,"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/posts\/1980\/revisions"}],"predecessor-version":[{"id":1984,"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/posts\/1980\/revisions\/1984"}],"wp:attachment":[{"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/media?parent=1980"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/categories?post=1980"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/tags?post=1980"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}