Oracle ODBC TNS-less connection string (for 64-bit Excel) -

-

Is there a 64-bit Oracle ODBC driver that supports a TNS-less connection (or EZ-connect) conference? I used "Microsoft ODBC for Oracle", which allowed a TNS-less connection string, but it was screwed for a long time and there is no 64-bit version (i.e. this 64-bit office / Will not work for Excel).

I have experience that the user has sometimes missing or invalid tnsnames.ora file in my organization. I want to use a DSN-less connection-string which requires tnsnames.ora which can be successfully executed on any computer that has the proper Oracle Driver installed. This is an example of my old DSN-less, TNS-less connection string, which uses the "Microsoft ODBC Driver for Oracle" driver (still works for users at 32-bit office): 

  driver = {Microsoft ODBC for Oracle}; Uid = myun; PWD = mypass; Server = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = myhostname) (port = 1521)) (CONNECT_DATA = (SID = mysid))); I'm trying to connect to  Oracleient11g_home1  ODBC drivers in Oracle, but how do I try (including EZ_Connect) I'm not able to get it without working tnsnames .ora, I constantly ask this pop-up to specify a service name to me:  
 Enter image details here  
 I use Easy-Connect and many other forms The shish, which specify the kind of straight down the Oracle server IP / hostname, but no luck:  
  Driver Oracle = {OraClient11g_home1}; Server = // oracleip address: 1521 / maisid; Uid = myUsername; PWD = mypassword;    
 
 
 You can completely insert TNS-string for the service name, e.g. .  SERVER = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = myhostname) (PORT = 1521)) (CONNECT_DATA = (SID = mysid)));   
 Attach this through double quotation marks and remove any carriage return and space charter.

Comments

Post a Comment

Popular posts from this blog

mysql - where clause in inner join query -

-
Please help me about this question: Look for functions ($ userpno) } {Echo $ userpno; $ This-> query = "SELECT task.employee_id, task.user_id, task.service_id, service.name AS servicename, service.description AS servicedescription, employee.name as employineame, employee.pic_path employment, employee.pic_path from work Work.user_id = '$ userpno' Join the INNER employee. Pno = task.employee_id Join INNER user user.pno = task.user_id service.service_id = task.service_id "INNER service; } query works perfectly without: WHERE task.user_id = '$ userpno' my Also try this method: WHERE task.user_id = $ userpno but it does not work. Error: Warning: mysqli_fetch_array () parameter 1 is expected to be mysqli_result, given in Boolean C: \ wamp \ www \ admin \ classes \ Task Php on line 22 Please tell me where I say where is it. Try: $ this-> query = "SELECT Task.employee_id, task.user_id, task.service_id, service.name AS s...
Read more

php - MySQL Query for Advanced Search multiple criteria -

-
I am working through an advanced search query where users select the checkbox based on multiple criteria. I am starting because I am hoping that I will know whether I am on the right path. I know that the query is quite messy Edit: I realized that there are two questions to be needed, so I have strictly modified a question question table data tables ss_users user_id FIRST_NAME LAST_NAME admin_level user_approved 1 Nick Jones 0 1 2 Johnny Rocket 0 1 table ss_user_profile_status user_id photo_uploaded 1 1 2 1 table ss_user_photos selected user_id file name photo_id 1 1 photo_1 .jpg 1 2 2 photo_2.jpg 0 3 2 photo_2.jpg 1 table ss_general user_id city state zip neighborhood 1 Baltimore maryland 00125 hamsterdam 2 Lekland My 11542 treemont table ss_languages ​​user_id French German Italian Spanish 1 0 1 0 1 2 0 1 1 Table ss_experience Waldorf Kumon homeschooling user_id 1 0 1 0 2 0 0 1 My current The result is that all users, which should not be the case: ... Select ss_use...
Read more

logging - How can I log both the Request.InputStream and Response.OutputStream traffic in my ASP.NET MVC3 Application for specific Actions? -

-
For a specific set of tasks, I need to log in to the incoming request inputstream as well as outgoing response. is. I am using an ActionFilterAttribute for this and overriding the OnActionExecuted and OnResultExecuted methods. So I'm starting with this idea ... Public category ActionLoggerAttribute: ActionFilterArrbit {Public Override Zero On-Offed Execution (ActionActioned Contact Filter Filter) {base.OnActionAxecuted (FilterContext); HttpRequestBase request = filterContext.HttpContext.Request; // TODO: Log the request. InputStream} Public Override Zero OnResultExecuted (ResultExecutedContext FilterContext) {base.OnResultExecuted (filterContext); HTTPRPSPointBase Response = FilterContacts Hpptex response; // TODO: Log on Response.OutputStream}} Ideally I'll hook it up with enterprise library logging because I'm already using it for error logging. Am I reaching the input and output stream at the right time? Can I easily use the Enterprise Library to log i...
Read more