the 2nd option i have tried earlier but it still gives error with the new name of the database
can you plzzz tell me in C:documents and settings where do get the defntion?
holyskylark58
Last Activity: Mar 25 '10, 03:19 PM
Joined: Mar 19 '10
Location: i am an Indian, my city is Kolkata
-
Database 'C:\Documents and Settings\doyel\ Desktop\clg project\library 1\library1\bin\ Debug\Database1 .mdf' already exists.
Could not attach file 'F:\clg project\library 1\library1\bin\ Debug\Database1 .mdf' as database 'Database1'.Leave a comment:
-
the code is given above i'll give the error within a minLeave a comment:
-
it says that there exists another database so that this database can not be attached.Leave a comment:
-
holyskylark58 started a topic how to move a database file from one drive to another drive and make it working.in SQL Serverhow to move a database file from one drive to another drive and make it working.
i have made my vb.net project in the C: i have used sql server 2005 for my database.
now i cut paste my project folder into D: but there i can not attach the database because it says that already in the C: the same database exits so this database in the D: can not be attached.
but actually there is no such database in the C: as i have CUT PASTE it.
plzz help me to solve this problem. -
CroCrew ,
if i create it in my desktop initialy. then move my project to the f:
there the problem arises.
ie the database cannot be attached. the error it gives, is there exists same db.mdf file in the desktop. so the db.mdf fie which is in the f: cannot be attached. but i have cut paste my project folder. there is no databade file of same name in the desktopLeave a comment:
-
but i am not using sql security option i am using windows security option there is no option of userid or password. so i cant make the connection string.Leave a comment:
-
to: CroCrew
can you please tell me what the IP to Database server; should be in line 6? i am not so familiar with this. where i can get this name. actually i get the connectin string from the app.config file. is it right to do that?
if not plzz tell me the correct way.Leave a comment:
-
thank you friend. i am really greatfu to you.
plzz if you can plzz move this thread to the sql area . actually i thought as this code is written in vb.net it'll be best to be post it here.
now if you think that to move it to the sql area will be better plzz do it.Leave a comment:
-
hey please stop asking such question if can you solve my problem then please answer me. it's very urgent.
moderator i have gone through the link you have given but whatever it says i hv done those in my code but still it is not worinkg how strange when i am using select command it is prefctly returning value as desired but it can not insert data in the database.Leave a comment:
-
Cannot see my updated rows in the database
Using this code i cannot insert data in the database . it gives no error but no row is created in the data base
...Code:Imports System.Data.SqlClient Public Class Form1 Dim con As New SqlConnection("Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database1.mdf;Initial Catalog=Database1;Integrated Security=True;User Instance=True") Private Sub Button1_Click(ByVal sender As System.Object,
No activity results to display
Leave a comment: