Solved

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

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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

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…
I had an issue with InstallShield not being able to use Computer Browser service on Windows Server 2012. Here is the solution I found.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
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…

914 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now