Go Back   Access World Forums > Apps and Windows > Other Software

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 01-03-2018, 05:47 AM   #1
Kronix
Newly Registered User
 
Join Date: Nov 2017
Posts: 102
Thanks: 26
Thanked 0 Times in 0 Posts
Kronix is on a distinguished road
ODBC connects through password server

I've noticed I can connect to a database via ODBC by entering the path to the database file, even if I don't have the username and password to access the server through Windows Explorer Network Neighborhood.

For example,

Code:
SampleServer:C:\SERVERFILES\DB\MyDB.dbx
can be entered as the database path in the ODBC connection Setup, and it will connect me to that database even if I do not have log-in credentials when navigating into SampleServer in Windows Explorer.

Why is this possible and how would I disable it? Does it have to do with a certain port being open to program calls?

Kronix is offline   Reply With Quote
Old 01-03-2018, 06:00 AM   #2
Ranman256
Newly Registered User
 
Join Date: Apr 2015
Location: KY,USA
Posts: 3,156
Thanks: 0
Thanked 690 Times in 675 Posts
Ranman256 will become famous soon enough Ranman256 will become famous soon enough
Re: ODBC connects through password server

is the password not saved in the ODBC setup?
once saved, you can connect as many tables as you want w/o passwords.
Ranman256 is offline   Reply With Quote
Old 01-03-2018, 07:47 AM   #3
Kronix
Newly Registered User
 
Join Date: Nov 2017
Posts: 102
Thanks: 26
Thanked 0 Times in 0 Posts
Kronix is on a distinguished road
Re: ODBC connects through password server

The password for the DB is in the ODBC entry. But that is different than the Windows login information for the server in Explorer. How can it even reach the database file without the login information for navigating to the file?

Kronix is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
SQL Server - ODBC - SQL Server Native Client Registry Bat File Rx_ SQL Server 0 01-28-2016 03:16 PM
ESRI GIS Oracle ODBC - SQL Server Linked Server Invalid metadata for column "SHAPE" Rx_ SQL Server 0 08-25-2015 06:34 AM
Link to SQL Server with ODBC without risking original data in SQL Server? David Ball General 1 08-21-2015 07:59 PM
ODBC--call failed. [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object TBC General 2 04-14-2011 09:46 AM
Access Project no longer connects to SQL Server (Disconnected) RickH General 1 06-29-2005 10:32 AM




All times are GMT -8. The time now is 12:40 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World