DevForce Community Forum : DataSourceKeyResolver identity insert issue http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce Classic : DataSourceKeyResolver identity insert issue Thu, 11 Jun 2026 00:06:57 -700 Fri, 25 Jul 2008 12:59:07 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=776 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ DataSourceKeyResolver identity insert issue : We've logged a bug report... http://www.ideablade.com/forum/forum_posts.asp?TID=776&PID=3247#3247 Author: kimj
Subject: 776
Posted: 25-Jul-2008 at 12:59pm

We've logged a bug report for this, thanks for bringing it to our attention.]]> Fri, 25 Jul 2008 12:59:07 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=776&PID=3247#3247 DataSourceKeyResolver identity insert issue : Thanks.Was having the same issue,... http://www.ideablade.com/forum/forum_posts.asp?TID=776&PID=3245#3245 Author: brentvee
Subject: 776
Posted: 24-Jul-2008 at 12:40am

Thanks.

Was having the same issue, and this helped :)
]]> Thu, 24 Jul 2008 00:40:03 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=776&PID=3245#3245 DataSourceKeyResolver identity insert issue : I'm posting this so if someone... http://www.ideablade.com/forum/forum_posts.asp?TID=776&PID=2851#2851 Author: DataMan
Subject: 776
Posted: 18-Apr-2008 at 4:45pm

I'm posting this so if someone else has this same issue they won't spend 4 days of debugging to figure out identity columns were not changing from -100 to a positive number when being saved to the table.  Here's the situation:
 
Have a ibconfig file that has the following line:
 
<rdbKey name="default" databaseProduct="Unknown">
<connection>Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=xxxx;Data Source=yyyyy</connection>
<probeAssemblyName>Model</probeAssemblyName>
</rdbKey>
 
Notice that it's name is "default"
 
Then I had a IDataSourceKeyResolver like the following:
 
public IDataSourceKey GetKey(string pKeyName, string pKeyExtension)
{
ConnectionStringNew = "Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=xxxx;Data Source=xxxx\serverhere"
return new IdeaBlade.Rdb.RdbKey("Live", ConnectionStringNew);
}

Because the ibconfig file said "Default" and the IDataSourceKeyResolver said "Live" my SQL identities were not working properly and storing as negative (-) numbers.

When I changed the resolver to match the config file everything worked fine.
 
The hard part to debug this is that I added this line in to the getentities code

RdbKey key = (RdbKey)mPersMgr.DataSourceResolver.GetDataSourceKey("Employee");

And when I created a watch on the key it would return looking like everything was ok.  The dataprovider was set as SQL.
 
Just posting this so someone else with this issue won't have to go though the "Fun" I did!
 
Thanks
 
]]> Fri, 18 Apr 2008 16:45:58 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=776&PID=2851#2851