How to connect to a database
-
I have a net management application (coded in Win32 API) and need to have a database connectivity. Idea is that an agent would run on each computer on the network and collect information about it and send it to a central database (probably MySQL). What is the best way to send this info? I don't want to use COM, not very familiar with it and want to keep app as simple as possible. :) Thanks Regards, Venet. Donec eris felix, multos numerabis amicos.
-
I have a net management application (coded in Win32 API) and need to have a database connectivity. Idea is that an agent would run on each computer on the network and collect information about it and send it to a central database (probably MySQL). What is the best way to send this info? I don't want to use COM, not very familiar with it and want to keep app as simple as possible. :) Thanks Regards, Venet. Donec eris felix, multos numerabis amicos.
-
hi, There are many ways, but first what kind of database you use? (Oracle or MS Access database) and what development envir. you are using? (VC++ 6.0 or VB6) DanielO
Thanks for your interest. I'm using VC++ 6.0. There is a MySQL database running of a Linux server, and I need to connect to that database, to provide information about each PC, so the net admin could run a simple query and see the state of the network and of course each machine as well. So what's the easiest way to connect to this database? Don't really want to use COM as this is quite time limited project. Thanks Regards, Venet. Donec eris felix, multos numerabis amicos.
-
Thanks for your interest. I'm using VC++ 6.0. There is a MySQL database running of a Linux server, and I need to connect to that database, to provide information about each PC, so the net admin could run a simple query and see the state of the network and of course each machine as well. So what's the easiest way to connect to this database? Don't really want to use COM as this is quite time limited project. Thanks Regards, Venet. Donec eris felix, multos numerabis amicos.
hi, i suppose you can do like this... go windows, control panel, data sources obbc (via system/admin tools in W2K) tab system dns add new choose sql server... etc. in MFC 6.0 Add a new class, derived of CRecordSet, choose your new made sql server connection and pick your table hope it helps, DanielO