I am at the moment participating in a project and we have run into a few difficulties which I'm hoping you guys may be able to help with.
In short, we are attempting to construct an online manager game related to cycling. Although the database has been created already in SQL Server Express and some of the website has been made, we also would like to create an executable file (written in Visual Basic) which can be placed on the server and scheduled to execute once a day. The file should read data from the database and perform its defined calculations, before writing back to the database again for further use on the website.
The problem at the moment is that I can't figure out how to make the file recognize the database in such a way that I am able to use read/write statements with SQL directly. I have tried looking numerous places online but all sources show examples of creating web forms and using buttons and such to call functions whereas I simply want one compiled executable.
If you have any advice or recommendations on how I may tackle the problem I would appreciate the help greatly.
Essentially it a question of what is needed (perhaps in terms of code) for me to make the VB file in such a way that I can do SQL queries on it independent of any user interaction. We want the code to handle the database updating on its own each day.
Hi, I was sent a .bak file which I need to open and place in sql server express. I googled this but did not come up with any clear instructions. Can some please give me a good link that explains this. Thanks
Hi all, I have the "Northwind" database in my Sql Server Management Studio Express.
In my C:ProSSEAppsSamplesForChapter02Chapter02 folder, I have the following 2 files: (1) ListColumnValues (MS-DOS Batch File) sqlcmd -S .sqlexpress -v DBName = "Northwind" CName = "CompanyName" TName = "Shippers" -i c:prosseappschapter02ListListColumnVales.sql -o c:prosseappschapter02ColumnValuesOut.rpt (2) ListColumnValues (Microsoft SQL Server Query File) USE $(Northwind) GO SELECT $(CompanyName) FROM $(Shippers) GO When I ran the following SQLcmd: C:ProSSEAppsSamplesForChapter02Chapter02>ListColumnValues.bat I got the following "ColumnValuesOut.rpt" with error messages:
'Northwind' scripting variable not defined. Msg 102, Level 15, State 1, Server L1P2P3SQLEXPRESS, Line 1 Incorrect syntax near '$'. 'CompanyName' scripting variable not defined. 'Shippers' scripting variable not defined. Msg 102, Level 15, State 1, Server L1P2P3SQLEXPRESS, Line 1 Incorrect syntax near 'CompanyName'.
I copied these T-SQL statements from a book and I do not know how to correct them. Please help and tell me how to correct these errors.
How do I move a tab serperated file into a table in SQL express using sql express? I need simple fast way to to this.
I can export all my access file into tab or comma files and then build the new tables and import them. I tried upsizing the table in access but sql express will not accept them at all and I cant find a way around it.
Hello, I'm have developed a web site with .Net 2.0 and Sql Express. To make a loooong story short, I have managed to lose the myDB.ldf file. I still have the .mdf file but can not get my app to connect due to the .ldf missing. Please help if you can. Many thanks!!! The error I get is: "Cannot open user default database. Login failed.Login failed for user 'myComputerUser'.File activation failure. The physical file name "D:WebProjectswebProjectApp_DatamyDb_log.ldf" may be incorrect. "
I have an app that i use to connect to the database file locally. The app collects the information schema tables data. Once i have connected to the file once i cannot come back and connect again because it says the file is in use. but if i close the app and reopen i can connect just fine.
This happens with every db file i connect to. I can connect to several different files in a row but as soon as i try to connect a second time it pops up in use.
What am i missing? It has to be something in my app since it releases it as soon as the app is closed. Let me know what else i need to provide on how the app runs if noone has come across this issue yet. One other note is that i am connecting to it in a background worker. I have already tried to dispose of the background worker but that is not what is holding the file.
How do I move a tab serperated file into a table in SQL express using sql express? I need simple fast way to to this.I can export all my access file into tab or comma files and then build the new tables and import them. I tried upsizing the table in access but sql express will not accept them at all and I cant find a way around it.Thanks
I need to be able to update a database in SQL Server Express from an Access database that a user will be uploading. Can anybody give me some suggestions about how to accomplish this besides reading in each record and updating the SQL server one record at a time. David
Hello, I am pulling my hair out here... I don't seemt o be able to solve this issue. I am Developing a new website using Sql Express. But I get this error sporadically claining that the "file is in use by another process". Thinking it is the Express management Studio I shut it down.... Nope still errors.. Ok maybe it is the XSD designer.... So I close that XSD designer window in visual Studio.... nope still erroring. hmmm... Maybe I'll shutdown Visual Studio and try that... Nope still gives the error. Ok let restart the SQL Express Services.. Nope still errors. OK OK REBOOT... Now it works for about two testing iterations. Then it starts all over.... What is locking this file? Is their any tools out there to tell me what is locking the File? I am using XP Home Edition, VS 2005 Statndar Edition with Sql Express... Thanks Chris
Hi, i'm still rather new to sql server and sql server express. My problem is that I have 50 fixed width files(actually was LIS file type, converted to txt using notepad). Each text file has about 50 columns of data. What would be the best way to get this into sql server db?
We use SQL Express in our Applikation in file mode. Users can create databases in different folders and pathes. Each time a user loggs into our applikation, we attach the db he choosed, and every time he closes the applikation, we detach the db.
While this works fine in Windows XP, we have serious problems with Windows Vista.
We tried a connectiong string with "attachdbfilename", "sp_attach_db" and SMO server.AttachDatabase
Where could we get some more advice for our problem. It is in fact an issue of UAC.
I am having a hard time finding the executable file to start sql express 2005 or SQL exress 2005 with advance services. I installed the SQL express and had the desktop icon....but I thought i would need to uninstall it before installing SQL 2005 with advance services. Now I can not find anything to start the program.
Hello Everyone, I am trying to restore a bak file which came with code for a tutorial. I think it is safe to restore, but sql server 2005 express has the following problem when I try to restore it. TITLE: Microsoft SQL Server Management Studio Express------------------------------ Restore failed for Server 'BOBSQLEXPRESS'. (Microsoft.SqlServer.Express.Smo) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Restore+Server&LinkId=20476 ------------------------------ADDITIONAL INFORMATION: System.Data.SqlClient.SqlError: The operating system returned the error '5(Access is denied.)' while attempting 'RestoreContainer::ValidateTargetForCreation' on 'C:Program Files (x86)Microsoft SQL ServerMSSQL.1MSSQLDashboard.mdf'. (Microsoft.SqlServer.Express.Smo) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&LinkId=20476 The links given for help have no information about the problem and I'm not really sure where I should be looking to solve this. I'm a newbie to databases so if you could provide a step-by-step answer that would be best. Thanks in advance. Robert
Hi All, I have a .sql file with all my queries written in it. Now I want to know, Is it possible to run this sql file in SQL Server 2005 Express Edition like we can do in Oracle? If it is possible then tell me how to do it?Thanx in advance for any kind of help.Regards,Paramhans Dubey.
Hi,i have a MDF sql server express database used by an asp.net application (located in local dir App_Data on the same computer as the Sql server).I would like to integrate it into Sql Server express. I mean: NOT only attach it, but transform it as it was created direclty into Sql server and not in Visual Web Developper tool.In Studio Management, i rightclicked on Databases and i took 'Attach'. Now i can see and manage that database from Studio Management, but it still refers to the local path of the MDF file. I see that by doing this query: select * from master...sysdatabases How can i make it a full database of Sql server?Thanks Tartuffe
I'm a little stuck here. How can I import a flat tab delimited file into a SQL 2005 Express table? The standard DTS and import features are not there :-(Thanks,Casey
I am just starting to learn SQL 2005 Express. After opening the Management Studio Express, I right Click on the Databases node and create new database. then create a name etc. The problem is that when I click ok to create the new database, I get a warning saying that Input a filename. However when I click on filename (after filepath) it is greyed out and I cant add a filename.
I have database written in SQL SERVER 2005 since last two year .Now the Database size become 33MB, and the log file become 450 MB . The log file is too large for me . Do you any know how clear the log file in SQL SERVER 2005 EXPRESS SP2 ?.Thanks
This might be obvious - but if so I've missed it so far.
Is it possible to connect remotely to an Express database used in a website which is created in the App_Data folder by VWDEE 2005 and attached by filename?
As far as I can tell these databases don't have a name and aren't mounted until an attempt is made to access them. I certainly can't see any sign of it in SQL Management Studio.
I'm a newbie. I have googled many web sites,but i can't find the help that how to upload or store files(include images) into a database with Asp.Net 2.0. Although i have found few samples about storing images into database,but the sample applied with Asp.Net 1.0 or 1.1 technology... In microsoft MSDN,i found the help about FileUpload control,but the sample is about how to upload files to servers's folder with saveas() method. Who can help me ?Give me a refer sample about upload files to database with Asp.Net 2.0. Is it need to use stream or what other method? By the way, i want make a document managment system with vwd and sql express. Thank u very much if u can give me a help.
Hi All,I have an asp.net 2.0 app that needs to bulk load data from an xml file into a Sql Server (Express) table. Is there an easy way to do this?Thanks,Claude.
We have a file based asp.net app built using Visual Web Developer and Sql Server Express 2005. We have finished development and testing and are now moving to the deployment stage. As a first step, we would like to be able to view it on a test machine using IIS (instead of VWDs built in web server). We have created a virtual directory in IIS and can view our app correctly at http:localhost/ForIIS_test.
However, when we get to a page that tries to access our Sql Sever Express database, we get the following error: An attempt to attach an auto-named database for file C:Documents and SettingsClaudeMy DocumentsVisual Studio 2005WebSitesForIIS_testApp_Data estDatastore.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share. Does anyone know how to overcome this problem? Any help appreciated. Claude.
Hi Guys, how many connections does sql 2005 express allow to .mdf file. I stumpled on info on a microsoft site (actually a forum post on msdn) that sql server express allows only a single connection to an .mdf file. Iam intrested in this because i developed reporting services reports in BIS and iam having problems. If i run a report from report manager, i have to wait for close to 20 minutes before i can be able to run my asp.net application agian. Else if i insert data or retrieve data from my asp.net application, then i have to wait again for 20 minutes or more before i can be able to run my reports else i will get an error that a connection can not be made to the database or that the database is being used by another process. So in all cases, i have to wait for 20--30 minutes before a connection can be made to the .mdf file. i.e after running a report or after inserting or retrieving data from the database through my asp.net application. Iam using sql sever 2005 express with advanced services and visual web developer on windows server 2003. Any ideas or help.
All -- Please help. Is it possible to connect to MDF file without having SQL Server 2005 Express installed on the machine? That is-- can one connect directly to an MDF in the same way and Access MDB file can be used? If no, then is there any way around this? If yes, then are there any limitations? Please advise. Thank you. -- Mark Kamoski
HiI had to recover my computer but before I did that I grabbed a new version of my mdf file but I don't know how to actually import it into SQL Server Management Studio Express evertime I try to open the file up it just crashes. I rather not have to redue that whole database again. I am a noob so step by step instructions are needed. Thanks
