I'm having a problem connecting a vb.net express program to sql server express. I'm connecting using the Data Source Configuration wizard.
This is what I know, In vb.net express edition, you have to connect to a local SQL Server. Second you have to use the Windows Authenication option inorder to connect to a mdf file. And last that User Instance=False.
However I'm still getting the error "Unable to open the physical file "C:\Test.mdf" Operating system error 32: "32(The process cannot access the file because it is being used by antoher process.").
In SQL server I create a login using the same signon name as my XP machine and gave permission in SQL server management studio to access the test database.
Please help,
Javon
Trying to connect VB.net Express to SQL server express
coreywelsh
Actually this will sound silly, but I got it working by just restating the computer.
I'm new to VB.net 2005 and using built in data connections. I used dynamic datasets and connections in the previous version of vb.
Thanks
dosler
You don't have the file open in Access, do you
Cordt
That makes perfect sense, it was my next suggestion. That sort of thing happens from time to time.