Motaz
asked on
ADO Deployment
I have an application that connect to MS-SQL server using ADO connection. After I deploy the this application it works only in one computer but it didn't work in other three computers, one of them is Win95 and the other two is WinNT service pack 3
Is there an important files that I must copy?
Motaz
Is there an important files that I must copy?
Motaz
Hi Motaz,
are you sure, that ADO is installed on those pc's where your app doesn't work?
If you look in the registry then you should find entries like:
\HKEY_CLASSES_ROOT\ADODB.C
\HKEY_CLASSES_ROOT\ADODB.R
which should point to files like msado*.dll usually located in the ADO-folder somewhere under :
Root:\program files\common files\microsoft shared\...
If ADO is not installed or you are not sure then go to the MS-site and download mdac_typ25.exe which contains the complete ADO installation.
HTH,
Thomas
are you sure, that ADO is installed on those pc's where your app doesn't work?
If you look in the registry then you should find entries like:
\HKEY_CLASSES_ROOT\ADODB.C
\HKEY_CLASSES_ROOT\ADODB.R
which should point to files like msado*.dll usually located in the ADO-folder somewhere under :
Root:\program files\common files\microsoft shared\...
If ADO is not installed or you are not sure then go to the MS-site and download mdac_typ25.exe which contains the complete ADO installation.
HTH,
Thomas
ASKER
How can I install ADO? I didn't find it in the Install Shield!
>How can I install ADO? I didn't find it in the Install Shield!
In the Delphi 5 CD, there's a folder called MDAC. IN that folder there's a file, Mdac_typ.exe, that is the installer for MDAC (Microsoft Data Access Components, which contains ADO).
Just deploy that file and run it on the client machine. It will install MDAC.
If necessary, for older Win95 machines, deploy DCOM95.EXE as well, and it will install DCOM for Win95.
If you don't have the D5 CD, MDAC installer is also available from Microsoft's web site.
Alex
In the Delphi 5 CD, there's a folder called MDAC. IN that folder there's a file, Mdac_typ.exe, that is the installer for MDAC (Microsoft Data Access Components, which contains ADO).
Just deploy that file and run it on the client machine. It will install MDAC.
If necessary, for older Win95 machines, deploy DCOM95.EXE as well, and it will install DCOM for Win95.
If you don't have the D5 CD, MDAC installer is also available from Microsoft's web site.
Alex
>in a computer that does not contain Delphi and it works
Maybe MDAC was installed by some application like MS Office or NT SP 5/6.
Many (and I mean *many*) Microsoft applications install MDAC wihout the user knowing. That's the beauty of using ADO: deployment is a lot easier, because there's no annoying BDE involved. Ok, you're having troubles, but you'll solve them once you follow my previous tip.
Yours,
Alex
Maybe MDAC was installed by some application like MS Office or NT SP 5/6.
Many (and I mean *many*) Microsoft applications install MDAC wihout the user knowing. That's the beauty of using ADO: deployment is a lot easier, because there's no annoying BDE involved. Ok, you're having troubles, but you'll solve them once you follow my previous tip.
Yours,
Alex
You can get a distributable at www.microsoft.com/data.
Internet Explorer (besides many NS software) also instals it.
Internet Explorer (besides many NS software) also instals it.
ASKER
Adjusted points from 20 to 60
ASKER
I setup MDAC_TYPE.exe but the problem is still exists (Dr. Watson).
I think the problem is not in installing MDAC because the office is installed in that computer.
Please help
I think the problem is not in installing MDAC because the office is installed in that computer.
Please help
Do you use any runtime packages?
This could then be an answer why your app only runs on computers on which Delphi is installed.
Thomas
This could then be an answer why your app only runs on computers on which Delphi is installed.
Thomas
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thomas
Run-time package? like what?
Run-time package? like what?
Cannot help you but interested to know the outcome.
I meant runtime packages from Delphi components or libraries, which you can select when compiling your app (Option: build with runtime packages).
But as you told before, your app once has run on a pc on which delphi was not installed.
Therefore I think, you built your app as a standalone-app and we should look for other possibilities.
As you said, MDAC is installed correctly on all client pc's.
What kind of errors do you get? (Error=Dr. Watson is not very helpful
;-) )
Thomas
But as you told before, your app once has run on a pc on which delphi was not installed.
Therefore I think, you built your app as a standalone-app and we should look for other possibilities.
As you said, MDAC is installed correctly on all client pc's.
What kind of errors do you get? (Error=Dr. Watson is not very helpful
;-) )
Thomas
Are you there, Motaz?
Hello?
Motaz?
Motaz?
ASKER
Comment accepted as answer
ASKER
The error in the other computers is Dr. Watson.