Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Can you create an ODBC connection to a database outside of your network?

Posted on 2011-03-09
5
525 Views
Last Modified: 2012-05-11
We have some data that a business partner would like us to share. We're OK with that. But he'd like us to set up an ODBC connection to his database, on his network, so that we can export that data to him thru ODBC. How could I connect to his database on his network? I'm clueless!
0
Comment
Question by:TexanDonnaP
  • 3
5 Comments
 
LVL 33

Accepted Solution

by:
digitap earned 500 total points
ID: 35090023
you'd simply launch the odbc interface and add an odbc source. what kind of database is it? you'd probably connect with the ip address of the database server. you'll also need a username and password. is this over a vpn?
0
 
LVL 57

Expert Comment

by:giltjr
ID: 35090410
You also need to make sure you have a ODBC driver for the remote data base in question.  DB2 on z/OS, for example, requires a special driver to connect.
0
 
LVL 33

Expert Comment

by:digitap
ID: 35090537
in addition to mysql.
0
 

Author Comment

by:TexanDonnaP
ID: 35095247
My business partner tells me that it's a SQL Server database. He wants us to export this data daily, so this could be a pain. I hadn't thought about using VPN to access his system before we export the data. Great idea. I'll have to see if I can create the ODBC connection using access by VPN. Thanks for the ideas, DIGITAP.
0
 
LVL 33

Expert Comment

by:digitap
ID: 35095345
sql...cool. that driver should already be available. using a vpn, you will most certainly want to use the ip of the database server. create the connection under system dsn rather than user. also, select the database to export from within the connect. from your export tool, simply reference the system dsn you created.
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you're not part of the solution, you're part of the problem.   Tips on how to secure IoT devices, even the dumbest ones, so they can't be used as part of a DDoS botnet.  Use PRTG Network Monitor as one of the building blocks, to detect unusual…
When it comes to security, there are always trade-offs between security and convenience/ease of administration. This article examines some of the main pros and cons of using key authentication vs password authentication for hosting an SFTP server.
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question