Moving Files from Linux to Windows

[lubiel2]

Hello,

Someone can help me with this please,
I need support or information about
What decision I need to take.

I am newbie in linux.

I have a Linux Machine, I have a software there
which generate daily one file eg txt format.

I need to read the rows in that file
and insert it into a database in linux or
my ideal is insert it in a database SQLServer
in windows, because i have there all rest my data operation.

I need to do this in an automatic way. All my process are
automatic, it running early daily.

I dont know which databases exist in my machine linux.

What can I do in order to read rows in that file???,
insert it in one databases and read the data to
send my SQLServer database in Windows???, all in
automatic way.

I can do this situation in windows, but in Linux OS
I dont know how start, and how.

I dont know if Linux use process automatic like is
in windows Schedule Task, where I can run a perl script
for example.


Any help is greatly appreciated.

[Stuka]

Well, if the Linux box has Python on it, you could use the mxODBC python module and connect to the MS SQLServer box like that.

[Suramya]

If you have installed samba then you can directly save the result file to your Windows box and then use scripts/programs on the windows box to process it.

More information on Samba is available at:
http://www.samba.org/

Installation/Configurations instructions and more is available at:

http://us4.samba.org/samba/docs/man/Samba-HOWTO-Collection.html

Linux does have a lot of schedulers. The most common one is called cron (One of the other is 'at') If you have KDE installed you can your a GUI frontend to cron called kcron to schedule tasks otherwises you will have to do it from the command line. For more info use man cron

Hope this helps.

- Suramya

PS: Welcome to Linux & JL

[lubiel2]

Hello,

Someone knows who detect if I have installed
Python in my Linux box ???

How Install it ???

[Suramya]

Type the following command at the command prompt: whereis python

This will tell you where python is installed, if you don't have it installed it will return a blank value.

On my machine I get the following output when I run it:

[suramya@StarKnight suramya]$ whereis python
python: /usr/bin/python1.5 /usr/bin/python /usr/bin/python2.2 /usr/lib/python1.5 /usr/lib/python2.2 /usr/include/python1.5 /usr/include/python2.2


Hope this helps.

- Suramya

[lubiel2]

Thanks.

I have installed Python 2.3.2

Someone knows the way to
install mxODBC - The Python ODBC Interface
and an example for connect from Windows
MS SQL Server 7 ???

[lubiel2]

Hello,

I have samba installed, but I dont know how do this:

---
If you have installed samba then you can directly save the result file to your Windows box and then use scripts/programs on the windows box to process it.
---

How I can directly save the result file to my Windows box ???

I need to share a folder in windows ??? How ???

I did this:

[root@112 /]# smbclient -L 64.57.213.xxx
added interface ip=64.57.213.xxx bcast=64.57.213.zzz nmask=255.255.255.224
error connecting to 64.57.213.xxx:139 (Connection refused)
Error connecting to 64.57.213.xxx (Connection refused)
Connection to 64.57.213.xxx failed
[root@112 /]#


Any help is greatly appreciated.

[Suramya]

First you need to share a folder with write access on the Windows computer. Then run the following command at the linux machine:


mount -t smbfs //whatever the windows computer name is/what ever the share name is/ /whereveryouwantitmounted/


If this command doesn't work try looking through these search results (http://justlinux.com/forum/search.php?action=showresults&searchid=778178&sortby=lastpost&sortorder=descending) for more help.

Hope this helps.

- Suramya