sql connectivity error?

Posted Date: 10 Aug 2008 Posted By: Rahul Member Level: Silver Points: 1 Responses: 1

My coonection string is like below:
strConnect = _T("Provider=sqloledb;Data Source=MyServerName;"
"Initial Catalog=MyDatabaseName;"
"User Id=MyUsername;Password=MyPassword;");

When i use to connect using this connection string it shows error that
"error:40 Under default settins sql does not allow to connect"

I do not have installed sql server.Is it required to connect....
i have installed "Visual studio 2005" and IIS server.

Responses

Author: R.Sujaa 10 Aug 2008

Member Level: Silver

Rating:

Points: 4

strConnect = _T("Data Source=MyServerName;"
"Initial Catalog=MyDatabaseName;"
"User Id=MyUsername;Password=MyPassword;");

Dont use provider for sql connectivity since provider sqloledb is used only for oledb connectivity

try connecting without provider definition in the connection string

Post Reply

This thread is locked for new responses. Please post your comments and questions as a separate thread.
If required, refer to the URL of this page in your new post.

	Next : what is the difference between overriding and shadowing?
	Previous : New Keyword
	Return to Discussion Forum
	Post New Message
	Category: .NET

Related Messages

dotNet Slackers

About Us Contact Us Privacy Policy Terms Of Use