I have a running inventory application in php/mysql that involves inventory management.this way(php/mysql) I can only sell the products online.
now a days I am making a vb.net application for that inventory system so that my agents can get the orders offline also.for that vb.net application I have made an access database which is going to be offline always,the initial problem that I am facing is with the vb.net and mysql connection.I have connected vb.net and mysql through myodbc (mysql driver) but the problem is I have to make an DSN for that in client or agent computer (which I dont want )cause nowbody would like to handover its database details to its employees,inshort I need to solve the following issues:
1.vb.net and mysql connection without myodbc or DSN.I dont want to leave my connection username and password open through DSN
2.connecting to remote host file system to download new product pictures after checking local access database (I dont know wheather I have to use ftp or http or sock)?????
yours help is highly appriciable,
thanxs