sqlconnection :S :S
-
When i use oledb.oledbconnection,i connect to SQL Server with this connection string :
Provider=SQLOLEDB.1; Persist Security Info=False;User ID=sa;Initial Catalog=MDLABS;Data Source=SQL;But when i use sqlclient sql connection , i cannot connect to sql server. my sqlclient connection string isPersist Security Info=False;User ID=sa;Initial Catalog=MDLABS;Data Source=SQL;What is missing? -
When i use oledb.oledbconnection,i connect to SQL Server with this connection string :
Provider=SQLOLEDB.1; Persist Security Info=False;User ID=sa;Initial Catalog=MDLABS;Data Source=SQL;But when i use sqlclient sql connection , i cannot connect to sql server. my sqlclient connection string isPersist Security Info=False;User ID=sa;Initial Catalog=MDLABS;Data Source=SQL;What is missing?Providing the error you get may go some way to helping people answer your question. Current blacklist svmilky - Extremely rude | FeRtoll - Rude personal emails | ironstrike1 - Rude & Obnoxious behaviour
-
Providing the error you get may go some way to helping people answer your question. Current blacklist svmilky - Extremely rude | FeRtoll - Rude personal emails | ironstrike1 - Rude & Obnoxious behaviour
-
ex.message = Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
pretty straightforward error message don't you think? A timout implies that the connection worked fine, but timed out on whatever operation you asked of it! Current blacklist svmilky - Extremely rude | FeRtoll - Rude personal emails | ironstrike1 - Rude & Obnoxious behaviour
-
pretty straightforward error message don't you think? A timout implies that the connection worked fine, but timed out on whatever operation you asked of it! Current blacklist svmilky - Extremely rude | FeRtoll - Rude personal emails | ironstrike1 - Rude & Obnoxious behaviour
J4amieC wrote:
A timout implies that the connection worked fine, but timed out on whatever operation you asked of it!
Unless it was a connection timeout ;P
-
J4amieC wrote:
A timout implies that the connection worked fine, but timed out on whatever operation you asked of it!
Unless it was a connection timeout ;P
Even if it was, that error message implies that the connection string was correct in syntax, but that the connection or operation timed out. I should have been more specific. Current blacklist svmilky - Extremely rude | FeRtoll - Rude personal emails | ironstrike1 - Rude & Obnoxious behaviour
-
When i use oledb.oledbconnection,i connect to SQL Server with this connection string :
Provider=SQLOLEDB.1; Persist Security Info=False;User ID=sa;Initial Catalog=MDLABS;Data Source=SQL;But when i use sqlclient sql connection , i cannot connect to sql server. my sqlclient connection string isPersist Security Info=False;User ID=sa;Initial Catalog=MDLABS;Data Source=SQL;What is missing?Take a look at this damn handy resource.... http://www.connectionstrings.com/[^] Regards, Rob Philpott.
-
Even if it was, that error message implies that the connection string was correct in syntax, but that the connection or operation timed out. I should have been more specific. Current blacklist svmilky - Extremely rude | FeRtoll - Rude personal emails | ironstrike1 - Rude & Obnoxious behaviour
"An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. " how to configure server for remote connections -- modified at 14:55 Thursday 27th April, 2006