Re: How to access to a DB in an NT domain.

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Paul Clement (UseAdddressAtEndofMessage_at_swspectrum.com)
Date: 05/20/04 

Date: Thu, 20 May 2004 08:27:16 -0500

On Wed, 19 May 2004 14:09:03 GMT, Daniele Barzotti <daniele.barzotti@eurocomtel.com> wrote:

¤ > ¤
¤ > ¤ I must using a database that resides in a NT Server and my application
¤ > ¤ run on coputers that make part of another domain.
¤ > ¤ So, when I try to connect my app to db an error is raised.
¤ > ¤ Question: there is a method (using ADO) to give the login username and
¤ > ¤ pwd of the server into the connection string or using some property?
¤ > ¤
¤ >
¤ > What is the error message that is being raised and what kind of database are you using?
¤ >
¤ > There is no method for returning the user ID and password.
¤
¤
¤ In this time I've try some things.
¤ I put my MDB database into my intranet server (Windows 2000 server with
¤ IIS and MDAC 2.6) and I've created a DSN.
¤ Then I've build a UDL file with these flags:
¤
¤ Provider=MS Remote.1;
¤ Persist Security Info=True;
¤ Location=EuroNet;
¤ Data Source=MyDatabase.mdb;
¤ User ID=MyID;
¤ Password=MyPassword;
¤ Mode=ReadWrite;
¤ Remote Server=http://inet;
¤ Remote Provider=Microsoft.Jet.OLEDB.4.0;
¤ Internet Timeout=300000;
¤ Transact Updates=True
¤
¤ The code is (I use MDAC 2.8):
¤
¤ ************************************************************
¤ Dim Conn as ADODB.Connection
¤ Dim RSAdo As New ADODB.Recordset
¤
¤ Conn.Open "File Name=" & App.Path & "\Connection.udl"
¤
¤ With RSAdo
¤ .Source = "Customers"
¤ .ActiveConnection = Conn
¤ .CursorType = adOpenForwardOnly
¤ .CursorLocation = adUseClient
¤ .Open
¤ End With
¤ ************************************************************
¤
¤ The error is raised on the RSAdo.Open call :
¤
¤ Err.Description = Internet Server Error
¤ Err.Number = 8447
¤
¤ I've a beginner in n-tier application :o(
¤
¤ Any suggestion?

Can you open the database from a file share on your server or do you have to use HTTP?

If you need to use HTTP and RDS then I would make certain that your server has been configured
properly:

HOWTO: Configure RDS for Windows 2000
http://support.microsoft.com/default.aspx?kbid=250536

Paul ~~~ pclement@ameritech.net
Microsoft MVP (Visual Basic)

Relevant Pages

  • Create SharePoint Portal failed.
    ... One mentioned ensuring that SQL Server uses a case ... 13:55:40 Service database server is 'USDC-JOHRIV'. ... Update dbo.propertylist set DisplayName = N'Last name' ...
    (microsoft.public.sharepoint.portalserver)
  • Re: ADO Connection Timeout
    ... to the central server, but you are willing to live with periods where it ... i.e. a local database or even a text file. ... to function until the connection can be restored to the server. ...
    (microsoft.public.data.ado)
  • Web Developers - Happy Hearts And HDTV! - Lockergnome
    ... Certificate on your MSIIS Web server. ... getting data from a database is only half the problem. ... Zend recently started a series about building rock solid code in PHP. ... which provides bulk database conversion. ...
    (freebsd-questions)
  • Re: TNS could not resolve the connect identifier
    ... This database resides on Machine A. ... The Web server is running on Machine B. ... Using tnsping is not as good as using a real connection such as via ... client (note that this is terminology that appears in the 10g R2 ...
    (comp.databases.oracle.server)
  • Config for OLTP system
    ... extrenal disks fo the 60GByte database server. ... IBM Informix Dynamic Server Configuration Parameters ... # BUFFSIZE - OnLine no longer supports this configuration parameter. ...
    (comp.databases.informix)