Access SQL database from my website

[Carty]

Hello,

I need to create an application which should access a database stored in a website. Is it possible to access MySQL databases? I currently have a website running on linux server and have MySQL databases. Is it possible to use them? Or is there any way to make an application read and write to a database or file stored on the net and i want to restrict access to that file for third persons. Can someone help me please. I know only VB .net.

Thanx a milllion in advance.

Regards
Carty..

 

[kulrom]

The only way is remote (external) connection with mySQL if your hosting allows it ... otherwise, asp.net is technology that cannot be run from Linux OS.

 

[Carty]

Hello kulrom,

Thanx a lot for your quick reply. Yes, my hosting allows remote connection to MySQL databases. So now can you help me how to read/write to the database. Im a beginner with little knowledge in VB.net so can you please provide me a detailed sample application for this. Thanx a lottt again in advance.

Regards
Carty..

 

[kulrom]

I see ... but where the asp.net app will be hosted? Local computer or ..???
Also you must choose connection driver. I would suggest MySQL Connector/Net ... then you can make a connection and access your data.
Actually, i just noticed that you are asking about CF rather but asp.net.
Well i have never tried to establish conn with mySQL from CF code. Maybe it is the same but i cant confirm that at the moment.