Account has proper access to Oracle database You are able to ping the Oracle Machine from Win 7Ĥ. Check the ODBC driver or Oracle client component is installed on your Win 7 Boxģ. Firewall is not blocking the port required for Oracle 11G.Ģ.
When I attempt to perform a ODBC test connetion to the oracle 11g database I received an error message indicating I needed to install the oracle driver eventhough I had installed the oracle driver.Īre you getting any specific error while connecting to Oracle 11G through ODBC? Can you please share the error details. Any and all help is greatly appreciated.įriday, Septem12:54:51 PM - Mike Washington With that being said, I'm not sure or completely understand why I have received that message even after installing Oracle 10g administrator option on the win7 box. You will be unable to use this driver until these components have been installed.
These components are supplied by oracle corporation and are part of the Oracle Version 7.3 (or greater) client software installation. The Oracle(tm) lcient and networking components were not found. The actual message that I get is the folowing: Account has proper access to Oracle database. I can ping and log into the oracle machine from the win7 box.Ĥ. You are able to ping the Oracle Machine from Win 7. The client version is installed on the win7 box.ģ. Check the ODBC driver or Oracle client component is installed on your Win 7 Box. The firewall is open and the actual version is 10g (sorry for the confusion about the version being used).Ģ. Firewall is not blocking the port required for Oracle 11G. ROTFLĪs per the error message, you have to install the client components (which will install the Oracle driver).įriday, Septem1:52:14 PM - Mike Washingtonġ. I've tried to follow your procedure but I can't pass the step where the wizard connects to SQL server.
I'm failing to install vmware update manager because it needs 32 bit DSN. Any idea why user DSN does n't work in 64- it system. Recently we are doing migration from windows 2003 server to windows 2008 server (32- bit to 64- bit).Īfter installing application in new server, it is not pinging the DB, faced problem in ODBC connection.Could you explain me why we need to create this system DSN? We were using User DSN in 32- bit system but it didn't work now.
On the 64-bit machine where the application is installed, open the Microsoft Windows ODBC Data Source Administrator using one of the methods shown below. īelow are the steps to create a 32-bit DSN on a 64-bit machine.
You can install the SQL Server native client either from the SQL Server media or by downloading it from. Before creating the DSN make sure the SQL Server Native client component is installed on the machine.