I created a link to a table but when I try to open the link, I get a ODBC error (ODBC -- call failed. [Oracle][odbc]Invalid datetime format. (#0)
More information:
-created link in Access 2000 database
-I can access other tables in Access to that same Oracle database using the same DSN
-I get...
I have a database that has the allowbypasskey set to false and I have turned off the menu options during startup
from one desktop, if I open that database and keep holding the shift key down, I can get menu options. I can then go to start up options, re-select everything, turn off the form that...
more details:
would like to do this using groups
example:
create an Oracle user called hr_db_user (assign access to db objects to it)
map a Windows group to that Oracle user (e.g. HR Oracle Group)
I am trying to figure out how to set up security for users connecting to an Oracle Database over ODBC links.
Details on set up:
Oracle 11g running on Linux
Windows 2003 domain
Users running Windows XP
I would like to be able to secure tables/views and tie it to their user accounts. I know...
I am trying to encrypt emails in Outlook but I keep getting the following error message: "Your digital ID name cannot be found by the underlying security system"
I have googled the error message and for the most part they say the same thing...that it is either a corrupt certificate or it is a...
I tried using a self-signed cert but had the same issue
don't think it is a cert issue
most likely the network service account can't read the cert
going to try a local admin acccount
I am trying to set up my clients to be able to encrypt their odbc connections to the SQL 2005 Server but I am having problems with the set up.
What I have done:
- went to http://myserver/cersrv (our local CA) and generated a certificate using the form. I named it the fqdn of the sql server and...
If I run this with a date such as 02/02/08, it doesn't return any records.
If I change Query two to <=#02/02/08# and run the unmatched query, it works.
If I change the queries to prompt instead of referencing a form, it still doesn't work.
If I change the the unmatched query and get rid of...
Query One:
SELECT dbo_Employees.SystemAssignedPersonID, dbo_Employees.CurrentHireDate
FROM dbo_Employees
WHERE (((dbo_Employees.CurrentHireDate)<=[Forms]![Head Count Form]![HCDate]))
ORDER BY dbo_Employees.CurrentHireDate DESC;
Query Two:
SELECT...
I am trying to create a simple unmatched query but I am having issues.
Situation:
Query one contains employee number and hired date
Query two contains employee number and termination date
I want to prompt for a date and return the employees that were hired before that date and weren't...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.