New Posts New Posts RSS Feed: Get "unable to connect" problem opening the Object Mapper
  FAQ FAQ  Forum Search   Calendar   Register Register  Login Login

Get "unable to connect" problem opening the Object Mapper
 Post Reply Post Reply
Author
  Share Topic Share Topic  Topic Search Topic Search  Topic Options Topic Options
Customer View Drop Down
Senior Member
Senior Member
Avatar
User Submitted Questions to Support

Joined: 30-May-2007
Location: United States
Posts: 260 		Post Options Post Options   Quote Customer Quote  Post ReplyReply Direct Link To This Post Topic: Get "unable to connect" problem opening the Object Mapper
    Posted: 12-Jul-2007 at 12:38pm

I get an "unable to connect" problem when opening the Object Mapper.
Back to Top
IdeaBlade View Drop Down
Moderator Group
Moderator Group
Avatar

Joined: 30-May-2007
Location: United States
Posts: 353 		Post Options Post Options   Quote IdeaBlade Quote  Post ReplyReply Direct Link To This Post Posted: 12-Jul-2007 at 12:39pm

Have you marked the "Save Password" checkbox.
Back to Top
Jaffir View Drop Down
Newbie
Newbie


Joined: 03-Jun-2008
Posts: 6 		Post Options Post Options   Quote Jaffir Quote  Post ReplyReply Direct Link To This Post Posted: 03-Jun-2008 at 7:10am
IdeaBlade,
 
this did not work.  This is really a show stopper.. if i can't get this part to work, I will not buy the product.  I've tried all the suggestions in the forum
 
1. Created a database connection in VS2005  - no success
2. Ran VS2005 as administrator - no success
3. Uninstalled and installed DevForce for (all users) -  no success
4. Posted comments here -- so far no success
 
Please help, because this seems to be a very common problem with all your customers.
 
thanks.
Back to Top
Jaffir View Drop Down
Newbie
Newbie


Joined: 03-Jun-2008
Posts: 6 		Post Options Post Options   Quote Jaffir Quote  Post ReplyReply Direct Link To This Post Posted: 03-Jun-2008 at 7:52am
IdeaBlade,
 
I've got it to work, i can actually connect now. 
 
In my case, the problem was the connection string, it was missing the password attribute i believe.  I copied the conn string from the tutorial .orm file, and it connected.  However, it did not give me the list of talbes.  You have to press the big red + sign on top.  The documentation does not point this out by the way.
 
Also, give the VS2005 user sysadmin rights in Sql Server (BUILTIN\Administrators or BUILTIN\Users)
 
 
I hope this helps people out there.
Back to Top
kimj View Drop Down
IdeaBlade
IdeaBlade
Avatar

Joined: 09-May-2007
Posts: 1391 		Post Options Post Options   Quote kimj Quote  Post ReplyReply Direct Link To This Post Posted: 03-Jun-2008 at 9:23am
The connection string was missing the password attribute because you hadn't checked the "Allow saving password" checkbox in the Data Link Properties dialog, and you were not using NT integrated security (this is assuming use of the OLEDB Provider for SQL Server, since providers differ on the connection info they gather).  "Saving the password" means that the final connection string built and used by the Object Mapper contains all information required to connect to the database server.
 
If you use NT Integrated security, your Windows userid must have permissions to the SQL Server and the database objects.  The connection string will not contain user/password information, but instead contain the attribute "Integrated Security=SSPI".  It will look something like this:
 
Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=IdeaBladeTutorial;Data Source=.
 
If you use SQL Server authentication, both userid and password should be present, and your connection string will look something like this:
 
Provider=SQLOLEDB.1;Persist Security Info=True;User ID=kim;Password=kim;Initial Catalog=IdeaBladeTutorial;Data Source=.
 
The SQL login id used by the Object Mapper - whether using integrated security or SQL security - does not require admin rights.  It requires permission to connect, and query permission on the database objects to be mapped.  It's frequently easier to login with an admin user id, particularly when doing development work, but it is not required. 
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down