[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

VB.net SQL Connection to SAP

Posted on 2014-08-12
2
Medium Priority
?
512 Views
Last Modified: 2014-08-15
Hi

Is there a way to connect a SQL database to a SAP database?
I have tried the .net SAP connector but find it difficult to get going so want to look at rather connecting the SQL
database to SAP and querying the SQL rather. Is this viable.

Thanks
0
Comment
Question by:Murray Brown
2 Comments
 
LVL 34

Accepted Solution

by:
Brian Crowe earned 2000 total points
ID: 40255749
You should be able to do this from either instance by creating a linked server.

http://sqlserverplanet.com/dba/how-to-add-a-linked-server
0
 

Author Closing Comment

by:Murray Brown
ID: 40264662
Thanks very much
0

Featured Post

Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

Question has a verified solution.

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

I have a large data set and a SSIS package. How can I load this file in multi threading?
One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
Suggested Courses

834 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