attach user mdf problem

G

GG

I had a visual basic .net application u0 and running on a pc with sql server
user mdf file.. I moved the application to a nother pc along with the mdf
and ldf files.


the ruser running the recompiled application does have full access to the
directory holding the mdf file and its ldf file however I got this error

---------------------------
Microsoft Visual Studio
---------------------------
myDBDataSet.CodeTable.Fill,GetData () could not be previewed.

An attempt to attach an auto-named database for file d:\\MDF\myDB.mdf
failed. A database with the same name exists, or specified file cannot be
opened, or it is located on UNC share.
---------------------------
OK Help
---------------------------
the connection string is
Data Source=.\SQLEXPRESS;
AttachDbFilename=d:\MDF\IeStringTmp.mdf;
Integrated Security=True;
Connect Timeout=30;
User Instance=True

I do notice the ldf file is named d:\MDF\IeStringTmp_log.LDF
is this normail?
also what should I do with the connection string to make it work?
 
G

GG

I got the application running with access to the db now however I still
have trouble viewing the the datasets using the connection string from the
visual studio


Looks like I have look a bit further inti how the datset shown int he data
source of visual studio is setup. I have been away from vidual studio for
too long.
 
G

GG

what does the following message means when I test the connection from visual
studio proeject data sources:

An error occurred while retrieving the information from the database

An attempt to attach an auto-name database for the file d:\MDF\MyDb.mdf
failed. A database with the same name exist, or specified file cannot be
opened, or it is location on UNC share
 
C

Cor Ligthert[MVP]

GG,

A visual basic net application is a very wide description as this can be
everything.

Are you talking about a mobile application?

Cor
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top