469,334 Members | 4,388 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,334 developers. It's quick & easy.

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 3077
debasisdas
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?
Thanks
Nov 7 '07 #3
I am reposting my question. Pl. Help me to solve my problem.
Thanks
Nov 14 '07 #4
AHMEDYO
112 100+
hi

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
lotus18
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
AHMEDYO
112 100+
Hi...

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
  5.  
  6.  
  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
GOOD LUCK
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
AHMEDYO
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
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
1 post views Thread by haryvincent176 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.