Re: Odbc connections and ADP?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

If you don't want to use ADO, then there is the possibility of setting up
the connection to the Oracle Server directly on the SQL-Server and perform
your queries to Oracle from stored procedures.

See
http://www.microsoft.com/sql/techinfo/tips/administration/addingoracle.asp
for more information.

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC


"DaveK" <DaveK@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:E86CC3B8-5F1F-4C94-88AC-531582328785@xxxxxxxxxxxxxxxx
>I have not done any DB programming in VB so that complicates things. Could
>I
> include the code in a stored procedure instead? Could you point me to any
> examples?
>
> Thank you.


.

Relevant Pages

  • Re: Permissions???
    ... > Server: SQL Server 2000. ... > the user could Write/Read data from server and execute stored procedures. ... > The connection was made with DSNs. ... ADO gives the following message when using stored ...
    (microsoft.public.data.ado)
  • Re: Help!!!
    ... Ensure your stored procedures include 'SET NOCOUNT ON'. ... > Server: SQL Server 2000. ... > I had an ADO conection to the from a VB Application, ... > The connection was made with DSNs. ...
    (microsoft.public.sqlserver.security)
  • Permissions???
    ... Server: SQL Server 2000. ... I had an ADO conection to the from a VB Application, ... The connection was made with DSNs. ... Now, the system has a huge number of calls, updates and stored procedures, ...
    (microsoft.public.data.ado)
  • Re: Writing updates from a wide DataTable
    ... In past projects I've used a mix of stored procedures and direct SQL (or ADO ... > Are query plans cached with that? ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Ignore & continue for ADO field is too small errors
    ... were to create one big UPDATE string, it would be a couple thousand ... Dim sField as String, vData as Variant ... I mentioned "ADO ... Stored Procedures" but didn't match up the correct URL. ...
    (microsoft.public.vb.general.discussion)