Page 1 of 1 1
Topic Options
#7321 - 2001-03-05 03:34 PM Kix and SQL
Anonymous
Unregistered


Can kixscript talk to a SQl Server Database. I know that kix can use redirectoutput command to output certain records to a .csv file but can in output records to a SQl database.

Regards

Top
#7322 - 2001-03-06 12:08 AM Re: Kix and SQL
cj Offline
MM club member
*****

Registered: 2000-04-06
Posts: 1102
Loc: Brisbane, Australia
I have an HTML/VBS solution for this, but not KiX yet. With OLE almost all things are possible, so I may be able to get KiX to either talk to my VBS or use OLE to run VBS commands and/or via a web page.

I have posted some of this HTML/VBS stuff here before, have a search...


cj

------------------
For more scripts goto my website and click the hammer and spanner icon.

chrismat@ozemail.com.au

Top
#7323 - 2001-03-07 10:39 PM Re: Kix and SQL
Anonymous
Unregistered


I was interested in writing to SQL and Access databases to, but couldn't find an esy way to do it. My solution, cheesy though it may be, was to write my data to a text file, putting in characters to delimit the fields, and then having the database import the info any time it is started. This also required using a query to sort out all the duplicates because the script would just keep writing every time someone logged on, and this created many redundant entries.

My application was generating a list of tasks for our help desk.

-=Jim=-

Top
#7324 - 2001-03-09 03:04 PM Re: Kix and SQL
Anonymous
Unregistered


Thanks fo all the help. I will probably do the same with the text file
Top
Page 1 of 1 1


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

Who's Online
0 registered and 764 anonymous users online.
Newest Members
ManuvdWielNL, Sir_Barrington, batdk82, StuTheCoder, M_Moore
17887 Registered Users

Generated in 0.048 seconds in which 0.024 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