Results 1 to 7 of 7

Thread: Database Problem

  1. Jan 31st, 2011, 05:33 AM #1
    kulfi
    kulfi is offline

    Thread Starter
    Lively Member
    Join Date
    Jan 2011
    Posts
    119

    Database Problem

    Hi Please can u see the attached attaching database problem i am just new to This Please guide me.
    thanks
    Attached Images Attached Images  
    Reply With Quote Reply With Quote
  2. Jan 31st, 2011, 08:56 AM #2
    techgnome
    techgnome is offline
    PowerPoster techgnome's Avatar
    Join Date
    May 2002
    Posts
    34,687

    Re: Database Problem

    You can't have two databases of the same name attached to SQL. The error is quite clear... you already have a database that is the same name as the one you are trying to attach.

    -tg
    * I don't respond to private (PM) requests for help. It's not conducive to the general learning of others.*
    * I also don't respond to friend requests. Save a few bits and don't bother. I'll just end up rejecting anyways.*
    * How to get EFFECTIVE help: The Hitchhiker's Guide to Getting Help at VBF - Removing eels from your hovercraft *
    * How to Use Parameters * Create Disconnected ADO Recordset Clones * Set your VB6 ActiveX Compatibility * Get rid of those pesky VB Line Numbers * I swear I saved my data, where'd it run off to??? *
    Reply With Quote Reply With Quote
  3. Jan 31st, 2011, 09:26 AM #3
    MarMan
    MarMan is offline
    Frenzied Member
    Join Date
    Jan 2010
    Location
    Connecticut
    Posts
    1,687

    Re: Database Problem

    Welcome!

    Where is the D: drive? Did you attach any other databases that way?
    VB6 Library

    If I helped you then please help me and rate my post!
    If you solved your problem, then please mark the post resolved
    Reply With Quote Reply With Quote
  4. Feb 1st, 2011, 12:16 AM #4
    kulfi
    kulfi is offline

    Thread Starter
    Lively Member
    Join Date
    Jan 2011
    Posts
    119

    Re: Database Problem

    NO actually i attached that database from a remote Area now i deleted it from the Visual Studio and i want to attach again but i am getting this message is it possible that i can know where the information is still saved which is not allowing me to attach. Thanks Please i am just new to this, it does not matter even i attach from the same remote area or from the D: Drive local drive i get the same message.
    Reply With Quote Reply With Quote
  6. Feb 1st, 2011, 12:49 AM #5
    techgnome
    techgnome is offline
    PowerPoster techgnome's Avatar
    Join Date
    May 2002
    Posts
    34,687

    Re: Database Problem

    Jsut because you deleted it from VS doesn't mean you deleted it from the database server... you just simply removed it from the data source explorer.

    -tg
    * I don't respond to private (PM) requests for help. It's not conducive to the general learning of others.*
    * I also don't respond to friend requests. Save a few bits and don't bother. I'll just end up rejecting anyways.*
    * How to get EFFECTIVE help: The Hitchhiker's Guide to Getting Help at VBF - Removing eels from your hovercraft *
    * How to Use Parameters * Create Disconnected ADO Recordset Clones * Set your VB6 ActiveX Compatibility * Get rid of those pesky VB Line Numbers * I swear I saved my data, where'd it run off to??? *
    Reply With Quote Reply With Quote
  7. Feb 1st, 2011, 01:05 AM #6
    baadil
    baadil is offline
    Junior Member
    Join Date
    Jan 2011
    Posts
    25

    Re: Database Problem

    As techgnome mentioned, you probably deleted the link to your DB in visual studio. DB is probably still attached in SQL server. In your add-a-connection dialog, choose "Select or enter a database..." instead of "Attach a database"

    Also, in future, it is probably a good idea to use a particular database name instead of auto-name.
    Reply With Quote Reply With Quote
  8. Feb 1st, 2011, 03:26 AM #7
    kulfi
    kulfi is offline

    Thread Starter
    Lively Member
    Join Date
    Jan 2011
    Posts
    119

    Re: Database Problem

    First of all thanks
    DataBase Name is CAD_Data_Base.mdf
    when i select the databse i get this message, remember that i have sql server running.

    A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

    Please i have one more question but it is very important
    when i import a MS Access Data base from remote area like \\10.0.0.155\V-Schedule\CAD_Data_Base.mdf to mdb file why the destination place of the file is changed i want the file to stay in the same place.
    THanks
    Last edited by kulfi; Feb 1st, 2011 at 06:21 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width