How To Get Data From MS SQL Server From Linux Machine?
Mar 10, 2004
hi 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 )
We have a heterogenious network of Windows 2003 Server/SQL Server 2005 machines and Linux file servers. For various reasons our HP/Compaq DLT tape drive robots are attached to our Linux file servers.
What options exist for sending backups to remote tape drives that are attached to a Linux host? I'm interested in solutions that have been actually implemented (we've been having plenty of fun with "this should work" scenarios ).
This question may be a bit naive but I have some data that I would like to transfer from a SQL 7 database to a DB2 database on Linux. Does anyone know how I would go about doing this. I have in the past transferred data from SQL 7 to Oracle and SYBASE using DTS without any difficultly. I cannot remember exactly but presume they were on NT.
Hello all,I have been trying to find some information about exporting data frompostgresql on linux to ms-sqlserver 2000 on windows but have not beenable to get hold of any information. I would really appreciate ifsomeone can point me to some source of information.Thanks in advance,Nishy
I m a new DBA I have a problem I have a SQL Server with 300 Databases on a machine. Now company has bought new Machine How to migrate data from old server to this new machine without recreating logins can some one help
Hi All;We are going to change our application server. We will copy all of ourDatabase from Mic 2000 Server OS to Mic 2003 Server OS. I found anarticle that how to move all the folders from same OS. My question isthat Would the 2003 OS be a problem when we copy all of the MC SQL 2000folders to New OS ? Has anybody done this before? Could you gimme yoursuggestions please?ThanksASA
We wanted to rebuild our main SQL server machine. How can we backup everything about the SQL server (such as all databases/objects and settings on security and users) and then recover them without any data loss? A related question is how to recover the server machine in case of system failure or whole machine crash down? Thanks!
Hey 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
Hey 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
Hey 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
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.
Am 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)?
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
I am trying to use a new Excel microsoft add-in using SQL server 2005. I installed the 180 day trial version of SQL Server 2005 on my local machine and according to the instructions it was suppose to be very easy to connect the excel add in to SQL. I am receiving an error message which I cannot find a resolution to using the readme file and wonder if you can help.
ERROR MESSAGE Unable to connect to server 'localhost'. Please make sure user 'ARTIMUS' has at least read permission to some database on the server.
If I use GetDate() function from client machine (using "\ServerMachineSQLExpress" instance from client machine "ClientMachine"), then from where I will get the DateTime value ?
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.
Hi, 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.
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?
I 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.
Hi,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.
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.
Help! I am using Script Transformation to output a new column as image[DT_IMAGE] field to store serialized object. In the VB script, the sample code as
The package always runs fine on my developing machine and will halt on other machine at AddBlobData after certain number row records were processed. I am stuck here. Anyone has any suggestion?
What I need is reading data from mutiple tables in one database and writing into a single table in another datable. In order preserve all the columns data, I use input column fields to construct a new object and then serialize it, and store the serialize data into detination db table. (The object and serialization function is coming from c# dll.)
Dim b As BusinessLicense = New BusinessLicense() b.ApprovalDate = Row.approvaldate b.BusinessId = Row.busid b.BusinessName = Row.busname b.NaicsCode = Row.naicscode b.NaicsDescription = Row.naicsdescr b.OwnerName = Row.ownername b.Phone = Row.phone b.Pkey = Row.pkey b.RenewalDate = Row.renewaldate b.StartDate = Row.startdate b.Suite = Row.suite
Row.serializedobject.AddBlobData(Serializer.Serialize(b)) '''----This is blocking line Row.infoType = BusinessLicense.TYPE
Both machine is xp with sp2. and standard SQL Server 2005 - 9.00.1399.06
Hi to everyone, I'm facing a problem that drives me crazy. I've a web application that has the following problem. When I test the application on my developement machine all runs fine, but when I put into production server there is a problem in connection pooling. Look at the following image, the blue line is the number of connection in the pool and the violet line is the number of connection reclaimed. From the image it is clear that connection are returned on the pool only in block, maybe when the garbage collection pass and reclaim the object. The strange thing is that on my developement machine all is good, and also I'm using Enterprise Library and the connection are managed internally.- Thanks to everyone for any help.
Hullo all I have two machines, One is a standalone machine and the other is on a domain network. How can I run a stored procedure/job on the standalone machine from the domain machine ? running the procedure as a Domain user results in a failed job/stored proc. also creating an sql login and attempting to run it as that user also fails. How can I solve this problem ? please e-mail me at wayde@sunnygrp.com if you have any thoughts...
I have a SQL Server 2000 database in a remote host and I want to move all my data to another remote (virtual) host, where on both machines I do not have direct access.
Can you advise me what is the best way to make this transition?
Hi All,I have a requirement to create the database with data and log files ina different machine on the network.Googling, I got a link which said Mapped drives do not work but UNC pathswork. However in my case, both are failing.Any advices or links on net will be highly useful.Thanks and Regards,Chandra Mohan
