Sounds to me that you have some permission problems. I use Crystal Reports
against MySQL and many other databases and it works fine. All you have to do
is setup a ODBC DSN (user or system DSN) with a username and password. Make
sure this user exists in MySQL so the user can get in. I would check yo
having to MySQL drivers?
> -Original Message-
> From: Venu [mailto:[EMAIL PROTECTED]]
> Sent: Friday, November 02, 2001 6:17 AM
> To: Adam Douglas
> Subject: RE: MySQL with MyODBC & Access
>
> Just download the dr
I've recently setup MyODBC and MS Access to use a ODBC profile that
is global to everyone. What I did was make a new user in MySQL and then
create a MyODBC User DSN. I made the links to MySQL in Access using this
profile. The problem I'm having is this, when you initially go into MS
Access
> On Wed, Sep 26, 2001 at 09:57:33AM -0600, Adam Douglas wrote:
> : Is there a list of features that InnoDB provides? Is InnoDB
> represented as a
> : table type? The reason I'm asking all these questions and
> require details is
> : because MIS at where I work
> as appealing for most people. One of the changes that I
> intend to make
> is to allow the code to be smart enough to determine whether the user
> has insert/update/delete permissions (verses just select) in which
> case, it will link them to the master copy instead of a slave
> for read
I've just recently heard about InnoDB. Correct me if I'm wrong here
but does InnoDB just enable MySQL to have transactions and row level
locking? Is there more to InnoDB.. I went to the web site and didn't see any
explanation of what InnoDB is other then the title on the first page.
-
Is there any advantage of using MyODBC vs. iODBC with MySQL as the backend
and M$ Access as the front end?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (
've found it quite slow. Tasks that use to take a
few seconds now takes 3 minutes or more.
> On Mon, Sep 24, 2001 at 04:19:55PM -0600, Adam Douglas wrote:
> > > Another small research in Access made me to see the changed
> > > table structure
> > > complet
> Another small research in Access made me to see the changed
> table structure
> completely. Please use this procedure to view or to refresh
> links when the
> structure or location of a linked table has changed.
>
> 1. Open the database in access that contains links to tables.
> 2. On the Too
> Another small research in Access made me to see the changed
> table structure
> completely. Please use this procedure to view or to refresh
> links when the
> structure or location of a linked table has changed.
>
> 1. Open the database in access that contains links to tables.
> 2. On the Too
> As a quick note, I tried the same with MS SQL Server through
> its latest ODBC
> driver by adding the new column, and I couldn't see any changes in the
> linked tables from Access 2002.
>
> So it shows clearly that, its some thing related to MS
> Access, not with the
> driver. It might be a b
> > Now I've found when I do changes to a table schema the
> changes are not
> > entirely at least reflected in a the same table linked in Access.
> > I had once
> > case where I changed a data type on one of the columns and
> that data type
> > was not changed on the linked table in Access. I h
> What type of schema do mean here ? Because as you know, MySQL doesn't
> explicitly supports any schema's except the catalogs( in MySQL term
> 'database'). If you can elaborate what exactly the problem
> you are facing,
> then we can provide a rapid solution.
>
> Also, as for as I know, when I
>> Now I have quite a bit of information on all these questions.. my
>> main concern is to find a Windows MySQL GUI Client that will do
everything
>> in a similar fashion as Access. I believe we would need the
>> basics but also
>> including visual query builder and reports. I've recently fou
t me would be greatly appreciated. I would
love to have this excellent database a part of the company I work for...
it's going to be a tough battle (smile).
---
Adam Douglas
Webmaster
Venmar CES Inc.
E-mail: [EMAIL PROTECTED]
Ph: (306) 242-3663 x285
Fx:
Ok I've finally gotten MySQL 3.23.37 installed and operating. Thanks to all
that helped! The problem I'm now experiencing is when I try to interface
with MySQL via PHP. MySQL seems to work fine by logging into MySQL directly
and through a MySQL GUI Client. I get the following error...
Warning: My
Yes I'm missing the query line in this posting my error (frustration is
taking over me ). The error occurs on line 5, which is the $dbconnection
line.
> -Original Message-
> From: Adam Douglas [mailto:[EMAIL PROTECTED]]
> Sent: Monday, August 13, 2001 2:00 PM
> To: M
Ok I've finally gotten MySQL 3.23.37 installed and operating. Thanks to all
that helped! The problem I'm now experiencing is when I try to interface
with MySQL via PHP. MySQL seems to work fine by logging into MySQL directly
and through a MySQL GUI Client. I get the following error...
Warning: My
Message-
> From: Gerald Clark [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, August 08, 2001 7:38 AM
> To: Adam Douglas
> Cc: [EMAIL PROTECTED]
> Subject: Re: Upgrading to 3.23.37 from 3.22.32
>
>
> Except, mysql needs write permission.
>
> Adam Douglas wrote:
>
>
D]]
> Sent: Wednesday, August 08, 2001 2:23 AM
> To: Adam Douglas; 'Gerald Clark'; [EMAIL PROTECTED]
> Subject: Re: Upgrading to 3.23.37 from 3.22.32
>
>
> Dear Gerald,
>
> does mysqld run as user "mysql"? And does user mysql have the correct
> rights f
Alright, but what if I do not have a ld.so.conf file? Do I just create one
in /etc/?
> -Original Message-
> From: Gerald Clark [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, August 08, 2001 8:26 AM
> To: Adam Douglas
> Cc: Mysql@Lists. Mysql. Com (E-mail)
> Subjec
I'm installed MySQL 3.23.37 and I can't get it started. I know there has be
number of posts regarding such a problem but I haven't seen a resolution to
fix mine specificly. I get this error when I try and load mysqld
/usr/libexec/ld.so: my_print_defaults: libpthread.so.14.20: No such file or
dire
MySQL reports read only table. As for file permissions, everything is fine.
Everyone has read and execute privileges.
>
> They are probably not owned by mysql anymore.
>
> Adam Douglas wrote:
>
> > I just upgraded MySQL from 3.22.32 to MySQL 3.23.37. All I did was
> &g
I just upgraded MySQL from 3.22.32 to MySQL 3.23.37. All I did was
pkg_delete the old MySQL and install the new one. Before I delete the old
MySQL I copied all the database files to a temporary location. Once the new
installation was successful I copied over all the database files into the
proper
Just do a SELECT query to MySQL before you do an INSERT then compare the
two. Compare whatever you don't want to be a duplicate. In most cases you'll
have a central point at which you should be able to check but it all depends
on your setup/situation. Understand? I could go into a more in depth de
The only place I've seen a tool like this is in urSQL (a MySQL GUI Client
for Windows 95/98/NT 4.0). I'm just using the unregistered version and this
feature seems to work fine. You can grab the program from the following
location, http://www.urbanresearch.com/software/utils/urbsql/index.html.
>
QL successfully?
> Hi !
>
> Can you send me the ODBC trace ?
>
> Thanks in advance
> venu
>
> > -Original Message-
> > From: Adam Douglas [mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, August 02, 2001 10:52 AM
> > To: '[EMAIL PROTECTED
> Adam Douglas schrieb am Donnerstag, 2. August 2001, 19:14:15:
>
> > I have a group of 3 queries that's used to find our
> representative for
> > Unitary, Applied and Wholesale based on a Zip Code. This
> all is executed
> > through PHP to MySQL. The thr
Well you have a couple options, you could export the Excel file to a
delimited text file and then import into MySQL. You could also just use the
Excel file and import directly into MySQL with the use of MyODBC and MS
Access. That's all I can think of right now. Either way would work fine I
believe
I have a group of 3 queries that's used to find our representative for
Unitary, Applied and Wholesale based on a Zip Code. This all is executed
through PHP to MySQL. The three queries work fine and get the results I
want. The problem is the 3 queries seem to work one minute but not the next.
You c
> Adam Douglas writes:
> > Correct 6 tables are being joined. Here's the explain of
> the query below
> > (btw, I'm not getting a index on CompanyShipInfo and
> PostalCodeInfo not
> > CompanyRep like I previous said). Excuse me if this seems
> dumb but
> -Original Message-
> From: Sinisa Milivojevic [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, July 31, 2001 1:27 PM
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Subject: Re: Query Not Using Indexing
>
>
> Adam Douglas writes:
> > I'm running M
I'm running MySQL v3.22.32. Here's my problem I run the following
select query and both CompanyRep and PostalCodeInfo tables are not
using my Indexing. Why? How can I get these two tables to use indexing
to speed up my query. You can look at my indexing on the two tables
below the query.
Any help
for adouglas to access it from
the machine I'm on. I'm also using port 3306. Do you have any ideas on how
to solve this problem?
---
Adam Douglas
Webmaster
Venmar CES Inc.
E-mail: [EMAIL PROTECTED]
Ph: (306) 242-3663 x285
Fx: (306) 242-3484
-
34 matches
Mail list logo
