Any Linux-based Apps Similar To MS SQL Enterprise W/ DTS ?
Jul 20, 2005
Hi all,
I bet this doesn't exist, but does anyone know of an MS SQL Enterprise
Manager-type application for Linux that would give me access to a DTS
stored on the server? I'm a web programmer by profession, and most of
my tools are Linux-based, but because I do so much indepth work in MS
SQL and DTS's, I've been dual-booting between Windows and Linux mainly
because there's no way I know of to access my MS SQL DTS's from Linux.
Any Linux solutions out there that will read and maybe even edit SQL
DTS's?
Thanks,
Alex.
View 1 Replies
ADVERTISEMENT
Jul 20, 2005
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 Related
May 26, 2007
I have a table that I am basically reduplicating a couple of times for each part of this database that I want to create.Each table basically has the same data: The tables will be called motherTable, fatherTable, sonTable, daughterTable and so on.I am pretty much using the following in each column: UserID, MotherID(or FatherID or SonID, etc., etc. and so on for each unique table), FirstName, LastName, MiddleName, BirthPlace, Photo, Age.I don't see an option to copy a table and just modify the second ID part and rename that table accordingly.How can I make this an easier way of creating these similar tables without retyping all these columns over and over again?Thanks in advance.
View 4 Replies
View Related
Apr 10, 2008
Hey Gurus,
I have a problem on getting the sql statement which will group similar column name and sum their number together(another column).
A million thanks in advance.
View 5 Replies
View Related
Sep 9, 1999
How many "applications" can be loaded onto Microsoft SQL Server 6.5?
Additional Information:
The OS platform is Windows NT Server 4.0 (SP5) on a Compaq ProLiant 1600 (PII 450) with 256Mb RAM
Proposed applications, although this probably will mean little, are Dataview (club membership) Peterborough (payroll) and Positive (HR).
Any assistance would be appreciated.
Thanks
Robert
robert@whiteley.com
View 1 Replies
View Related
Oct 21, 2006
Hey guys, my first post so here goes...
I'm wondering if anyone here knows how to write a program (or download a program) that pretends its a sql server and listens for connections, so that when an app thinks its sending its connection string to a server, its sending it to the locally installed program, so that you can get the UID and password from the connection string.
I'm working at a company where we need to write an extension to the software we use but we don't know the login to use for it. These programs are horribly designed. If you run it with the net card disabled it dumps the connection string to the screen but of course it has the UID and pass starred out. Any thoughts?
View 1 Replies
View Related
Jun 21, 2007
I'm struggling to connect to my SQL server whilst running a dot net application which is located on a network drive.
the program will run perfectly from my c drive, but as soon as i move the program file on to the network, it no longer recognises my windows permissions, and does not connect to the database.
can someone help?
is there some code that i need to add to my dot net code?
View 2 Replies
View Related
Jun 7, 2007
I have SQL Server 2000 with databases on the NetApps filer CIFS share.For example, the datafiles are located at \network shareserversharemicrosoftsqlservermssqldata...Whenever there is a filer failover, some of the databases go in suspectmode. Is there a setting on SQL Server like a time out setting from thenet apps that can be modified so that the databases will wait for awhile before going into the suspect mode?Raziq.*** Sent via Developersdex http://www.developersdex.com ***
View 1 Replies
View Related
Jan 4, 2007
Help!
Does anyone know where can i find some windows or web applications using ssis for manipulations?
View 4 Replies
View Related
Sep 8, 1999
If a user's pc needs to run 2 different applications (sold by 2 different vendors) and one must be 6.5 and the other must be 7.0, are there any problems with the client machine?
My understanding is that each of the apps comes with the pieces it needs to connect. I'm trying now to reach the tech types at the vendors and ask what kind of custom setup (if any) is needed on a user workstation or if the install does everything. If they come with their own dlls and odbc data sources, might all be well?
Does anyone have apps loaded on a desktop that connects to both a 6.5 and a 7.0?
Thanx,
Dick Scherrer
View 1 Replies
View Related
Dec 8, 2006
Hello,
i am planning to build Pocket Pc App and i would like to know if i can use Sql Mobile as my data store. The data base design is quite complex.
I wont be using any recplication/synchronization in my app since its a standalone app.
pls suggest.
Thanks
Karthik
View 3 Replies
View Related
Nov 9, 2007
most articles I read suggest that apps need to retry upon failure in a mirrored environment, using a different connection string, not worrying a whole lot about waiting for the retry. But I heard somewhere that the original connection string can also contain info about the mirrored db, thus eliminating the need to use two different connection strings, and perhaps not even needing to retry programatically. Which is correct? I also heard that programatic retry could be required anyway because of some bug involving the "first" failure and disappearance of a connection pool. Can someone just provide the 50,000 foot view of what it takes to make an app "mirror aware"?
View 1 Replies
View Related
Jan 22, 2004
havent workd with linux especially sed in a long time. wondering if someone could help me with the following:
want to replace first occurance of * followed by a blank space in a servlet with
@web.servletname="xxx" display-name="xxx" @web.servlet-mapping url-pattern="/xxx.xxx/*"
code in servlet looks likes follows:
/**
* Description of the class
* @web.servletname="xxx" display-name="xxx" @web.servlet-mapping url-pattern="/xxx.xxx/*"
*@author
*@created jan 21,2003
*/
After sed is executed, code should look as follows:
/**
* Description of the class
*
*@author
*@created jan 21,2003
*/
Thank u
View 2 Replies
View Related
Sep 27, 2006
Hi guys,I've got two apps that are going to have pretty much the same users and i wanted them to have the same ASPNET.MDF user database. Is it possible to store the ASPNET.MDF in a different location and then have the two apps access it from there or alternatively have it in the App_Data folder of one of the apps and then have the second app access it from there?Thanx
View 2 Replies
View Related
May 31, 2006
Hi
My console applications work for SA and no other user. I can run the Stored procedures used in the console application from Query analyser when logged in with username/password that I am attempting to use for console applications. I am using SQL server authenication. User access permissions look ok in Enterprise Manager. Access is permit for my user.
Any suggestions?
Thanks
View 1 Replies
View Related
Dec 17, 2005
A few years ago I wrote an active-X server to maintain a singleconnection to a file .mdb from multiple apps on same PC because I washaving to many database curptions.Should I use the same Active-X server for the same in a MS SQL ServerDSN connection or is it ok to have multiple apps from the same pc usingthe DSN?
View 1 Replies
View Related
Aug 31, 2006
I have an application that was developed under Visual Basic .NET 2005 Standard that I keep continuously running to monitor and gather data and store that data in a SQL Server Express database. This is all done on a single computer that's not networked to anything. The trouble is, I'd like to look at the data in the database from time to time without shutting down the application, but I'm not able to do so. If I try to copy the database files, named lamination.mdf and lamination.ldf, to another location, I get the following error message;
"Cannot copy lamination: There has been a sharing violation. The source or destination file may be in use."
I would like to be able to copy the file to my office computer where it would be convenient to use Management Studio Express to look at the database tables. I can't even use Management Studio Express on the computer where the application is running, as I get the following message when I try to attach the database:
"CREATE FILE encountered operating system error 32(The process cannot access the file because it is being used by another process.) while attempting to open or create the physical file 'C:Documents and Settings barnardMy DocumentsVisual Studio 2005ProjectsLamination Phase ILamDataBaseLamination.mdf'. (Microsoft SQL Server, Error: 5123)"
Here is the connection string in the VB application:
"Data Source=.SQLEXPRESS;AttachDbFilename="C:Documents and Settings barnardMy DocumentsVisual Studio 2005ProjectsLamination Phase ILamDataBaseLamination.mdf";Integrated Security=True;User Instance=True"
In the VB app, connections to the database are made only every few minutes, and the connections are immediately closed.
Is there anyway I can either copy the database files, or at least look at the database tables with Management Studio Express without stopping the VB application?
Thanks,
Tim
View 7 Replies
View Related
Jun 17, 2006
i'm building apps using sql server express and I want to deploy to servers that have the 2.0 .net framework but have sql server 2000 database.
Can this be done, and if so, how?
Observing God€™s Holy Spirit, I see God saying that The Lord Jesus influences every natural occurrence of kindness, righteousness, and judgment (Jeremiah 9:23-24). I believe God, so I thank The Lord Jesus for your grace in these matters.
View 4 Replies
View Related
May 3, 2006
Is there a way to execute ETL packages programatically? Specifically, is it possible to
manually invoke the ETL package to execute from, say, an ASP.NET
application?
If so, how do you do that?
I've been searching MSDN regarding this but all I see are examples on programatically building packages.
View 3 Replies
View Related
Apr 10, 2007
hello,
im new to linux env, can u tell me how can i create DSN name in LINUX,
In Windows start menu>control panel>administrative tool>Data Source(ODBC)>User DSN>Add
but in LINUX i dont know how to create it, can any 1 help in this regard
View 1 Replies
View Related
Nov 24, 2005
Hi All,
Can I connect to the MS SQL database from the Redhat Linux 9.
Is there MS SQL client or database driver on linux available. I wanted to use the data from the MS SQL database in the C++ program running on Linux.
Thanks in advance,
torpedo
View 2 Replies
View Related
Jun 15, 2007
Are you using Windows on Linux - or Linux on Windows, and if so, which virtualization system are you using and for what purpose?
Mark Smith
View 2 Replies
View Related
Apr 5, 2004
there are some crazy people that tried to install MSDE/SQL server on linux (with wine)?
P.S.
When a commercial guy ask you if something can be done, don't answer "maybe", because he'll get it as a "sure"....
View 1 Replies
View Related
Sep 7, 2005
Can you run SQL Server on a Linux Redhat server?
View 4 Replies
View Related
Jun 15, 2007
Are you using Windows on Linux - or Linux on Windows, and if so, which virtualization system are you using and for what purpose?
Mark Smith
View 1 Replies
View Related
Sep 12, 2006
Hi everyone,I'm looking into moving my desktop system at work to Linux from WindowsXP, and one tool I've yet to find a suitable replacement for is MS SQLEnterprise Manager. I mainly need to query MS SQL databases fromLinux, and management tasks (monitor backups, services, etc) can bedone on the MS SQL servers themselves. THere was an application I usedto use on OSX which would connect to a variety of databases, includingMS SQL, and they had a Linux version of the client .. but can'tremember the name. But really any Sybase client that can connect to MSSQL with some ease will work.Thanks for any suggestions or ideas ...Alex
View 5 Replies
View Related
Jun 15, 2007
Are you using Windows on Linux - or Linux on Windows, and if so, whichvirtualization system are you using and for what purpose?Mark Smith
View 1 Replies
View Related
Jun 8, 2007
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 1 Replies
View Related
Jul 12, 2004
Hi
I installed Sql Server 2000 in my server with windows authentication.
IIS side under security tab checked Windows authentication option.
When i try to my asp.net web application everything is working fine.
But now as per user wish i dont want to use windows authentication.So sql side i create one user called 'global' and giving full permissions .In IIS side unchecked the windows option and checked
Anonymous access and given 'global' user id at anonymous user account place.
Now when i try to run my Web application i can connect to sql servel and fetch the data but no events are running in my .aspx page.means when i click any button or select list or combo box nothing is happening.All events are not firing and also not giving any error message.Its simple showing the page as it is.
When i un checked Anonymous access and checked windows authentication everyting working fine.
Really not getting why its doing like this .
Pl help me in this.
thanks
View 1 Replies
View Related
Nov 18, 1999
New to MSSQL
Management is getting frustrated with the increase in number of NT servers for MSSQL and Vendor packages. Currently we purchase a box for each app. We would like to go to one or two MSSQL servers running multiple application database's (based on size etc) . How are you handling this? Do you do this for test only or both test and production? Any gotcha's. Any help will be appreciated.
Thanks
john
View 1 Replies
View Related
Jun 6, 2007
We are currently migrating our sequel 6.5 databases to sequel 2005
We have a handful of vb6 apps that connect to the current 6.5 database.
Can anyone recommend the "best practice" for connecting vb6 apps to sequel 2005 databases ?
Thanks in advance.
View 1 Replies
View Related
Nov 8, 2007
what proactive steps can we take to make our app (ado, stored procs etc) cluster aware, in the event that we someday use clustering? For instance, I read things about retry strategies etc but dont even know if retry is on a different connection or what appears to be the same connection. We already make our trans as small as possible.
View 7 Replies
View Related
Sep 5, 2006
I'm planning an SQL 2005 deployment and would like to know if an SQL server should be kept as dedicated as possible. Should apps that access SQL be kept on other servers? What are the do's and don't's along these lines? The plan here is to install everything that accesses SQL on the same server with the database, but this seems like a bad move to me. Am I right?
Thanks!
Gregg
View 2 Replies
View Related
