473,804 Members | 3,776 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

how to connect ADODB with oracle odbc

21 New Member
i'am working with the datareport without using dataenvironment i.e with the help of ADODB but i am not able to understand how to connect with oracle.please help me
Mar 30 '07 #1
2 1514
Dököll
2,364 Recognized Expert Top Contributor
Assuming you have not already tried this, go to Data Source Administrator, add coonection there to your Oracle db.

Good luck!
Mar 31 '07 #2
Dököll
2,364 Recognized Expert Top Contributor
Attempting to add this forward for you to see, pramodrepaka...
Apr 5 '07 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

3
2932
by: TK | last post by:
I have a problem getting ADOdb working with Oracle 9i. Before I tried to connect to Oracle, I successfully connected to an MS Access table via a DSN, and looped through all the records in that table, so I am pretty sure ADOdb is installed correctly, but I could be wrong. To connect to Oracle 9i, I first go in and un-comment extension=php_oci8.dll and extension=php_oracle.dll in the php.ini file, but when I do that, the CGI script always...
5
13220
by: jrefactors | last post by:
My machine is Windows XP with Oracle 9.2 Home; IIS and Oracle are in the same box. I have tried both Oracle OLEDB Provider and Microsoft ODBC For Oracle, but both not working. For Microsoft ODBC For Oracle approach, I added a data source in Oracle Data Source Administrator, in System DSN tab, I created a system data source named OracleDSN with Microsoft ODBC for Oracle.
0
3089
by: chris | last post by:
Hi, I try to connect to Access with php with te code below. The database and table are ok. <?php include('../adodb/adodb.inc.php'); $db =& ADONewConnection('access'); $dsn = "Driver={Microsoft Access Driver (*.mdb)};Dbq=newres.mdb;Uid=Admin;Pwd=;"; $db->Connect($dsn);
0
2108
by: Ragtimer | last post by:
I've been trying to build a DAO.QueryDef.Connect string, building it from a user ID and password string obtained previously by a log-in dialog box, using it to log in to an Oracle database through an ODBC connection. The problem I have is that it's intermittent, in that invariably the first time I try to connect I still get the Oracle log-in prompt where the user has to type in all the info again anyway; and on subsequent connections...
2
7975
by: jmev7 | last post by:
Any way to avoid having to manually enter my user name & password for the Oracle login box? I normally run a query on an attached Oracle table and have to enter the un/pw before the query will run. There's no place to enter this information in. Later, if I run subsequent queries on the table in question, I don't need to enter un/pw again. I can leave my PC on 24x7, but that's not really a solution. I need to know if I can log in to the...
1
2635
by: dssengar | last post by:
I am using the code:- strCon = "Driver={Microsoft ODBC for Oracle}; " & "SERVER= abc; uid=abc;pwd=abc;" Dim oCon As Object Set oCon = New ADODB.Connection Dim oRs As Object Set oRs = New ADODB.Recordset oCon.Open strCon
2
1871
by: dounax | last post by:
Hello, I want to connect to an Oracle 9.2 database from a web site. - I have created a DSN file, I access the database from Excel - I have written the following vbScript, that works: dim rs Dim connString Dim conn
3
3076
by: evonczoernig | last post by:
I Can not connect to Oracle 10g XE from ASP perscript web page on IIS 6 running on server 2003. I have set up the database and the ODBC connections. The ODBC connection is workinh and I can connect to it via the ODBC test. I have the same ASP application running on a VISTA workstation and it connects fine. Here is the connection string that works fine on the VISTA PC put I can not get it to work on the server 2003 system. $Conn =...
2
5360
by: evonczoernig | last post by:
I Can not connect to Oracle 10g XE from ASP perlscript web page on IIS 6 running on server 2003. I have set up the database and the ODBC connections. The ODBC connection is workinh and I can connect to it via the ODBC test. I have the same ASP application running on a VISTA workstation and it connects fine. I am not using DBD I use ADODB.Connection. This works on other servers. NT, VISTA, server 2000. Not sure if it is a permission issue...
0
10583
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10082
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
9160
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7622
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5525
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5654
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4301
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
3822
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2995
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.