07.05.2020

Odbc Client For Mac Highsierra

66
Odbc Client For Mac Highsierra Average ratng: 5,8/10 443 votes

If you want to import data into Excel for Mac from a database (for example, from FileMaker Pro), you need an Open Database Connectivity (ODBC) driver installed on your Mac. The driver you get depends on which version of Excel for Mac you have. The OpenLink ODBC Driver for Firebird (Express Edition) is a multi-threaded 'Wire Protocol' Driver, enabling seamless out-of-the-box connectivity supported databases, and eliminating the need for the installation of any database-specific client networking software. This version of Excel does provide an ODBC driver for connecting to SQL Server Databases. On the Data tab, click New Database Query > SQL Server ODBC.Then use the dialog boxes to import the data. If you are connecting to other ODBC data sources (for example, FileMaker Pro), then you'll need to install the ODBC driver for the data source on your Mac. Installation failed trying to install MySQL ODBC connector on macOS High Sierra. Ask Question. Up vote 2 down vote favorite. I'm trying to install this mysql odbc connector on my macOS High Sierra machine, but I get this error. Loading rJava on Mac OS High Sierra. Best Video Software for the Mac How To Run MacOS High Sierra or Another OS on Your. This software is really great if you need to connect a FileMaker database to a SQL/ODBC database. The OpenLink Express ODBC Driver for Microsoft SQL Server is a Type-B class of driver enabling seamless connectivity to your database out-of-the-box, thus eliminating the need for the installation of any database-specific client networking software.

Active1 year, 8 months ago

In R 3.4.0,

fails on macOS 10.12.4. I also downloaded RODBC_1.3-15.tar.gz from CRAN and tried,

In both cases, I got 'ODBC headers sql.h and sqlext.h not found'. A discussion of this in Installation of RODBC/ROracle packages on OS X Mavericks says the following:

Nov 28, 2017  Download Microsoft Remote Desktop 10 for macOS 10.11 or later and enjoy it on your Mac. ‎Use the new Microsoft Remote Desktop app to connect to a remote PC or virtual apps and desktops made available by your administrator. How can the answer be improved? Get the Remote Desktop client. Follow these steps to get started with Remote Desktop on your Mac: Download the Microsoft Remote Desktop client from the Mac App Store. Set up your PC to accept remote connections. (If you skip this step, you can't connect to your PC.) Add a Remote Desktop connection or a remote resource. What is the remote desktop client for mac.

To fix this, you need to download the latest version of iODBC (www.iodbc.org), and then unzip the file and set your header and library search paths to the location where you put the unzipped package. If you don't know how to set your search paths, you could just put the header files (sql.h and sqlext.h) in the /usr/include directory, and the libiodbc.a file in the /usr/lib directory.

I downloaded iodbc-42.5.tar.gz and untarred it into a directory next to RODBC, untarred from RODBC_1.3-15.tar.gz. Sadly, I can't find how to set header and library search paths, and when I try to put the header files in /usr/include, the system won't let me.

iodbc-42.5/iodbc/README.MACOSX says,

You first need to install the latest Mac OS X Developer Packages, which can be found at http://developer.apple.com/tools

I think I've done that, but I don't know how to check it. [In fact, I think I've done it multiple times: The message ODBC headers sql.h and sqlext.h not found, disappeared for a while from the still-negative response to install.packages('RODBC', type='source'), only to reappear later after I successfully installed port and ran sudo port install gcc6. Then I got ODBC headers sql.h and sqlext.h not found again.]

iodbc-42.5/iodbc/README.MACOSX continues,

Then, you can open the Xcode Project Builder files under mac/iODBCinst, mac/iODBC, mac/iODBCtest and mac/iODBCtestw.

I don't know how find any of these. It further continues,

or execute the following commands from a terminal session to build all the frameworks and demo applications:

I did $ cd mac and got -bash: cd: mac: No such file or directory. Evidently, I need to substitute something for mac here, but I don't know what. ???

Thanks.

TallTed
7,2562 gold badges15 silver badges29 bronze badges
Spencer GravesSpencer Graves

1 Answer

I solved the problem with:

where '/path/to/libiodbc-srcs/include' is the path to the 'include' folder containing the missing files, 'sql.h' and 'sqlext.h'. In my case it was something like '~/Documents/Rstuff/iodbc-42.5/iodbc/include', which I checked with the following in R:

Then the following worked for me:

Net extender client for mac. This is described in p. 19 of https://cran.r-project.org/web/packages/RODBC/vignettes/RODBC.pdf, except that contains a stray quote (<'>), which threw me off the first few times I read it, because was not familiar with that syntax.

On R-Sig-Mac, Marc Schwartz offered two suggestions: First, Installation of RODBC on OS X Yosemite, which may work with 'brew'; I didn't try that, because I got the above to work first.

Second:

This should work also with the path substitution mentioned above.

Odbc Client 11

I hope this helps someone else.

Community♦
Spencer GravesSpencer Graves
Got a question that you can’t ask on public Stack Overflow? Learn more about sharing private information with Stack Overflow for Teams.

Neat Scanner Driver For Mac High Sierra

Not the answer you're looking for? Browse other questions tagged rmacos-sierrarodbciodbc or ask your own question.

Best Mail Apps for Mac: macOS High Sierra Edition

Love it or hate it, unless you choose to live a quiet, unconnected life, we all have to deal with email. For most of us, managing email, especially with multiple accounts from various providers, can be a real pain. Fortunately there is a handful of apps that are making great strides towards easing that pain. Take a look below at some of the mail apps for Mac to help you keep your inbox under control.

If we missed any of your favorites, please let us know in the comments so we can give them a try!

Editor’s Note: this list is a constantly evolving as new apps are released or as old apps are updated. Today, we’re looking at a handful of apps that work well with Apple’s new macOS High Sierra.

Price: Free
Named one of the best of Mac by Apple itself in 2016, Spark is still one of the most popular, user-friendly, and best overall email clients for Mac. With a focus on keeping you inbox free of chaos, Spark lets you organize everything into easy to find (and hide) categories and subsections. You can schedule emails, set selective alerts, and search through your mailboxes easily. Convenience and a sleek look are the name of the game with Spark.
Price: $9.99
AirMail 3, whose iOS counterpart made our list of 5 Best Mail Apps for iPhone/iPad, is a long-running contender in the email management landscape. Though it has been around for a while, the app developers have done an excellent job of keeping it fresh, clean and powerful. The iOS and Mac versions of AirMail provide a uniform experience with its folders and labeling system and overall design of the app. Many of the features you would come to expect from an email client are included, but there are also some that are unique. An example would be the minimal view which is perfect for users like me who are in their email all day. With the minimal view, your inbox is displayed as a one-column timeline like you would see in something like the Mac Twitter app. Some users are frustrated with the complications they have when trying to move emails into different folders (the drag and drop apparently isn't as easy as proposed). However, it seems that for users who need some help, AirMail's superior customer support is available via web chat. Way to go, Mark and Sarah!
Price: Free
Polymail is easy to use and has a beautiful interface, making it one of the best mail apps for Mac. It offers numerous features to make your life easier, like snoozing emails to read them later, scheduling emails to automatically be sent later. You also get unlimited per-recipient email tracking, to keep you in the know about when and by whom your messages are read. Works with Mac and iOS, and the fact that it's free doesn't hurt.
Price: Free
Hey, who says the stock mail app can't make the list? Especially since it was specifically designed to take advantage of macOS High Sierra, Apple Mail is one of the best mail apps for Mac users. If you've been a Mac user for any amount of time, you're likely familiar with the core functionality, but there are some new features to take note of. Tabs are now used more widely throughout macOS Sierra, and Mail is no exception. With the addition of tabs, you can have all of your inboxes from different accounts open at once and just flip back and forth — pretty convenient. I should say, though, that many users, myself included, aren't thrilled with how convoluted the process is to get additional tabs. There is no simple + to be found. Hopefully Apple will address this in an update. Besides tabs, you'll also find full support for Siri, so you can compose new messages, read emails, set reminders, find specific emails and more via voice command. If Apple Mail becomes your preferred app, this is incredibly handy.
Price: $5.99
For day-to-day email, Inbox by Gmail has become my go-to. Ever since its release in 2014, I have favored the quick management of email messages to Inbox's bigger brother Gmail. Boxy is a standalone email client for Inbox that brings the service outside of your browser and adds a bit more customization and features, making it one of the best mail apps for Mac. Once you're inside the app, you'll immediately notice the familiar design that looks almost exactly like Inbox. However, if you want to switch things up, you have multiple themes to choose from as well as the option for different font sizes. As you'd expect, you will find all of the features of Inbox by Gmail that you've grown to love such as the inbox bundles, the ability to snooze emails, pin messages and more. The app isn't perfect though. Many users find the file attachment process slightly frustrating. With the omission of a browse-for-file option, you're required to attach your files by dragging and dropping. Sometimes, if your desktop or Finder windows are covered, that requires some fishing and cuts down on your efficiency.
Price: $19.99
Canary is a simple and easy-to-use email app that promises efficiency and security. Every email you send will have end-to-end encryption, so you never have to worry about privacy or security. That will always happen automatically, so you never need to double check that you've enabled encryption. With natural language search, smart filters, algorithmic bulk cleaner, and intelligent typography enhancements, Canary focuses on keeping things organized and easy to find. At $19.99, it's definitely worth it, and it easily earns a spot on this list.
Price: Free
Inky is the only Mac email app on this that isn't available from the App store, but it is still worthy of its place here. It seems like every other day, there is a major news headline that deals with someone's account being hacked or a security breach at large corporations. If this has motivated you to seek out more online security, Inky is definitely something you should check out. Every email sent through the Inky client is encrypted end-to-end, so the contents of your email cannot be read by anyone else besides the intended recipient. Additionally, you can send digitally-signed emails with Inky, so the person on the other end can be sure the email came from you. Outside of the security features, Inky comes with other features that help manage your email. You'll find built-in mailboxes similar to what Inbox offers to automatically group incoming messages, and you can also tag new emails for later sorting.
Price: $49.99/year
Newton Mail, like AirMail, found itself on our list of the 5 Best Mail Apps for iPhone/iPad and also reigns supreme as one of the best mail apps for Mac. Just like what you'll find in the iOS counterpart, Newton Mail for Mac comes with a handful of what it calls superchargers to help you master your inbox. Some of the more notable superchargers include read receipts, handoff functionality so you can start an email on iPhone, then finish on your Mac, and the ability to connect your inbox to major productivity services like Evernote, OneNote, Pocket, Trello, and more. Newton Mail has a beautiful interface that honestly makes email a tiny bit more enjoyable. But I have to break it to you: if you want to commit to using Newton Mail as your daily driver, prepare yourself for the $49.99 per year subscription fee. This is among the most expensive email clients, so soak up that free 14-day trial!

Bonus picks

Price: Free
What Boxy is to Inbox, Kiwi is to Gmail. Kiwi is an email client for Gmail that allows you to use the email service as a native app. With Kiwi, you'll find a familiar, nearly identical experience to what you get with Google's flagship email service, but you'll get a few additional features that you might find handy. Probably the most convenient feature is the global shortcuts that allow you to start a new email from anywhere at anytime. If you're like me, and have windows open on top of other windows at all time, a quick keyboard shortcut can save a lot of time. Another feature that lends itself to convenience and productivity, is the dropdown manager from the macOS menu bar. Clicking on the Kiwi icon in the menu bar, drops down a list of all of your inboxes so you can jump directly to the messages you need, or compose a new message from the appropriate inbox. And it's currently free.
Price: $129.99
Microsoft Outlook finds itself a spot in our bonus picks because it really is more than just an email client. Outlook still holds a place near and dear to the hearts of businesses large and small because it offers a complete suite of productivity tools in one place. Whether you love or hate the experience, it's hard to deny the handiness of having full access to your calendar, tasks and notes all within the same app. The Microsoft Outlook app was recently updated to bring a more friendly, modern design. This update was welcome, to say the least, but it didn't quite solve the issue of the app being quite overwhelming with the number of icons, menus and tabs you will find scattered throughout. If you're an average user who is looking for a way to better manage your own inbox, the $129.99 price tag is hard to justify, but for businesses, this tool, or suite of tools, really, is something to consider. And check out your other options with the full office suite.

We all have to deal with email in some way or another. The question is, what app is going to make your experience a little bit easier/more productive? Will you prioritize encryption and opt for Canary, or go with a simplistic, modern experience like AirMail? Or will you stick with something more tried and true, but maybe a little less pretty like Microsoft Outlook?

What would you say are the mail apps for Mac? Let us know in the comments below!

What does Applecare cover, and is it worth the buy?

When you decide to purchase an Apple device you're also going to be faced with a decision about extra coverage. Should you buy AppleCare?
Jan—02—2019 03:25PM EDT

The best laptops for college students

Odbc Client For Mac High Sierra

Check out some great laptops for a variety of college needs.
Oct—08—2018 05:56PM EDT

What is the best laptop for video editing and graphic design?

Apps like Premiere Pro and Photoshop usually cause most computers to begin to stutter but what are the best laptops for video editing and graphic design? Find out in our curated list.
Jul—27—2018 11:30AM EDT

15 funny things to ask Siri

Apple has built Siri to have a personality, and it can be quite witty when asked the right questions. Bored? Let's have some fun with our good ol' friend Siri.
May—04—2018 08:48AM EDT

What might Apple announce during this week’s ‘field trip’?

Odbc Client Download

Apple is taking a crack at the education market with a mysterious event this week in Chicago.

Quicken Essentials For Mac High Sierra

Mar—26—2018 05:50PM EDT