Oracle Questionssubmit your own question
Oracle Provider for OLE DB connection strings pool
Oracle Provider for OLE DB connection strings can use connection pool?
Escaping a semicolon in Oracle Connection String
Hi, I hope you can help me with my (hopefully) easy problem :) I am using the following connectionstring to connect to the Database in VBA: strCon2 = "Driver={Oracle in OraClient11g_home2};Dbq=MY_SERVICE_NAME;" & _
Oracle ODBC x86 and x84 on Excel 32bits.
I have the Oracle Runtime 11g 32 bits and the 12c Runtime 64bits instaled on my system, and i would like to know if is possible to use the 32bits Oracle 11g(11.2.0.1) ODBC driver on my Excel.
Can't connect to local Oracle 11g express
Hello. I have an Oracle 11g Express installation on my personal Windows 7 PC. Its DB name is the default - XE. I can connect to it in sqlplus just fine.
connect from Oracle to MS SQL Server
I want to Connect from Oracle to MS SQL Server with a connection string to pass location (IP) / username / Password and SQL Database !
Difference between OraOLEDB.Oracle and OraOLEDB.Oracle.1
What is the different between these two connection strings? Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;User Id=myUsername; Password=myPassword; Provider=OraOLEDB.Oracle.1;Data Source=MyOracleDB;User Id=myUsername;
Connecting to Oracle using python's pyodbc library
I am trying to connect to Oracle 12c R1 using the python library pyodbc. I am having zero luck. Can anybody help? thx in advance!
[ODBC Manager] Data Source Name too long
ODBC connection in Oracle . Have written a VB script which connects to an Oracle database using ODBC connection string. When trying to connect its gives me an error [Microsoft][ODBC Manager] Data Source Name too long.
INSERT ALL Statment with OraOleDb.oracle
I need to insert in oracle db multiple rows with INSERT ALL statment. I note oraoledb.oracle provieder doesn't run with this statment. It needs Driver={Oracle in OraClient11g_home1} connection. It is correct?
Issue connection an ASP.Net site with two Oracle database on same server
Hi I've taken over a ASP.Net site using an Oracle back-end, I can get it to connect to the database on our development PCs but on the live server, I'm having an issue as follow and wonder if anyone could help as not an Oracle expert and the Oracle server was setup many years ago...
Issue connection an ASP.Net site with two Oracle database on same server
Hi I've taken over a ASP.Net site using an Oracle back-end, I can get it to connect to the database on our development PCs but on the live server, I'm having an issue as follow and wonder if anyone could help as not an Oracle expert and the Oracle server was setup many years ago...
Issue connection an ASP.Net site with two Oracle database on same server
Hi I've taken over a ASP.Net site using an Oracle back-end, I can get it to connect to the database on our development PCs but on the live server, I'm having an issue as follow and wonder if anyone could help as not an Oracle expert and the Oracle server was setup many years ago...
Oracle OLE DB - Connection string without password
Hello, I'm working on programmatic queries relying on the Oracle provider for OLE DB (in VB script). I can successfully query my database using the standard syntax: Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;User Id=myUsername;Password=myPassword;
re: Having hard time with Microsoft ODBC connection to Oracle
Hello, Could anyone please tell me what do I need to do in order to connect to Oracle 11g through VB script. I already had my tnsnames.ora file set up on my machine and I was able to TNSPING to the Oracle 11g database and I was also able to SQLPLUS mylogin/mypassword@database.
Connect UiPath with oracle database 12c
Hi, I want to connect UiPath(Robotic Process Automation) with oralce data base 12c. i tried alot to find the solution via google, but no success. please post your suggestion. I tried with the following string :
ODBC attribute query
hi What does MLD=0 represent in the attribute of a Odbc Connectstring? Thanks N
Oracle SQL Developer version 1.2.1 connection issue
hi, I am using Oracle SQL Developer version 1.2.1. I want to connect to the Database server using VBScript. I wrote the below code but getting an Error "database source not found and no default driver specified".
VBA Excel to send data to Oracle..need help
I have a project where I have to send data from an Excel spreadsheet to an Oracle database. I have installed the latest Oracle client and the ODBC drivers.
[ODBC question] I have a question about ODBC connection
Hi everyone I am writing to you to help about connecting Oracle using the ODBC. I have to connect to an Oracle Database that is RAC Environment using a SID. I currently try to connect to an Oracle database using ODBC in C, linux.
Error with Oracle ODBC Connection String
We use an ODBC Connection string to connect a SQL database pulling in demographic data from our Oracle student record system. We just upgraded our PeopleTools and changed to a higher version of the Oracle driver which was the only change. The connection string was as follows:
Connection string for connecting via LDAP
I want to connect to Oracle Database via c# code using LDAP. Please provide me the connection string which includes server name, service name, user name and password.
SQL Server Reporting Services 2012 ODBC Connection String
Hi, I am trying to make a new ODBC connection to our company's SQL Server Reporting Services 2012 server to reach an Oracle db, however I've been unsuccessful trying to create the connection string.
Data Source name too long
I have used connection string as below in my VB macro. ConnectionString="Data Source=(DESCRIPTION = (ADDRESS=(PROTOCOL=TCP)(HOST=servername)(PORT=portno))(CONNECTDATA=(SERVICENAME=servicename))));uid=username;pwd=password;"
Oracle database connection from javascript
I am trying to connect to the Oracle database using javascript angularjs. I need to write the code and the connection string. I don't have much experience with doing this so I would appreciate any help. Thank you
Creating a connection string
I am using Easy Query Builder and I would like to connect to a file on my computer which is a database I built with Toad Data Manager. The file is an sql file in notepad that I have stored on my system.
Windows 7 64 Bit, Oracle ... Error3706 Provider Cannot be found . Help Please
Setting Up a new client for a customer Windows 7 Professional 64 Bit -VB6 Oracle Error: Error:3706 Provider Not Found. It may be installed correctly
TNS: could not resolve the connect identifier specified
Hello. Can someone help me figure out what I may have wrong with this connection string? This will be used in a VB.net program with the string entered in the APP.CONFIG file. (names changed obviously)
Data source name not found and no default driver specified
I am using oracle 11g xpress edition and ASP.net I have got following error ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified My connection string is as follows**
Use TableSpace name in an ODBC connection string
I wish to transfer MS-Access tables to Oracle 12 on a regular basis for data conversion purposes. I have established the necessary ODBC DSN and the VB connection string and it all works very nicely and fast.
Oracle 11g connection string for VB6 ADO
what is the connection string for oracle XE 11g for VB6 ADO ? The following did not work as suggested on this site... Driver=OraOLEDB.Oracle;dbq=localhost:1521/XE;Uid=myuser;Pwd=mypassword;
- Load more posts