c# - Oracle ManagedDataAccess and special characters when logging in -


i've encountered issue oracle.manageddataaccess seems impossible use non-ascii connectionstring (non-ascii empirical guess).

this fine , dandy:

var cs = string.format("data source={2};password={1};user id={0}", "user", "pwd", "mydb"); var connection = new oracleconnection(cs); connection.open();

but not work (å, ä , ö swedish letters):

var cs = string.format("data source={2};password={1};user id={0}", "åäö", "lösenord", "mydb"); var connection = new oracleconnection(cs); connection.open();

and throws

oracle.manageddataaccess.client.oracleexception: ora-01017: invalid username/password; logon denied

both users capable of logging on via sqldeveloper.

does know of way around this? or known limitation manageddataaccess (well, dataaccess) libraries oracle?

ninja stuff, ie using chr(int), hard when signing in..

db info:

nls_language    american nls_territory   america nls_currency    $ nls_iso_currency    america nls_numeric_characters  ., nls_characterset    we8mswin1252 nls_calendar    gregorian nls_date_format dd-mon-rr nls_date_language   american nls_sort    binary nls_time_format hh.mi.ssxff nls_timestamp_format    dd-mon-rr hh.mi.ssxff nls_time_tz_format  hh.mi.ssxff tzr nls_timestamp_tz_format dd-mon-rr hh.mi.ssxff tzr nls_dual_currency   $ nls_comp    binary nls_length_semantics    byte nls_nchar_conv_excp false nls_nchar_characterset  al16utf16 nls_rdbms_version   11.2.0.1.0

edit:

also tested (ie adding quotes, oracleconnectionstringbuilder "="):

var cs = string.format("data source={2};password={1};user id={0}", "\"åäö\"", "\"lösenord\"", "mydb"); var connection = new oracleconnection(cs); connection.open();

i ran same problem , issue got fixed latest odp managed driver version september 16, 2016 (4.121.2.20150926).

be careful download 32bit section of oracle website (http://www.oracle.com/technetwork/database/windows/downloads/utilsoft-087491.html) oracle seems have missed add 64 bit section, latest version still october 2015. more information see question on oracle forums: https://community.oracle.com/message/14037653#14037653

makes kinda wonder though oracle to, since did not support language specific characters 3 years in managed driver...


Comments

Post a Comment

Popular posts from this blog

curl - PHP fsockopen help required -

i trying work on cloudflare api , have found in documentation. unfortunately have no idea how can use in fsockopen or through curl. here example of post request. need know how can make request below data post using curl or fsockopen curl https://www.cloudflare.com/api_json.html -d 'a=cache_lvl' \ -d 'tkn=8afbe6dea02407989af4dd4c97bb6e25' \ -d 'email=sample@example.com' \ -d 'z=example.com' \ -d 'v=agg' here link cloudflare https://www.cloudflare.com/docs/client-api.html#s4.2 try one: $ch = curl_init("https://www.cloudflare.com/api_json.html"); curl_setopt($ch, curlopt_returntransfer,1); curl_setopt($ch, curlopt_followlocation, 1); curl_setopt($ch, curlopt_ssl_verifypeer,false); // handling of -d curl parameter here. $param = array( 'a' => 'cache_lvl', 'tkn' => '8afbe6dea02407989af4dd4c97bb6e25', 'email' => 'sample@example.com', 'z' =...
Read more

HTTP/1.0 407 Proxy Authentication Required PHP -

i working in restricted network/limited access internet. since have use proxy make web service call. here php code calling web service , response . $client = new soapclient("http: //www.xyz.com/abc/wsdls/login.wsdl", array("trace" => 1, "exceptions" => 1, 'proxy_host' => $proxy_host, 'proxy_port' => $proxy_port, 'proxy_login' => $proxy_login, 'proxy_password' => $proxy_password)); response is fatal error: uncaught soapfault exception: [wsdl] soap-error: parsing wsdl: couldn't load ' http://www.xyz.com/abc/wsdls/login.wsdl ' : failed load external entity if copy url error message , paste in browser(with same proxy settings) works. 2nd scenario is, if pass values instead of variables giving me diffarant response $client = new soapclient("http: //www.xyz.com/abc/wsdls/login.wsdl", array("trace" => 1, "exceptions" => 1, 'proxy_host' ...
Read more

c# - Resource not found error -

i have problem accessing method on homecontroller. show code of method : [httpget] public actionresult decriptidentifiantetredirige(string login_crypter, string mdp_crypter) { string loginacrypter = _globalmanager.protegemotdepasse(login_crypter); string mdpacrypter = _globalmanager.protegemotdepasse(mdp_crypter); user userapp = new models.user(login_crypter, mdp_crypter); if (userapp.authentificationvalidee(userapp.userlogin, userapp.password)) { session["name"] = userapp.userlogin; return redirecttoaction("accueil", "home"); } else { return redirecttoaction("validerauthentification", "home"); } } then in routeconfig.cs wrote route : routes.maproute( name: "authentificationapresdecryptage", url: "{controller}/{action}/{login_crypter}/{mdp_crypter}", defaults: new...
Read more