472,142 Members | 1,315 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,142 software developers and data experts.

Setup file for VB project having ADODC

Hi All,
I have developed project in VB6.0 with access as backend.I have used ADODC control in VB to retrieve data from access. I have created the Setup file by Package & Deployment. Now when i install the software on other PC whole program works fine but ADODC can not establish connection with database. Then if I install VB6.0 then only ADODC works. Can any body guide me how can i create set-up file so that i can install my software without installing VB. Thanks
Oct 25 '07 #1
9 3218
8,127 Expert 4TB
Take care to include all the .DLL and .OCX files in the setup.
Nov 4 '07 #2
Hello Debasis
I m including all the .dll & .ocx files that are listed in 'Included files " list in package & deploy wizard. Please tell me which other files should i include?
Nov 7 '07 #3
I am reposting my question. Pl. Help me to solve my problem.
Nov 14 '07 #4
112 100+

i think that almost package and development tools dont registry activeX Components & Dll it just copy it, i cant remmember but u can check, if it dont registry u must registry it.
Nov 15 '07 #5
866 512MB
Hi Neelesh2007

Why don't you try to change your adodc connection properties using .udl file?
Nov 15 '07 #6
hello Ahemedyo,
how can i registry activex?
Hello lotus18
can i change adodc connection properties using .udl file?

Pl. tell me

Thnaks to you both
Nov 17 '07 #7
112 100+

you can use Regsvr32.exe /s ["yourfile.dll" or "yourfile.ocx"] , if you just will test by your hand type it in run

if you wanna to make it with your application you have two methods

method 1:

Expand|Select|Wrap|Line Numbers
  1. Shell "Regsvr32.exe /s MyFile.dll", vbHide
care in your mind if your file path have any space you must place it within double quote """" & FilePath & """"
'================================================= ========second method:

Expand|Select|Wrap|Line Numbers
  1. Private Declare Function LoadLibrary Lib "kernel32" Alias "LoadLibraryA" (ByVal lpLibFileName As String) As Long
  2. Private Declare Function GetProcAddress Lib "kernel32" (ByVal hModule As Long, ByVal lpProcName As String) As Long
  3. Private Declare Function RegistryCOM Lib "user32" Alias "CallWindowProcA" (ByVal lpPrevWndFunc As Long, ByVal hWnd As Long, ByVal Msg As Long, ByVal wParam As Long, ByVal lParam As Long) As Long
  4. Private Declare Function FreeLibrary Lib "kernel32" (ByVal hLibModule As Long) As Long
  7. Public Function RegistryFile(ByVal FilePath As String) As Integer
  8. Dim LibraryHandle As Long
  9. Dim RegistryFunctionAddress As Long
  10.     LibraryHandle = LoadLibrary(FilePath)
  11.     If (LibraryHandle = 0) Then RegistryFile = 1: Exit Function
  12.     RegistryFunctionAddress = GetProcAddress(LibraryHandle, "DllRegisterServer")
  13.     If (RegistryFunctionAddress = 0) Then Call FreeLibrary(LibraryHandle): RegistryFile = 2: Exit Function
  14.     Call RegistryCOM(RegistryFunctionAddress, 0&, 0&, 0&, 0&)
  15.     Call FreeLibrary(LibraryHandle)
  16. End Function
Nov 17 '07 #8
Thanks Ahmedyo
But pls tell me at what stage should i register? I think after diploying setup file. Am i correct? And if i want to use 1st method for registering should i repeat the command for registering each .ocx and .dll one by one? Please reply.
I hope registry will solve my problem.
Thank you very much.
Nov 18 '07 #9
112 100+
Hi ...

yas man you must registry each file after copy it,this rule with all method that i was descript, copy file and then registry, but i recommend you to try it using hand first from command line, because if the problem is not to registry the file then you wast ur time in setup application

Best Regards
Nov 18 '07 #10

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by alanrn | last post: by
3 posts views Thread by hangten | last post: by
reply views Thread by Adam Clauss | last post: by
2 posts views Thread by Sathyaish | last post: by
reply views Thread by Mark | last post: by
4 posts views Thread by Joe | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.