Oracle Connection

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

scminter - 01 Oct 2007 03:52 GMT

I can connect Infopath to my Oracle database, select a table and then I get
an error stating I can only connect to a SQL or Access database.

But it allowed me to connect to Oracle and select the tables. The
connection is there.

Any ideas why Microsoft stopped short on this?

Has anyone connected Infopath to an Oracle database?

We are a very large enterprise who would very much like to utilize Infopath
to create dynamic forms alongside our MOSS implementation. We are stunned
there seems to be no support for an Oracle database.

Any ideas on when Microsoft is pursuing a connection to Oracle?

Reply to this Message

Ben Walters - 01 Oct 2007 04:05 GMT

Currently Microsoft only supports connections to either SQL or Access.
While I have not heard anything about when or if Microsoft is going to
change this in the future, I do know that you can do this using a web
service to facilitate communications.
This can also provide a more secure mechanisim for connecting to your DB.
Hope this helps

Cheers,
Ben Walters

>I can connect Infopath to my Oracle database, select a table and then I get
>an error stating I can only connect to a SQL or Access database.
[quoted text clipped - 11 lines]
>
> Any ideas on when Microsoft is pursuing a connection to Oracle?

Reply to this Message

Clay Fox - 03 Oct 2007 00:19 GMT

You may want to check out the Database Accelerator. It leverages SQL but can
be interfaced with an Oracle Database either via web services or on a
database level.

You can learn more at http://www.qdabra.com

Signature

Thanks

Clay Fox

Qdabra Software
http://www.qdabra.com

InfoPathDev.Com
The Largest InfoPath Forum in the World
http://www.infopathdev.com

> I can connect Infopath to my Oracle database, select a table and then I get
> an error stating I can only connect to a SQL or Access database.
[quoted text clipped - 11 lines]
>
> Any ideas on when Microsoft is pursuing a connection to Oracle?

Reply to this Message

Navdeep Gosal - 23 Jul 2008 18:33 GMT

Clay,

QDABRA requires SQL server, even if you intend on using it for Oracle. Do you any Database Accelerators or something similar that allows you to connect to Oracle w/o SQL Server?

Reply to this Message

Clay Fox - 24 Jul 2008 06:30 GMT

I have used Qdabra with SQL and then used DTS or SIS integration between SQL
and Oracle.

Otherwise you need web services which connect directly to Oracle.

I know Qdabra has plans to add compatibility to other databases besides MS
SQL in the future but this is not in the current release.

Sorry.

Signature

Clay Fox / Microsoft InfoPath MVP
www.InfoPathDev.com / The InfoPath Authority / Downloads, Samples, How-To,
Experts, Forum

> Clay,
>
> QDABRA requires SQL server, even if you intend on using it for Oracle. Do you any Database Accelerators or something similar that allows you to connect to Oracle w/o SQL Server?

Reply to this Message