HAs anybody out here used the Oracle 10G. I want to know the feasibility related to the this version of oracle and the ASP.NET compatibility with it.

Hi, You can do it by following the below steps: 1. Create a System DSN, giving the connectivity to the SQL Server database, which u want to import. 2. Create a new Acesss Databe(.mdb) 3. Goto files,select Get External Data -> Import. 4. Now from the file types, select the ODBC databases and locate the dsn whihc u have created. 5. Choose the tables which u want to import and click Ok. This will import all the selected SQl tables to your Acess databse. Indus_v:)

Hi, You can go for the Database Access Application Blocks, if you want to use multiple databases simultaneously in a single applications. You can got to the Microsoft site for this: ttp://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnpag2/html/daab.asp :)Indus_v

Hi, Although i have successfully implemented the Microsoft Data Access Application Blocks with Oracle 8i but i am suspicious reagrding the DAAB compatibility with Oracle 10G. If anybody has used the DAAB with the Oracle 10g or has the knowledge regarding the same, kindly share it and help me our. ~Indus_v