Database connection to Visual C or VB in Visual studio

[Sten Björsell]

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.

[Syed Qadeer]

ERP uses the MySQL Database , so you need to look for ODBC connection strings for MySQL and connect to the remote database.

[Maxwell Morais]

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.

--
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...@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