c# - SqlConnection unable to connect using IP address -


pretty simple question.

i cannot connect using string:

 sqlconnection myconnection = new sqlconnection("network address=(192.168.1.120); password=userpassword; user id=username; database=mydb");

i try change data source, address, , anytime have period in string raises exception. if change point localhost name no period or hostname not using fdnq works fine. know what's that?

the exception raised when using ip address or server name several subdomains period invalid. "incorrect syntax near '.'."

i went connectionstrings.com , copied same string used before , failed.

my sqlcommand had bad sql syntax in due several lines of concatenation. stupid me.


Comments

Post a Comment

Popular posts from this blog

c# - Operator '==' incompatible with operand types 'Guid' and 'Guid' using DynamicExpression.ParseLambda<T, bool> -

i'm using dynamic linq library , there source code , basic docu , nuget version pm> install-package dynamiclinq i'm trying construct clause involves guids i have tried string "id == @0" . parameter array object[] value ( guid xxxx ) var whereclausesb = buildlogicalkeywhereclause2(entity, logicalkey); //build string var parms = buildparamarray(entity, logicalkey); // object[] var wherelambda = ofsi.bos.core.dynamicexpression.parselambda<t, bool>(whereclausesb.tostring(),parms); //parse an exception thrown in dynamicexpression.parselambda operator '==' incompatible operand types 'guid' , 'guid' i have tried guid , string.(fail) i tried , "id = @0" (fail). string == string works, int32==int32 not guid == guid not any ideas? try using equals method instead of == operator in string: "id.equals(@0)"
Read more