Trouble Installing MyODBC Connector

------_=_NextPart_001_01C7B50F.761AB9DF
Content-Type: text/plain;
charset="windows-1250"
Content-Transfer-Encoding: quoted-printable

Hello List -

I'm attempting to install the ODBC Connector (I've tried 3.51.12, =
3.51.16, 5.0.11) on a Windows XP Pro machine. The installation seems to =
be successful, but when I try to add the data source (via ODBC Data =
Source Administrator) the new driver is not listed.

When I installed the two different v3 distributions, no path was =
displayed in the installer and no option to identify the path. The =
installer told me the installation succeeded, but I can't find the =
driver in the data source admin.

When I installed v.5, the path was verified in the installer (c:\Program =
Files\MySQL\MySQL Connector ODBC 5.0) and after the installation I found =
the files there. But still no driver in the data source admin.

Any ideas would be greatly appreciated.

Katherine Simpson
katherine@pinionbizsvcs.com

No virus found in this outgoing message.
Checked by AVG Free Edition.=20
Version: 7.5.472 / Virus Database: 269.9.4/860 - Release Date: 6/21/2007 =
5:53 PM
=20

------_=_NextPart_001_01C7B50F.761AB9DF--

RE: Trouble Installing MyODBC Connector

I presume you have actually clicked the Add button? The reason I ask
this is because I got caught by something like this when I installed
MyODBC. When you open the ODBC dialog in Control Panel you see a list of
existing connections. MySQL will not appear there initially. I took that
as meaning MyODBC was not correctly installed.

When you click on the Add button you should see something like "MySQL
Connector/ODBC v5" or "MySQL ODBC 3.51 Driver" in the list of drivers.
If that is not there I don't know what your problem is.

John Bonnett

-----Original Message-----
From: Simpson, Katherine [mailto:katherine@pinionbizsvcs.com]=20
Sent: Saturday, 23 June 2007 6:24 AM
To: myodbc@lists.mysql.com
Subject: Trouble Installing MyODBC Connector

Hello List -

I'm attempting to install the ODBC Connector (I've tried 3.51.12,
3.51.16, 5.0.11) on a Windows XP Pro machine. The installation seems to
be successful, but when I try to add the data source (via ODBC Data
Source Administrator) the new driver is not listed.

When I installed the two different v3 distributions, no path was
displayed in the installer and no option to identify the path. The
installer told me the installation succeeded, but I can't find the
driver in the data source admin.

When I installed v.5, the path was verified in the installer (c:\Program
Files\MySQL\MySQL Connector ODBC 5.0) and after the installation I found
the files there. But still no driver in the data source admin.

Any ideas would be greatly appreciated.

Katherine Simpson
katherine@pinionbizsvcs.com

No virus found in this outgoing message.
Checked by AVG Free Edition.=20
Version: 7.5.472 / Virus Database: 269.9.4/860 - Release Date: 6/21/2007
5:53 PM
=20

--
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: Trouble Installing MyODBC Connector

John - Thanks for your reply. Yes, I did click the Add button.

On the User DSN tab, I have three existing data sources: dBASE files, =
Excel Files, and MS Access Database. I click on the Add button and get =
the Create New Data Source dialog, with a list of about 20 drivers. The =
MyODBC driver is not listed in that list, even though I thought I =
successfully installed it.

When I installed the v5.0 driver, the following directory was created, =
which contains a half dozen files:

C:\Program Fiels\MySQL\MySQL Connector ODBC 5.0\

When I installed the v.3.51 connector, even though the installation says =
it was successful, a new directory for the driver files is not created =
(that I can find.) But either way, no MySQL drivers are showing up in =
the Create New Data Source dialog.

Thanks for your reply - if you have any other ideas, please feel free to =
throw them out there.

-Katherine

> -----Original Message-----
> From: Bonnett, John [mailto:John.Bonnett@vision.zeiss.com]=20
> Sent: Monday, June 25, 2007 3:57 PM
> To: Simpson, Katherine; myodbc@lists.mysql.com
> Subject: RE: Trouble Installing MyODBC Connector
>=20
> I presume you have actually clicked the Add button? The=20
> reason I ask this is because I got caught by something like=20
> this when I installed MyODBC. When you open the ODBC dialog=20
> in Control Panel you see a list of existing connections.=20
> MySQL will not appear there initially. I took that as meaning=20
> MyODBC was not correctly installed.
>=20
> When you click on the Add button you should see something=20
> like "MySQL Connector/ODBC v5" or "MySQL ODBC 3.51 Driver" in=20
> the list of drivers.
> If that is not there I don't know what your problem is.
>=20
> John Bonnett
>=20
> -----Original Message-----
> From: Simpson, Katherine [mailto:katherine@pinionbizsvcs.com]
> Sent: Saturday, 23 June 2007 6:24 AM
> To: myodbc@lists.mysql.com
> Subject: Trouble Installing MyODBC Connector
>=20
> Hello List -
>=20
> I'm attempting to install the ODBC Connector (I've tried=20
> 3.51.12, 3.51.16, 5.0.11) on a Windows XP Pro machine. The=20
> installation seems to be successful, but when I try to add=20
> the data source (via ODBC Data Source Administrator) the new=20
> driver is not listed.
>=20
> When I installed the two different v3 distributions, no path=20
> was displayed in the installer and no option to identify the=20
> path. The installer told me the installation succeeded, but=20
> I can't find the driver in the data source admin.
>=20
> When I installed v.5, the path was verified in the installer=20
> (c:\Program Files\MySQL\MySQL Connector ODBC 5.0) and after=20
> the installation I found the files there. But still no=20
> driver in the data source admin.
>=20
> Any ideas would be greatly appreciated.
>=20
> Katherine Simpson
> katherine@pinionbizsvcs.com
>=20
> No virus found in this outgoing message.
> Checked by AVG Free Edition.=20
> Version: 7.5.472 / Virus Database: 269.9.4/860 - Release=20
> Date: 6/21/2007
> 5:53 PM
> =20
>=20
> No virus found in this incoming message.
> Checked by AVG Free Edition.=20
> Version: 7.5.472 / Virus Database: 269.9.6/865 - Release=20
> Date: 6/24/2007 8:33 AM
> =20
>=20

No virus found in this outgoing message.
Checked by AVG Free Edition.=20
Version: 7.5.472 / Virus Database: 269.9.6/865 - Release Date: 6/24/2007 =
8:33 AM
=20

--
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: Trouble Installing MyODBC Connector

Dear Katherine,

Have you tried registering the driver from the command line? I can confirm
that I don't have any special directories created when I install 3.51.x -
I'm on Vista x64 now, so all the files get put in SysWow64 (32-bit
compatibility directory) but on XP they get put in system32. You should have
myodbc3i.exe and myodbc3m.exe among others.

Myodbc3i.exe can be used to register the driver, which might allow you to
pin down where the problem is more accurately.

The command to register the driver can be seen if you type

myodbc3i /?

from the command prompt within the system32 / syswow64 directory. The
example for "register a driver" that they give uses .so files (I think
that's Linux?) but use can use the windows equivalent - I can't remember if
they're the lib files or the dll files. So, something like:

myodbc3i -a -d -t"MySQL ODBC Driver
3.51;DRIVER=c:\windows\system32\myodbc3.dll;SETUP=c:\windows \system32\myodbc
3S.dll"

or

myodbc3i -a -d -t"MySQL ODBC Driver
3.51;DRIVER=c:\windows\system32\myodbc3.lib;SETUP=c:\windows \system32\myodbc
3S.lib"

That should give you a "driver count" - if it's greater than 1, then you
already had the driver registered. If it fails, post the message here and we
might be able to help out. If it succeeds, try using the example (again,
"myodbc3i /?") of creating a DSN from the command line and see what message
you get there:

myodbc3i -a -su -t"DSN=MyDSN;DRIVER=MySQL ODBC 3.51
Driver;SERVER=myServerHostname;UID=myUser"

or (for a system data source rather than a user data source)

myodbc3i -a -ss -t"DSN=MyDSN;DRIVER=MySQL ODBC 3.51
Driver;SERVER=myServerHostname;UID=myUser"

Again, if that gives error messages then maybe post them here..?

Hope that helps,

Al McNicoll
Integritec Limited


-----Original Message-----
From: Simpson, Katherine [mailto:katherine@pinionbizsvcs.com]
Sent: 26 June 2007 00:08
To: Bonnett, John; myodbc@lists.mysql.com
Subject: RE: Trouble Installing MyODBC Connector

Thanks for your reply - if you have any other ideas, please feel free to
throw them out there.

-Katherine

> -----Original Message-----
> From: Bonnett, John [mailto:John.Bonnett@vision.zeiss.com]
> Sent: Monday, June 25, 2007 3:57 PM
> To: Simpson, Katherine; myodbc@lists.mysql.com
> Subject: RE: Trouble Installing MyODBC Connector
>
> I presume you have actually clicked the Add button? The
> reason I ask this is because I got caught by something like
> this when I installed MyODBC. When you open the ODBC dialog
> in Control Panel you see a list of existing connections.
> MySQL will not appear there initially. I took that as meaning
> MyODBC was not correctly installed.
>
> When you click on the Add button you should see something
> like "MySQL Connector/ODBC v5" or "MySQL ODBC 3.51 Driver" in
> the list of drivers.
> If that is not there I don't know what your problem is.
>
> John Bonnett
>
> -----Original Message-----
> From: Simpson, Katherine [mailto:katherine@pinionbizsvcs.com]
> Sent: Saturday, 23 June 2007 6:24 AM
> To: myodbc@lists.mysql.com
> Subject: Trouble Installing MyODBC Connector
>
> Hello List -
>
> I'm attempting to install the ODBC Connector (I've tried
> 3.51.12, 3.51.16, 5.0.11) on a Windows XP Pro machine. The
> installation seems to be successful, but when I try to add
> the data source (via ODBC Data Source Administrator) the new
> driver is not listed.
>
> When I installed the two different v3 distributions, no path
> was displayed in the installer and no option to identify the
> path. The installer told me the installation succeeded, but
> I can't find the driver in the data source admin.
>
> When I installed v.5, the path was verified in the installer
> (c:\Program Files\MySQL\MySQL Connector ODBC 5.0) and after
> the installation I found the files there. But still no
> driver in the data source admin.
>
> Any ideas would be greatly appreciated.
>
> Katherine Simpson
> katherine@pinionbizsvcs.com
>
> No virus found in this outgoing message.
> Checked by AVG Free Edition.
> Version: 7.5.472 / Virus Database: 269.9.4/860 - Release
> Date: 6/21/2007
> 5:53 PM
>
>
> No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.5.472 / Virus Database: 269.9.6/865 - Release
> Date: 6/24/2007 8:33 AM
>
>

No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.472 / Virus Database: 269.9.6/865 - Release Date: 6/24/2007
8:33 AM




--
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