07-15-2009
Ubuntu Bulk Insert to Windows SQLServer
Hi,
Anyone can help me, I can connect from ubuntu "freetds driver" to Windows sqlserver Database and doing select, insert, update, etc.
But when I try to use the Bulk Insert with these command;
1> BULK INSERT test FROM '/home/test/test.txt' WITH (FIRSTROW = 2, CODEPAGE = 'ACP', DATAFILETYPE = 'char', FIELDTERMINATOR = ',',ROWTERMINATOR = '\n')
2> go
Msg 4861, Level 16, State 1, Server GMSERVER, Line 1
Cannot bulk load because the file "/home/test/test.txt" could not be opened. Operating system error code 3(The system cannot find the path specified.).
Thanks in Advance.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi:
How will I execute a Stored Procedure that sits on NT/SQLServer.
Any help would be appreciated.
Thanks (3 Replies)
Discussion started by: mayohan
3 Replies
2. AIX
I have an application working in unix accessing oracle 9i database on a IBM AIX Unix 5.2 system.
I want this unix application to retrieve data from a SQL server 2000 server to oracle database.
how can i connect to this SQL server database from a unix application
pls help me if you can (2 Replies)
Discussion started by: samsonsimon
2 Replies
3. Shell Programming and Scripting
Hi,
I am doing a migration of Oracle database to SQLSERVER 2005.Mostly my application code is perl scripts and i want to modify the scripts so as to connect to SQLSERVER.
What all would be the changes i have to make for just establishing a connection from Perl script to SQLSERVER... (3 Replies)
Discussion started by: DILEEP410
3 Replies
4. UNIX for Dummies Questions & Answers
hi all..
i need to install RHEL5 on my machine.
m having 15gb of primary partition reserved for this.....
problem is: i have WindowsXP and Ubuntu 8.10 already running ......
XP on first primary and Ubuntu on logical.
Please help me installing RHEL5 without disturbing XP... (0 Replies)
Discussion started by: AVINAZZ
0 Replies
5. UNIX for Dummies Questions & Answers
I am sure this is simple to do but as a newbie to UNIX i don't know much.
I have Ubuntu installed on my machine alongside windows 7.
How do i access all the folders, files and more importantly programs and softwares installed on Windows so i can use them in Ubuntu instead of going back and... (1 Reply)
Discussion started by: pipsonian
1 Replies
6. Windows & DOS: Issues & Discussions
Hello,
How can I please have a program automatically upload some files from a ubuntu server to my machine desktop that is running windows XP? I would like to be able to do that from the windows machine itself.
Thanks, (3 Replies)
Discussion started by: Pouchie1
3 Replies
7. Debian
HI ! all
I have some model which works fine in windows 7 OS with matlab program I want to run all those from Ubuntu 12.04 32-bit OS.
is there any provision to run windows applications? wine I tried, its not working, if any other available kindly explain the usage also
Note : Dual boot ... (5 Replies)
Discussion started by: Akshay Hegde
5 Replies
8. Shell Programming and Scripting
hi, i'll want to try on the parameter with three possibility because mine colleagues usally to work on the other name folders.
for example:
MSSQL
SQL SERVER
SQLSERVER
case $q in
a) echo -ne "Work database: "
echo ""
echo " 1) ORACLE"
echo... (4 Replies)
Discussion started by: gsflash80
4 Replies
9. Ubuntu
guys tell me steps to install ubunto of linux kali over
windows 7 (0 Replies)
Discussion started by: Roshan4u
0 Replies
10. Shell Programming and Scripting
Hello,
Objective is to insert bulk values in DB table using isql.
Following code tried:
isql -SServer_name -Ddb_name -Uuser_name -Ppassword < file.txt
cat file.txt
for i in `cat data_value_file.txt`
do
insert into tempdb..temp_table11 values ('$i')
go
done
cat... (3 Replies)
Discussion started by: manishdivs
3 Replies
LEARN ABOUT OPENSOLARIS
test-speech
test-speech(1) User Commands test-speech(1)
NAME
test-speech - a test application provided by gnome-speech
DESCRIPTION
test-speech is a simple test application provided by gnome-speech. It is used to verify the driver for a speech engine, e.g., freetts-syn-
thesis-driver, is funcioning properly, in order to make sure users can activate and interact with the gnome-speech driver successfully.
GNOME Speech aims to be a general interface to various text-to-speech engines for the GNOME desktop. It allows the simple speaking of text,
as well as control over various speech parameters such as speech pitch, rate, and volume.
FILES
The following files are used by this application:
/usr/bin/test-speech a test application provided by gnome-speech
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Availability |SUNWgnome-a11y-speech |
+-----------------------------+-----------------------------+
|Interface stability |Volatile |
+-----------------------------+-----------------------------+
SEE ALSO
libgnomespeech(3), attributes(5)
NOTES
gnome-speech is written by Marc Mulcahy and Michael Meeks.
SunOS 5.11 3 Dec 2006 test-speech(1)