Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to connect with SQL Server using http based API Expand / Collapse
Author
Message
Posted Tuesday, June 11, 2013 6:01 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, October 23, 2013 11:07 PM
Points: 4, Visits: 19
Hi,

I am new to this. I want to connect SQL SERVER 2008 with a CRM called Salesforce (without using any existing tools).
Some expert suggested me that it can be done using http based API of SQL Server 2008.
I want to know whether http based API of SQL Server is available and how it can be used.
Or is there any other way by which i can connect with SQL Server (by coding)

Please help.
Thanks
Post #1462021
Posted Tuesday, June 11, 2013 7:31 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Friday, August 29, 2014 2:32 PM
Points: 13,302, Visits: 12,168
Hi and welcome to SSC. Can you please try to explain what it is you are trying to do? From your description I cannot figure out where to begin.

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1462122
Posted Thursday, June 13, 2013 1:03 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, October 23, 2013 11:07 PM
Points: 4, Visits: 19
Hi
Thanks for ur rply..

I am working on Salesforce Platform(Cloud technology) using Apex language..
i have to connect to Sql Server from Salesforce.
Just wanted to know whether any API or something else is available for SQL Server, using which i can do the connectivity.
U may find this question as invalid on this forum.. but m not getting any solution from Salesforce forums which is according to my requirement.

pls reply
Post #1462918
Posted Thursday, June 13, 2013 7:10 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Friday, August 29, 2014 2:32 PM
Points: 13,302, Visits: 12,168
afreen281989 (6/13/2013)
Hi
Thanks for ur rply..

I am working on Salesforce Platform(Cloud technology) using Apex language..
i have to connect to Sql Server from Salesforce.
Just wanted to know whether any API or something else is available for SQL Server, using which i can do the connectivity.
U may find this question as invalid on this forum.. but m not getting any solution from Salesforce forums which is according to my requirement.

pls reply


SQL allows for connections to be made but there isn't an API. You just make a connection to the server. This can be done over the web. Take a look at http://www.connectionstrings.com/ for the exact syntax that will meet your requirements.


_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1463068
Posted Monday, June 17, 2013 3:21 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 4:14 AM
Points: 2,868, Visits: 3,215
Direct http access to SQL Server was deprecated a few releases ago and does not exist in SQL 2012. I would advise you look for an alternative solution that will continue to work after you have upgraded to a more recent version of SQL Server.

Original author: SQL Server FineBuild 1-click install and best practice configuration of SQL Server 2014, 2012, 2008 R2, 2008 and 2005. 28 July 2014: now over 30,000 downloads.
Disclaimer: All information provided is a personal opinion that may not match reality.
Concept: "Pizza Apartheid" - the discrimination that separates those who earn enough in one day to buy a pizza if they want one, from those who can not.
Post #1464039
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse