Solved

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

Posted on 2011-03-09
5
531 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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Many companies are looking to get out of the datacenter business and to services like Microsoft Azure to provide Infrastructure as a Service (IaaS) solutions for legacy client server workloads, rather than continuing to make capital investments in h…
ADCs have gained traction within the last decade, largely due to increased demand for legacy load balancing appliances to handle more advanced application delivery requirements and improve application performance.
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…

749 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