Manually Register MyODBC?

I've just tried both the MSI and the Setup.exe installers - neither
work. I've downloaded the version without an installer, and run the
batch file, which copied files around, but didn't register anything.

Can someone please tell me what entries in the registry I need for
MyODBC to function ( and anything else I have to do )?

Thanks.

--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: dkasak@nusconsulting.com.au
website: http://www.nusconsulting.com.au


--
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: Manually Register MyODBC?

On Thu, May 24, 2007 at 10:25:31AM +1000, Daniel Kasak wrote:
> I've just tried both the MSI and the Setup.exe installers - neither
> work. I've downloaded the version without an installer, and run the
> batch file, which copied files around, but didn't register anything.
>
> Can someone please tell me what entries in the registry I need for
> MyODBC to function ( and anything else I have to do )?

There should be a utility called myodbc3i.exe that can register the
driver. Otherwise the registry detail is like so:

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\MySQL ODBC 3.51 Driver]
"UsageCount"=dword:00000001
"Driver"="C:\\WINDOWS\\system32\\myodbc3.dll"
"Setup"="C:\\WINDOWS\\system32\\myodbc3S.dll"
"CPTimeout"=""

Jess

--
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: Manually Register MyODBC?

On Thu, 2007-05-24 at 00:49 -0500, Jess Balint wrote:

> On Thu, May 24, 2007 at 10:25:31AM +1000, Daniel Kasak wrote:
> > I've just tried both the MSI and the Setup.exe installers - neither
> > work. I've downloaded the version without an installer, and run the
> > batch file, which copied files around, but didn't register anything.
> >
> > Can someone please tell me what entries in the registry I need for
> > MyODBC to function ( and anything else I have to do )?
>
> There should be a utility called myodbc3i.exe that can register the
> driver.

Yeah I've tried that one too. Didn't do anything.

> Otherwise the registry detail is like so:
>
> [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\MySQL ODBC 3.51 Driver]
> "UsageCount"=dword:00000001

What's this? Is it a string?
I'm not a registry hacker ...

> "Driver"="C:\\WINDOWS\\system32\\myodbc3.dll"
> "Setup"="C:\\WINDOWS\\system32\\myodbc3S.dll"
> "CPTimeout"=""

This bit I follow ...

But it still doesn't work. I get an error:

The setup routines for the MySQL ODBC 3.51 Driver ODBC driver could not
be loaded due to system error code 126.

... and then another error:

Could not load the setup or translator library.

I tested this a couple of years ago, and had it working ... 3.51.06 or
so ... but I can't use this version because it can't authenticate
against newer MySQL servers.

--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: dkasak@nusconsulting.com.au
website: http://www.nusconsulting.com.au


--
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: Manually Register MyODBC?

On Thu, May 24, 2007 at 04:26:43PM +1000, Daniel Kasak wrote:
> > There should be a utility called myodbc3i.exe that can register the
> > driver.
>
> Yeah I've tried that one too. Didn't do anything.

Any error message?

> > Otherwise the registry detail is like so:
> >
> > [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\MySQL ODBC 3.51 Driver]
> > "UsageCount"=dword:00000001
>
> What's this? Is it a string?
> I'm not a registry hacker ...

The part inside the brackets is the path in the registry. You can
probably just copy that snippet from my original mail into a .reg file
and import it into the registry.

> > "Driver"="C:\\WINDOWS\\system32\\myodbc3.dll"
> > "Setup"="C:\\WINDOWS\\system32\\myodbc3S.dll"
> > "CPTimeout"=""
>
> This bit I follow ...
>
> But it still doesn't work. I get an error:
>
> The setup routines for the MySQL ODBC 3.51 Driver ODBC driver could not
> be loaded due to system error code 126.
>
> ... and then another error:
>
> Could not load the setup or translator library.

I've seen this error before, but I think it was due to the setup library
either missing or referencing the wrong path. You might not need the
setup lib if you also create the DSNs with myodbc3i.exe or enter them
directly into the registry.

> I tested this a couple of years ago, and had it working ... 3.51.06 or
> so ... but I can't use this version because it can't authenticate
> against newer MySQL servers.

I'm not sure if any changes would prevent this. Also, you know there is
an 'old password' feature that allows older clients to connect?

Jess

--
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: Manually Register MyODBC?

On Thu, 2007-05-24 at 01:55 -0500, Jess Balint wrote:

> On Thu, May 24, 2007 at 04:26:43PM +1000, Daniel Kasak wrote:
> > > There should be a utility called myodbc3i.exe that can register the
> > > driver.
> >
> > Yeah I've tried that one too. Didn't do anything.
>
> Any error message?

No. Fails basically silently:

dkasak@dkasak
~/documents/myodbc/mysql-connector-odbc-noinstall-3.51.15-wi n32/bin $
~/.cxoffice/bin/wine myodbc3i.exe
Using the default (win98) bottle.
libGL warning: 3D driver claims to not support visual 0x62
dkasak@dkasak
~/documents/myodbc/mysql-connector-odbc-noinstall-3.51.15-wi n32/bin $

( sorry about text wrapping )

> > But it still doesn't work. I get an error:
> >
> > The setup routines for the MySQL ODBC 3.51 Driver ODBC driver could not
> > be loaded due to system error code 126.
> >
> > ... and then another error:
> >
> > Could not load the setup or translator library.
>
> I've seen this error before, but I think it was due to the setup library
> either missing or referencing the wrong path. You might not need the
> setup lib if you also create the DSNs with myodbc3i.exe or enter them
> directly into the registry.

DSNs in the registry, eh? I'll look at another Windows box and see if I
can do this, but I don't hold out much hope.

> > I tested this a couple of years ago, and had it working ... 3.51.06 or
> > so ... but I can't use this version because it can't authenticate
> > against newer MySQL servers.
>
> I'm not sure if any changes would prevent this. Also, you know there is
> an 'old password' feature that allows older clients to connect?

Yeah I know. At the moment, that's at the bottom of the list of options,
but the list is getting smaller quickly ...

--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: dkasak@nusconsulting.com.au
website: http://www.nusconsulting.com.au


--
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: Manually Register MyODBC?

Hi Daniel,

below the .reg file that I use to add a system dsn..obviously modify to
suit... don't know if it will be aNy use

cheers

mike

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\MAPMYSQL]
"Driver"="C:\\WINDOWS\\system32\\myodbc3.dll"
"DATABASE"="mysqldatabase"
"DESCRIPTION"="MySQL Db for MAP"
"PWD"="mysqlpwd"
"SERVER"="lmysqlserver"
"UID"="mysqluser"
"OPTION"="515"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources]
"MAPMYSQL"="MySQL ODBC 3.51 Driver"



Daniel Kasak wrote:
> On Thu, 2007-05-24 at 01:55 -0500, Jess Balint wrote:
>
>
>> On Thu, May 24, 2007 at 04:26:43PM +1000, Daniel Kasak wrote:
>>
>>>> There should be a utility called myodbc3i.exe that can register the
>>>> driver.
>>>>
>>> Yeah I've tried that one too. Didn't do anything.
>>>
>> Any error message?
>>
>
> No. Fails basically silently:
>
> dkasak@dkasak
> ~/documents/myodbc/mysql-connector-odbc-noinstall-3.51.15-wi n32/bin $
> ~/.cxoffice/bin/wine myodbc3i.exe
> Using the default (win98) bottle.
> libGL warning: 3D driver claims to not support visual 0x62
> dkasak@dkasak
> ~/documents/myodbc/mysql-connector-odbc-noinstall-3.51.15-wi n32/bin $
>
> ( sorry about text wrapping )
>
>
>>> But it still doesn't work. I get an error:
>>>
>>> The setup routines for the MySQL ODBC 3.51 Driver ODBC driver could not
>>> be loaded due to system error code 126.
>>>
>>> ... and then another error:
>>>
>>> Could not load the setup or translator library.
>>>
>> I've seen this error before, but I think it was due to the setup library
>> either missing or referencing the wrong path. You might not need the
>> setup lib if you also create the DSNs with myodbc3i.exe or enter them
>> directly into the registry.
>>
>
> DSNs in the registry, eh? I'll look at another Windows box and see if I
> can do this, but I don't hold out much hope.
>
>
>>> I tested this a couple of years ago, and had it working ... 3.51.06 or
>>> so ... but I can't use this version because it can't authenticate
>>> against newer MySQL servers.
>>>
>> I'm not sure if any changes would prevent this. Also, you know there is
>> an 'old password' feature that allows older clients to connect?
>>
>
> Yeah I know. At the moment, that's at the bottom of the list of options,
> but the list is getting smaller quickly ...
>
> --
> Daniel Kasak
> IT Developer
> NUS Consulting Group
> Level 5, 77 Pacific Highway
> North Sydney, NSW, Australia 2060
> T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
> email: dkasak@nusconsulting.com.au
> website: http://www.nusconsulting.com.au
>
>
>


--
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: Manually Register MyODBC?

On Fri, 2007-05-25 at 10:58 +1200, Mike Harknett wrote:

> Hi Daniel,
>
> below the .reg file that I use to add a system dsn..obviously modify to
> suit... don't know if it will be aNy use
>
> cheers
>
> mike


Thanks for the email Mike. I'll keep this one flagged for later, because
it looks handy. I've actually gotten the latest v5 MyODBC driver working
by using the zip distribution without an installer, and running the
Install.bat script. I'm yet to do any real testing, but hopefully
everything goes smoothly now.

Dan

--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: dkasak@nusconsulting.com.au
website: http://www.nusconsulting.com.au


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