Re: Cannot add Oracle ODBC tables to Data Designer panel using VS.NET 2005

Yes, I have the Oracle client software installed. I use TOAD and SQLPlus on
my machine. But I don't know the which lower-level Oracle APIs need to be
installed (except for the ODBC drivers). Where can I find out which APIs
and drivers are installed?

In "Add or Remove Programs", I have "Oracle 8.1.7" and "Oracle Client"
listed. What else is recommended/needed?

Thanks,
Jerry N.


"Frank Hickman" <fhickman3_NOSP@xxxxxxxxxxxxxxx> wrote in message
news:eVnNuG6FIHA.3716@xxxxxxxxxxxxxxxxxxxxxxx
"Jerry N" <starfire@xxxxxxxxxxxxxxxx> wrote in message
news:%23L3djRbEIHA.3916@xxxxxxxxxxxxxxxxxxxxxxx
With Visual Studio .NET 2005, I have created a Oracle database connection
using:

Data source - Microsoft ODBC Data Source
Data provider - .NET Framework Data Provider for Oracle

I've tried using "Data source - Oracle Database" but I don't get a list
of tables, etc.

When I try to add a table to the Data Designer panel, I get the following
error message:

---------------------------

Mouse drag operation failed.



Input string was not in a correct format..

---------------------------



Have I configured the Oracle database connection properly? Are there any
workarounds to this error?



Thanks,

Jerry N



Do you have the proper Oracle client software installed? I have found
that just using the MS supplied Oracle drivers still require the Oracle
client drivers.

hth
--
============
Frank Hickman
NobleSoft, Inc.
============
Replace the _nosp@m_ with @ to reply.




.

Relevant Pages

  • Re: Oracle, Word XP(mail merge)
    ... >and ODBC driver provided with Word XP are only designed ... but of course Oracle has ... >open" before trying to connect tot he data source. ... we are having problems converting ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Using the Data View as lookup on a doc lib.
    ... lookup columns can only be other SharePoint Lists. ... Crate a SharePoint list and sync it with the Oracle data source some how ... > When I try to create the lookup column in the document library the data ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Oracle, Word XP(mail merge)
    ... My Word/Oracle experience is at least a couple of years out of date, ... the Oracle provider ... and ODBC driver provided with Word XP are only designed to work with an old ... open" before trying to connect tot he data source. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: AS 2005 connection problems to Oracle
    ... The Data Source is set up to use the Oracle client just below the ... I specify the fully qualified name of the instance ... IBDEV.xxx.NET and then the schema name and password. ...
    (microsoft.public.sqlserver.olap)
  • dbi:oracle win2k ORA-1222 problems
    ... The database is Oracle 7 running on a totally different machine. ... I found a bit of code that would check all available DBI drivers and their data sources. ... Driver: Oracle ... Data Source is DBI:Oracle:Space ...
    (perl.dbi.users)