473,544 Members | 1,760 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

ODBC permissions

Hello

I have posted to this group as it seems to be a lot busier than the
odbc specific ones. If you can suggest a more appropriate group I will
post it there.

I am connecting to databases on a server using asp pages. There are two
databases, an Access database and a Sage database (part of the Sage
Line 50 accounting package)

These are the connection strings

Access
"Provider=Micro soft.Jet.OLEDB. 4.0;Data Source=c:\datab ase\mydb.mdb"

Sage
"Driver={Sa ge Line 50
v10};DIR=C:\Sag e\Accounts\ACCD ATA;UseDataPath =No;UID=usernam e;PWD=password"

The Access connection works for any user, the Sage connection only
works if the user is an administrator on the server (the UID and PWD
for the Sage connection are Sage specific and don't need to match the
username of the person using the asp pages). I get the same results
using a DSN. I can connect to the Sage database on the server as a
normal user by using a local DSN with the DIR setting as the mapped
network drive on the server, so I don't think the problem is
file/folder permissions (they look ok anyway).

The error when a user tries to connect via ASP to the Sage database is:

Microsoft OLE DB Provider for ODBC Drivers error '80040e4d'
User ID or Password invalid

I don't think this is from the actual connection because as soon as you
make the user an administrator it will work. I don't think the driver
is checking if the user is an administrator because then it wouldn't
work using a local DSN and a network path. It seems the Sage driver is
trying to do something that can't be done by a normal user on the
server (e.g. launch a process).

Anyone got any ideas how I can find out what is going on and get users
to access the Sage database.

Thanks

Nov 19 '05 #1
2 4387
Might be a tough one to track down, but I'd probably start in
Administrative Tools -> Local Security Policy and turn on auditing,
particularly "Audit privledge use" and "object access" for failures.
You might turn up something in the security log.

You might also try the FileMon and RegMon tools from sysinternals.co m
to see if the record any access errors when your Sage stuff is
starting up.

HTH,

--
Scott
http://www.OdeToCode.com/blogs/scott/

On 6 Oct 2005 03:03:24 -0700, di*********@yah oo.com wrote:
Hello

I have posted to this group as it seems to be a lot busier than the
odbc specific ones. If you can suggest a more appropriate group I will
post it there.

I am connecting to databases on a server using asp pages. There are two
databases, an Access database and a Sage database (part of the Sage
Line 50 accounting package)

These are the connection strings

Access
"Provider=Micr osoft.Jet.OLEDB .4.0;Data Source=c:\datab ase\mydb.mdb"

Sage
"Driver={Sag e Line 50
v10};DIR=C:\Sa ge\Accounts\ACC DATA;UseDataPat h=No;UID=userna me;PWD=password "

The Access connection works for any user, the Sage connection only
works if the user is an administrator on the server (the UID and PWD
for the Sage connection are Sage specific and don't need to match the
username of the person using the asp pages). I get the same results
using a DSN. I can connect to the Sage database on the server as a
normal user by using a local DSN with the DIR setting as the mapped
network drive on the server, so I don't think the problem is
file/folder permissions (they look ok anyway).

The error when a user tries to connect via ASP to the Sage database is:

Microsoft OLE DB Provider for ODBC Drivers error '80040e4d'
User ID or Password invalid

I don't think this is from the actual connection because as soon as you
make the user an administrator it will work. I don't think the driver
is checking if the user is an administrator because then it wouldn't
work using a local DSN and a network path. It seems the Sage driver is
trying to do something that can't be done by a normal user on the
server (e.g. launch a process).

Anyone got any ideas how I can find out what is going on and get users
to access the Sage database.

Thanks


Nov 19 '05 #2

Scott Allen wrote:
Might be a tough one to track down, but I'd probably start in
Administrative Tools -> Local Security Policy and turn on auditing,
particularly "Audit privledge use" and "object access" for failures.
You might turn up something in the security log.

You might also try the FileMon and RegMon tools from sysinternals.co m
to see if the record any access errors when your Sage stuff is
starting up.
Thanks for your reply. I tracked down the problem using FileMon. The
Sage driver was trying to access:
C:\Documents and Settings\All Users\Applicati on
Data\Microsoft\ Crypto\RSA\Mach ineKeys
I added read permissions for Authenticated Users to this directory and
it worked.

Thanks again.
--
Scott
http://www.OdeToCode.com/blogs/scott/

On 6 Oct 2005 03:03:24 -0700, di*********@yah oo.com wrote:
Hello

I have posted to this group as it seems to be a lot busier than the
odbc specific ones. If you can suggest a more appropriate group I will
post it there.

I am connecting to databases on a server using asp pages. There are two
databases, an Access database and a Sage database (part of the Sage
Line 50 accounting package)

These are the connection strings

Access
"Provider=Micr osoft.Jet.OLEDB .4.0;Data Source=c:\datab ase\mydb.mdb"

Sage
"Driver={Sag e Line 50
v10};DIR=C:\Sa ge\Accounts\ACC DATA;UseDataPat h=No;UID=userna me;PWD=password "

The Access connection works for any user, the Sage connection only
works if the user is an administrator on the server (the UID and PWD
for the Sage connection are Sage specific and don't need to match the
username of the person using the asp pages). I get the same results
using a DSN. I can connect to the Sage database on the server as a
normal user by using a local DSN with the DIR setting as the mapped
network drive on the server, so I don't think the problem is
file/folder permissions (they look ok anyway).

The error when a user tries to connect via ASP to the Sage database is:

Microsoft OLE DB Provider for ODBC Drivers error '80040e4d'
User ID or Password invalid

I don't think this is from the actual connection because as soon as you
make the user an administrator it will work. I don't think the driver
is checking if the user is an administrator because then it wouldn't
work using a local DSN and a network path. It seems the Sage driver is
trying to do something that can't be done by a normal user on the
server (e.g. launch a process).

Anyone got any ideas how I can find out what is going on and get users
to access the Sage database.

Thanks


Nov 19 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
3108
by: David Lozzi | last post by:
This happens a lot to my databases. I store them at the root of my developing files, i.e. c:\My Projects\Proj1\database.mdb. Randomly, the security settings on this database will drop to the basic secutiry, myself and SYSTEM. I need IUSR on it so I can access it through my ASP pages... I get errors like this: Microsoft OLE DB Provider for...
11
3734
by: Wolfgang Kaml | last post by:
Hello All, I have been working on this for almost a week now and I haven't anything up my sleeves anymore that I could test in addition or change.... Since I am not sure, if this is a Windows 2003 Server or ADO or ODBC issue, I am posting this on all of the three newsgroups. That's the setup: Windows 2003 Server with IIS and ASP.NET...
3
2741
by: Steve Farber | last post by:
I'm not especially new to databases and I have used ODBC before with other data sources, but I cannot seem to get Access 2003 to talk to MySQL 4.0.15. I have MySQL running with new tables defined, but I cannot get a connection to those tables via ODBC using MyODBC 3.51. Can anyone point the way? Many thanks,
2
6270
by: Tina Robichaux | last post by:
I have found info on this problem at MS, but they say this problem does not occur with SQL 2K and MDAC 2.6 SP2, yet I am still experiencing it: I have a SQL user specifically created to SELECT on 5 tables in one database. I have created an ODBC file DSN using that login/password. I create an Access DB, attempt to link to the five SQL tables...
1
2539
by: paul_tomlin | last post by:
We connect via terminal services to an excel spreadsheet that has an ODBC link to an access database using a pivot table, when we try to refresh the data within the excel spreadsheet we receive the following error "the microsoft jet database engine cannot find the input table or query....." this works ok if the user connects to terminal...
5
3882
by: somersbar | last post by:
hello all, im trying to connect to a microsoft access database from an ASP.NET web form. i keep getting the following error though: ERROR Could not use '(unknown)'; file already in use. ERROR Driver's SQLSetConnectAttr failed ERROR Could not use '(unknown)'; file already in use.
1
3795
by: Hitesh Joshi | last post by:
Hi, I have a prod database (main bread & bread DB) and have a small access database that sales team is using... I created a login inside SQL 2000 and gave db_read permission and SELECT permissions... and public. Role of public is EXEC store procs and view some systables... I linked those tables that I gave permissions through ODBC link...
4
6471
by: Rodent | last post by:
I have an IIS 6.0, 2003 Server running with PHP installed. I have an access database with a DSN ODBC connection configured. When this ODBC is configured to access the database locally - great, works fine. When configured to access a remote copy of this database I get the following : "....Warning: odbc_connect() : SQL error:
1
1520
by: GinaM1 | last post by:
Hi All, I am working with a software package that logs messages via ODBC to a remote SQL Server 2005 Service Pack 2 database. The server OS is Server 2003 Service Pack 1. The software that we are working with successfully creates the SQL table and SQL user for the logging as the ODBC connection is set up. We have verified that both the user...
0
7359
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
7598
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
0
7757
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
0
7699
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
4905
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3400
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
0
3398
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
1833
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
0
651
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.