On 13/08/10 14:36, George Gallen wrote:
> I'm making the assumption that the UV server is on Unix, and the SQL
> server is on ... Well, windows.
That assumes that it is MS SQL-Server, and not just any old SQL server
such as MySQL, PostgreSQL etc.
> Using perl, there is nothing that needs to be added to the windows system,
> or any configuration changes (other than allowing the IP of the unix
> machine to connect and/or with a particular username).
And if it's some other SQL server, on nix, it's not a problem either.
I've been writing a little Perl/Tcl/MySQL database and it's pretty
trivial. Reading csv's where the data came from and dumping it into the
DB, and also creating screens to update the db directly. Running on gentoo.
> Nor, any services to start or schedule to read the flat files into MSSQL
> No ODBC's to install on unix or windows that are not already there.
>
> Create a VOC pointer to /tmp for instance
> Write out a flat file to that VOC FILE
> SH -c 'perl uploadfile.pl -f filenameintmp'
>
Cheers,
Wol
_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
