MS SQL Server Client Under Linux/unix.
Jul 20, 2005Hi, 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.
ADVERTISEMENT
Access SQL Server 2005 From C++ Programs In UNIX/LINUX
May 17, 2007Hi,
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
Integration With Unix/linux
Aug 9, 2000Hi
we are in an envireonment where we use unix/linux mostly.. there are a lot of apps that run on this environment(eg coldfusion)now the concern for us is to be able to access the sql database on the NT/win2k boxes..what could be a solution for this are there any drives that any one can suggest for talking from unix to nt??
thanks
sri
Native SQL 2005 Driver For PHP Under Linux/Unix
Oct 16, 2007Hello!
I'm looking a native driver for SQL 2005 running under Linux/Unix!
Or Is accessible anywhere source code of the existing driver for php?
I tried FreeTDS, but it has some bugs and has no support.
Is there any good solution for this problem?
Thanks!
Linux SQL Server Client
Jan 26, 2007Hi,
Does Microsoft provide SQL Server Client for Linux, specifically SLES 9 64 bit? If none from Microsoft, any suggestion for third party package of SQL Server Client for SLES9 64bit? Thanks
Weidong
Girl In Need! Anyone Do This: Unix Client -&> ODBC -&> MSSQL Server
Jul 28, 2004Anyone 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!
Is It Possible To Use A Simple ODBC Config On A Unix Client To Connect To MS-SQL Server?
Jul 20, 2005Anyone 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 RelatedUsing ReportViewer Web-control From Linux Client
May 5, 2007I'm about to create a web-page that will display RS-reports using the ReportViewer.
What is the client demands for being able to use the ReportViewer web control?
Can a linux-client using let's say Firefox use the ReportViewer?
Regards Andreas
MS SQL Client Software For UNIX Platform
Jul 5, 2001How can i connect to the MS SQL server ruuning on Windows NT from a SOLARIS machine.?
Is there any client software available for this?
Deleting Files With The FTP Client On A UNIX Box
May 2, 2008
I get the following error when I try to delete files using the FTP client in a SSIS package. This is the error I get.
Error: 0xC002918E at FTP Task, FTP Task: Unable to delete remote files using "FTP Connection Manager".
Task failed: FTP Task
This is a unix server. I'm able to delete the files using other FTP clients but the FTP client in the SSIS package cannot delete the files. I read on many places on the interent that this is a known MS bug. Let me know if there is some sort of work around for this. I'm using SQL servewr 2005 SSIS packages to accomplish this task..
Thanks
Unix, Windows For Unix, And Direct Read Of .mdf File This Is A True Story
Sep 13, 2007First, 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.
Linux Server(Verified)
Jun 7, 2007Hey Guys - I was just wondering - if you have started to use Linux Servers along with SQL Server- and if so, which Distribution of Linux and for what purpose. Cheers - Mark Smith
View 2 Replies View RelatedLinux Server(Usage)
Jun 6, 2007Hey Guys - I was just wondering - if at work you have started to use Linux Servers - and if so, which Distribution of Linux and for what purpose. Cheers - Mark Smith
View 1 Replies View RelatedLinux Server(Verified)
Jun 7, 2007Hey Guys - I was just wondering - if you have started to use Linux Servers along with SQL Server- and if so, which Distribution of Linux and for what purpose. Cheers - Mark Smith
View 1 Replies View RelatedDoes SQL Server 2005 Run On Red Hat Linux?
Jun 20, 2007Hello Everyone -
This may be a silly question, but does SQL Server 2005 run on any other platforms besides Windows? Will SQL Server 2005 run on Red Hat Linux? Or any other flavor of UNIX? Thank you for your time and assistance. I appreciate the help.
Connecting To SQL Server From Linux
Aug 22, 2006Am trying to connect to SQL Server 2000 from a Debian Linux installation. What would be the best place to get documentation on this? Is using Open-TDS recommended (is there any other way)?
will greatly appreciate any assistance.
thanks
How To Query SQL Server On Windows From LINUX?
Apr 16, 2008Hello, everyone:
I have a C++ codes on Linux and SQL Server 2005 Express on Windows. C++ codes need to query data from SQL Server. How to setup then connection? Any suggestion will be great appreciated.
ZYT
How To Get Data From MS SQL Server From Linux Machine?
Mar 10, 2004hi all,
I need to collect data from 60 SQL Server into one big DB2 server using mulit threaded C program under linux, just wonder if anyone have tried to make a program under linux to get data from MS SQL Server under windows.
i need to code in C under linux, connect to SQL server and also connect to DB2 server
what i understand so far we need on clinet side (linux machine)
1. ODBC software ( there is open source unixODBC )
2. MS SQL Deiver under linux ( i checked softlink )
does anyone has experince in such stuff ?
i need a start point
any suggestions ?
SQL Server 2005 Express && Linux??
Feb 22, 2006Hi all,
I'm looking at setting up my own developer server at home so I can do more programming - at work I have limited capability so want to experiment a bit more.
Windows Server is far to expensive for me to consider so I'm looking at Sun Chili!Soft.ASP to run the ASP pages, etc and now just need SQL server. I have seen Microsoft now kindly offer this free version but is it likely to work on this Linux based system? Sun Chili!Soft.ASP currently supports SQL 7 and 2000 - is there any difference with SQL Express?
Hope anyone can help.
Cheers
Can I Install MS SQL Server2000 Into A Linux Server?
Apr 26, 2008
good day to all experts
can i install MS SQL Server2000 into a linux server?
thank you very much for any help regarding this matter
C++/Unix/SQL Server
Jun 20, 2001I 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
SQL Server (not 6.5) On Unix?
Apr 23, 2008Are 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 Related(free) SQL Server Mgmt Tool For Linux
Apr 23, 2008I have a Linux machine here at work that I do some development on, along with a few other tasks. It's also on my primary machine at home. Is anyone aware of a SQL Server Management suite that will run (natively - not in a VM) on Linux? I've used Aqua Data Studio in the past, but I would rather not have to pay for another License just for a part-time use.I'm not looking for a full suite of graphical utilities. If I could get the basic functionality of Query Analyzer (query window, object scripting, etc..), I'll be happy.I've googled around, and the pickings have been rather slim. The only thing I've found is something called Transact-SQL Analyzer (http://sourceforge.net/projects/sqlanalyzer/). I haven't tried it yet, but I'll give it a shot. Has anyone used it before? It doesn't make mention of 2k5 support, either.
View 6 Replies View RelatedConnecting To Sql Server (within Windows Domain) Through Linux?
Jul 20, 2005Hi,I'm planning to develop a small intranet to provide our organizationwith documents online. I've decided to do this using jsp/servletsusing a tomcat server. For an operating system, I have chosen red hatlinux. However, I'd like to keep a small database on a sql server asa datasource. However, this sql server is already part of ourorganization's windows domain. I suspect I'll need to configure sambaso that other terminals on the windows domain will be able to reachthe intranet. What's the best manner in which to connect my linuxservlets to this sql server database? I suspect this may bedifficult, considering the sql server exists within a windows domain,but as a beginner, what do I know. Perhaps someone could point me inthe right direction.
View 4 Replies View RelatedConnecting To SQL Server From Unix
Feb 24, 2004Has 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
Accessing SQL-Server From UNIX
Apr 11, 2008
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?
How Can I Access SQL Server From SCO Unix?
Jan 11, 2007We 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....
Accessing SQL-Server From UNIX
Apr 12, 2008
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
Client Unable To Establish Connection Encryption Not Supported On SQL Server. (Microsoft SQL Native Client)
May 2, 2006On Windows XP systems I get the following issue when trying to browse the MSDB folder in SSIS
Client unable to establish connection
Encryption not supported on SQL Server. (Microsoft SQL Native Client)
I have noticed another post where several others have noticed the same issue. It appears to only occur on Windows XP installations. Is there a workaround or fix for this?
Accessing Sql Server Data From Unix
Apr 5, 2001Hello !
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
Read UNIX File From SQL Server
Feb 6, 2004Is it possibel to run a DTS job to read a file from unix server?
View 4 Replies View RelatedSQL Server 2012 :: UNIX Timestamp In Second
Oct 27, 2014I'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?
Accessing SQL Server 2000 Via UNIX
Jul 20, 2005Hi,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 Related