Re: OpenSchema with DSN less connection

From: Brian Bushay TeamB (BBushay_at_Nmpls.com)
Date: 11/19/03 

Date: Tue, 18 Nov 2003 20:41:14 -0600

>The database is Oracle9i. When I use an ODBC connection (via DSN) the
>OpenSchema works correctly....I would have thought that the OLE DB
>Provider would be more likely to work than the ODBC driver (obviously
>I'm wrong).

I would have guessed that too. maybe you should try Oracle's Oledb provider 

--
Brian Bushay (TeamB)
Bbushay@NMPLS.com

Relevant Pages

  • Re: SSIS is pathetic with ODBC connections ...
    ... assumes that the data source is relational, OLE DB does not. ... OLE DB provider, and apparently there is not one for Double Byte Progress ... databases using the DataDirect ODBC driver. ...
    (comp.databases.ms-sqlserver)
  • Re: Ole db provider for an odbc data source
    ... We now wish to wrap this odbc driver to be able to provide an ole db ... That is an OLE DB provider that comes with ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (microsoft.public.data.oledb)
  • Re: ANN: AnySQL Maestro (freeware cross-database tool)
    ... Also OpenSchema knows nothing about DBMS specific objects, such as tablespaces, jobs, partitions, full-text catalogs, etc. ... Also AnySQL Maestro strongly depends from OLE DB Provider / ODBC Driver you have installed. ... Do you have a product like AnySQL where I can connect to a variety of database vendors and have full database management? ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: How to get IBMDA400 provider
    ... i found that it can be done using IBMDA400 OLE DB Provider. ... if you install client access the odbc driver is included within the ...
    (microsoft.public.vb.general.discussion)
  • Re: VB Oracle Error : 80004005 SQL Data type out of range <2>
    ... I don't know Oracle, so there is not much I can do. ... or the Oracle ODBC driver. ... One idea is to change from using the default provider - OLE DB over ODBC - ... which is the Oracle OLE DB provider. ...
    (microsoft.public.data.oledb)