Database connection to Visual C or VB in Visual studio

Hello, I am new here!

Where do I find the ERP-related information to access our  ERP data ?
Read only for now at least!
I have most of the database stuff like data set , data adapters and connection strings  sorted out in Visual Studio for local data.  But I have no idea how to practically connect to web based ERP, or how to download the data base(s) for local access. 
The default data base options provided  in VS are:
MS Access database file
MS SQL server
MS SQL server database file

and <other>, and I have no idea of limitations... 
 
Looking forward to advice!
Sten



----
Shipco Circuits Ltd. http://www.ship.ie/

All business is conducted subject to NL 01 E.



Note:

 

If you are posting an issue,

  1. We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

     

    End of Note



    You received this message because you are subscribed to the Google Groups “ERPNext Developer Forum” group.

    To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un…@googlegroups.com.

    To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/ab73b813-985c-471b-82ac-3a13b6e87b84%40googlegroups.com.

    For more options, visit https://groups.google.com/d/optout.
ERP uses the MySQL Database , so you need to look for ODBC connection strings for MySQL and connect to the remote database.

On Thursday, 27 March 2014 14:14:01 UTC+3, Sten Björsell wrote:
Hello, I am new here!

Where do I find the ERP-related information to access our  ERP data ?
Read only for now at least!
I have most of the database stuff like data set , data adapters and connection strings  sorted out in Visual Studio for local data.  But I have no idea how to practically connect to web based ERP, or how to download the data base(s) for local access. 
The default data base options provided  in VS are:
MS Access database file
MS SQL server
MS SQL server database file

and <other>, and I have no idea of limitations... 
 
Looking forward to advice!
Sten



----
Shipco Circuits Ltd. http://www.ship.ie/

All business is conducted subject to NL 01 E.



Note:

 

If you are posting an issue,

  1. We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

     

    End of Note



    You received this message because you are subscribed to the Google Groups “ERPNext Developer Forum” group.

    To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un…@googlegroups.com.

    To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/4196c2f4-8946-4103-a016-2fc9d260f551%40googlegroups.com.

    For more options, visit https://groups.google.com/d/optout.
Hi, Steven!

If you have the need to modify data starting another application, do not use a direct access to the database.

Do this through the web API, which is here https://github.com/frappe/wn-client


The implementation is developed in Python, but I believe it will not be difficult reuses there, you can re-implement in VB.Net or usalá directly in VB.Net installing IronPython in your Visual Studio.


2014-03-27 9:21 GMT-03:00 Syed Qadeer <sd...@gmail.com>:
ERP uses the MySQL Database , so you need to look for ODBC connection strings for MySQL and connect to the remote database.


On Thursday, 27 March 2014 14:14:01 UTC+3, Sten Björsell wrote:
Hello, I am new here!


Where do I find the ERP-related information to access our ERP data ?
Read only for now at least!
I have most of the database stuff like data set , data adapters and connection strings sorted out in Visual Studio for local data. But I have no idea how to practically connect to web based ERP, or how to download the data base(s) for local access.
The default data base options provided in VS are:
MS Access database file
MS SQL server
MS SQL server database file

and <other>, and I have no idea of limitations...
Looking forward to advice!
Sten



----
Shipco Circuits Ltd. http://www.ship.ie/

All business is conducted subject to NL 01 E.



Note:



If you are posting an issue,

  1. We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.



    End of Note



    You received this message because you are subscribed to the Google Groups “ERPNext Developer Forum” group.

    To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un…@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/4196c2f4-8946-4103-a016-2fc9d260f551%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.



--

Best Regards.

Maxwell Morais
Python Developer powered by Webnotes framework <3
+55 11 954329659




Note:

 

If you are posting an issue,

  1. We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
  2. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  3. For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.

     

    End of Note



    You received this message because you are subscribed to the Google Groups “ERPNext Developer Forum” group.

    To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un…@googlegroups.com.

    To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/CABK1YkPgLQGE8sMC9bTK6wk-%3DgsCP-xm%2BGW0EFXt4q7vQ1d%2BeA%40mail.gmail.com.

    For more options, visit https://groups.google.com/d/optout.

Hi all,

just came accross this post from a search engine. As it might be relevant for others, here a quick update: I agree with @max_morais_dmm that the API is the way to go for when interacting with ERPNext from Visual Studio. And there is a wrapper for the API for Visual Studio in C# (which also works in VB): https://github.com/libracore/ERPNextSharp