How to distribute database application?!

[smalig]

Hello, I'm looking for the solution of my problem - I need to install my VB-application, which use Oracle database (DSN-less), on the computers without Oracle Clients (otherwise it's works fine). I use ADO to connect to the database and it included in the setup package. But message what I get everytime on the PC without Oracle Client is "Oracle client and networking components where not found. These components are supplied by Oracle Corporation...". Does anybody know how to solve this problem?

[Jerry Grant]

I think you will have to install the Oracle Client software if you are going to connect to an Oracle database via ADO, there are several articles in the MSDN on the subject.

As I don't use Oracle here, I can't test it but have you tried the latest release of MDAC (2.6) to see if this is included?

Good luck

[smalig]

Thank you Jerry, of course I have included MDAC in the my setup package, but application does not works when I try open database by using following code:

strConnString = "Provider=MSDAORA;Data Source=" & Service
dbCn.Open strConnString, UserName, Password

[Jerry Grant]

This was the article I reffer to, indicating that the Oracle Client is reqired:

From MSDN:

PRB: SQL Distributed Query with Oracle Needs Oracle Client and Networking Components
ID: Q220915



--------------------------------------------------------------------------------
The information in this article applies to:

Microsoft SQL Server version 7.0
Microsoft OLE DB Provider for Oracle, version 2.0

--------------------------------------------------------------------------------


SYMPTOMS
Attempting to use a SQL 7.0 linked server using the Microsoft OLE DB Provider for Oracle, may result in the following error message:



Server: Msg 7399, Level 16, State 1, Line 1

OLE DB provider 'MSDAORA' reported an error.

[OLE/DB provider returned message: The Oracle(tm) client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 (or greater) client software installation.

You will be unable to use this provider until these components have been installed.]



CAUSE
The error is cause by not having the Oracle client and networking components installed. The SQL 7.0 machine needs the Oracle client and networking components in order to use MS Oracle provider to connect to an Oracle server.



WORKAROUND
You need to install Oracle client and networking components on the SQL 7.0 machine. The Oracle client software (SQL*Net) is manufactured by Oracle Corporation. This software can be obtained only from Oracle Corporation.



MORE INFORMATION
Microsoft SQL Server version 7.0 provides the ability to perform queries against OLE DB providers. This is done by using the OpenQuery or OpenRowset Transact-SQL functions or by using a query with four-part names including a linked-server name. For example:




sp_addlinkedserver 'mylinkedserver', 'product_name', 'myoledbprovider', 'data_source','location', 'provider_string', 'catalog'

SELECT * FROM OPENQUERY(mylinkedserver, 'select * from table1')
SQL Server 7.0 installs Microsoft OLE DB Provider for Oracle. You need to install Oracle client and networking components on the SQL Server machine in order to query a local or remote Oracle server database from SQL Server query using Microsoft OLE DB Provider for Oracle.

For T-SQL code examples on setting up and using distributed queries with an Oracle server search on "Microsoft OLE DB Provider for Oracle" in the index of the SQL Server 7.0 Books Online.

For information about how to contact Oracle, please query in the Knowledge Base for one or more of the following articles:

Q65416 Hardware and Software Third-Party Vendor Contact List, A-K

Q60781 Hardware and Software Third-Party Vendor Contact List, L-P

Q60782 Hardware and Software Third-Party Vendor Contact List, Q-Z

The third-party products discussed here are manufactured by vendors independent of Microsoft; we make no warranty, implied or otherwise, regarding these products' performance or reliability.

So I think you will need to bite the bullet!