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

Comments

Please log in to comment

Community Chosen Answer

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

Answered 07/10/2012 by: henrik80
Second Degree Blue Belt

Please log in to comment

Answers

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.
Answered 07/10/2012 by: talonsprem87
Tenth Degree Black Belt

  • Yes, I'm making use of Admin studio and lets say dat my application has odbc entries and what I have to do?
Please log in to comment
1

In 64 bit OS, there are different ODBC for 64 bit and 32 bit. Make sure you are using the correct one.

Answered 07/10/2012 by: piyushnasa
Red Belt

  • Dear friend please give me clear explaination if i came to know that my application has odbc entries what I have to do?
  • add them in the odbc table in the package or add them through registry.
Please log in to comment
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.

Answered 07/10/2012 by: jagadeish
Red Belt

  • 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?
  • 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
Please log in to comment
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.

Answered 07/10/2012 by: VBScab
Red Belt

  • 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
  • This content is currently hidden from public view.
    Reason: Removed by user request
    For more information, visit our FAQ's.
  • 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 ....
    • 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.
  • 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.
Please log in to comment
-1

Btwn.. Are you creating any Tutorial for packaging?

Answered 07/10/2012 by: jagadeish
Red Belt

  • No, I'm new to this and so asking
    what do u mean by tutorial?
  • ok..
Please log in to comment
Answer this question or Comment on this question for clarity