Connecting to DB using vb.net

(3) Share

Report

Posted on by CU20031439-0

Hello

We moved to the online bc (Sylogist) version some months back. When we had the on premise DB, I was able to create a form for quickly searching/viewing information from vendors/check ledger etc. I would like to adapt that code to use the online version we are on. Can someone describe how I may be able to change the connection method in the code?

Thank you

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (6)

Answers (1)

Suggested answer

Suresh Kulla 50,243 Super User 2025 Season 2 on at

Like (1)

Report

Your query is not clear. Are you trying to connect BC Saas to a different database on your server? In Saas, you cannot connect directly to a SQL or DB server, you have to use Azure Functions and then use API to retrieve or update data.

Was this reply helpful? Yes No
CU20031439-0 12 on at

Like (1)

Report

Hello

My apologies. I am not very knowledgeable on a lot of this. Like I said, we had a on premise server before. Now we work on BC online through a vendor named sylogist. I logon through the https URL. I managed to write vb.net code to connect to my on premises server and access the db (before when it was on premises) and I would like to be able to connect to the online version now and have my code work as before ( I know that I may need to do some modifications)

I was reading and someone posted a method using AL and JSON to publish a 'hello world' app to a sandbox test environment for example.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,329 Super User 2025 Season 2 on at

Like (1)

Report

You mentioned that your environment is Online (SaaS)
If it is SaaS, it cannot be done. Including partners, there is no way to directly access the database like in the On-Pre environment.

This can only be done through API and Web Service.

Thanks

ZHU

Was this reply helpful? Yes No
Verified answer

Khushbu Rajvi. 20,275 Super User 2025 Season 2 on at

Like (2)

Report

In Business Central SaaS, you cannot connect directly to the database like in on-prem. Instead, you must use APIs or Web Services to access data. You can modify your VB.NET code to interact with BC Online using Azure Functions and REST APIs.

Was this reply helpful? Yes No
Suggested answer

Gerardo Rentería Ga... 25,154 Most Valuable Professional on at

Like (2)

Report

Hi, good day
I hope this can help you, and give you some hints.

Losing Direct Access to SQL Server from Business Central SaaS

Best Regards
Gerardo

Was this reply helpful? Yes No
Vahid Ghafarpour 12,090 Super User 2025 Season 2 on at

Like (2)

Report

If any of the responses helped resolve your issue, please take a moment to mark the best answer. This helps others in the community quickly find solutions to similar problems.

To do this, simply click the "Does this answer your question?" button on the most helpful response and like the helpful posts. If your issue is still unresolved, feel free to provide more details so the community can assist further!

Thanks for being an active part of the Dynamics 365 Community!

Was this reply helpful? Yes No