Problems using Access to establish initial ODBC connection

Hello,

This is a duplicate message of a post I sent to the online forum, but
I figured that since I needed to subscribe to ask about obtaining the
Tiger-compatible source, I'd run this by you too....

I'm hoping this problem will be really easy for somebody, I'm
experienced with MySQL and PHP, but I'm a noob with ODBC and the
connector deal.

Need to connect to my MySQL server via Access via ODBC.

1) installed the Connector on the Windows machine
2) Setup the DSN through the control panel to my server, entered my
user/pass and server name, clicked test connection and it worked fine
3) Launched Access 2003, created new database
4) File menu -> Get External Data -> Link Tables
5) Set the file type to "ODBC databases"
6) Create a new DSN, select the MySQL ODBC driver, tried entering my
server name, user name, password and database within the Advanced
section (is this case-sensitive? Does it require the curly brackets
i.e. user={username}?! Unclear about this), also tried leaving this
blank, saved my DSN file, says a connection cannot be made, would I
like to save a non-verifiable DSN? I click yes
7) When I click OK I get the error message "cannot find driver {MySQL
ODBC 3.51 Driver} in System Information

Am I doing something wrong? Why is it that my connection works within
the control panel, but not within Access?

Can somebody please enlighten me?

Thanks, in advance for your time!




-----------
Joe Auty
NetMusician: helping musicians exploit new communication mediums
http://www.netmusician.org
joe@netmusician.org


--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org

Re: Problems using Access to establish initial ODBC connection

I tried creating both a User and System DSN in the control panel.
Both test out fine and are created with no error messages. Neither
appear as options with Access.

The steps for creating a System DSN:

1) Data Sources Panel -> System DSN -> Add
2) Select MySQL Driver, Click Finish
3) Fill out the login stuff, click "Test" it works fine, Click OK

Am I missing something?

On Jun 17, 2005, at 3:44 AM, Martin King-Turner wrote:

> Joe,
>
> Why are you trying to create a new DSN in step 6? Can you not just
> select
> the DSN you already created in step 2? Simply selecting an
> existing DSN is
> the way I normally achieve this and it works just fine!
>
> Regards,
> Martin
>
> -----Original Message-----
> From: Joe Auty [mailto:joe@netmusician.org]
> Sent: 17 June 2005 09:26
> To: myodbc@lists.mysql.com
> Subject: Problems using Access to establish initial ODBC connection
>
>
> Hello,
>
> This is a duplicate message of a post I sent to the online forum, but
> I figured that since I needed to subscribe to ask about obtaining the
> Tiger-compatible source, I'd run this by you too....
>
> I'm hoping this problem will be really easy for somebody, I'm
> experienced with MySQL and PHP, but I'm a noob with ODBC and the
> connector deal.
>
> Need to connect to my MySQL server via Access via ODBC.
>
> 1) installed the Connector on the Windows machine
> 2) Setup the DSN through the control panel to my server, entered my
> user/pass and server name, clicked test connection and it worked fine
> 3) Launched Access 2003, created new database
> 4) File menu -> Get External Data -> Link Tables
> 5) Set the file type to "ODBC databases"
> 6) Create a new DSN, select the MySQL ODBC driver, tried entering my
> server name, user name, password and database within the Advanced
> section (is this case-sensitive? Does it require the curly brackets
> i.e. user={username}?! Unclear about this), also tried leaving this
> blank, saved my DSN file, says a connection cannot be made, would I
> like to save a non-verifiable DSN? I click yes
> 7) When I click OK I get the error message "cannot find driver {MySQL
> ODBC 3.51 Driver} in System Information
>
> Am I doing something wrong? Why is it that my connection works within
> the control panel, but not within Access?
>
> Can somebody please enlighten me?
>
> Thanks, in advance for your time!
>
>
>
>
> -----------
> Joe Auty
> NetMusician: helping musicians exploit new communication mediums
> http://www.netmusician.org joe@netmusician.org
>
>
> --
> MySQL ODBC Mailing List
> For list archives: http://lists.mysql.com/myodbc
> To unsubscribe: http://lists.mysql.com/myodbc?
> unsub=martin.kt@nb2bc.co.uk
>
>
>


--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org

Re: Problems using Access to establish initial ODBC connection

Okay, but the reason (or one of the reasons) I created a new DSN was
because the System/User DSN was not showing up in Access.

Can somebody rundown the steps needed to connect to a MySQL database
for the first time in Access 2003?


On Jun 17, 2005, at 11:22 AM, Barry Stear wrote:

> You don't need to create a new DSN . Just use the existing DSN that
> you created in Step 1 and it should connect fine.. after all that is
> the connection you tested.. Not DSN in #6. If you use the DSN entry
> that tested correctly you should have NO problems.
>
> Barry
>
> On 6/17/05, Joe Auty wrote:
>
>> I tried creating both a User and System DSN in the control panel.
>> Both test out fine and are created with no error messages. Neither
>> appear as options with Access.
>>
>> The steps for creating a System DSN:
>>
>> 1) Data Sources Panel -> System DSN -> Add
>> 2) Select MySQL Driver, Click Finish
>> 3) Fill out the login stuff, click "Test" it works fine, Click OK
>>
>> Am I missing something?
>>
>> On Jun 17, 2005, at 3:44 AM, Martin King-Turner wrote:
>>
>>
>>> Joe,
>>>
>>> Why are you trying to create a new DSN in step 6? Can you not just
>>> select
>>> the DSN you already created in step 2? Simply selecting an
>>> existing DSN is
>>> the way I normally achieve this and it works just fine!
>>>
>>> Regards,
>>> Martin
>>>
>>> -----Original Message-----
>>> From: Joe Auty [mailto:joe@netmusician.org]
>>> Sent: 17 June 2005 09:26
>>> To: myodbc@lists.mysql.com
>>> Subject: Problems using Access to establish initial ODBC connection
>>>
>>>
>>> Hello,
>>>
>>> This is a duplicate message of a post I sent to the online forum,
>>> but
>>> I figured that since I needed to subscribe to ask about obtaining
>>> the
>>> Tiger-compatible source, I'd run this by you too....
>>>
>>> I'm hoping this problem will be really easy for somebody, I'm
>>> experienced with MySQL and PHP, but I'm a noob with ODBC and the
>>> connector deal.
>>>
>>> Need to connect to my MySQL server via Access via ODBC.
>>>
>>> 1) installed the Connector on the Windows machine
>>> 2) Setup the DSN through the control panel to my server, entered my
>>> user/pass and server name, clicked test connection and it worked
>>> fine
>>> 3) Launched Access 2003, created new database
>>> 4) File menu -> Get External Data -> Link Tables
>>> 5) Set the file type to "ODBC databases"
>>> 6) Create a new DSN, select the MySQL ODBC driver, tried entering my
>>> server name, user name, password and database within the Advanced
>>> section (is this case-sensitive? Does it require the curly brackets
>>> i.e. user={username}?! Unclear about this), also tried leaving this
>>> blank, saved my DSN file, says a connection cannot be made, would I
>>> like to save a non-verifiable DSN? I click yes
>>> 7) When I click OK I get the error message "cannot find driver
>>> {MySQL
>>> ODBC 3.51 Driver} in System Information
>>>
>>> Am I doing something wrong? Why is it that my connection works
>>> within
>>> the control panel, but not within Access?
>>>
>>> Can somebody please enlighten me?
>>>
>>> Thanks, in advance for your time!
>>>
>>>
>>>
>>>
>>> -----------
>>> Joe Auty
>>> NetMusician: helping musicians exploit new communication mediums
>>> http://www.netmusician.org joe@netmusician.org
>>>
>>>
>>> --
>>> MySQL ODBC Mailing List
>>> For list archives: http://lists.mysql.com/myodbc
>>> To unsubscribe: http://lists.mysql.com/myodbc?
>>> unsub=martin.kt@nb2bc.co.uk
>>>
>>>
>>>
>>>
>>
>>
>> --
>> MySQL ODBC Mailing List
>> For list archives: http://lists.mysql.com/myodbc
>> To unsubscribe: http://lists.mysql.com/myodbc?
>> unsub=bstear@gmail.com
>>
>>
>


--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org

RE: Problems using Access to establish initial ODBC connection

Joe,

This sounds very strange. When you get to the "Select Data Source" =
dialogue
in Access, do you see any DSN's in either the "File Data Source" or =
"Machine
Data Source" tabs? System/User DSN's from the Control Panel should be
listed in the "Machine Data Source" tab - you will need to click on this =
tab
to see them because Access shows "File Data Source" by default.

Martin
-----Original Message-----
From: Joe Auty [mailto:joe@netmusician.org]=20
Sent: 17 June 2005 17:30
To: Barry Stear; myodbc@lists.mysql.com
Subject: Re: Problems using Access to establish initial ODBC connection


Okay, but the reason (or one of the reasons) I created a new DSN was =20
because the System/User DSN was not showing up in Access.

Can somebody rundown the steps needed to connect to a MySQL database =20
for the first time in Access 2003?


On Jun 17, 2005, at 11:22 AM, Barry Stear wrote:

> You don't need to create a new DSN . Just use the existing DSN that=20
> you created in Step 1 and it should connect fine.. after all that is=20
> the connection you tested.. Not DSN in #6. If you use the DSN entry=20
> that tested correctly you should have NO problems.
>
> Barry
>
> On 6/17/05, Joe Auty wrote:
>
>> I tried creating both a User and System DSN in the control panel.=20
>> Both test out fine and are created with no error messages. Neither=20
>> appear as options with Access.
>>
>> The steps for creating a System DSN:
>>
>> 1) Data Sources Panel -> System DSN -> Add
>> 2) Select MySQL Driver, Click Finish
>> 3) Fill out the login stuff, click "Test" it works fine, Click OK
>>
>> Am I missing something?
>>
>> On Jun 17, 2005, at 3:44 AM, Martin King-Turner wrote:
>>
>>
>>> Joe,
>>>
>>> Why are you trying to create a new DSN in step 6? Can you not just=20
>>> select the DSN you already created in step 2? Simply selecting an
>>> existing DSN is
>>> the way I normally achieve this and it works just fine!
>>>
>>> Regards,
>>> Martin
>>>
>>> -----Original Message-----
>>> From: Joe Auty [mailto:joe@netmusician.org]
>>> Sent: 17 June 2005 09:26
>>> To: myodbc@lists.mysql.com
>>> Subject: Problems using Access to establish initial ODBC connection
>>>
>>>
>>> Hello,
>>>
>>> This is a duplicate message of a post I sent to the online forum,
>>> but
>>> I figured that since I needed to subscribe to ask about obtaining =20
>>> the
>>> Tiger-compatible source, I'd run this by you too....
>>>
>>> I'm hoping this problem will be really easy for somebody, I'm=20
>>> experienced with MySQL and PHP, but I'm a noob with ODBC and the=20
>>> connector deal.
>>>
>>> Need to connect to my MySQL server via Access via ODBC.
>>>
>>> 1) installed the Connector on the Windows machine
>>> 2) Setup the DSN through the control panel to my server, entered my=20
>>> user/pass and server name, clicked test connection and it worked
>>> fine
>>> 3) Launched Access 2003, created new database
>>> 4) File menu -> Get External Data -> Link Tables
>>> 5) Set the file type to "ODBC databases"
>>> 6) Create a new DSN, select the MySQL ODBC driver, tried entering my
>>> server name, user name, password and database within the Advanced
>>> section (is this case-sensitive? Does it require the curly brackets
>>> i.e. user=3D{username}?! Unclear about this), also tried leaving =
this
>>> blank, saved my DSN file, says a connection cannot be made, would I
>>> like to save a non-verifiable DSN? I click yes
>>> 7) When I click OK I get the error message "cannot find driver =20
>>> {MySQL
>>> ODBC 3.51 Driver} in System Information
>>>
>>> Am I doing something wrong? Why is it that my connection works
>>> within
>>> the control panel, but not within Access?
>>>
>>> Can somebody please enlighten me?
>>>
>>> Thanks, in advance for your time!
>>>
>>>
>>>
>>>
>>> -----------
>>> Joe Auty
>>> NetMusician: helping musicians exploit new communication mediums=20
>>> http://www.netmusician.org joe@netmusician.org
>>>
>>>
>>> --
>>> MySQL ODBC Mailing List
>>> For list archives: http://lists.mysql.com/myodbc
>>> To unsubscribe: http://lists.mysql.com/myodbc?
>>> unsub=3Dmartin.kt@nb2bc.co.uk
>>>
>>>
>>>
>>>
>>
>>
>> --
>> MySQL ODBC Mailing List
>> For list archives: http://lists.mysql.com/myodbc
>> To unsubscribe: http://lists.mysql.com/myodbc?=20
>> unsub=3Dbstear@gmail.com
>>
>>
>


--=20
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: =
http://lists.mysql.com/myodbc?unsub=3Dmartin.kt@nb2bc.co.uk



--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=3Dgcdmo-myodbc@m.gmane.o rg

Re: Problems using Access to establish initial ODBC connection

Thank you!

I feel like a big dummy... I selected the machine data source tab and
didn't receive an error message, but initially I still didn't get the
dialog asking what tables I want to link to. I *believe* installing
the Microsoft Access driver (*.mdb) in the Data Source control panel
fixed this, because I got this working =)

Thanks for your help!


On Jun 17, 2005, at 1:25 PM, Martin King-Turner wrote:

> Joe,
>
> This sounds very strange. When you get to the "Select Data Source"
> dialogue
> in Access, do you see any DSN's in either the "File Data Source" or
> "Machine
> Data Source" tabs? System/User DSN's from the Control Panel should be
> listed in the "Machine Data Source" tab - you will need to click on
> this tab
> to see them because Access shows "File Data Source" by default.
>
> Martin
> -----Original Message-----
> From: Joe Auty [mailto:joe@netmusician.org]
> Sent: 17 June 2005 17:30
> To: Barry Stear; myodbc@lists.mysql.com
> Subject: Re: Problems using Access to establish initial ODBC
> connection
>
>
> Okay, but the reason (or one of the reasons) I created a new DSN was
> because the System/User DSN was not showing up in Access.
>
> Can somebody rundown the steps needed to connect to a MySQL database
> for the first time in Access 2003?
>
>
> On Jun 17, 2005, at 11:22 AM, Barry Stear wrote:
>
>
>> You don't need to create a new DSN . Just use the existing DSN that
>> you created in Step 1 and it should connect fine.. after all that is
>> the connection you tested.. Not DSN in #6. If you use the DSN entry
>> that tested correctly you should have NO problems.
>>
>> Barry
>>
>> On 6/17/05, Joe Auty wrote:
>>
>>
>>> I tried creating both a User and System DSN in the control panel.
>>> Both test out fine and are created with no error messages. Neither
>>> appear as options with Access.
>>>
>>> The steps for creating a System DSN:
>>>
>>> 1) Data Sources Panel -> System DSN -> Add
>>> 2) Select MySQL Driver, Click Finish
>>> 3) Fill out the login stuff, click "Test" it works fine, Click OK
>>>
>>> Am I missing something?
>>>
>>> On Jun 17, 2005, at 3:44 AM, Martin King-Turner wrote:
>>>
>>>
>>>
>>>> Joe,
>>>>
>>>> Why are you trying to create a new DSN in step 6? Can you not just
>>>> select the DSN you already created in step 2? Simply selecting an
>>>> existing DSN is
>>>> the way I normally achieve this and it works just fine!
>>>>
>>>> Regards,
>>>> Martin
>>>>
>>>> -----Original Message-----
>>>> From: Joe Auty [mailto:joe@netmusician.org]
>>>> Sent: 17 June 2005 09:26
>>>> To: myodbc@lists.mysql.com
>>>> Subject: Problems using Access to establish initial ODBC connection
>>>>
>>>>
>>>> Hello,
>>>>
>>>> This is a duplicate message of a post I sent to the online forum,
>>>> but
>>>> I figured that since I needed to subscribe to ask about obtaining
>>>> the
>>>> Tiger-compatible source, I'd run this by you too....
>>>>
>>>> I'm hoping this problem will be really easy for somebody, I'm
>>>> experienced with MySQL and PHP, but I'm a noob with ODBC and the
>>>> connector deal.
>>>>
>>>> Need to connect to my MySQL server via Access via ODBC.
>>>>
>>>> 1) installed the Connector on the Windows machine
>>>> 2) Setup the DSN through the control panel to my server, entered my
>>>> user/pass and server name, clicked test connection and it worked
>>>> fine
>>>> 3) Launched Access 2003, created new database
>>>> 4) File menu -> Get External Data -> Link Tables
>>>> 5) Set the file type to "ODBC databases"
>>>> 6) Create a new DSN, select the MySQL ODBC driver, tried
>>>> entering my
>>>> server name, user name, password and database within the Advanced
>>>> section (is this case-sensitive? Does it require the curly brackets
>>>> i.e. user={username}?! Unclear about this), also tried leaving this
>>>> blank, saved my DSN file, says a connection cannot be made, would I
>>>> like to save a non-verifiable DSN? I click yes
>>>> 7) When I click OK I get the error message "cannot find driver
>>>> {MySQL
>>>> ODBC 3.51 Driver} in System Information
>>>>
>>>> Am I doing something wrong? Why is it that my connection works
>>>> within
>>>> the control panel, but not within Access?
>>>>
>>>> Can somebody please enlighten me?
>>>>
>>>> Thanks, in advance for your time!
>>>>
>>>>
>>>>
>>>>
>>>> -----------
>>>> Joe Auty
>>>> NetMusician: helping musicians exploit new communication mediums
>>>> http://www.netmusician.org joe@netmusician.org
>>>>
>>>>
>>>> --
>>>> MySQL ODBC Mailing List
>>>> For list archives: http://lists.mysql.com/myodbc
>>>> To unsubscribe: http://lists.mysql.com/myodbc?
>>>> unsub=martin.kt@nb2bc.co.uk
>>>>
>>>>
>>>>
>>>>
>>>>
>>>
>>>
>>> --
>>> MySQL ODBC Mailing List
>>> For list archives: http://lists.mysql.com/myodbc
>>> To unsubscribe: http://lists.mysql.com/myodbc?
>>> unsub=bstear@gmail.com
>>>
>>>
>>>
>>
>>
>
>
> --
> MySQL ODBC Mailing List
> For list archives: http://lists.mysql.com/myodbc
> To unsubscribe: http://lists.mysql.com/myodbc?
> unsub=martin.kt@nb2bc.co.uk
>
>
>


--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org