Tags: io os sp for on BS nbsp SQL installationSystem platform: 64-bitMSSQL 2005 32-bitAfter installing the 32-bit Oracle client, create the Dblink times error in sql:The OLE DB provider "MSDAORA" for linked server "Szmesp" reported an error. The provider did not give any information about the error.Cannot initialize the data source object of OLE DB provider "MSDA
Encounter this problem, online search a lot, most of the inaccurate interpretation, after exploring according to their own understanding to write how to solve.Phenomenon: The problem is more clear on the Internet, the use of Plsql Developer connection to the database will report a problem with the inability to locate the Oci.dll file, there may be different reports, but the problem is to say this file problem.Cause: The Plsql Developer used here is 32 bits, and the database is
Today, I want to write a program. The environment is win7vs2008oracle. First, you must ensure that you can connect to the database. Check that the code is correct, but take it directly. Error: "BadImageFormatException is thrown when you try to load the Oracle client database. If you run the 32-bit Oracle client in 64-
Tags: style c a color data RGBOracleClient Program to connect Oracle database, the following error is indicated:The data connection is unsuccessful, check that the database is started when attempting to load an Oracle client when BadImageFormatException is raised. This issue occurs if you run in 64-bit mode with the 32
Tag:cahttpcom use data Transfer from:http://www.360doc.com/content/14/0602/10/4903283_382949382.shtml This you need to install a 32-bit Oracle client to use Plsql, But at this time sqlplus can not be used, hehe . I tried the following method, successfully, haha 1) install Oracle 11g 64-
: Configure PL/SQL developer Start PL/SQL developer, In the Login window interface, click the Cancel button to make the main interface, click Tools->preferences, in the connection need to configure the following two parameters: oracle home:c:\oracle\instantclient_11_2 oci Library:c:\oracle\instantclient_11_2\oci.dll This configuration is complete, now can be n
to at least 4g,2 a G is very card.2. While hard disk space is generally no problem, set aside about 2G.3. The installation is complete, there will be an interfaceWe can either unlock the required account or change the user name in password management. Careful to find that there is such a sentence: The database control URL bit https://localhost:1158/em. This is equivalent to Enterprise Manager in SQL Server. Unlike it, the manager is managed with a br
Haha! I cannot remember the error description, which is a problem I encountered before. It is estimated that it will not take much time for me to solve such a problem in the future, but I still want to write it out. Maybe it will help some people someday.
Approximate Problem description:
The Oracle database is used in the development system on Windows x86. After the system has been developed and deployed on Windows x64, the problem arises and th
Write a message todayProgramThe environment is win7 + vs2008 + oracle. You must first ensure that you can connect to the database. ConfirmCodeThere is no problem, but take it directly. Error:
"Badimageformatexception is thrown when you try to load the Oracle client library. If the 32-bit Oracle client component is ins
1. Download Instantclient-basic-win32;2. Unzip and place it under the product folder of the Oracle installation directory of the native database, such as my directory:3. Configure Environment variables:Add these system variables to the system variables:oracle_home=e:\app\loach\product\instantclient_11_2tns_admin=e:\app\loach\product\instantclient_11_2nls_lang= Simplified Chinese_china. ZHS16GBK For example: 4. By opening the Plsql development, you can
SSMS Linked Server (Success)Finally, the driver of Oracle HOME1 can be found in 64bit ODBC, so the ODBC test connection succeeds in modifying the TNS file in the Oracle Client installation directory.In SSMs, create a new linked Server, select the Oracle Provider for OLE DB directly, enter the appropriate configuration, enter the user name, password in the securi
method One: Use Sqlplus# # #64位: [[email protected] ~]$ sqlplus/as sysdba sql*plus:release 11.2.0.3.0 Production on Fri Oct 318:44:05 Copyri Ght (c) 1982, Oracle. All rights reserved. Connected to:oracle Database 11g Enterprise Edition release11.2.0.3.0-64bit productionwith The partitioning, OLAP, Data Mining and Realapplication testing options sql> If it is 64
Tags: position 64-bit system body exception 64-bit ORACL. dll ACL RACThe client installs the 32-bit Ora client in the Win7 64-bit system, and the NET install post-connection database ra
Tags:httpcom use data html cti This you need to install a 32-bit Oracle client to use Plsql, but at this time sqlplus can not be used, hehe . I tried the following method, successfully, haha 1) install Oracle 11g 64-bit 2) Install the 32-
Currently, Windows operating systems can be divided into two categories: 32-bit and 64-bit (64-bit also distinguishes x86_64-bit and itanium), and Oracle clients are also differentiated
The project used a 64-bit Oracle, but the local use of 32-bit plsql, so the Chinese is always displayed in the Plsql is garbled, began to think it is a database problem, after verifying the database has no problem, the Internet search for an afternoon, finally got the answer. Originally need to create a new bat file in
Label:Today, we share a note of my own study, hoping to bring help to those who meet the same problem. I do not know if everyone in the Win7 64-bit system with PB to connect to the Oracle database, have encountered "Oracle Library Oci.dll couldnot be loaded" issue. Today, in the Win7
Label:64-bit operating system how to use Plsql to connect remote or local Oracle data in the case of locally installed Oracle databasesCurrently Plsql only supports 32-bit Oracle clients, how can I use Plsql to connect data with a
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.