Cannot Create System Dsn Odbc Data Souce as Administrator

9673 views
Skip to first unread message

Ron Aaronson

unread,
Apr 23, 2009, 9:26:34 AM4/23/09
to
I am logged on to Vista 64-bit as an administrator. Using the ODBC
data source administrator that is in the Control Panel I can create
and successfuuly test a system dsn odbc data source. But, this data
source is invisible to Microsoft Access 2007. When I recreate the
data source as a user dsn, Microsoft Access has no problems with it.
Based upon reading articles, I thought i would try to create the
system dsn data source using C:\Windows\syswow64\odbcad32.exe. I did
not think this was actually a 32/64 bit issue, since Access is able to
use the data source when it is a user dsn, but what the heck. When I
try using th3 32-bit odbc administartor I get the message "you are
logged on with non-administrative privileges" even when I make sure
the program is run as an administrator.

Anybody knows what is going on?

Pak-Ming Cheung - MSFT

unread,
May 5, 2009, 4:56:01 AM5/5/09
to
It seems that you hit the 32-bit/64-bit issue. It is discussed in the
following KB article in detail:
http://support.microsoft.com/kb/942976

It is right to use 32-bit ODBC Administrator to manage DSN connecting to
32-bit driver (MS Access 2007 *only* supports 32-bit ODBC driver).

For the problem of "you are logged on with non-administrative privileges",
please make sure you are using elevated console to type
"c:\windows\sysWOW64\odbcad32.exe"

Thanks,
Ming.
WDAC Team, Microsoft.

P.S. We recommend customers to use the forum to ask questions in the future,
where you can obtain a faster response (Forum is at:
http://social.msdn.microsoft.com/forums/en-US/sqldataaccess/threads/)

Ron Aaronson

unread,
May 21, 2009, 7:23:22 AM5/21/09
to
A belated thanks!

aloyce....@gmail.com

unread,
Jan 16, 2014, 1:51:56 PM1/16/14
to
i try to link ms access with wampersever but get message that saying:You are loggeg on with non-Administative privilege.System DSNs could not be created or modified.
Any one who can help me

aloyce....@gmail.com

unread,
Jan 16, 2014, 1:55:05 PM1/16/14
to
aim Aloyce Mtaturu try to link ms access with wamper server but i get a message that saying:You are logged on with non-Administrative privilege.System DSNs could not be created or modified.

fatjac...@gmail.com

unread,
Mar 24, 2016, 2:19:35 PM3/24/16
to
I am logged into Windows server 2012 R2 64bit as an administrator, I am right clicking the odbc64 bit app and choosing run as administrator, when I click the System DSN tab, I STILL am getting that I am not running with admin privilege.

Even if I use the administrator powershell, or cmd or us run as administrator. No matter what, System DSN doesn't work.

I don't generally bash Microsoft, or use foul language or troll, but I have had enough. YOu can see my name, who I am, and I stand by my next statement.

Fuck you, Microsoft. Fuck you, fuck you, fuck you, fuck you. Fuck your tendency to change everything about the interface to make 20 year admins have to pay for classes to learn how to do the same shit they already know how to do, fuck you for not actually making your OS secure against virii, hackers, or accidents, only against people trying to do their jobs. Fuck you for making usable products obsolete, fuck you for making everything that used to be one-click now take three, fuck you for trying to force me to use your way instead of my way, fuck you, fuck you, fuck you, fuck you.

And then, get up in the morning, count your money, and fuck you again.

Love, Steve.
Reply all
Reply to author
Forward
0 new messages