Re: Internet Server Error

From: James A. Schulz (jaschulz_at_wiseware.com)
Date: 04/07/04 

Date: Wed, 7 Apr 2004 10:10:58 -0500

Del,

I am very new at this.

I am trying to write a little app to reach a single table ("Instructors") in
an Access DB which is kept on the faculty server at the school where I
teach. Last year I wrote a little ASP app that gives other faculty access
to their records in the "Instructors" table and it works fine. I just want
to make a Delphi app that will allow me to access all the records in the
"Instructors" table. My connection string looks like this:

Remote Provider=MS Remote;
Remote Server="http://faculty. school here>.edu";
Provider=Microsoft.Jet.OLEDB.4.0;
Data Source="./<my server path here./Instructors/Datastores/<my db name
here>.mdb";
[I have also tried: Data Source="Server.MapPath""./< my server path
here>/Instructors/Datastores/,my db name here>"")";]
User ID=<my userid here>;
Password=<my password here>;
Persist Security Info=False;
Internet Timeout=300000;
Transact Updates=True;
Jet OLEDB:System database="System.mdw"

Currently, the error I am getting says the either the username or the
password is invalid. Both are correct (of course), for the server. The db
has no password defined. However, I did make a workgroup info file for the
db, using my server username. That file, System.mdw, is in the folder with
the app, and it is also in the Datastores folder on the server. I can't
understand where the "invalid account name or password" error comes from
because it occurs before the app even tries to access the web (I am running
Zone Alarm, and so I have to give permission for any web access).

Any suggestions?

JAS

"Del Murray" <Del.Murray@CreditHawk.Net> wrote in message
news:4073e863$1@newsgroups.borland.com...
> We need some more info on the connection. I know that if you use
> TADOConnections and have a client connection alias set up with the sql
> server network utility , that the connection will work and you can do
> anything you want. However, If the DB is behind a firewall, there are 2
> ports that need opened in the firewall. SQL Server uses one port to
> "contact" the database and connect. It uses another to actually perform
data
> manipulation. You may have bumped into that problem. .. maybe
>
>

Relevant Pages

  • Re: Deployment + Vista
    ... I'm talking about the user being able to edit the server connection setting ... MSI will allow you to edit the app directory, ... function in order to put together the connection string something like: ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Digging in to trace files
    ... > Ed you are probably aware that even though the server is running MTS ... > you can create a dedicated connection when you need to correct? ... However, the app uses ... to shared server by requiring a high number of concurrent sessions ALSO ...
    (comp.databases.oracle.server)
  • Re: UK school RM Easylink and asp.net
    ... I have win 2000 server. ... The app is loaded on a folder which is pointed to by a virtual folder ... assessment software I've written for schools - www.sandcastle.me.uk) ... Now in order for a remote computer to access it and run it I am ...
    (microsoft.public.dotnet.security)
  • Re: Remote running of VB app using TS
    ... multi-user access requires a server OS. ... Internet or over a LAN or WAN using TS even as single user. ... either at the console or through a remote connection. ... running the app with TS. ...
    (microsoft.public.windows.terminal_services)
  • Re: Thread Issue
    ... > in/output streams to all of them from the application server. ... > a sepreat client. ... So your 'app' server is acting as a proxy; every client connection made to ...
    (comp.lang.java.programmer)
Loading