We are test Uniform ODBC drivers. When we run a new Database in Microsoft Access to import tables through the ODBC we get this error
Internal Error – unable to initialise NLS during driver load.
I am using an Microsoft Access application which accessing an Oracle Database with ODBC.
each time i change data in the ACCESS forms, the change is committed in the database. I would like to know how to set the AUTOCOMMIT off.
I have one .mdb (Microsoft Access Database) file and it has some tables in it. I had load it once using toad. But now i have to load it frequently into the database. Is it possible using external table, so i can access that tables using "select" statement.
View 6 Replies View RelatedI'm using Microsoft Access 2007 as a front end to Oracle 10g tables using an ODBC Connection. I need to be able to add attachments to the records in one of my linked tables to hold emails, screen shots, log entries etc.
Access 2007 handles this capability with a field format called Attachment. I don't want to store the attachments locally but want them to be stored in Oracle, but I'm not sure what format the field in Oracle needs to be so that it will come across in Access as an Attachment field.
Using Server 2008 Standard Edition 64 bit. We have been running full client (admin) version 10.2.0 and just installed full client (admin) 11.2.0. Both homes are in my path variable with 11.2 first.
From ODBC Administrator, I can can create new system data sources using the 11.2 client driver and the testing widget built into the data source creator says my connection is good to both 10.2 dbs and 11.2 dbs. So the 11.2 odbc driver would seem to be working.
However, from MS Access, I can only see 10.2 drivers and 10.2 data sources, which fail unless I put the 10.2 home in first place in my path.
I cannot find a way to "access" the 11.2 drivers from MS Access. If I try to create a new data source from inside MS Access, I only see the old 10.2 driver.
I am New to Oracle and PL/SQL. How to import ACCESS database to Oracle(10g) using PL/SQL.
View 1 Replies View RelatedODBC--call failed.TNS:listener was not given the SID in CONNECT_DATA (#12504)
TNSname sets the SID. SQL*Plus is able to connect from the client Windows XP Proff using the same name. Access, on the same client, uses the same Oracle driver to connect successfully to other Oracle databases. These other databases show equal tnsname (different name and SID...)
ODBC Data Source Administrator configures the database and the test connection is successful.
Cannot set up a link from Access to the Oracle database. At some point, I have created a new Access database and it did let me connect, view the list of tables, and set up links to several tables, but the next day I could not open any of the tables and the complain was: ODBC--connection to 'MYDB' failed.
It seems that SQL*Plus passes correctly the SID from the TNSname but ODBC, when invoked from Access, does not. Yet, ODBC does it right for other databases.
We have an issue regarding OS level authentication to access Oracle 11gR2(11.2.0.1) database.
Our environment -
UNIX - AIX 5.3 (OS user id password is having kerberos security).
Oracle 11.2.0.1 (32 bit client) installed in server 1
Oracle 11.2.0.1 (64 bit server) installed in server 2.
Everything works fine when we created a general userid test_db in the database and connect through sqlplus test_db@dbname.
But when we try to use the option of OS level authentication using "sqlplus /", it throws following error and could not be connected.
ERROR: ORA-12545: Connect failed because target host or object does not exist
I have created the same OS user name in database (with external password authentication) with prefix OPS$. we have set ORACLE_SID as well.
I am using oracle 11g client library on Linux 64bit machine and trying to connect to oracle database using jdbc thin driver.The url format what I am trying to use is:
jdbc:oracle:thin:@IP address:port:service_nameWhen service_name = orcl :
I am able to connect with the above syntax. But when the service_name is having . e.g service_name = orcl.177.39.45, with the above format I get the above error.
If I change the URL syntax to following, it works
jdbc:oracle:thin:@IP address:port/service_name
But both seems to be valid syntax.So I would like to undestand the reason behind the same. When service_name is having ".", why ":" does not work and "/" works and when the service_name is without " ." , 1st format works. Is there any specific reason behind same?
i try to import MyData.DMP to my oracle using PL/SQL developer
i try this: Tools -> Import tables -> i choos MyData.DMP -> import
but i can see the new database in the log file i see this:
Import started on 03/07/2012 13:43:23
C:\app\ME\product\11.1.0\db_1\bin\imp.exe log=C:\DOCUME~1\ME\LOCALS~1\Temp\plsimp.log file=C:\DOCUME~1\ME\lab.DMP userid="scott/tiger@ORCL as sysdba" buffer=30720 commit=no full=yes grants=yes ignore=yes indexes=yes rows=yes show=no constraints=yes
Import finished on 03/07/2012 13:43:23
I am getting Oracle odbc ora-28000 account locked error
View 1 Replies View RelatedI'm trying to setup ODBC connection for my Oracle client while installing BO. Following are the steps I followed.
1. Downloaded the Oracle Client from the link [URL] . From that downloaded two zip files. “Instant Client Package – Basic Lite" and “Instant Client Package – ODBC”. Extracted the Zip Files to the folder I created under C: as C:Oracleinstantclient_11_2.
2. Since I'm setting up in ODBC in windows 2008 64-bit R2. I was advised to install 32 bit . So in cmd prompt, from the location C:Oracleinstantclient_11_2, ran odbc_install.
3.Created the Environment variables as
i) *TNS_ADMIN - C:Oracleinstantclient_11_2*
ii) *Oracle_Home - C:Oracleinstantclient_11_2*
iii) *Edited the PATH variable with ;C:Oracleinstantclient_11_2*
4. Created the tnsnames.ora file in C:Oracleinstantclient_11_2. Its content are as follows.
clarity_dev =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = claritydev.vip.its.ebay.com )(PORT = 1521))
)
(CONNECT_DATA =
(SID = clarity)
)
)
5. From the folder %windir%sysWOW64odbacd32.exe, Opens ODBC Data Source Adminsitartor. In that I found my Oracle in instantclient_11_2 and added following details.
Data Source Name : claritydev.vip.its.com
TNS Service Name : clarity_dev
User Id: clarity1
When I test connect it, I get error *ORA-12154:*
* TNS:could not resolve the connect identifier specified*
I've seen FAQs for this error, but couldn't find anything which solves. Is there any steps I'm missing? I've checked in DB properties. It uses SID not the Service Name.
aix 6.111.2.0.3 I have an expdp dump from prod to be imported to our test database.I have imported it using impdp, but to my surprise the tables were imported but lots of indexes were not created? even If I have used TRANSFORM=SEGMENT_ATTRIBUTES:N just to use the default USERS tablespace. How do I import the indexes separately, skipping the tables and other objects?
View 14 Replies View RelatedI am attempting to connect to an Oracle 8i database via the Oracle 9.02 ODBC driver and I am receiving the following error message upon testing the connection in WinXp's ODBC Data Source Administrator dialog box: "Unable to connect SQLState=IM004 [[Microsoft]][[ODBC Driver Manager]] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed" .
I am running Oracle Client 9.2 on a P4 machine running winXP.
I'm using following connection string: +connectionString="Driver={Oracle ODBC Driver};Server=someDb;Uid=useruidr;Pwd=password"+
when I call method "Open" on "OdbConnection" I get following exception: +ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified+
"someDb" is specified correctly in tsnames.ora,
"...client" and "...clientin" are added to PATH environmental variable
ORACLE_HOME is set to "...client"
I have Oracle Client 11.2.0.3.0 installed
Operating system is Windows 7 32 bit
When I change Driver to "Microsoft ODBC for Oracle" it works fine. However I want to use Oracle ODBC Driver.
when i create db link then it show below:
SQL> conn sys as sysdba
Enter password: ********
Connected.
SQL> show user
USER is "SYS"
SQL> create database LINK orafaccess using 'ORAFACCESS';
Database link created.
SQL> desc emp@orafaccess
ERROR:
ORA-02085: database link ORAFACCESS.APEX.COM connects to HO.WORLD
SQL>
I am trying to run impdp over network to import tables only but i am getting an error saying not able to create metadata and the import fails
Here are the steps below,
1. Source database created a user and granted select on certain tables to the user.
2. Created a user in the Target database.
3. Created a public link as sys user in the target database.
4. granted imp and exp full database to both users and all the other privs.
5. Started the impdp from the target server.
The import fails with
$impdp abc/xyz directory=DATA_PUMP_DIR network_link=TESTAR logfile=net_import_proddev.log TABLES=impdb.abc parallel=12 REMAP_SCHEMA=IMPDB:ABC
Import: Release 11.2.0.3.0 - Production on Tue Apr 23 13:10:51 2013
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "IMPDB"."SYS_IMPORT_TABLE_01": abc/******** directory=DATA_PUMP_DIR network_link=TESTAR logfile=net_import_proddev.log TABLES=impdb.abc parallel=12 REMAP_SCHEMA=IMPDB:ABC
[code]....
I try to transfer data from one database to another one through data pump via SQL Developer (data amount is quite important) exporting several tables. Tables export is doing fine, but I encounter the following error when I import the file (I try data only and data + DDL).
"Exception: ORA-39001: argument value invalid dbms_datapump.get_status(64...=
ORA-39001: argument value invalid
ORA-39000: ....
ORA-31619: ...
The file is in the right place, data pump folder of the new database. User is the same on both base, database version are similar.
I work in a large bank in a department that produces reports for different areas of the bank. By and large, we use Microsoft Office products to interface with our Oracle databases.Recently, we had two new databases come online that use Oracle 11g - we were not using any 11g databases before this point. We have two other databases that we use that run on Oracle 10g.
Up until the two new databases were brought in, our reporting was done from systems that used 10g and 9I. We all ran the Oracle 9I driver to connect to them, and it worked very well without issue. With the addition of the 11g databases to our reporting pool, we have been forced to upgrade our ODBC connections to the 11g driver, and it has not gone well at all. I had one query that typically ran in 30 minutes take +13 hours+ to run yesterday. Speed is not the only issue, either; we have sporadic ODBC call fails, crashes, and other general failures to deal with.
Our Oracle DBAs have been trying to solve the issue, but have not yet found a solution, and each day that this goes on we fall further and further behind, as I have daily time-sensitive reports to send out that depend on this data.
One of our DBAs said she read somewhere that Oracle had not included MS Access support in the 11g driver, and that the errors were due to the imperfect connection that the driver created. I don't know of there's any truth to that, but it would provide an explanation for our troubles. We have to use Access for our reporting, as over 90% of our existing reports and processes use Access, and having to change over everything at once is just not feasible.
Is there any way to force the 9I and 11g ODBC connections to coexist, so that we don't have to use the 11g driver for our 10g databases? Or is there a better 11g driver available?
how to acess tables of another user from the sys user as dba in oracle 8 dont have the password but need to acess the table
View 1 Replies View RelatedI am using oracle 11g express edition and MY Sql database How to establish database link between them using ODBC gateway. I am using ODBC gateway Mysqlodbc connector.
View 1 Replies View RelatedI need to find out which users have direct access to tables, not through the roles.
Is dba_tab_privs the right table to query or table_privileges is the correct one.
What is the difference between these two.
I have gone through the documentation but I am still not clear about the difference between them.
Let me know whatever your thoughts are on this.
The code was originally an MS Access Query with linked tables to the Oracle DB however trying to remove the need for access and have it drop directly into Excel using Recordset.
SELECT
SWPRO.CASE_INFORMATION.CASEDESC,
SWPRO.OUTSTANDING_MAIL.CASENUM,
CASE_DATA_1.FIELD_VALUE,
SWPRO.OUTSTANDING_MAIL.SENTDATE,
SWPRO.OUTSTANDING_MAIL.DEADDATE
FROM
[code]....
We have got a new requirement wherein, The customer wanted the DBA Vendor (US) NOT to access the confidential information (ALL Columns) in the DB tables of PRODUCTION database. This is for few applications to comply with with export control rules. The thin support by Customer DBA will be allowed to access the Data, if required .
1) Web Based Interface ?.
2) DB Encryption (But if we encrypt ALL columns Serious performance issue expected, File level will not restrict DB level access)
3) Special setting on DB (DBA to do only backup and restoration related work only - But cannot access data)
4) Standard Tools / Utilities / Others ??.
Technologies are Oracle ,SQL
Successfull installation of my Oracle Client was done.When i opened Enterprise Manage Console and i try to login to a database, the following error occurs
" The procedure entry point kpufhndl() could not be located in the dynamic link library OCI.dll "
What can be done to resovle this error?
I am developing an 64bit And-In software. My OS is windows7 64bit Ultimate. Developer tool is Microsoft Visual Studio 2010 Ultimate 64bit any-CUP.Server is SUN server and Oracle database 10.2.0.5 64bit enterprise edition.I have installed instantclient-odbc-win64-10.2.0.5 on my computer.I am able to connect through the command line sqlplus user/pass@server.In date source(c:windowssystem32odbcad32.exe), ODBC Driver connection successful.But in VS2010 C#, use Tools -> Connect Database,I get an error 193 (Oracle in instantclient10_2,c:ora10_64SQORA32.dll) cann't be loaded.SQORA32.dll is 32bit ODBC Driver or 64bit ODBC Driver?How can I connect database with vs2010 64bit?
View 2 Replies View RelatedI am trying to export and import tables from oracle...For this i am using imp exp utility...But this is being carried out from cmd prompt...IS there any way by which i can execute these from sql prompt..So that by establishing jdbc connection thgh java code...i cud run the code...
View 6 Replies View RelatedI got an error while trying to install Oracle 9i on a Win XP machine. So, I decided to wipe out Oracle completely and starting again. I deleted all the Oracle entries from the registry and then tried deleting the folder. But while doing that, I am getting the following error - "Cannot delete oci:Access denied"
The disk is neither write-protected nor is the oci.dll file in use.
The way to do IMPORT of a schema's ALL the TABLES only. Through Data Pump. I don't want to import any other objects like 'package',procedure etc...
Is it the only way is specifying them within EXCLUDE parameter?
What i have to do to overcome the following error..whenever im using toad im getting this error since start writing and executing procedures and functions.
access violation at address 006b5b1b in module 'toad.exe' read of address 0000011d