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 2 4401
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
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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
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 ODBC Drivers (0x80004005)
The Microsoft Jet database engine
cannot open the file '(unknown)'. It...
|
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 actiavted
Access 2002 mdb file (and yes, proper rights are set on TMP paths and path,
|
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,
|
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 using that
DSN, using a trusted connection. The ODBC drivers ignore the users
permissions, and...
|
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 services as the
administrator however if they connect as any other issue it won't work
Anyone got...
| |
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.
|
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 into
access db with the user that I created inside SQL as readonly user...
but to my surprise when I...
|
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:
|
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 and the table have been set up on the SQL Server machine. By default, full permissions are not...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
| |
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 choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
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 into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
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
| |
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 effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |