DevForce Community Forum : The installation in SQL EXPRESS 2005 succeeds but cannot connect http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce Classic : The installation in SQL EXPRESS 2005 succeeds but cannot connect Mon, 20 May 2013 20:12:03 -700 Wed, 18 Jul 2007 13:27:51 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=142 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ The installation in SQL EXPRESS 2005 succeeds but cannot connect : Your problem is that there is... http://www.ideablade.com/forum/forum_posts.asp?TID=142&PID=721#721 Author: davidklitzke
Subject: 142
Posted: 18-Jul-2007 at 1:27pm

Your problem is that there is enough connectivity to the database that you can pass the "Test Connection" test, but DevForce is not able to read the schema information from the database.  There are a number of things which can cause this problem, most of them related to database installation issues, not DevForce issues.

(1) Probably the most  common reason for this message is when you use SQL Server passwords and neglect to mark the checkbox "Allow Saving of Password".  This is almost certainly not your problem.
 
(2) Another common cause is when you don't have a "DevForce compliant" provider (e.g., you're trying to use Access).  That shouldn't be your problem, but you might just try using the OLEDB provider to see whether you have any better luck.  If the OLEDB provider works with the Object Mapper, you can then still use the Native Client provider at runtime.  Just change the connection string in the ibconfig file.
 
(3) Most of the other problems have to do with how the database was installed or configured.  Sometimes just uninstalling the database and reinstalling will fix the problem.
 
(4) The wrong version of MDAC sould cause this problem.  Go to Program Files\Common Files\System\OleDB.  Right click on oledb.dll and chose Properties and then select the Version tab.  You should be using version 2.81 or higher.
 
(5) A corrupted System DLL could cause the problem.
 
(6) The problem could be caused by a Security issue.
 

 

]]> Wed, 18 Jul 2007 13:27:51 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=142&PID=721#721 The installation in SQL EXPRESS 2005 succeeds but cannot connect : Just a quick update, I have tried... http://www.ideablade.com/forum/forum_posts.asp?TID=142&PID=720#720 Author: jacktripper1000
Subject: 142
Posted: 18-Jul-2007 at 10:29am

Just a quick update, I have tried to uninstall and install this and that  is not a solution to this problem.

 
]]> Wed, 18 Jul 2007 10:29:39 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=142&PID=720#720 The installation in SQL EXPRESS 2005 succeeds but cannot connect : Hi, I have similar problem I think.... http://www.ideablade.com/forum/forum_posts.asp?TID=142&PID=717#717 Author: jacktripper1000
Subject: 142
Posted: 18-Jul-2007 at 8:08am

Hi, I have similar problem I think. I have used IdeaBlade devforce express in past so I am confused what's going on on my system.

I had an installation 3.4.x which was not being able to connect to the database so I upgraded to latest 3.5.2.3 but I still see the problem.

Here's what is happening. I open Visual Studio 2005 and IdeaBlade Object Mapper and try to connect to the database. In the settings I use SQL native driver, give the correct name of the SQL Server 2005 named instance MYSERVER\SQLEXPRESS and use Integrated security. Then I click test connection and it works. But when I come back to Ideablade Object Mapper, it shows me not connected and Add Classes also fails. Here's the string for your reference.

Provider=SQLNCLI.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=IdeaBladeTutorial;Data Source=MYSERVER\SQLEXPRESS

I also tried ODBC and did a SQL trace on that and the log shows that IdeaBlade application is talking okay to ODBC (didn't see any errors) but still cannot connect.

Is there some log from Object Mapper that can tell me what's wrong?

Please help.

Jack

]]> Wed, 18 Jul 2007 08:08:38 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=142&PID=717#717 The installation in SQL EXPRESS 2005 succeeds but cannot connect : If your SQL Express installation... http://www.ideablade.com/forum/forum_posts.asp?TID=142&PID=307#307 Author: IdeaBlade
Subject: 142
Posted: 12-Jul-2007 at 11:10am

 If your SQL Express installation is using a named instance you need to use "ServerName\SQLEXPRESS" for the server name.  If you're using the Data Link Properties window from the Object Mapper you can type in the server name if it's not found in the drop down list.

You can also use the SQL Native Client provider

]]> Thu, 12 Jul 2007 11:10:15 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=142&PID=307#307 The installation in SQL EXPRESS 2005 succeeds but cannot connect : I haveinstalled the tutorial in... http://www.ideablade.com/forum/forum_posts.asp?TID=142&PID=306#306 Author: Customer
Subject: 142
Posted: 12-Jul-2007 at 11:08am

I have installed the tutorial in SQL EXPRESS 2005, but
from the OM it cannot connect to me, because from the option "Microsoft OLE DB for Provider SQL Server" it never discovers the DB nor the server.

]]> Thu, 12 Jul 2007 11:08:17 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=142&PID=306#306