Search results for query: *

I need to get the Computer Name of the computer connecting to a Citrix server. For example. I'm on computer "ClientMachine" and I connect to citrix and run my application. My Application needs to return "ClientMachine". Anybody know where this information is stored or how I can get it...

Ok, I'm trying to allow the user to browse their computer for a file ending in a specific file extention (in this case .mdf). The problem is, I don't know how. I can get the dialog box to pop up that allows them to browse for folders, but I don't know how to do this for files.

I'm not really a web designer but I'm trying to broden my scope as a programmer by learning how to design, create, and code webpages. In doing so I've started my own site to promote the music I make in my spare time. But now I'm not sure how to add my next feature. When a user downloads a song...

I'm getting a &quot;Incorrect Syntax&quot; error when I execute this SQL Statement. What is wrong? &quot;SELECT * FROM Permit WHERE Prefix = 'Template' AND Auth_DT <= #2/28/2004 12:23:25 PM#&quot; Permit is the table Prefix is nvarchar Auth_DT is datetime

How can I tell if a Database is already attached to SQL/MSDE or not? I'm creating a new install for a custom aplication that uses SQL as the database and I'm trying to figure out the best way to attach the database. One way is to attach it durring the install... another option is to have the...

I installed SQL Database Engine (MSDE) using the below ini file. [Options] INSTANCENAME=TagLinkMSDE securitymode=sql SAPWD=taglink DISABLENETWORKPROTOCOLS=0 I then try to connect to the newly installed instance of MSDE using the below connection string. m_cn.Open &quot;Provider = SQLOLEDB.1...

Ok, All I need to do is remove the file name from the end of a string in a wise script. The path string comes from my Wise For Windows Installer setup and when it reaches my InstallMaster Script it looks like: C:\Program Files\Setup.exe But I need it to be C:\Program Files I know I can use...

Instead of having one &quot;ProductID&quot; editbox on the &quot;UserInformation&quot; dialog, I have 3. Each box has it's own value (SerA, SerB, and SerC). But now, when you run the application, if the fields are correct, the ProductID Error Message will still load the next dialog box. I'm...

Ok, I've been at this for about 3 days now and I'm sorry if my constant &quot;restore&quot; questions are getting old but I've finally figured out exactly what's going wrong and I think I'm offically SOL. I need to (through code since none of my clients will have SQL Server) Backup and Restore...

Some of you might have noticed my 4 posts in the past 2 days all about the same Restore problem but I've finally figured out what's going wrong. I'm trying to tell my SQL database to restore through VB code, thus requireing me to link to the database to tell it to execute. However, it's telling...

Ok, I'm new to SQL server in case you couldn't tell by now.. but when trying to execute KILL 1 I get the error that says: &quot;Only user processes can be killed&quot; How do I know of the spid is a User Process? Thanks -N473

This is been an ongoing problem for me that the SQL people have helped me out with grarely. Currently, here is my situation: The user clicks the &quot;Restore&quot; button and the program is suppose to automatically Restore a backed up SQL Server database. But, the program finds out that there...

I keep getting this error while trying to restore the database: &quot;Exclusive Access could not be obtained because the database is in use. RESTORE database is terminating abnormally.&quot; I am sure though that no one has logged onto the system while I am doing the restore but I keep...

My software runs on MSDE assuming that the majority of my clients will not have Microsoft SQL Server installed on their computers. How do you do a backup and restore without having SQL Server? I tried executing this code &quot;BACKUP DATABASE [tablename] TO DISK = '[path]'...&quot; but that...