# Local SQL server DB connection
**URL:** https://community.thunkable.com/t/local-sql-server-db-connection/1064035
**Category:** Questions about Thunkable X
**Tags:** database
**Created:** [January 22, 2021, 1:49pm UTC](https://community.thunkable.com/t/local-sql-server-db-connection/1064035 "2021-01-22T13:49:14Z")
**Posts on this page:** 10
**Page:** 1
### Author:  [@Giuseppe\_Geppo\_Catta](https://community.thunkable.com/u/Giuseppe_Geppo_Catta)
#### Post date: [January 22, 2021, 1:49pm UTC](https://community.thunkable.com/t/local-sql-server-db-connection/1064035/1 "2021-01-22T13:49:14Z")
Hi,
is there a way to connect with an SQL server DB in a private network using thunkable?
Better if using OLEDB
thank you!
---
### Author:  [@muneer](https://community.thunkable.com/u/muneer)
#### Post date: [January 22, 2021, 3:29pm UTC](https://community.thunkable.com/t/local-sql-server-db-connection/1064035/2 "2021-01-22T15:29:00Z")
If your SQL Server DB provides API connections then YES.
---
### Author:  [@Giuseppe\_Geppo\_Catta](https://community.thunkable.com/u/Giuseppe_Geppo_Catta)
#### Post date: [January 22, 2021, 4:16pm UTC](https://community.thunkable.com/t/local-sql-server-db-connection/1064035/3 "2021-01-22T16:16:52Z")
At the moment I connect to the DB using a connection string with OLEDB as provider using LabVIEW
---
### Author:  [@luv.ak.tech](https://community.thunkable.com/u/luv.ak.tech)
#### Post date: [January 23, 2021, 3:19am UTC](https://community.thunkable.com/t/local-sql-server-db-connection/1064035/4 "2021-01-23T03:19:05Z")
as he said if you have a api for that than you can else no
---
### Author:  [@Giuseppe\_Geppo\_Catta](https://community.thunkable.com/u/Giuseppe_Geppo_Catta)
#### Post date: [January 23, 2021, 7:05am UTC](https://community.thunkable.com/t/local-sql-server-db-connection/1064035/5 "2021-01-23T07:05:14Z")
What does It means “if I have an api”?
It’s Microsoft SQL SERVER. Is there an api for It?Does It provide an api by itself?
---
### Author:  [@muneer](https://community.thunkable.com/u/muneer)
#### Post date: [January 23, 2021, 7:12am UTC](https://community.thunkable.com/t/local-sql-server-db-connection/1064035/6 "2021-01-23T07:12:31Z")
This is a good read
> **[How to Code a REST API for Microsoft SQL Server: The Hard Way and the Easy Way...](https://blog.dreamfactory.com/how-to-code-a-rest-api-for-microsoft-sql-server-the-hard-way-and-the-easy-way/)**
>
> We’ll look at the steps, timing, and cost of hand-coding a bespoke SQL Server REST API, so you can build the perfect application!
---
### Author:  [@Giuseppe\_Geppo\_Catta](https://community.thunkable.com/u/Giuseppe_Geppo_Catta)
#### Post date: [January 23, 2021, 7:39am UTC](https://community.thunkable.com/t/local-sql-server-db-connection/1064035/7 "2021-01-23T07:39:40Z")
Ok, so It seems ti me that the answer for my needs in NO. ☹
No direct thunkable way.
Reading the article It seems to me I should provide credentials to Dreams factory service, And have a PC with dreamfactory installed that work as http server. Too tricky for me
I can’t do this, I’m not amministrator of the net.
I expected a DB “plugin” to connect using connection string end execute query.
---
### Author:  [@muneer](https://community.thunkable.com/u/muneer)
#### Post date: [January 23, 2021, 7:56am UTC](https://community.thunkable.com/t/local-sql-server-db-connection/1064035/8 "2021-01-23T07:56:22Z")
This is one way but you can call it with browser API
See this article
> **[How to quickly create a simple REST API for SQL Server database](https://medium.com/voobans-tech-stories/how-to-quickly-create-a-simple-rest-api-for-sql-server-database-7ddb595f751a)**
>
> In IT consulting projects, we frequently have to use an existing database. Here’s how to create a simple REST API for a database in SQL Server using Node.js and the two modules Express (a Web…
Yes, it requires a kind of service but this is again a versatile terminology.
---
### Author:  [@domhnallohanlon](https://community.thunkable.com/u/domhnallohanlon)
#### Post date: [April 2, 2021, 9:05pm UTC](https://community.thunkable.com/t/local-sql-server-db-connection/1064035/9 "2021-04-02T21:05:02Z")
> [@Giuseppe\_Geppo\_Catta](#):
>
> It’s Microsoft SQL SERVER
Not sure if your server supposed postgreSQL but would this be an option for you @Giuseppe_Geppo_Catta?
[https://www.sqltoapi.com/](https://www.sqltoapi.com/)
---
### Author:  [@ioannis](https://community.thunkable.com/u/ioannis)
#### Post date: [November 8, 2024, 1:30pm UTC](https://community.thunkable.com/t/local-sql-server-db-connection/1064035/10 "2024-11-08T13:30:35Z")