Oracle Questionssubmit your own question

Oracle Provider for OLE DB connection strings can use connection pool?

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;" & _

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.

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.

I want to Connect from Oracle to MS SQL Server with a connection string to pass location (IP) / username / Password and SQL Database !

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;

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 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.

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?

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...

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...

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...

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;

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.

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 :

hi What does MLD=0 represent in the attribute of a Odbc Connectstring? Thanks N

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".

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.

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.

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:

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.

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.

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;"

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

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.

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

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)

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**

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.

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;