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;
Hi there, the connection from Excel VB to Oracle 10g and 11g using the Microsoft OLE DB-Provider 'MSDAORA' and installed Oracle Client works fine with this connection string:
hi.. how i can use ODP tool for oracle connection while working with VB.NET
Hi...sir i want to connect with oracle through vb.net using OLEDB,, how i can ? and is there any alternative except OLEDB and ODBC to connect with oracle 10g.. thank u
I am sharing the code and web.config everything seems to be fine but i am getting an exception when i am filling the datasource.I am getting an exception on the line dtAdapter.Fill(ds)
First thank you for your kind information in advance. This is first time to use p6 professional R8.2 , i cannot start using the program every time asking for string, username and password. My questi
I have read countless postings on connecting to Oracle and I am still stumped. One problem may be that I am running a 64 bit machine with 32 bit Oracle installed trying to make everything work. When I
I just replaced the hard drive on my Windows 7 machine (my development computer). I did not have any issues with this working on the old hard drive, but I think I remember I had to change something or
Can i get a complete list of hyperion settings and maybe we can add this to oracle or another section. here is what i have so far "Data Source=https://server.company.com/aps/XMLA;Initial Catalog=DBNam
This might be better posted to Microsoft forum, but since I'm here... I had a connection string that worked on a 10g Oracle DB when using the HP QTP tool. Now the string doesn't work. I keep gett
Hi, I want to use cobol to retrieve data from oracle data base. But I have not see any connection string for oracle Somebody have an example of connection to oracle database with cobol with a simpl
Hi, Is there a way to send encrypted password in the connection string? Please let me who had same objective and have any solution for it.
Hi, On a Windows 2008 server, in ODBC Data Source Administrator, I have defined a system data source (System DSN) named TRAP, with the driver : "Oracle dans OraClient11g_home1". In the ASP scrip
Hi we use,Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production We got a requirment to connect to SQL Server DB and get access a View. My DBA provided servername, DB name,User
I have a PC with two Oracle clients, each with his tnsname.ora. In it I created an ODBC connection (System Data Source). I want to know which of tnsname.ora is used to connect to the Oracle.
can someone tell me how to turn on/off encryption in the following connection string? ConnectionString: 'Provider=MSDASQL.1;Extended Properties="DRIVER={Oracle in CLIENT9201_HOME};.......
How to connect the postgres database from oracle database.
I am running Oracle 10g on an Windows XP system. How do I access data in a MS-eXcel spreadsheet from SQLPlus? I have set up the eXcel ODBC Driver. What does the following SQL Server code translate
I'm working in Visual Studio. I have created a OleDbConnection object that i need to assign a string to. From what i gather, i think i should use this one: Provider=msdaora;Data Source=MyOracleDB;User
Hi, I've installed a Windows Server 2008, with Oracle 10g client... The old provider in my ".asp" page doesn't work (Windows Server 2003 + Oracle 9i client): conn.open "Provider=MSDAORA;Data
Hi! I’m accessing an Oracle database via Oracle Provider for OLE DB 11g Release 1 (11.1.0.7.20) using Delphi (several versions). The program works as expected, opening tables and displaying info
I am trying to utilze excel vba to connect to a microsoft access database that is linked to oracle tables at work. I have been able to do this by saving my password in access for the oracle linked ta
I am trying to make ODBC connection using: 1. Primavera SDK 2. XE in Oracle 3. Microsoft for Oracle but always connection failed. I have windows 7 Ultimate x64 and Primavera P6 V7 with
I am using asp.net to create a project and i need a connection string to connect it with an Oracle server which is on a LAN network. I know its IP address, and port number I will arrange if required.