REDIRECT_QS_SrvConn=2 REDIRECT_QS_AllConn=2 REDIRECT_QS_ConnectionId=17157226249401451611730 REDIRECT_MMDB_ADDR=18.191.231.184 REDIRECT_MMDB_INFO=result found REDIRECT_GEOIP_COUNTRY_CODE=US REDIRECT_GEOIP_COUNTRY_NAME=United States REDIRECT_GEOIP_CONTINENT_CODE=NA REDIRECT_SCRIPT_URL=/pbx-data-logger/tutorials/pbxlogger-odbc-data-source.htm REDIRECT_SCRIPT_URI=https://aggsoft.com/pbx-data-logger/tutorials/pbxlogger-odbc-data-source.htm REDIRECT_prefer-language=en REDIRECT_HTTP_PREFER_LANG=en REDIRECT_HTTP_PROTO=http: REDIRECT_HTTP_GEOIP_COUNTRY_CODE=US REDIRECT_SUBPAGETYPE=examples REDIRECT_LimitDecodeAis_Counter=0 REDIRECT_DOCUMENT_PATH=/usr/sites/aggsoft/www.aggsoft.com/web/pbx-data-logger/tutorials REDIRECT_FILENAMEONLY=pbxlogger-odbc-data-source REDIRECT_REL_CANONICAL=https://aggsoft.com/pbx-data-logger/tutorials/pbxlogger-odbc-data-source.htm REDIRECT_HTTPS=on REDIRECT_SSL_TLS_SNI=aggsoft.com REDIRECT_STATUS=200 QS_SrvConn=2 QS_AllConn=2 QS_ConnectionId=17157226249401451611730 MMDB_ADDR=18.191.231.184 MMDB_INFO=result found GEOIP_COUNTRY_CODE=US GEOIP_COUNTRY_NAME=United States GEOIP_CONTINENT_CODE=NA SCRIPT_URL=/pbx-data-logger/tutorials/pbxlogger-odbc-data-source.htm SCRIPT_URI=https://aggsoft.com/pbx-data-logger/tutorials/pbxlogger-odbc-data-source.htm prefer-language=en HTTP_PREFER_LANG=en HTTP_PROTO=http: HTTP_GEOIP_COUNTRY_CODE=US SUBPAGETYPE=1 HTTPS=on SSL_TLS_SNI=aggsoft.com HTTP_ACCEPT=*/* HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com) HTTP_COOKIE=fly_geo={"countryCode":"us","region":"oh","dma":"535"}; fly_ab_uid=42935300-00aa-4339-8772-4eaa5d560345; fly_device=desktop HTTP_ACCEPT_ENCODING=gzip, br, zstd, deflate HTTP_HOST=aggsoft.com PATH=/sbin:/usr/sbin:/bin:/usr/bin SERVER_SIGNATURE=<address>Apache Server at <a href="mailto:support@aggsoft.com">aggsoft.com</a> Port 443</address> SERVER_SOFTWARE=Apache SERVER_NAME=aggsoft.com SERVER_ADDR=104.238.133.207 SERVER_PORT=443 REMOTE_ADDR=18.191.231.184 DOCUMENT_ROOT=/usr/sites/aggsoft/www.aggsoft.com/web/ SERVER_ADMIN=support@aggsoft.com SCRIPT_FILENAME=/usr/sites/aggsoft/www.aggsoft.com/web/pbx-data-logger/tutorials/examples.html REMOTE_PORT=48455 REDIRECT_QUERY_STRING=pbxlogger-odbc-data-source REDIRECT_URL=/pbx-data-logger/tutorials/pbxlogger-odbc-data-source.htm GATEWAY_INTERFACE=CGI/1.1 SERVER_PROTOCOL=HTTP/1.1 REQUEST_METHOD=GET QUERY_STRING=pbxlogger-odbc-data-source REQUEST_URI=/pbx-data-logger/tutorials/pbxlogger-odbc-data-source.htm SCRIPT_NAME=/pbx-data-logger/tutorials/examples.html DATE_LOCAL=Tuesday, 14-May-2024 21:37:04 UTC DATE_GMT=Tuesday, 14-May-2024 21:37:04 GMT LAST_MODIFIED=Wednesday, 24-Sep-2014 11:26:01 UTC DOCUMENT_URI=/pbx-data-logger/tutorials/examples.html USER_NAME=aggsoft DOCUMENT_NAME=examples.html QUERY_STRING_UNESCAPED=pbxlogger-odbc-data-source DOMAIN_ADD=/pbx-data-logger/ DOWNLOAD_URL=/download/ DOWNLOAD_URL_NAME=USA DOWNLOAD_URL2=https://dl2.aggsoft.com/ DOWNLOAD_URL2_NAME=Europe TAG=pbxlogger TAGID=19 SUBSCRIBE_LIST=pbxlogger DOWNLOAD_EXE_NAME=pbxlogger3 DOWNLOAD_ASK_EMAIL=Advanced PBX Data Logger Enterprise TITLE=Advanced PBX Data Logger TITLE2=PBX Data Logger captures SMDR or CDR data from RS232, RS845, TCP or UDP ports and can write it to various files or databases. PLUGIN_NO_PARSER=1 PLUGIN_NO_LOGGING=1 VERSION_ENT=1 VERSION_PRO=1 VERSION_STD=1 PRODUCT_HOME=/pbx-data-logger.htm PRODUCT_RSS=https://www.aggsoft.com/incl/pbxlogger.rss.xml PRODUCT_FAVICON=/pbx-data-logger/favicon.ico PRODUCT_REL_DATE=2001-01-01 PRODUCT_VER=3.7.8.514 PRODUCT_DOMAIN=https://www.aggsoft.com PRODUCT_CAT=UtilitiesApplication PRODUCT_CAT2=Data Logger Software PRODUCT_PRICE=145.00 PRODUCT_PRICE_CURRENCY=USD PRODUCT_RATING=4.9 PRODUCT_RATING_COUNT=44 PRODUCT_REVIEW_COUNT=24 ITEMS_LC=pbx ITEMS_UC=PBX ITEMS=PBX data TUTOR_PATH=/pbx-data-logger/tutorials/ RELATED_FILE=/pbx-data-logger/tutorials/pbxlogger_related.htm LABEL_LANG=en LANG_PATH= LABEL_DOWNLOAD=Download LABEL_BUY=Buy LABEL_BUY2=Buy Now! LABEL_BRIEF=Brief description: LABEL_PROBLEMS=What problems can be solved with Advanced PBX Data Logger? LABEL_GETTING=Getting started is easy. Advanced PBX Data Logger is ready! LABEL_FEATURES=Features: LABEL_SCR1=Screenshot: LABEL_SCR2=More screenshots LABEL_COMP1=Compatible with Windows 7 LABEL_COMP2=Works with Windows Server 2008 R2 LABEL_RELATED=Advanced PBX Data Logger related topics: LABEL_RELATED2=Related downloads: LABEL_OS_VER=incl. Server, x86 and x64 LABEL_LAST_NO_SPACES_AFTER=!!! LABEL_ABOUT=About LABEL_AWARDS=Awards LABEL_CHANGELOG=Changelog LABEL_HELP=Help LABEL_LANGNAME=LangName LABEL_PDFMANUAL=PDF manual LABEL_PLUGINS=Plugins LABEL_SCREENSHOTS=Screenshots LABEL_TUTORIALS=Tutorials LABEL_VER=Latest version: LABEL_VER_FOR=For LABEL_CONTACT=contacts LABEL_SUPPORT=support LABEL_PRODUCT=product LABEL_ONLINEHELP=Online Help LABEL_AWARDS2=Some program awards LABEL_FEAT1=Feature Matrix LABEL_FEAT2=Features comparison LABEL_BUYNOW2=Prices and purchase LABEL_DOWNLOAD1=Free trial version LABEL_DOWNLOAD2=Free trial version LABEL_KEYWORDS=pbx logger,pbx data logger,smdr logger,cdr logger,calls logger,smdr to database,call accounting LABEL_TITLE=PBX Data Logger - captures and logs phone calls for more than 260 PBX LABEL_DESC=PBX Data Logger allows you to capture and store call records from SMDR or CDR data to databases and generate informative reports LABEL_SLOGAN=Trust In Confidence! TUTOR_TITLE=How to create an ODBC data source TUTOR_KEYWORDS=odbc data source, ODBC DSN, pbx to odbc database, pbx, odbc database, write pbx to odbc database, pbx logger, pbx data logger, Advanced PBX Data Logger TUTOR_DESC=How to create an ODBC data source REL_CANONICAL=https://aggsoft.com/pbx-data-logger/tutorials/pbxlogger-odbc-data-source.htm MAIN_CSS_INCLUDED=1 PRODUCT_FAVICON_TYPE=x-icon DISABLE_GA=1 PRODUCT_GA=UA-911637-1 DELAYLOAD_OK=1 PRODUCT_HOME2=https://aggsoft.com/pbx-data-logger/tutorials/pbxlogger-odbc-data-source.htm PRODUCT_LDS_JSON_AUTHOR={"@type": "Organization","name":"AGG Software","url":"https://www.aggsoft.com","logo": {"@type": "ImageObject","url": "https://www.aggsoft.com/img/aggsoft48.gif"}} PRODUCT_LDS_JSON=<script type="application/ld+json">{ "@context": "https://schema.org","@type": "TechArticle","headline": "How to create an ODBC data source","image": "https://www.aggsoft.com/img/aggsoft48.gif","author": {"@type": "Organization","name":"AGG Software","url":"https://www.aggsoft.com","logo": {"@type": "ImageObject","url": "https://www.aggsoft.com/img/aggsoft48.gif"}},"genre": "Tutorial","dependencies":"Advanced PBX Data Logger software installed on your computer","proficiencyLevel": "Beginner","publisher": {"@type": "Organization","name":"AGG Software","url":"https://www.aggsoft.com","logo": {"@type": "ImageObject","url": "https://www.aggsoft.com/img/aggsoft48.gif"}},"url":"https://aggsoft.com/pbx-data-logger/tutorials/pbxlogger-odbc-data-source.htm","mainEntityOfPage": "https://aggsoft.com/pbx-data-logger/tutorials/pbxlogger-odbc-data-source.htm","description": "How to create an ODBC data source"}</script> GET_DOWN_BTN_NARROW=1

Advanced PBX Data Logger

How to create an ODBC data source

Note: In 64-bit editions of Windows, there are separate lists of data sources for the 32-bit and 64-bit modes. You need to configure a data source for the 32-bit mode. To access the respective version of the ODBC Data Ssource Administrator console, click the "Setup" button in the "ODBC database" module.

Note: The system ODBC data source lets you run the program as an application or as a service.

1. Switch to the "System DSN" tab and click the "Add" button (Figure 1).

Figure 1. Data source administrator

2. In the window that opens, select a driver for your database (Figure 2).

Figure 2. Selecting a driver

3. The following steps depend on the driver selected. Usually, you should configure a connection to the database.

Related articles:

Read more about:

Call logging Call accounting SMDR to SQL SMDR Listener Cables and signals