CProviderTypes - Doubt

From: chitracl (chitrak_at_vjil.com)
Date: 03/16/05 

Date: Wed, 16 Mar 2005 03:28:39 -0500

Hi all,
I have an application which takes data from one database and put in
another. I need to create some intermediate temp tables in the target
database as same as the source. Lets say my source is SQL Server and
target is Oracle. If i want to create a table with datatypes of SQL
Server's but again it should be compatible for oracle. I am failing in
getting the right data type bcos OLEDB gives data type number to a group
of types like 129 is for text,varchar,char so if i supply 129 to provider
types it fetches all the above three but then how will i get the
compatible one?

Please suggest me on this.

Thanks in advance
Chitra

Relevant Pages

  • Single application - multiple target databases - which DB driver?
    ... I'd be interested in peoples thoughts on which database driverto ... use for an application where the target db varies.... ... Currently our main application is Oracle based using Direct Oracle ... particularly users of SQLDirect ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: losing precision while selecting NUMBER values from Oracle 7.3
    ... > DBI script selects/displays 39 digits after the decimal point, ... > digits from target, which is a Oracle 8 database. ...
    (perl.dbi.users)
  • losing precision while selecting NUMBER values from Oracle 7.3
    ... Source db is Oracle 7.3 and target db is Oracle 8.1.7. ... DBI script selects/displays 39 digits after the decimal point, ... which is a Oracle 8 database. ...
    (perl.dbi.users)
  • Re: Storing time values via jdbc thin driver
    ... If I use the 10.2 driver java.sql.Time is stored with 1970-01-01 HH:MM. ... Do I have to update all my records to 1970 when using oracle 10 driver? ... supported by the database is irrelevant to the case IMO. ... (and TIME is a standard *core* SQL data type. ...
    (comp.databases.oracle.server)
  • Re: Storing time values via jdbc thin driver
    ... If I use the 10.2 driver java.sql.Time is stored with 1970-01-01 HH:MM. ... Do I have to update all my records to 1970 when using oracle 10 driver? ... supported by the database is irrelevant to the case IMO. ... (and TIME is a standard *core* SQL data type. ...
    (comp.databases.oracle.server)