CProviderTypes

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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

Date: Wed, 16 Mar 2005 00:22:22 -0800

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 compatibale 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 compatabile one?

Please suggest me on this.

Thanks in advance
Chitra
 

**********************************************************************
Sent via Fuzzy Software @ http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...

Relevant Pages

  • Properties : set different from get
    ... Sent via Fuzzy Software @ http://www.fuzzysoftware.com/ ... Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources... ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Can
    ... Sent via Fuzzy Software @ http://www.fuzzysoftware.com/ ... Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources... ...
    (microsoft.public.dotnet.languages.vb)
  • Re: 2005 Beta 2 install problems
    ... Sent via Fuzzy Software @ http://www.fuzzysoftware.com/ ... Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources... ...
    (microsoft.public.sqlserver.server)
  • Cannot create WebApp ??
    ... Sent via Fuzzy Software @ http://www.fuzzysoftware.com/ ... Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources... ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Memory/Leak Tool?
    ... Sent via Fuzzy Software @ http://www.fuzzysoftware.com/ ... Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources... ...
    (microsoft.public.dotnet.framework)