Solved

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

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

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

Join Greg Farro and Ethan Banks from Packet Pushers (http://packetpushers.net/podcast/podcasts/pq-show-93-smart-network-monitoring-paessler-sponsored/) and Greg Ross from Paessler (https://www.paessler.com/prtg) for a discussion about smart network …
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.
Internet Business Fax to Email Made Easy - With  eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, f…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

777 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