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
Hello!
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!
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.
View 1 Replies View RelatedHi
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
My application is written in C/C++ on Linux platform. I am wondering if there is a C/C++ driver for Linux to access SQL server.
thanks.
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....
I am having trouble installing SQL Server 2005 Express. I was told to uninstall and reinstall clean but now SQL Server does NOT show in the Add/Remove Program list but when I try to install, my system says I already have SQL Server installed. I get error messages every time. Any ideas???
View 2 Replies View RelatedI went through the install of the MS SQL Server 2005 Std Edt only to find that I can not open up the "SQL Server Business Intelligence Development Studio" since I was missing the exe to run it that should have been located at "C:Program FilesMicrosoft Visual Studio 8Common7IDEdevenv.exe". Due to this happening it seemed to me that some of the install failed, so I went about trying to uninstall the SQL Server setup. Within the "Add or Remove Programs" tool I selected the "Microsoft SQL Server 2005" from the list and clicked on the button that said "Remove". This did not seem to do anything except for remove the "Microsoft SQL Server 2005" selection from that tool selection list. It went way to quick and did not display any dialogs as it removed the engine. Also I can still opent the Management Studio and see all the normal stuff and I can query the data within the databases. The two part question is...
1) How do I get the Microsoft SQL Server 2005 program relisted in the "Add or Remove Programs" tool's selection list?
2) How do I get the "SQL Server Business Intelligence Development Studio" installed correctly?
The only warning message I received during the install was in regards to the hardware not being quite up to par with amount of RAM. I saw no errors within the install tool.
Thanks in advance for any help you can offer!!! Please let me know if anything else is needed to answer this question.
Is
"Microsoft SQL Server 2005 Mobile [ENU] Developer Tools"
equal to
"Microsoft SQL Server 2005 Mobile Edition"?
If not, what is it?
Hello 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.
I have Microsoft SQL Server 2005 Express Edition Toolkit installed but there is something from with the installation since every time that I try and create a Report Server Project It gives me error
Could not load file or assembly "Microsoft.ReportingServices.Designer, Version 9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannopt find the file spesified.
How can I reinstall it or repair the installation so it will work. I have uninstalled every SQL2000 component in Add Remove Programs and reinstalled them. The problem is however that I cannot see an entry for "Microsoft SQL Server 2005 Express Edition Toolkit" in the Add Remove programs in Windows XP Profesional.
Can someone please help me. Maybe tell me where the uninstall file is located on disk??
Any help will be great
Manu Thanks
Hello all, does anyone know of a SS2005RS user audit program that an administrator can run on a RS server to show which userids have access to folders? I have in mind a pgm that would show:
folder users
Home user01, user02, user03
folderA user01,user02, user05
folderB user02, user06
Is there a pgm available as a download, or does someone have a home-grown pgm whose source they would let out?
Has anyone else faced this need?
Thanks in advance
Hi 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
Is it possible to install MsSQL / Access on Linux? The reason I am asking is I have a linux virtual dedicated server, and develop both php/mysql and asp/mssql/access database, is there another program or something I can run on my server to allow development of programs needs mssql/access?
Thanks in advance for replies,
Jeff
EDIT: I am new to Linux, however have found this: http://www.knoda.org/ Is this what I might need?
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...
I need to access a MS-SQLSERVER with a Linux (SuSE 9.0) based computer.I need to do some selects.What do I have to do what kind of client Software and how do I have toinstall on the linux Maschine to comunicate with this Server?Probably some kind of odbc?thanx for any hints.Maximilian Gablinger
View 2 Replies View RelatedFirst, 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,
We are trying to move our application from SQL2005 to SQL2005, we are using 2005 jdbc driver 1.1.
The problem we have is, when a date is retrieved from the database, only the year part got correctly, but the date is automatically set to January 1 of that year. The interesting thing is this problem doesn't occur on local development environment (developer's windows platform), it only happens when we deploy the application to production server (unix).
Does anyone know what is going on, how to fix it?
Thanks.
Cathie
Hello all,We need to access MS SQL 2000 database from RHEL platforms. I'vetested unixODBC and Easysoft ODBC-ODBC Bridge (under trial license).They work together pretty well. Unfortunately Easysoft ODBC-ODBCBridge is not a free solution. Anybody have any experiences with otherODBC solutions that can make MS SQL accessible to unix? I've heard ofiodbc but without any hands-on details.Thanks in advance for sharing your experience.Bing
View 5 Replies View RelatedOur firm needs to analyze some financial data for a client. They gave us a SQL database file in ANSI format. Is there a way to import this data into SQL 2005?
Thanks,
Steve
I am currently having issues getting the odbc32ad driver configured properly so I can transfer the database off of the old Oracle 7 database (currently running SCO UNIX). I have the orignal Oracle 7 disk and installed the drivers, but I am not sure what the SA login for Oracle is, nor do I know what the "Connection String" is.
Has anyone made this transfer before? Please help.
Could someone from the SQL Server Express team confirm that SQL Server Express SP2 w/Advanced Services shows up as "SQL Server 2005" in the installed programs list? The "Express" portion seems to be missing. And how would one tell the difference between the Standard Edition and the Express Edition based on this?
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
View 2 Replies View RelatedHey 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 RelatedHey 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 RelatedAm 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
Hi,
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
Hello, 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
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 )
does anyone has experince in such stuff ?
i need a start point
any suggestions ?
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
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 RelatedI 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 Related