I'm trying to use MySQL and the ODBC 2.5 driver to access
a remote database on a Linux server. I have NO problem hitting
the database from Access 97 & the ODBC 3.5 driver. I just can't
seem to do it from Access 2.0. I'm brand new at this, so go easy
on me. Thx. 5 2421
You really mean access version 2.0 ? two point zero ???
and not access 2000 [two-thousand] ???
i can use vfp 5,6,7 and 8 with both versions of the odbc driver -
but access 2.0 is SUCH an old product - I'm not even sure if it could
handle odbc stuff at all.
hth - mondo regards [Bill]
--
William Sanders / Electronic Filing Group Remove the DOT BOB to reply via
email.
FREE LONG DISTANCE -> mailto:ex********@efgroup.net
Free Satellite Receivers and installation -> http://www.vmcsatellite.com/?aid=58456
mySql / VFP / MS-SQL
"MLH" <CR**@NorthState.net> wrote in message
news:oi********************************@4ax.com... I'm trying to use MySQL and the ODBC 2.5 driver to access a remote database on a Linux server. I have NO problem hitting the database from Access 97 & the ODBC 3.5 driver. I just can't seem to do it from Access 2.0. I'm brand new at this, so go easy on me. Thx.
Yeah, unfortunately, I really do mean two-point-zero. It handles ODBC.
I just am having prblems with the syntax.
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxxxxxxx
On Mon, 13 Oct 2003 18:46:57 GMT, "swdev1" <ws**********@advmed.com>
wrote: You really mean access version 2.0 ? two point zero ??? and not access 2000 [two-thousand] ???
i can use vfp 5,6,7 and 8 with both versions of the odbc driver - but access 2.0 is SUCH an old product - I'm not even sure if it could handle odbc stuff at all.
hth - mondo regards [Bill]
Yeah, unfortunately, I really do mean two-point-zero. It handles ODBC.
I just am having prblems with the syntax.
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxxxxxxx
On Mon, 13 Oct 2003 18:46:57 GMT, "swdev1" <ws**********@advmed.com>
wrote: You really mean access version 2.0 ? two point zero ??? and not access 2000 [two-thousand] ???
i can use vfp 5,6,7 and 8 with both versions of the odbc driver - but access 2.0 is SUCH an old product - I'm not even sure if it could handle odbc stuff at all.
hth - mondo regards [Bill]
"MLH" <CR**@NorthState.net> wrote in message
news:p1********************************@4ax.com... Yeah, unfortunately, I really do mean two-point-zero. It handles ODBC. I just am having prblems with the syntax.
Wow what a relic ;-)
I'd just try to extract .csv's and start from scratch
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxxxxxxx
On Mon, 13 Oct 2003 18:46:57 GMT, "swdev1" <ws**********@advmed.com> wrote:
You really mean access version 2.0 ? two point zero ??? and not access 2000 [two-thousand] ???
i can use vfp 5,6,7 and 8 with both versions of the odbc driver - but access 2.0 is SUCH an old product - I'm not even sure if it could handle odbc stuff at all.
hth - mondo regards [Bill]
"MLH" <CR**@NorthState.net> wrote in message
news:p1********************************@4ax.com... Yeah, unfortunately, I really do mean two-point-zero. It handles ODBC. I just am having prblems with the syntax.
Wow what a relic ;-)
I'd just try to extract .csv's and start from scratch
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx xxxxxxxxxxxxxxxxxxxxxx
On Mon, 13 Oct 2003 18:46:57 GMT, "swdev1" <ws**********@advmed.com> wrote:
You really mean access version 2.0 ? two point zero ??? and not access 2000 [two-thousand] ???
i can use vfp 5,6,7 and 8 with both versions of the odbc driver - but access 2.0 is SUCH an old product - I'm not even sure if it could handle odbc stuff at all.
hth - mondo regards [Bill]
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Lenz Grimmer |
last post by:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hi,
MySQL 4.0.14, a new version of the popular Open Source/Free Software
Database, has been released. It is now available in source and binary...
|
by: Adam Smith |
last post by:
I have a dedicated server running 'FreeBSD 4.9 STABLE' at a hosting
site. They have done some default installations, presumably from the CVS
ports package ??. Herein lies the problem, "I do not...
|
by: DJJ |
last post by:
I am using the MySQL ODBC 3.51 driver to link three relatively small MySQL
tables to a Microsoft Access 2003 database. I am finding that the data from
the MySQL tables takes a hell of a long time...
|
by: Sai Hertz And Control Systems |
last post by:
Dear all,
Their was a huge rore about MySQL recently for something in java functions
now theirs one more
http://www.mysql.com/doc/en/News-5.0.x.html
Does this concern anyone.
What I...
|
by: Good Man |
last post by:
Hi there
I've noticed some very weird things happening with my current MySQL setup
on my XP Laptop, a development machine.
For a while, I have been trying to get the MySQL cache to work....
|
by: Cheryl Langdon |
last post by:
Hello everyone,
This is my first attempt at getting help in this manner. Please
forgive me if this is an inappropriate request.
I suddenly find myself in urgent need of instruction on how to...
|
by: mistral |
last post by:
phpMyAdmin 2.6.2 problem: can no connects to mySQL database: each time
shown error #1045 - Access denied for user 'username'@'192.168.1.2'
(using password: YES)
Is seems, this is most common...
|
by: Atli |
last post by:
This is an easy to digest 12 step guide on basics of using MySQL. It's a great refresher for those who need it and it work's great for first time MySQL users.
Anyone should be able to get...
|
by: JamieHowarth0 |
last post by:
I have been trying to find a solution to this on the Internet for months. Literally, ages and ages and ages, praying that someone in the open-source community has enough knowledge to put together an...
|
by: sganeshsvk |
last post by:
sir,
Suppose we want to share the two Linux system in mysql database then we using GRANT ALL PRIVILEGES query for access permission between two System Databases.
Likely i want to share the...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
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,...
| |