I already made a .VB project using MVS 2010,I'm new in attaching database to SQL server and I'm confused attaching which database I'm going to attach because in the same folder i found that there's two
if user needs to attach the databases to the instance of server manually before being able to use the application?I have added the mdf file to my Setup project. It installs and copies the file to application folder. I donot know if the file needs to be attached or there is a way that application could do it automatically (attach to MyComputerSQLExpress)
I am attaching DBs using following code. Dim conn As New SqlConnection("Server=MyHomeServerSQLExpress;Database=master;Integrated Security=SSPI") Dim cmd As New SqlCommand("", conn) cmd.CommandText = "CREATE DATABASE dbNoPWD ON ( FILENAME = 'd:dbNoPWD.mdf' ), ( FILENAME = 'd:dbNoPWD_log.ldf' ) FOR ATTACH" conn.Open() cmd.ExecuteNonQuery() cmd.Dispose() conn.Dispose()
I do not want to give any username and password. When I ran the above code and then checked SSMS, I found my attach DB was not checked in Roles (pls. see pic.) The problem with this is my network computers can not access this DB. I want to run some code like above (without sa password) and want that all my network computers can access the DB without my user get involved in setting up SSMS.
Just after installing my application, I need to attach my DB to SQL server. I am using following code for it.
Dim cmd As New SqlCommand() Dim vrMyConString As String = "Data Source=.SQLExpress; INITIAL CATALOG=master; uid=sa; pwd=sa;" Dim conn As System.Data.SqlClient.SqlConnection = New SqlConnection(vrMyConString) cmd.CommandText = "sp_attach_db 'e:dbTest.mdf', 'e:dbTest.ldf'" ' conn.ConnectionString = "Data Source=.SQLExpress; INITIAL CATALOG=master; uid=sa; pwd=sa;" conn.Open()
[Code]...
It returns an error:"Login failed for user 'sa'. The user is not associated with a trusted SQL Server connection."
Just after installing my application, I need to attach my DB to SQL server. I am using following code for it.[code]It returns an error: "Login failed for user 'sa'. The user is not associated with a trusted SQL Server connection."
I am using the following VB code to attach my DBs to server.
Dim cnnConnection As New SqlConnection("Data Source=.SQLEXPRESS;AttachDbFilename=" & Application.StartupPath + "datafiles" + TextBox1.Text + ".mdf" & ";Integrated Security=True;Database='" & TextBox1.Text & "';Connect Timeout=30") cnnConnection.Open()
But it gives an error:
Unable to open the physical file "D:.Net ProgramsSQLDBAttachExperimentsSQLDBAttachExperimentsinDebugdatafilesdbSQLtest.mdf". Operating system error 5: "5(error not found)". Cannot attach the file 'D:.Net ProgramsSQLDBAttachExperimentsSQLDBAttachExperimentsinDebugdatafilesdbSQLtest.mdf' as database 'dbSQLtest'.
I have created my site using ASP.NET Personal Starter Kits 3.5. I use Visual Studio 2008 only . .with its built-in SQL Server (2005 Express) ... my database in App_Data is ASPNETDB.MDF ...I have created some of my tables also ....in ASPNETDB ..In my local PC the site was running fine ...But when I publish my site on production server it doesn't work and shows the following error
I have developed a VB.NET program using a strongly typed dataset. This dataset has its connection to a SQL Server 2008 R2. The software should now be additionally used offline. The database should be exported to a *.sdf database. If no connection to the SQL server is produced, the software have to try to connect to the *.sdf database.I would like to achieve:
1. Export the data in the SQL Server 2008 R2 database to a local *.sdf file.
2. This *.sdf file has to work as an alternate connection string in the strongly typed dataset.
How can I write a connection string? I has four different computer that can be connect via ethernet.How can I maintain a inserting data if to computer insert on same table at a single time..??
I am tring to make the below application work with SQL Server 2005 Database Currently it works for test.mdb, which is in the same folder with the application. How shoud I modify the MapPath to work with SQL Server.
i have a app in visual basic mobile 2008, so i finish but now i need to tranfer the data generate in the in the app mobile to data base in sql server 2008.
I am developing a desktop application in VB.NET 2005. I have a requirement whereby a user need to select a .txt file from his machine (client) and after clicking the save button, i need this file to be saved in the server into a specific folder. Similarly, i should be able to retrieve the file as well.
I am using following code to attach my database to SQL Server. The problem is if I create a new file and attach it through my code but when I detach the file using SSMS and again run the same code, it gives error. [code] All the permissions are the same even first time.Also what should be the connection string if I need to use DB with uid sa and pwd abc123?
I don't know if I am asking the question correctly, but I want to keep a program I use all the time in memory (running).So instead of closing the program (main form), I would like to simply set it's visible =false. This is easily done and works.Then on restart (I already know how to check to see if it is running) I would like to attach to it and make that running version's main form be visible again.
I am trying to write code to send a mail message with an attached file.my code works fine if I don't try to attach a file but crashes when I do. I have not been able to figure this out.[code]
I have a project that I am doing which is as follows and need your help to complete the last section I can start word no problem with process.start("winword.exe")the problem is the attachment I attached the documents using project resources and then add exisiting text files and attach it to the project but when I debug I get the following error the code used is as follows
I've written a simple program for viewing images. My issue is how someone would view these images If I deployed my project to a client. To display the images, I have an Access 2007 database with the full path written for each and the program reads the full path into the Picturebox.ImageLocation property. I've also stored the full, root, and relative paths in the database as separate fields. My issue is how to add these pictures to my project. and which project to add them to.
Do I add them to the main project with my forms?Do I add them to the installer/setup-wizard Project?Should I all the files individually or as a compressed .zip file? Additionally, I don't know how to point to these files once they're installed on a different machine/network. Do I write a different root path to the database when the program is installed somehow?
say I have a library, in which I added a few Console.WriteLine(..) statements tot during the implementation and see w going on when I use the library in a Console AppNow I want to use the same library in an ASP.NET app. Ideally I would be able to log on to the production webserver, and somehow start a command prompt and attach it to the website and see the messages in real time as they occur. How do I do that?
I want the program I am making to show the cursors position on the process it is attached to. Sorry if this is a lot to ask for. Can you tell me how to.
1. Make a drop down menu with the list of process.
2. When i click on one of the processes, my program attaches to it.
3. When I move the cursor over the process, my program tells me the co-ordinates of the mouse on the process.
4. When i press F3, Timer3 Starts.
5. Make the mouse move to a co-ordinate on this process.
If it is too much to ask for, can you just tell me how to do 1 of them and hopefully someone else will tell me to do the others.
simple way of attaching a progress bar to the tasks of a button.When I press a button, several tasks will commence and I want a progress bar to show it's... well... progress.
I am currently using the follwoing in my install routine, the idea is to check if the db exists. if the db does exist then leave the mdf name as is and attach it as a temp db then i can run a compare between the 2 db. however if the db does not exist i want to rename the mdf and attach it. however after renaming the mdf i cant attach the file.[code]
attaching filesI am using VB2005 and MS access as a database.I have created a project where a user can add a new record and sometimes with adding the new record you also need to add backup, example a picture,excel, word, txt,pdf.I need to know how to do this?It can be save either on a folder on a local drive or database.I would like to be able to select a file and save it, and if
i have a list of links on a form and when you click one, it will set a specific groupx visible to true in a set position. So I have about 8 groupbopx control on this form. When I drag one out of the way and another in the form in design time, it seems they stay inside one another at times if they overlay. I don't understand this. Then some will not show at runtime depending where they arer left from design time even though I set the position to be in the form. This is completely different from vb6. Why are they staying inside other groupbox controls rather than being independent?
I recently upgraded the MS SQL Server installed on my personal computer from 2005 Express to 2008 Express. Problem is when I try to add an SQL database file to a project using VS 2005 I get an error message saying that the version of my database server is not supported, I must have SQL Server 2005 Beta 2 or later installed. I didn't do it yet but I'm pretty sure that when I open the other projects that I included a database file to it, I'm going to get the same error. My question is it possible to have two SQL Servers installed on my machine? If so, is it a good idea to have two DB servers in the same machine?
Ive created one database Sql Server Compact Edition 2005, with one table ("Cliente") I know that I can created my database good, but i have a problem saving information since three textbox, in my table(With columns "Nombre" "Apellido" "Cliente". In my form there is a button save ("Guardar"). When I do click in my button appear the next message : "The column cannot contain null values. [ Column name = Nombre,Table name = Cliente ] " and happen the same with apellido and Id_Cliente. And this happen becouse my code cant save the information....
This is the code
Option Explicit On Option Strict On
Imports System Imports System.IO Imports System.Data
[CODE]...
And the code for my button is:
Private Sub cmdguardar_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdguardar.Click
Dim myconnection As SqlCeConnection Dim mycommand As SqlCeCommand
before re-inventing the wheel, i want to ask you how i can do this best: I have a VB.Net application that uses a database connection to MS SQL Server 2005 (express version). There are users that input data with the application into the database lets say once to 2x an hour to once a minute. I want to do backups like this: Once a day or once a week (in the evening) a full backup, and whenever the program/user is idle for lets say 10 Minutes, i want to do an incremental backup (so that it does not take so long until he can work on after the backup).
There are no big security issues, just copying the backup data files to a network share / a different computer or server would be fine. i guess the average db size may be 300MB, but the daily increments about 1MB.