|
by: David |
last post by:
Hi,
I have a local user on our network running MS Access 2003 (on Win XP
Home), which needs to connect to a Back-End MySQL DB on our Cobalt
Qube 3 Server.
I installed the correct software to run the Access on their Win XP OS,
and installed the ODBC MySQL Driver 3.51.
When I test the connection in the ODBC panel, CONNECTED !
Then I open MS Access, and great, the app works.
|
by: black lee via DBMonster.com |
last post by:
we would like to provide users with changing password feature in our
application. I understand that db2 uses password of operating systems. does
anyone know if there is sql commend or api we use in our application to
change password? thanks.
We are using DB2V8.2 Express Edition V8.2, and ODBC Driver is IBM DB2 ODBC
Driver. our application is C application.
--
Message posted via http://www.dbmonster.com
|
by: Len Kowalik |
last post by:
MSAccess 2000, SQL-Server 97
I am getting a permission denied response from an attempt to execute a
stored proc, which has public access revoked and app role access, on
the last statement of the following code:
----------------------------------------------------------------------
strAttributes = "DATABASE=User_ProfilesQual" & _
vbCr & "Description=Default logon DB" & _
vbCr & "OemToAnsi=No" & _
|
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: Zlatko Matiæ |
last post by:
Hi!
In MS Access/PostgreSQL combination I have login form. After user writes all
neccessary inputs and push the button, a startup procedure creates DSN-less
connection string, receates all linked tables and change connection string
in all pass-through queries. It works nice...
But, how to achieve LOGOUT ? I would like to allow users to login/logout
consecutively from MS Access front-end without need to close front-end.
I tried to perform...
|
|
by: Jean |
last post by:
Hi everyone,
I was hoping somebody could assist me in this issue. I am quite a
newbie to ODBC connections and was struggling to search for related
topics. Here is my situation:
I have a Access 2000 .mdb file which has several linked tables to a
ODBC data source, namely an Oracle back-end. I have already setup the
connctions to these back-end tables in the ODBC Administrator, and it
works fine. When I view one of these tables for the...
|
by: yves piel |
last post by:
Hello,
I'm developping a java application which use an ms-access database via
jdbc/odbc bridge.
However, it seems that ms-access databases have to regularly been
compacted (for indexes and page size).
So how can I do it from java since I haven't got Access nor vb ?
thank you :)
|
by: Greg Strong |
last post by:
Hello All,
Is there any way to close an ODBC connection via DSN without completely
closing the Access front-end?
I'm doing some testing with using Access as a front-end to Oracle 10g
Express edition. When the user ID and password is entered on a form and
after a successful connection it seems Access doesn't change the
connection. Even if I enter an invalid user ID and/or password the
connection continues to work.
|
by: Greg Strong |
last post by:
Hello All,
The short questions are
1 Do you know how to make DSN connection close in Access to Oracle 10g
Express Edition?
&/or
2 Do you know how to make a DSN-less pass-through query work from
|
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:
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 synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
|
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.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
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: 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: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|