I know that SQL Server runs on Windows Server, is it possible to download data in UNIX using shell script? does SQL Server has any binary or command line client for any operating system other than Windows?
View 5 RepliesI've got a question about the UNIX timestamp solutions, I am using this one:
select convert(datetime, switchoffset(convert(datetimeoffset, dateadd(second, start_date, '19700101')), datename(TzOffset, sysdatetimeoffset())))
from x
This works great for today (wintertime), but when I query the past, say last week, it will still hold the current offset of my server GMT+1, where it was GMT+2.
Is there a way to get always the right date/time from a sql-query?
Outlook says 'to prevent your privacy outlook prevented the image download' I don'y want users to right click and download image from the 'empty box'.Here is my code:
SET @EMAIL_CONTENT = '<html>'+CHAR(10)
+ ' <body>'
+ ' <p> '
+ ' Happy Birthday..! '
+ ' <span style="font-size:large;">'
+ @FIRST_NAME
+ ' </span>' +CHAR(10)
[code]....
Hello !
I am owrking in java developmenton solaris using weblogic6.0
Does any body know how to access sql server data from solaris.
If some body knows that, can you please post me the steps
that i need to do it.
Thanks
Veena
First, let me start by saying I know the answer to this, but due to politics any answer I give will be viewed with some disdain and disbelief.
A Unix/Network [rtdpmin one our sister agencies is trying to solve a problem that really does not need to be solved, but ....
The sister agency uses Information Builder's WebFocus on Unix. When they try to read my data warehouse in SQL Server 2000 it times out on them (on their end and they claim they cannot fix it) (This is using the supplied WebFocus ODBC/JDBC driver for SQL Server). This has lead to accusations of us not letting them read the data.
After much gnashing of teeth over "if you do data and data analysis for a living, why do I have to show you how to set-up an ODBC connection" we have shown them how to connect to the data, read it, and transfer it using MS-ACCESS, EXCEL, and more importantly SPSS. This is not good enough because they cannot figure out how to put it into WebFocus.
Their network person has come-up with the brilliant idea of reading the .mdf directly by installing Windows for Unix on the Unix side and then just pointing to the .mdf file and "reading it ".
Unless I have missed something somwhere (I will admit possible), I know you need a driver to read MS-SQL and that driver in every example I have seen could care less about the physical location of the .mdf file. It wants to know what database, what server (ip or name) and what security/login to use.
Could someone give me a more "technical answer" or even Microsoft's party line so I do not have this person mucking around with my production server trying to acomplish the impossible.
Hi I am trying to download data from one sql server to a local table. What are my options?
Thanks.
I have an SSIS package that inserts website URLs from a SQLServer table into a variable used by an HTTP Connection Manager, then downloads the data files from those URLs using a ForEach Loop and a Script Task. Works beautifully when a data file is found at the URL, but hangs if no data file is found. I've set the Timeout property on the HTTP Connection Manager to 30 seconds, but doesn't work. how to first check if a data file exists, of if the request returns nothing, or how to trap this situation in a try-catch?
Here is the VB code I'm using in the Script Task:
Public Sub Main()
Try
' Connect to website using HTTP connection manager
Dim nativeObject As Object = Dts.Connections("HTTP Connection Manager").AcquireConnection(Nothing)
' Create a new HTTP client connection
Dim connection As New HttpClientConnection(nativeObject)
[code].....
Hi, I have a script written in ASP to load data file (.csv) to ms sql. In the script, I have a portion of script looks like taht :
.....
Do While NOT oInFile.AtEndOfStream oOutFile.WriteLine Replace(oInFile.Readline, chr(13), vbcrlf)Loop
.....
After that, I will use a BULK INSERT to input data to ms sql.
I am wondering how do I convert each row (data) to vbcrlf in Stored Procedure? Coz' I did not compose the convertion part, and I got no error when running BULK INSERT, but no rows are inserted :( HELP!!!!
I guess it's because the file is not being converted into a correct format??
It seems to me that files created on Unix machines with line terminator , or chr(10), cannot be imported using the Bulk Insert statement. Is this a bug, or an oversight by Microsoft? Does this mean that unless one replaces all with
, there is no way to use Bulk Insert to import Unix files? This is a very strange behavior by MSSQL. Even lessor programs such as Excel and Word automatically recognize chr(10) as a line termination character. Am I missing something, or is this just the way MSSQL is?
Get a filestream download link with only access to read and with folder navigation
I need a link with the path to get the file stream blob, that path could be used to download a document using any windows app like windows explorer, etc. the requirement is that path does not allow customer to navigate in filesstream share folders or see other files and only can read the file of the path,
Checking :
[file_stream].GetFileNamespacePath(2)
Allow you navigate in folders.
NON_TRANSACTED_ACCESS read_only, resolve the requirement to disable the save in file table, but allow you navigate and see other files.
I am very new to this board and I am not sure whether the following question belongs to this board. I will ask it anyway.
Can someone tell me where (book or web site or an example) I can go to learn how to be able to connect to a SQL Server database in a unix (in my case Solaris) environment using C/C++. I have been doing database programming using Oracle, Acess on NT with C/C++/ODBC comfortabley. I just need to learn how to go about in a Unix environment.
Wango
Are there any tools for installing SQL Server on a unix machine? (It seems to me like 6.5 might have been the last version that worked on unix?)
View 4 Replies View RelatedHas anyone tried to connect to a SQL Server 2K running on Windows 2000 from a unix machine? If so then could you provide me some help?
Thanks in advance
I have UNIX application, running on AIX, SUN and HP, (RISC & Itanium).
This application working with Oracle, via OCI, and OCCI, (I can use ODBC as well).
I would like replace Oracle with SQL-Sever.
Does there is a way/driver to access MS-SQL Server from Unix?
We are running SCO Unix 5.0.5. We need a command line sql client that can connect to a MS SQL server running on a windows server. Can someone point me in the right direction? I don't want to write a sql client. I just want a command line sql client binary that is ready to work.
I want to do something like this in a unix shell script:
# sql -s 10.1.2.3 -u username -p password -f sqlcommandsinafile.txt -o sqlresults.txt
Any help would be appreciated....
Hi,
My program is running on UNIX, (SUN, AIX and HP), and work with Oracle.
I would like to use SQL-Server instead of Oracle, but the program must run on UNIX.
Is there is a way/driver to work with SQL-Server from UNIX?
*new in SQL-Server area...
Thanks
Is it possibel to run a DTS job to read a file from unix server?
View 4 Replies View RelatedHi,I am having a problem accessing SQL Server 2000 via UNIX. I amaccessing SQL Server 2000 from Solaris using Sybase Open Client(CT-Lib). Here is the error message:CT-LIBRARY error:ct_connect(): network packet layer: internal net libraryerror: Net-Library operation terminated due to disconnectI have another SQL server 6.5 and I do not have any problems accessing6.5 using the same strategy. Can someone tell me how I shouldconfigure to access SQL Server 2000 from UNIX?Thanks,Amy
View 1 Replies View RelatedHi, everyone!I was just wondering if any of you knows of a linux/unix client(preferably on the command line) that would connect to ms sql server?Any hints would be appreciated!Roumen.
View 1 Replies View RelatedI have a windows server 2003 R2 sharing a filesystem using NFS. I have created a group and passwd file and mapped the ids' to the unix login ids' . I', able to mount but when I try to cd to the directory I get "NFS access failed for server testsrvr: RPC: Authentication error". On the win2k3 server I'm getting an event error "There was a mapping failure". I have the Admin id on the win2k3 server mapped to the unix root login .
View 1 Replies View RelatedHi,
I am new to SQL server, currently using 2005, my web server using 2000, we have also 2000 installed, which has enterprise.
I would like to create a schedual for daily data download to our local server, if it is possible in 2005, or may be we can use 2000 enterprise, but I am really stuck how to set this into my system.
Please someone help...
I was a Oracle Developer / DBA on Unix Environments all along my career, Very recently iam starting to manage a SQL Server 2005/Windows 2003 Server setup.
Part of my new job is to automate to load Huge Data files/Flat Files (3/4 GB in size) into SQL Server 2005 DB.
Have these initial questions..
Since the files are too large to open at once... What sort of Command Line Interfaces people use on the Windows Boxes.. like doing a "wc" (Word Count) / GREP 'ng Files / Massaging Data Files one line at a time (Like using SED / AWK Commands).. Etc
Any Input / Direction is appreciated...
Hello,
How can I assign the ODBC Database(Progress) on UNIX as publisher and SQL Server as subscriber. When I use the Enterprise Manager, I cannot see the Unix Server. I just can see the server and database in DTS.
Would you please explain the steps?
Alice
Hello,
I am trying to connect to a Microsoft SQL Server 7.0 from a SCO box (version 3.2v4.2)using sisql/bcp (sybase product). I can connect to a 6.5 database but when I try the same script to connect to 7.0 I get the following message: DB-LIBRARY error:
Unable to connect: SQL Server is unavailable or does not exist.
Is there anything I can do in order to fix this problem? Any ideas?
Thanks
HI...I wonder if anybody could assist my problem. I am very new to online. I have bought a DIY portal and hosting. It is on SQL server.
I wanted to do a lead capture page and put an Autoresponder to it. I bought AD 2019 and Porfit Sponder, but it's requirement is UNIX operating system.
1. Can I link the AR(needs UNIX) to my site on SQL ?
2. Does it need a device to translate any data ?
Regards,
Lena
Money is in the lists...where did my money go?
http://simurl.com/more-E-GOLD
http://simurl.com/Top3Percent
Hi,
I am new to SQL server, currently using 2005, my web server using 2000, we have also 2000 installed, which has enterprise.
I would like to create a schedual for daily data download to our local server, if it is possible in 2005, or may be we can use 2000 enterprise, but I am really stuck how to set this into my system.
Please someone help...
I HAVE ONE COLUMN CONTAING THE INTEGER TYPE DATA COMING in UNIX DATE FORMAT. NEED TO CONVERT IT TO THE SQL SERVER DATE TIME FORMAT.
NOTE: UNIX IS STORING THE DATE IN SECONDS STARTING FROM 1970/1/1
ANYBODY CAN HELP ME TO SOLVE THIS PROBLEM.
e.g. The UNIX date time is 973101026 need to be converted to SQL DATE TIME
Anyone support a config where you have an unix/linux (AIX here) ODBC client connection to SQL Server database? I am looking for a simple, supportable configuration that does not require me to learn perl or instal a bunch of crap gnu shareware on enterprise class machines.
Please help!
Hi,
Is there as way to access SQL SErver DB for DML Operations from C++ programs in UNIX/LINUX. The current approach is by uisng Pro C to connect to ORACLE from C++. But I want to connect to SQL Server 2005.
Regards,
Kart
Anyone support a config where you have an unix/linux (AIX here) ODBCclient connection to SQL Server database? I am looking for a simple,supportable configuration that does not require me to learn perl orinstal a bunch of crap gnu shareware on enterprise class machines.Please help!
View 3 Replies View RelatedHi there.
I'm trying to extract data from my SQL server & everything in the script I've got is working (extracting correct data) except for one field - which is for the most part it's off by +2 days (on a few occasions - I see it off by just +1 day or even +3, but it's usually the +2 days).
I'm told that it's due to the conversion formula - but - since SQL is not my native language, I'm at a bit of a loss.
The DB table has the date field stored as a type: CHAR (as opposed to 'DATE')
Can anyone out there help?
Please advise. Thanks.
Best.
K7
I think I am definitely thrashing and am not getting anywhere on something I think should be pretty simple to accomplish: I need to pull the total amounts for compartments with different products which are under the same manifest and the same document number conditionally based on if the document types are "Starting" or "Ending" but the values come from the "Adjust" records.
So here is the DDL, sample data, and the ideal return rows
CREATE TABLE #InvLogData
(
Id BIGINT, --is actually an identity column
Manifest_Id BIGINT,
Doc_Num BIGINT,
Doc_Type CHAR(1), -- S = Starting, E = Ending, A = Adjust
Compart_Id TINYINT,
[Code] ....
I have tried a combination of the below statements but I keep coming back to not being able to actually grab the correct rows.
SELECT DISTINCT(column X)
FROM #InvLogData
GROUP BY X
HAVING COUNT(DISTINCT X) > 1
One further minor problem: I need to make this a set-based solution. This table grows by a couple hundred thousand rows a week, a co-worker suggested using a <shudder/> cursor to do the work but it would never be performant.
I want to select weekly data from daily data.lets say Today's date-10/23/2014(Thursday) My data is in date time but i want to see only date
output should be from last week Thursday to this week Wednesday. similar for previous dates
Weekly sum(profit)
10/16 - 10/21 - $1000
10/9 - 10/15 - $4100
10/2 - 10/8 - $ 8038
--
--
--