I want to upload a file (e.g. .xls, .pdf, .doc) and save into the Sql Server 2000 database through the web interface, and then to download this file. Any idea???
View Complete Post
When I try to attach a database using SQL server 2008 express version, it gives me an error message. it says
"Msg 18456, Level 14, State 1, Server LINDA\SQLEXPRESS, Line 1
Login failed for user 'LINDA\Linda'"
How can I fix this error?
I've look around the forums but I can't get the solution for my problem. I've installed Visual studio 2010 with sqlexpress edition. Then I have renamed my
computer. After renaming my computer I've deleted the directory
C:\Users\uporabnik\AppData\Local\Microsoft\Microsoft SQL Server
Data\SQLEXPRESS. After restart, I have started VS2010, open Server explorer and I've added the connection to a new database. I've been able to add new tabels, bu when I've tried to add a diagram, it didn't work. In properties window od the database I
saw, the the database owner was oldComputerName\username not newComputerName\userName. In
sql server management studio I've reanmed the user oldComputerName\userName to newComputerName\userName. After attaching the database it worked fine.
I've returned to Visual studio 2010. When creating new database, the owner of new database is oldComputerName\userName. The next tip was renaming the SQLServerMSSQLUser$ComputerName$SQLEXPRESS(and other names with sql...) in
Local Users and gorups in Mange My computer. After restarting the compter I've got the same result. When creating new .mdf file in server explorer of visual studio, the database owner is oldComputerName\userName.<
I have created dummy database, Table in SQL Server 2005 with some values.
Iam able to pull data from the SQL database to sharepoint dataview webpart through data connection using sharepoint desigher.
Now i have to enter new record in to SQL table through sharepoint. i have checked with sharepoint designer but unable get it done.
Can some one have idea on this. Please help me to get it done
Thanks in Advance.
Using - Visual Studio 2005 Professional, SQL Server 2005 Express, WinForms App
Problem - I am unable to connect to SQL Server local Database file (.mdf) through SQL Server Authentication.
I am addding a SQL Database file (local) in the c# winapp solution by right-click -> add new item -> SQL database file.
It adds the file, starts a wizard to create datasets and tableAdapters. Dataset files (.xsd) are created in solution. In the Data Connection pane along ToolBox we can see Database1.mdf.
When i right click on databse1.mdf -> Modify Connection.
It shows a form with Test Connection option. The connection gets tested for Windows Auth.But for SQL Server Auth it shows following error message -
When User Instance = True
Error 1 "Failed to generate a user instance of SQL Server. Only an integrated sonnection can generate a user instance. The connection will be closed"
When i set User Instance = False it shows this message -
Error 2 "An Attemp to attach an auto-named database for file C:\Doc&Sett\Admin\MyDocs\VS2005\Projects\SamApp\SamApp\Database1.mdf failed. A database with the same name
If i want to create a web site that take your picture and share it for your friends, what the best way to save the picture files on server? What the way is safer for the picture files? What the way has the best performance?
Please help me
With Regards. Mojtaba
I need to show an AsyncFileUpload in insert template for the listview and bind its FileContent property to the Content property in my AttachedFile Object (that linq created when it mapped my AttachedFile Table in the database)
I've no idea how to go about wiring all this up. Plz Help!
I created myFile.mdf using SQL Server Management Express and saved some data to it using vb.net. When I tried to open it in SQL Server Management Express, It did not open it saying there is no editor available for it. How to open this file?