|
by: Steve |
last post by:
I normally use MySQL with PHP, but I'm delving into connecting to Access
with ODBC (for a database that I already have set up at work), and I'm
running into a couple of errors. I'm just trying to do a simple query
with two columns - one a name (VARCHAR), and one an integer column.
First, if I add an ORDER BY clause, so the query looks like this:
$sql = "select tblScores.FullName, sum(tblScores.Points) as TotalPoints
from tblScores...
|
by: puppet_sock |
last post by:
Does the breaking of an ODBC connection produce a logoff event?
I can't seem to get it to.
What I was hoping was to use a trigger to do automatic cleanup
of session specific data. But the closing of the ODBC does not
fire the logoff trigger, even though closing sqlplus does.
Is there something I'm missing here? Is there a better way to
cleanup session specific data when connecting through ODBC?
I'm concerned with the case where the...
|
by: Kong Li |
last post by:
Follow up to this thread, the latest Oracle 9i release 2 patchset
(9.2.0.5) fixed the handle count leak problem. The problem is in
Oracle client component.
Thanks.
Kong
-----
From: Kong Li (likong@email.com)
|
by: Ralf Obst |
last post by:
Hello,
we get a message SQL0204N when trying to import tables from a DB2/VM
into an MS Access database.
The message text is: ... "DB2/VM SQL0204N 'SQLTables ' not defined
".
When importimg from an ODBC data source Access offers a list box
containing all the tables/views etc. The user can select one or more
tables to import.
|
by: Dave |
last post by:
Hey guys, I have an ODBC problem that has me stumped. I wrote a VBA
script to run in Microsoft Excel that pulls data out of an application
using that application's ODBC driver and puts it into Excel. I am
trying to translate the same program over to Microsoft Access and I ran
into a problem. Access locks up if the data I am querying for is not
present in the database.
To retrieve data from the database of the application, my Excel...
|
|
by: Jeremy Dillinger |
last post by:
I am trying to design a program that will use data from a MySQL database.
Currently all the data is being used with PHP scripts from a website. I am
also trying to build a software solution that can use the same data. I have
gone through all the data connectors in Visual Basic.net and none of them
have the options for connecting to MySQL. Does anybody know how I would go
about doing this? Thanks in advance!
Jeremy
|
by: SKB |
last post by:
Hi,
I am absolutely new to this area. I am getting the following difficulty
:
Access denied for user 'ODBC'@'localhost' (using password: NO)
when I try the mysql command from within the C:\Program
Files\MySQL\MySQL Server 5.0\bin on the command window.
Please note that the MySQL is runnging as I have tried the command NET
START MySQL and it gives the following output:
The requested service has already been started.
More help is...
|
by: RLN |
last post by:
RE: Access 2003 using WinXP SP2
Problem: When I start up my app I double click either one of my two
Oracle tables in the table list, it asks for an id and pass. I need
them to be linked at startup automatically.
The Oracle db contains two tables I need.
I've already created an ODBC data source that contains the userid and
pass to link to the Oracle DB. It works.
When I go into linked table manager, I can link to them just fine
|
by: Mike |
last post by:
I have transferred the data from Access to MySQL using
MySQL's tool. The transfer worked great and saved me a
lot of time (thanks MySQL). Now I'm trying to get the
Access database, or a new access database, to talk across
ODBC and see the data.
I created the DSN through the control panel and it works
without error.
How do I setup Access so it can see the data. The data
|
by: mkarim |
last post by:
I am running this query:
UPDATE REPORT_CLIENT RC SET
ca_move = (SELECT UNIQUE (CASE WHEN rtrim(ltrim(ca_vormonat)) = '' OR length(rtrim(ltrim(ca_vormonat))) IS NULL OR rtrim(ltrim(ca_vormonat)) = '' OR length(rtrim(ltrim(ca_vormonat))) IS NULL OR upper(rtrim(ltrim(ca_vormonat))) = upper(rtrim(ltrim(ca_move))) THEN '' ELSE 'X' END) FROM REPORT_CLIENT RC)
It runs fine in Oracle, but gives the error "single-query returned multiple rows"...
|
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: 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 captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
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: 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: 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 the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
|
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...
|