SQL Server import csv or txt on a Solaris box Post: 302846719

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

i'm pulling my hair out getting a solaris 8 box to work as a caching name server

i've gone through the sun docs as well as a Solaris Network Admin book. while the book is fair, it lacks detail and i'm sure there are things it's missing on getting a caching only name server working. as for the sun docs... what it has is really miserable. i can't make anything out of it. ...

2. UNIX for Dummies Questions & Answers

Getting a file from win3k server on to my solaris 9 box

Hey guys, Please don't lynch me for asking this question but I'm trying to get a file from a windows 2k3 server and store it on one of my Solaris 9 machines (automated in cron or something weekly) so I can then store it to tape. I'm just trying to think of the best way to get the file and I'm...

3. Shell Programming and Scripting

From Solaris UNIX to MS SQL Server

Hello, my problem is, that I want to send an SQL-Statement via ksh-Shell to an MS-SQL-Database based on SQL Server 2005. I want to receive a file, which can be used for further actions on UNIX (Sun OS 5.9). ODBCUnix and JDBC and FreeTDS are not allowed. Does anybody have a suggestion? Br,...

4. Solaris

Can we use a solaris box as a web server?

Can we use a solaris box as a web server? If yes then can any one can explain each and every steps to configure a Solaris web server?

5. Solaris

Solaris box to AD,Exchange server 2003

Forgive me if this question has been asked before, but I am trying to add a solaris box to server 2003, it is an active directory and exchange server. I have succeeded in adding it to network in general -- meaning I can access the server and xp files over the network. But what I want to do is...

6. Programming

import .txt and split word into array C

Hi, if I want to import .txt file that contain information and the number separate by space how can I split and put into array In C Example of .txt file 3 Aqaba 49789 10000 5200 25.78 6987 148976 12941 15.78 99885 35262 2501 22.98 Thank

7. Shell Programming and Scripting

shellscript to read data from txt file and import to oracle db

Hi all, Help needed urgently. I am currently writing a shellscript to read data/record from a flat file (.txt) file, and import/upload the data to oracle database. The script is working fine, but it takes too long time (for 18000 records, it takes around 90 mins). I guess it takes so long...

8. Shell Programming and Scripting

How to import a value from txt file

Hello, I want to give a value from a txt file to my variable at my ksh script. I`ve searched on the net and I found the command variable < file.txt but it cannot see the file. The .txt file contains two values in the first and the second line. Is there any way to give the first-line value to...

9. Shell Programming and Scripting

Import 2 columns from 8 .csv files into pandas df (side by side) and write a new csv

I have 8 .csv files with 16 columns and "n" rows with no Header. I want to parse each of these .csv and get column and put the data into a new.csv. Once this is done, the new.csv should have 16 columns (2 from each input.csv) and "n" rows. Now, I want to just take the average of Column from...

10. Solaris

I can't edit a txt file shared from Window server to Solaris

Hello, I'm working with Solaris and I need to share files between Windows Server 2012 and Solaris through an authentication with an Active Directory user, where Windows Server is the "main server". All was going good, until after see the WS files and I tried to open one and modify it, but I cannot...

LEARN ABOUT DEBIAN

gammu-smsd-odbc

GAMMU-SMSD-ODBC(7)						       Gammu							GAMMU-SMSD-ODBC(7)

NAME

       gammu-smsd-odbc - gammu-smsd(1) backend using ODBC abstraction layer to use any supported database as a message storage

DESCRIPTION

       New in version 1.29.92.

       ODBC  backend  stores  all  data  in  any  database  supported by ODBC, which parameters are defined by configuration (see gammu-smsdrc for
       description of configuration options).

       For tables description see gammu-smsd-tables.

       This backend is based on gammu-smsd-sql.

SUPPORTED DRIVERS

       On Microsoft Windows, Gammu uses native ODBC, on other platforms, unixODBC can be used.

LIMITATIONS

       Due to limits of the ODBC interface, you might have to tweak SQL queries to work in used SQL server, see SQL Queries for more details.

       Partially this can be configured using SQL.

CONFIGURATION

       Before running gammu-smsd you need to create necessary tables in the database. You can use examples given  in  database	specific  backends
       parts of this manual to do that.

       You specify data source name (DSN) as Host in gammu-smsdrc. The data source is configured depending on your platform.

       On Microsoft Windows, you can find instructions on Microsoft website: http://support.microsoft.com/kb/305599

       For unixODBC this is documented in the user manual: http://www.unixodbc.org/doc/UserManual/

EXAMPLE

       Example configuration:

       [smsd]
       service = sql
       driver = odbc
       host = dsn_of_your_database
       sql = sql_variant_to_use
       user = username
       password = password

       See also

	      gammu-smsdrc

AUTHOR

       Michal iha <michal@cihar.com>

COPYRIGHT

       2009-2012, Michal iha <michal@cihar.com>

1.31.90 							 February 24, 2012						GAMMU-SMSD-ODBC(7)

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

i'm pulling my hair out getting a solaris 8 box to work as a caching name server

Discussion started by: xyyz

2. UNIX for Dummies Questions & Answers

Getting a file from win3k server on to my solaris 9 box

Discussion started by: kingdbag

3. Shell Programming and Scripting

From Solaris UNIX to MS SQL Server

Discussion started by: usagi67

4. Solaris

Can we use a solaris box as a web server?

Discussion started by: Sesha