Windows 7 64bit, Classic ASP, Visual Studio connection to Oracle Database

References

26.12.2013 Update

We realized, over a 64bit OS you may need to change the default application pool to accommodate 32bit applications. Please refer to this post

https://help.webcontrolcenter.com/KB/a1114/how-to-enable-32-bit-application-pool-iis-7-dedicatedvps.aspx

 

 

http://www.connectionstrings.com/

http://stackoverflow.com/questions/234657/binding-asp-net-gridview-to-an-oracle-sys-refcursor

So, you are still using classic ASP or develop 32bit .NET applications using Visual Studio and Oracle databases on a Windows 7 64bit box and completely lost as connection cannot be established?

Here are few workaround solutions

Install the latest Oracle clients (both 64bit and 32bit)

If you installed Oracle client in the following folders (example)

D:\app\yourusername\product

right click on the folder, under security tab check whether authenticated users have read privileges.

If not, provide the basic privileges (Read & Execute, list folder contents, Read) Refer the image

image

Now add the user “IIS_ISURS” user and provide the same rights mentioned above

RESTART your Windows 7 “64bit” box now!

You can establish the connection from classic ASP like following

<%
    Dim adoCon                'Holds Connection
    Dim rsViewRecords        'Holds Recordset

    Set adoCon = Server.CreateObject("ADODB.Connection")
    if Err.Number <> 0 then 
        Response.Clear() 
        response.Write "<hr>ORASESSION Error<br>" & err.number & "  --  " & err.Description & "<hr>"
        response.End
    end if 

    adoCon.Open "provider=oraoledb.oracle;data source=test;user id=apps;password=apps;plsqlrset=true"

    Set rsViewRecords = Server.CreateObject("ADODB.Recordset")

    %>

 

Regards,

Admin

Advertisements

Sharing EPSON LQ Series Dot Matrix Printer between Windows 7 & Windows XP

 

We got the tip from following link and all we do here is to structure the instructions in a better format

http://windows7forums.com/windows-7-support/39605-printer-driver-network-printer.html

1. Open Devices and Printers

image

2. Select add printer near the top menu bar

3. Select add local printer

image

4. Choose Create a new port and local port from drop down arrow Click Next

image

5. In the enter a port name do one of the following

1. \\MachineNameHostingPrinter\Printer’sShareName or

2. \\ipaddressOfMachineHostingPrinter\Printer’sShareName

image

6. In the install printer driver dialog box do one of the following

image

1. In the left panel select your printer manufacturer and in the right panel select your printer model (to use Win7 native drivers) if you’ve already had the Epson attached and installed on the Windows 7 machine, this step should work for you.

2. Select the have disk button and direct the install process to the folder where you have download and extracted the Win 7 drivers for your printer. Unfortunately if Epson doesn’t provide any Windows 7 drivers this step will not work for you.

 

We hope the above instructions relieve some kind of stress for hardware teams!

Regards,

Admin

Windows 7 “no internet access” false message

We lost the count of discussions initiated through this blog, every time there was another “reason” for this false message with Windows 7. After using Windows 7 more than couple of years time, recently we noticed this false message being an annoyance once again with few of the dell desktop machines we started using at work.

Loads of googling around brought us to a topic which discussed about AVG blocking Windows network awareness service and further dwelling into the topic proved that, any Anti-virus with a built-in firewall capability could indirectly affect the above said service, thus causing “no Internet access” false message. At work we use symantec endpoint as corporate solution and Avast Internet security suite with few client systems which are dominantly used for Oracle development.

Somehow, Symantec end point suite always disliked Oracle forms developer suite(s) and we were forced to switch to Avast suite for those users who are into Oracle development.

Back to the topic, following a tip obtained from google search, we did the following

Avast -> settings -> Troubleshooting-> and checked “load avast services only after loading other services” and bingo! no more false messages, no more yellow triangle with network connection icon.

Agent Ransack is here! Forget using Windows 7 Search

Quite an old topic, ain’t it? Windows 7 “enhanced” search always sucked and it is still! It sucks big time when you try to search for something from a USB connected external hard-disk or device as the indexing engine doesn’t have any information about the contect of the drive yet!

One extremely handy tool for such occassion is having Agent RanSack, light in weight, absolutely free Windows search utility and it does return results with an amazing speed. Why to waste your time for Windows 7 to do an indexing on your external HDD? Go ahead and search using Agent RanSack. Get it here http://mythicsoft.com/Page.aspx?type=agentransack&page=download

Regards,

Admin

Yahoo Messenger 11 connectivity issues behind ISA 2006 firewall

Update

With update 11.5.0.155-us Yahoo messenger has additional issues with negotiating a handshake with ISA server. Please read this KB article http://support.microsoft.com/kb/309347 for additional IE setting changes in order to let yahoo through ISA server.

 

Do you “still” IM using yahoo messenger? The latest version has facebook integration and more to offer which allows you to communicate (chat) with your friends online over social networks.

However, Yahoo messenger fails to establish a connection to it’s servers if behind ISA firewall. Here we are offering you some guidelines dealing with such scenarios.

Most acceptible reasoning for connectivity issues behind ISA firewall should be, YM failing to forward the NTLM authentication credentials to ISA fiewall while trying to establish a connection. Once failed to establish a connection, user will be provided a chance to troubleshoot the issue, which does the trick!

All you need to do is to click the troubleshoot button and wait for the process to complete. If curious, click on the details button to see multiple connectivity checks performed by YM. As soon as the troubleshoot activity completed, rush to login again with your username and password

You should able to logon to yahoo services without troubles this time. Please note, you should try to logon immediately once after the troubleshooting process is completed. This means you cannot wait minutes after the troubleshoot activity is completed. Else you will once again have to go through the entire process of troubleshooting until you manage to logon.

Enjoy all new features offered by Yahoo Messenger from “work” now

Windows 7, deal with network adaptor issues

We have one 6530b HP laptop machine with us, which has gone through half dozen formats, mainly due to issues with network adaptor. The last format was performed 2 weeks back and realized one important factor. If windows finds a proper driver for your network adaptor, NEVER NEVER try to upgrade the driver using OEM or chip manufacturer drivers!

We were doing the same mistake always as the driver configured by Microsoft dates back to year 2009 beginning. Once the driver set by Microsoft untouched, the network related issues are almost non-existing right now.

Hope this information is useful for those who have few years old hardware and a new age OS like Windows 7!

for Windows7bugs,

Admin

Oracle Developer 10g 10.1.2.0.2 Crash on Windows 7 while opening forms modules!

We are using Oracle developer 10g, details:

Forms [32 Bit] Version 10.1.2.0.2 (Production)
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 – 64bit Production
With the Partitioning, OLAP and Data Mining options
Oracle Toolkit Version 10.1.2.0.2 (Production)
PL/SQL Version 10.1.0.4.2 (Production)
Oracle Procedure Builder V10.1.2.0.2 – Production
PL/SQL Editor (c) WinMain Software (www.winmain.com), v1.0 (Production)
Oracle Query Builder 10.1.2.0.2 – Production
Oracle Virtual Graphics System Version 10.1.2.0.2 (Production)
Oracle Tools GUI Utilities Version 10.1.2.0.2 (Production)
Oracle Multimedia Version 10.1.2.0.2 (Production)
Oracle Tools Integration Version 10.1.2.0.2 (Production)
Oracle Tools Common Area Version 10.1.2.0.2
Oracle CORE 10.1.0.4.0 Production

and recently noticed additional crashing behavior on Windows 7 (64Bit) without any apparent reasons. Based on one of our previous posts, after dwelling into possible reasons figured out the following!

Few of the database level procedures were modified with more parameters(IN and OUT) which was causing the developer suite to crash down.

So, prior you make changes to database level procedures or functions, MAKE SURE YOU DO CHANGE THE PROCEDURE/FUNCTION CALLS FROM YOUR FORM MODULES with all new IN and OUT parameters, then proceed with compiling your Procedures and Functions @ database level. If anybody is aware of another method to deal with this situation, please pass the information through comments.

for Windows7bugs,

Admin

How to reproduce the darn “Additional log on information may be required” Windows “false” error message.

Are you feeling glad? During last few updates, Microsoft has fixed(?) this annoying notification to a greater extend. However if you want to reproduce this error do the following:
Disable your network adaptor.
Connect your computer to another available connection (Preferably to a tethered connection)
Disconnect from the new network
Enable your default connection

Now watch the notification popping up and the network connection with “famous” yellow triangle (Warning) until next restart.

for Windows7bugs
Admin

Testing Oracle 10g developer forms locally (On Windows 7)

Okay guys, another post after another break :) This time we are going to figure out how to test your Oracle 10g developer forms locally. Until recent comments we were not knowing that fellow folks were having issues running developer 10g forms locally on Windows 7 machines. Okay here we go
Step 1
Install the latest java run time from here and make sure you are installing 32bit. Usually java 32bit gets installed under this path “C:\Program Files (x86)\Java\jre6”
Following is test environment

OS: Windows 7 64bit Professional Editions, 3GB Mem
10g Developer: Forms [32 Bit] Version 10.1.2.0.2 (Production)
Database: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production

Usually when you try to run a form locally for the first time after starting the OC4J instance, an older version of java initiator is installed in your system. I don’t quite remember whether the installation offers any kind of customization so that the end user could change the path or other options. I won’t recommend one either!
If you have done a standard installation, the java initiator should get installed on this path “C:\Program Files (x86)\Oracle\JInitiator 1.3.1.22”.

Step 2

In order to let Developer 10g forms run locally you need to change the jvm.dll file found under “C:\Program Files (x86)\Oracle\JInitiator 1.3.1.22\bin\hotspot” with a most recent one. As we installed the latest java run time 32bit in “Step 1”, browse to the following folder “C:\Program Files (x86)\Java\jre6\bin\client” copy the jvm.dll which is above 2MB in size, and go back to folder “C:\Program Files (x86)\Oracle\JInitiator 1.3.1.22\bin\hotspot”

Now paste the new jvm.dll file inside this folder and try to run the forms again! It should work now!