/build/static/layout/Breadcrumb_cap_w.png

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


0 Comments   [ + ] Show comments

Answers (6)

Posted by: henrik80 11 years ago
Second Degree Blue Belt
2

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

Posted by: talonsprem87 11 years ago
10th Degree Black Belt
1
  1. 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.
  2. 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.
  3. 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 11 years ago
Posted by: piyushnasa 11 years ago
Red Belt
1

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 11 years ago
  • add them in the odbc table in the package or add them through registry. - piyushnasa 11 years ago
Posted by: jagadeish 11 years ago
Red Belt
0

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 11 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 11 years ago
Posted by: anonymous_9363 11 years ago
Red Belt
0

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 11 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 11 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 11 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 11 years ago
Posted by: jagadeish 11 years ago
Red Belt
-1

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 11 years ago
  • ok.. - jagadeish 11 years ago
 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ