[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql-win32
Subject:    Re: Reserved Error (-7778) in MS Access 2000 when trying to link or
From:       Christian Herbst <herbst () ccrma ! stanford ! edu>
Date:       2002-02-22 22:48:56
[Download RAW message or body]

Hi Jon-David,

I'm getting the same error as you. Do you have a solution for problem as
of yet?

(I guess that the setup utility crates a User DSN called myodbc3-test. I
checked this guy in the ODBC administration tool, choosing the option
Configure/"Test Data Source" - this worked fine. However, there's now
actually connecting to it from within Access upon linking/importing some
tables).

Best,
Christian


jds wrote:
> 
> -----Original Message-----
> From: jd [mailto:jd@fhsws.com]
> Sent: Tuesday, February 19, 2002 9:40 PM
> To: win32@lists.mysql.com
> Subject: Reserved Error (-7778) in MS Access 2000 when trying to link or
> import tables
> 
> I get this error -7778 when trying to link or import tables Access 2000.
> These are my first hours using MySql, but I believe I have it all set up
> correctly. I have exported the data to a MySql db from Access, I have
> verified the data is in there using MySQLGUI. I have set up a system DSN to
> the db and the Test Connection indicates I can connect.
> 
> >>>>i believe you have to set up myODBC as a User Data Source, then select
> it as a Machine Data Source when you link the tables in Access.
> 
> In the DSN
> configuration I have set the Host/Server Name, database name. I've set the
> use to "root" with no password as I haven't set up any security yet.
> 
> >>>>you might try connecting to localhost first, just a thought.
> 
> I've
> also set the "Return Matching Rows" option, "Don't Prompt On Connect"
> option, and "Change BIGINT columns to INT" option.
> 
> The error occurs immediately after I select OK after selecting the DSN in
> the Select Data Source dialog.
> <clip>
> 
> hth,
> 
> jon-david
> 

-- 

////////////////////////////////////////////////////////////////////////

Christian Herbst
http://www-ccrma.stanford.edu/~herbst/

////////////////////////////////////////////////////////////////////////

---------------------------------------------------------------------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
posting. To request this thread, e-mail win32-thread8421@lists.mysql.com

To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it,
e-mail win32-unsubscribe@lists.mysql.com instead.

[prev in list] [next in list] [prev in thread] [next in thread]