hello,

i want to connect to a oracle database. Now in VS2005 whaen i select the
oracle driver i get the message:

System.Data.OracleClient requires Oracle client software version 8.1.7 or
greater.

Must i install a oracle client? ....
Is this free?
Where can i download it?

thanks
Franz

Microsoft ODBC driver for Oracle gives support only till oracle 7 and
partially to Oracle 8. Its best you try to get the driver from Oracle or a
third party vendor.

thanks, any link for this driver - is any of this free?

thanks


Show quoteHide quote

try this

http://www.oracle.com/technology/software/tech/windows/odbc/index.html

i downloaded - Oracle10g ODBC Drivers are Version 3.52, Level 2 compatible
drivers. ->10.1.0.5.0 25-Apr-2006 2.1 MB

and after extracting i see that there are some jar . files (ex.install1.jar)
....

Means that i must install on the w2k3 webserver - a java runtime engime?,
for accessing from .NET the ODBC driver for oracle?. In my application i
musthave to acces the SAP - BW - for some reports.

thanks


Show quoteHide quote

Well, check this out too..
http://www.sqlservercentral.com/columnists/hji/oracleandsqlserverinteroperabilitypart3.asp

thanks Omnibuz - i installed the clientsoftware

For the servicename must i enter the IP-Adress of the server?
Any example of connectionstring? I get now if i go over the wizard with dns
- i message - that "A connection could not be made using the file data source
parameter entered"


Show quoteHide quote

Hi Xavier,
  I haven't really used the the client. But if you want an example of the
connection string then you may want to check this.
http://www.connectionstrings.com

i looked earlier on this site - but i did not find any way to enter the
port:1527 for the oracle database - like it is defined in the TSNAMES.ORA



Show quoteHide quote

sql query - sp
How can I Rearrange my Data
tring’
FOREIGN KEY that REFERENCES a server login for a database?
Top behaviour