Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
ODBC
- Thread starter hacpro
- Start date
do you have the Apache Derby driver?
Leslie
Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual
Essential reading for database developers:
The Fundamentals of Relational Database Design
Understanding SQL Joins
Leslie
Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual
Essential reading for database developers:
The Fundamentals of Relational Database Design
Understanding SQL Joins
SkipVought
Programmer
FYI, Les,
alphabetcitydataworks seems to have gone away. You might want to use
Skip,
[sub]
![[glasses]](/data/assets/smilies/glasses.gif "[glasses] [glasses]")
When a wee mystic is on the loose..
It's a Small Medium at Large!![[tongue]](/data/assets/smilies/tongue.gif "[tongue] [tongue]")
[/sub]
alphabetcitydataworks seems to have gone away. You might want to use
Skip,
[sub]
When a wee mystic is on the loose..It's a Small Medium at Large!
[/sub]hacpro
A few pointers on the basics of ODBC
It is a client side connectivity (ie it runs on the PC that connects to the server). There are three components:
1. The ODBC driver - provided by the vendor of the data source.
2. The ODBC data source - this is a named setting for a database connection. with specific settings for the data source - exact requirements will depend on the driver.
eg: IP address of server, login ID/password, file on disk if its file based etc.
3. The ODBC administrator (odbcad32.exe) which lets you set up, amend and delete ODBC data sources.
Your app then connects through the ODBC to the data source to access the data.
Far more detail about ODBC and setting it up at my introduction to ODBC at
John
A few pointers on the basics of ODBC
It is a client side connectivity (ie it runs on the PC that connects to the server). There are three components:
1. The ODBC driver - provided by the vendor of the data source.
2. The ODBC data source - this is a named setting for a database connection. with specific settings for the data source - exact requirements will depend on the driver.
eg: IP address of server, login ID/password, file on disk if its file based etc.
3. The ODBC administrator (odbcad32.exe) which lets you set up, amend and delete ODBC data sources.
Your app then connects through the ODBC to the data source to access the data.
Far more detail about ODBC and setting it up at my introduction to ODBC at
John
- Status
