oracle ODBC and linked tables

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

From: nopelf (nopelf_at_discussions.microsoft.com)
Date: 06/29/04 

Date: Tue, 29 Jun 2004 04:56:01 -0700

history: I am using ODBC (oracle provided 9i) to link oracle tables to my app. I am using a connection string in attempt to avoid the users from being prompted for the db login.

IN ODBC I am connecting with a string - and it is confirmed -
* but I still have to log into the db link when the db link is initiated....

I have tried RDO, DAO, and ADO methods, all connect, but still required login when a table (db link) is opened...

RECAP: again, I confirm my login with the string - works perfectly. Then when a linked table is opened you are prompted for a login to the database. I am trying to avoid this.

ANY suggestions?

Relevant Pages

  • Re: EXEC master..xp_cmdshell Prevention
    ... I take it you're using string concatenation to build your sql statements. ... Next item -- using dbo for a web application's login is dangerous, ... sounds as though either a) your connection string isn't what you think it is ...
    (microsoft.public.sqlserver.security)
  • Re: EXEC master..xp_cmdshell Prevention
    ... way to significantly reduce vulnerabilities around dynamic string execution. ... > I found that my web application did use a connection string in a file ... I have created a new login account ...
    (microsoft.public.sqlserver.security)
  • Re: connection string
    ... In my project there are man connection string. ... Dim xmlDoc As New System.Xml.XmlDocument ... Dim TripleDes As New TripleDESCryptoServiceProvider ...
    (microsoft.public.dotnet.framework)
  • Re: Change login and password prompt
    ... > Where can i change Password and Login Prompt. ... can confirm this with the dd command: ... bytes to get to the "Password:" string, ... replacement string in the same way as was in the input file. ...
    (comp.os.linux.misc)
  • Multipart connectionstring question
    ... I’ve got an asp.net site that contains an access database. ... running the same app both on my machine and my host without making changes. ... How could one even use a server.mappath with a database connection string? ...
    (microsoft.public.dotnet.general)