DevForce Community Forum : SQLbulkcopy needs connection string http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce Classic : SQLbulkcopy needs connection string Sat, 11 Apr 2026 01:12:52 -700 Mon, 19 Aug 2013 12:26:36 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=4282 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ SQLbulkcopy needs connection string : Your solution using the datasourekeyresolver... http://www.ideablade.com/forum/forum_posts.asp?TID=4282&PID=16751#16751 Author: BigA25
Subject: 4282
Posted: 19-Aug-2013 at 12:26pm

Your solution using the datasourekeyresolver worked perfectly. Thank you so much :-)]]> Mon, 19 Aug 2013 12:26:36 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=4282&PID=16751#16751 SQLbulkcopy needs connection string : What you're doing will return... http://www.ideablade.com/forum/forum_posts.asp?TID=4282&PID=16750#16750 Author: kimj
Subject: 4282
Posted: 19-Aug-2013 at 10:56am

What you're doing will return the connection string used by DevForce for this key, so I don't know why it would be incorrect.  If you have multiple RdbKeys make sure you're looking at the correct key.  
 
If this is an n-tier application be sure you retrieve the RdbKeys on the server, since you likely (and shouldn't) have the connection strings on the client.
 
Also, if you're using a DataSourceKeyResolver this won't return the resolved connection string for the key, but something like this will:
 
var key = pm.DataSourceResolver.GetDataSourceKey(name) as RdbKey;
var cnstring = key.ConnectionString;
 
]]> Mon, 19 Aug 2013 10:56:32 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=4282&PID=16750#16750 SQLbulkcopy needs connection string : For performance reasons I... http://www.ideablade.com/forum/forum_posts.asp?TID=4282&PID=16749#16749 Author: BigA25
Subject: 4282
Posted: 19-Aug-2013 at 10:14am

For performance reasons I am trying to use sqlbulkcopy to insert a bunch of data into the sqlserver. 

I have been trying to use

IdeaBladeConfig.Instance.RdbKeys[0].Connection 

to get the connection string but I seem to be having trouble due to it not being in the correct form.

Also the Data Source off that connection doesn't seem to be correct. 

How can i get a sql connection string from ideablade?


Edited by BigA25 - 19-Aug-2013 at 10:26am]]> Mon, 19 Aug 2013 10:14:32 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=4282&PID=16749#16749