ODBC Questions - Techist - Tech Forum

Go Back   Techist - Tech Forum > Computer Software > Microsoft Windows and Software
Click Here to Login
Closed Thread
 
Thread Tools Display Modes
 
Old 11-12-2006, 03:06 PM   #1 (permalink)
Master Techie
 
Join Date: Mar 2004
Posts: 2,069
Default ODBC Questions

Hello

I had a bunch of ODBC questions, i would appreciate if you guys/gals could mystify ODBC.

If i create a *.mdb file using MS Access, am i creating an ODBC driver, or do i actually create the ODBC driver though the ODBC Data Source Administrator?

what does the ODBC driver contain, what langage is it written in? what is its extension?
__________________

rookie1010 is offline  
Old 11-12-2006, 04:10 PM   #2 (permalink)
It's all just 1s and 0s
 
office politics's Avatar
 
Join Date: Jan 2004
Location: in the lab
Posts: 6,555
Send a message via MSN to office politics
Default

odbc is driver, prolly a dll, that allows you to interact with particular databases. When you install MS Access on a windows box, you also instal a odbc driver. you can see this in the odbc administrator by looking at the driver tab. If you setup a data source in the administrator, it will preconfigure settings for an app to interact with a particular file.

i use odbc connections in ASP and PHP to interact with SQL, MS Access, Excel, & MySQL.

heres a good tutorial for using asp to interact with SQL. the CONN STRING at the top could easily be changed to interact with other types of databases

http://www.asp101.com/samples/db_edit.asp - click view ASP code to see conn string
__________________

office politics is offline  
Old 11-12-2006, 05:30 PM   #3 (permalink)
Master Techie
 
Join Date: Mar 2004
Posts: 2,069
Default

thanks for the reply

So by adding new database files, one is not creating a new driver, correct?

so The dsn just adds an entry to the overall database library list
rookie1010 is offline  
Old 11-12-2006, 06:16 PM   #4 (permalink)
It's all just 1s and 0s
 
office politics's Avatar
 
Join Date: Jan 2004
Location: in the lab
Posts: 6,555
Send a message via MSN to office politics
Default

creating new database files does not create new odbc drivers.

a single odbc driver can be used to interact with many different database servers or files.

the dsn configures file/server location, usernames, passwords, etc used to connect to different database servers or files.
office politics is offline  
Closed Thread

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off




Copyright 2002- Social Knowledge, LLC All Rights Reserved.

All times are GMT -5. The time now is 10:47 AM.


Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2017, vBulletin Solutions, Inc.