ADO sqloledb won't connect running on Win2003 server

To All

I have a wierd situation where I have a very successful ADO xHarbour\FWH C++
application ( executable ) which resides on a Win2003 server.

When the users run the executable from the server ( shortcut on their pc )
the application connects to the SQL server and runs flawlessly.

However .. if you are at the server console ( physically at the server ) ..
and you run the same application ( on the server ) it will start but fail to
connect to the first table.

Totally exhausted here trying to find an answer .. I have found Google ideas
on adding Persistant Security Info=False to no avail.

Here is the connection string :

oRs := TOleAuto():New( "ADODB.Recordset" )
oRs:CursorType := 1 // opendkeyset
oRs:CursorLocation := 3 // local cache
oRs:LockType := 3 // lockoportunistic

cSQL := "SELECT * FROM utility WHERE progid ='"+xPROGID+"'"
TRY
oRS:Open(cSQL,'Provider='+xPROVIDER+';Data Source='+xSOURCE+';Initial
Catalog='+xCATALOG+';User Id='+xUSERID+';Password='+xPASSWORD )
CATCH oErr
MsgInfo( "Error in Opening UTILITY CRASH BURN table" ) /// dies here
RETURN NIL
END TRY

Again .. this app runs the executable flawlessly as a shortcut on the
workstation .. but the same app will not run sitting at the server running
the app ON the server ??

Hope that makes sense. Any help would be appreciated.

Rick Lipkin
SC Dept of Health, USA


.

Relevant Pages

  • Re: Homegrown synchronization
    ... to check for update files in the Import DropBox for the server. ... similar to the import code used to update a remote backend). ... code to close the "sync" app. ... synch app, but only one at a time would be able to do synchs. ...
    (microsoft.public.access.replication)
  • RE: Beginners Questions
    ... We do use Windows form on the presentation layer which is on ... terminal server and call web services on the business logic side. ... of using "proxy" authentication on SQL Server. ... > I have written an app with a Windows Forms UI that is deployed to clients ...
    (microsoft.public.dotnet.distributed_apps)
  • Re: Ruby Enterprise App Design Advice
    ... Load balanced to send user to best server. ... FastCGI or SCGI - We would like to replace FastCGI with something ... certain instance and want to have a single session server (if I understand ... deals with login and logout and assigns an app server. ...
    (comp.lang.ruby)
  • RE: C++ Garbage Collector on VMS?
    ... And HW is usually not a problem in th app tier. ... One for App server, one for DB. ... Tiers were a great concept when HW could not keep up with the processing required by each tier and network speeds were slow and unreliable. ... In small to medium app environments, ...
    (comp.os.vms)
  • Re: Schannel and Session Renegotiation
    ... Schannel does not support the server sending app ... We are discussing the option of providing support for the client blowing off ...
    (microsoft.public.platformsdk.security)
Loading