Click here to Skip to main content
16,021,765 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi,
Can anyone let me know which one is more advantageous in connecting to the database. Using an ODBC connection or using a connection string from system registry.
Also is there any special administrative rights required to connect to registry from the VB6 code?

Thanks in advance,
Sreeram Rengarajan
Posted

1 solution

You still do not understand what ODBC is about. ODBC is simply a type of interface for accessing a database. Each of these interfaces require specific connection string containing information regarding the user and the database location.
You can put several types of connection strings of different interface(ODBC, OLEDB, etc) on the system registry to be used.

As it is now year 2010 you should be using OLEDB instead, unless the database you are connecting to only supports ODBC.

You may require rights to read a registry depending on the registry location. However if this is a .NET application you should put your connection string in the .config file.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900