Hi all,
Although I've got quite a lot of experience with php and (M/My)SQL, I
only used both within an online php script. These last few months I
bought an option with my webhost to access the remote database via ODBC
via my homePC. I use MS Access (linked tables) on my PC, just because
it's very easy to make new reports / forms / querys / ... And, in
principle, it should work, shouldn't it? And it does... most of the
time, however there very, very often errors. Most of the time I can
solve these just by closing and re-openinging Access, but there have to
be better solutions for this.
Following error messages are extremely frequent:
- Most of the time, Access is complaining 'ODBC Connection Fault
(Connection Lost)'. Ok, so maybe, there's a little network problem
(stop complaining and try again ;) ). The annoying thing is that Access
also asks to re-enter the password, although I did mark (when the
initial connection was made) to remember the password. Funny thing, if
I just enter the password myself in the little popup window, everything
works perfectly, but why can't Access do that for itself?
- In some cases this method doesn't work and I just have to close and
re-open Access to get it working again. But why? What does opening and
closing Access change ? Is it resetting the connection? But why can't
Access do that without having to close itself?
- Also very often and very annyoing : I justed added a record in
Access and just after that I try to change the newly added record. But
Access refuses because 'data has been change by another user'. What
other user? I'm the only one using this DB. If I wait 5 minutes, I can
change whatever i want.
I guess these problems are pretty common for everyone working with ODBC
/ MySQL (I guess). But, there has to be stable, better solutions?
Should I not use Access (if not: what should I use), or can you connect
to a MySQL database in another (better) way.
I'm really hoping for answers, it's driving me nuts! :)
Thanks!
1  2200  PEB 1,418
Recognized Expert Top Contributor
Hi man,
I've the same pb with MySQL! I've nto worked enought but some of these things can be set using the ODBC connection settings and other properties in Access about ODBC connections
See
in Access VB
ODBCConnectStr
ODBCTimeout
ConnectionTimeo ut Property
For the moment it's all! I'll work also on this field!
Nice chance!
:)
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: Mr Dygi |
last post by:
Hi,
PHP 4.3.4 installed manually from package *.zip and Apache 2. I have a
problem with this simple code:
<?php
$link = mysql_connect("127.0.0.1","","")
or die("Could not connect: " . mysql_error());
echo "Connected successfully";
mysql_close($link);
|
by: Mike MacSween |
last post by:
My client has an MS Access database application on her local machine. I have
full access to that in terms of changing the design.
I've got a simple PHP/MySql application on shared hosting, so no direct
access to the db server.
I'd like to give her the facility to export the information in her local
Access application to the shared PHP/MySql site. From one command button (or
similar) in the Access application.
|
by: Sarah Tanembaum |
last post by:
Beside its an opensource and supported by community, what's the fundamental
differences between PostgreSQL and those high-price commercial database (and
some are bloated such as Oracle) from software giant such as Microsoft SQL
Server, Oracle, and Sybase?
Is PostgreSQL reliable enough to be used for high-end commercial
application? Thanks
|
by: MLH |
last post by:
Using MS Access, I have attached to MySQL servers in other states
and other countries on the other side of my router. But when I use the
MySQL ODBC driver 3.51 to connect to a MySQL server on my own LAN,
the driver tells me it cannot make the connection. Here are the ODBC
driver connection parms:
Data Source Name: (free field - name my "my linux box" will do nicely)
Host/Server Name (or IP) - something like MSQLUserName@ServerName.net...
|
by: Ben |
last post by:
Hi,
I started with php and mysql and i discovered three methods for connecting
to a database:
$conn="DRIVER={MySQL ODBC 3.51 DRIVER};SERVER=10.0.0.181;DATABASE=reserv";
$connect=odbc_connect($conn,'root','pw');
include('/inetpub/wwwroot/resphpaccess/adodb/adodb.inc.php');
| | |
by: Alex Hardin |
last post by:
Hey,
I'm trying to use the connect to database wizard to connect to a MySQL
database on my web server, 66.235.193.45 (I'm actually not sure if that
points specifically to my part of the server, if not, the domain that
goes right to is is www.freddyswebgraphics.com, which I have tried as
well), and everytime I try to test the connection I get this error
message.
Test connection failed because of an error in initializing provider....
|
by: zMisc |
last post by:
I am using VB.NET 1.1 and cannot connect to a MySQL (v5) database.
I've done the following:
1) Create a DSN for MyODBC.
2) Connect using: Driver=MySQL ODBC 3.51 Driver; Server=localhost; Data
Source=test; UID=test; PWD=pwd; OPTION=3
When I run my app, I get this error: An OLE DB Provider was not specified in
|
by: news.telia.net |
last post by:
Hi!
I have a question. I have installed php and mysql on an apache-server on
windows and I can't connect to the server.
I tried to create a database (since I am trying to learn howto). My manual
said I should write this at the shell:
c:\mysql\bin>mysqladmin -u root creare mindb
I did this and got this error:
|
by: 111mike |
last post by:
Hello,
Here's my problem. I cannot connect to mysql database using odbc string
connections or dns. I keep getting a "cannot connect to mysql server localhost." I'm running windows XP Pro and have installed IIS as my server. I have installed Mysql 5.0 and mysql ODBC driver 3.51.12 in their default locations. Database is up and running okay, as I've been able to create databases and tables and access
them via the command prompt and...
|
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: 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: 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: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
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...
| |
