c# - Reading content from MS Access db using ADO.net and trying to insert the values into a SQL Server table -

c# - Reading content from MS Access db using ADO.net and trying to insert the values into a SQL Server table -

i'm using oledb connection read table in ms access. i've closed connection , i'm trying insert values retrieved sql server table using entity framework.

while establishing connection sql server, i'm getting error:

a network-related or instance-specific error occurred while establishing connection sql server. server not found or not accessible. verify instance name right , sql server configured allow remote connections. (provider: sql network interfaces, error: 26 - error locating server/instance specified)

the error message crystal clear: server not found. so, take 2 steps.

verify connection string misspelled server name.

verify sql server instance accepting connections network, disable default.

go to:

start > programs > sql server 2005 > configuration tools > sql server surface area configuration

click on surface area configuration services , connections

select instance having problem > database engine > remote connections

enable local , remote connections

restart instance

see article:

http://www.sswug.org/articlesection/default.aspx?targetid=44331

c# entity-framework