Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ADO Installed Program

Status
Not open for further replies.
Japskunk72

Japskunk72

Programmer
Feb 19, 2003
64
US
I have a finished application that was written in VB 6.0 sp2, ADO 2.7, Crystal Reports 8.0. It will not connect to the ODBC link when it has been installed on a client computer. The program works on an Admin computer with all the developement software installed but not on any other computer? the ODBC links have been setup and i have triple checked the SQL security for loggin in to SQL 2000. The program will load after it has been installed but will not query the Database and display any information. I have a combo box that lists a certain criteria on boot. nothing is in it. There is info in the DB tables though.
any ideas will be appreciated!
Thanks
JT
 
Sort by date Sort by votes
What is your error. What error does it return?

Craig

"I feel sorry for people who don't drink. When they wake up in the morning, that's as good as they're going to feel all day."
~Frank Sinatra
 
Upvote 0 Downvote
Did you use the package and deployment wizard (or another setup program) to ensure that all required files (.dll's, .ocx's, etc.) are copied and registered on the target computer. The exe is not enough. VB requires some additional runtime files itself.

If you have used a setup program then double check to see that all files were installed on the target.

Thanks and Good Luck!

zemp
 
Upvote 0 Downvote
It was the MDAC! Just for the hell of it i went on microsofts website and downloaded the newest one and installed it. I thought it added it to it. It even sais on the install... "Installing MDAC" i guess not. I am using the Package and Deployment wizard to do this.

Thanks for the help
JT
 
Upvote 0 Downvote
It may have installed the wrong version of MDAC. Check in C:\Program Files\Microsoft Visual Studio\VB98\Wizards\PDWizard\Redist to see which version of MDAC the PDW is using to install on the target. If it is not the one your app is using then rename the exiting one and paste a copy of 2.7 in that folder.

Thanks and Good Luck!

zemp
 
Upvote 0 Downvote
sorry, typo. It should read 'rename the existing one'

Thanks and Good Luck!

zemp
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

BigTG
  • Locked
  • Question
Converting an old XP VB6 program to run on Windows 7 & Windows 10
Replies
5
Views
693
vb5prgrmr
vb5prgrmr
Ken01
  • Locked
  • Question
I have a program, developed in VB6
Replies
6
Views
961
Ken01
Ken01
BigTG
  • Locked
  • Question
Legacy VB6 program
Replies
4
Views
702
xwb
xwb
MaxJo
  • Locked
  • Question
MOUSEEVENTF_LEFTDOWN in Compiled Program
Replies
6
Views
638
MaxJo
MaxJo
Swi
  • Locked
  • Question
Adobe SDK
Replies
6
Views
343
Swi
Swi

Part and Inventory Search

Sponsor

Back
Top