Page 1 of 1 1
Topic Options
#103060 - 2003-07-17 07:46 PM Storing Data to a table
Incognito Offline
Getting the hang of it

Registered: 2001-07-09
Posts: 66
I'm sure there is a way but I need some guidance..

I'm sure there is a way, but I need some guidance..

I am currently creating a text file for each station that logs into my network containing workstation & user specific info (IP address, name, password age, etc.)

Is there a way to combine all of these log files into a database table?

I would need to have a record for each PC indexed on user name. I also envision the process to overwrite the record the next time that user ran the login script.

Has anyone else done anything like this?

Top
#103061 - 2003-07-17 07:53 PM Re: Storing Data to a table
Howard Bullock Offline
KiX Supporter
*****

Registered: 2000-09-15
Posts: 5809
Loc: Harrisburg, PA USA
Unless you can guarantee that all of your clients have the proper ADO or ODBC capability I would write the data to a text file based on the computer name and then have a secondary process to parse the text files and write the data to a database of your choosing.

See Jens' fine DB... UDFs in the UDF Library.
_________________________
Home page: http://www.kixhelp.com/hb/

Top
Page 1 of 1 1


Moderator:  Arend_, Allen, Jochen, Radimus, Glenn Barnas, ShaneEP, Ruud van Velsen, Mart 
Hop to:
Shout Box

Who's Online
1 registered (Allen) and 1334 anonymous users online.
Newest Members
Viginette, ManuvdWielNL, Sir_Barrington, batdk82, StuTheCoder
17888 Registered Users

Generated in 0.048 seconds in which 0.023 seconds were spent on a total of 12 queries. Zlib compression enabled.

Search the board with:
superb Board Search
or try with google:
Google
Web kixtart.org