ODBC entries
What is ODBC and how can we know whether our application have ODBC entries or not and whqat we have to do if our application has ODBC entries
Please explain in a step by step manner
Answers (6)
Open Database Connectivity, its basically names of connections with a driver and attributes assigned to the connection.
You can find the ODBC entries in the registry under HKCU\Software\ODBC and HKLM\Software\ODBC
There are also some MSI table to handle these (their names start with ODBC) http://msdn.microsoft.com/en-us/library/windows/desktop/aa370546(v=vs.85).aspx
- Open Database Connectivity (ODBC) refers to a software API method for using database management systems (DBMS). ODBC was created so as to be independent of programming languages or operational systems and offers access to different database systems. The standard ODBC consists of an ODBC core and the respective specific ODBC database drivers. The core, also known as Driver manager, is independent of the database and acts as an interpreter between the application and the database drivers. The database drivers, on the other hand, contain DBMS-specific details and offer a mechanism for connecting with different ODBS-enabled database systems.
- you can come to know about ODBC entries in your package using a tool like prism , picture taker or install rite, whether you application is creating some odbc entries in your package.
- Depending on what technology you are making use of , there are different ways to handle ODBC entries
For MSI: only keeping odbc related registries in our package would suffice. you can remove odbc related ini files from your package
For App-V: You need to merge the odbc related registries with local.
Comments:
-
Yes, I'm making use of Admin studio and lets say dat my application has odbc entries and what I have to do? - vinodreddy10 12 years ago
In 64 bit OS, there are different ODBC for 64 bit and 32 bit. Make sure you are using the correct one.
Comments:
-
Dear friend please give me clear explaination if i came to know that my application has odbc entries what I have to do? - vinodreddy10 12 years ago
-
add them in the odbc table in the package or add them through registry. - piyushnasa 12 years ago
After installing source, go to Start Menu->Run and type odbcad32. This will lauch 'ODBC Data Source Administrator'
Watch the first 4 tabs named User DSN, System DSN, File DSN and Driver
If you found any your application releated entry/new entry in any of the tab, it means that your application has ODBC entries..
Now go to Start Menu->Run and type regedit
Go to HKLM\Software\ODBC and HKCU\Software\ODBC hives and export your app related registries as .reg file
Note : If you fing anything in HKCU\Software\ODBC, you can keep them in HKLM and remove them from HKCU
After Capturing the application, go to ODBC tables, delete the ODBC entries and import the above created .reg file into respective component.
Comments:
-
really taq a lot and how to export them as reg file and why we have to delete in HKCu and we have to move to HKLM
Please explain it? - vinodreddy10 12 years ago -
Mostly, you will get 'User DSN' in HKCU, that you can move it to HKLM rather than keeping it in HKCU..
You can export registries from registry editior (regedit) by right click and Export option - jagadeish 12 years ago
With the greatest respect, you should not be using this forum as a training room. To not know what ODBC is displays a staggering lack of knowledge of PC operating systems and Windows in particular.
Get yourself on a basic PC training course, then an application packaging course.
If you subsequently have tricky practical problems, by all means ask about them here.
Comments:
-
Thanks for ur suggestion and blog is just to help and make us to know the unknown things.
I do have basic knowledge that is y i'm asking all these questions - vinodreddy10 12 years ago -
I donno why unnecessary people who isn't answered even a single of my questions is speaking over here. If u wish to give the answer juz do that other wise .... - vinodreddy10 12 years ago
-
I'm really sorry for the people who helped me to understand and make me to learn by their valuable answers. This not for you all. - vinodreddy10 12 years ago
-
Vinod, VBScab is a highly respected member of this forum since the inception of AppDeploy. I would suggest you to be kind in your words and have some respect. Thanks.
He is not wrong in saying this when you are asking basic questions which should be covered in your packaging training before moving on to the production floor. - piyushnasa 12 years ago
Btwn.. Are you creating any Tutorial for packaging?
Comments:
-
No, I'm new to this and so asking
what do u mean by tutorial? - vinodreddy10 12 years ago -
ok.. - jagadeish 12 years ago