9.2 with SAS/Access for MySQL
in [SAS]
|
Prev: PROC FCMP VARARGS Weirdness
Next: Excel Read-In Oddity
From: Chris T on 15 Oct 2009 09:59 Okay, I'm in tech support hell right now. This may be a long shot, but is anyone running a windows x64 system with 9.2 along with SAS/Access for MySQL? And, do you happen to have installed MySQL v5.0? Long story short, it's not working and tech support doesn't seem to have the solutions. I feel like it has something to do with this libmysql.dll, and maybe the one I have just isn't compatible with this version of SAS. Cheers!
From: friden on 15 Oct 2009 10:37 On Oct 15, 9:59 pm, Chris T <chris.tin...(a)gmail.com> wrote: > Okay, I'm in tech support hell right now. > > This may be a long shot, but is anyone running a windows x64 system > with 9.2 along with SAS/Access for MySQL? And, do you happen to have > installed MySQL v5.0? > > Long story short, it's not working and tech support doesn't seem to > have the solutions. I feel like it has something to do with this > libmysql.dll, and maybe the one I have just isn't compatible with this > version of SAS. > > Cheers! It should work with MySQL 5.0. What's kind of error information you get? Please check you configuration in this usage note: http://support.sas.com/kb/19/250.html
From: Chris T on 15 Oct 2009 11:25 The standard error: ERROR: The SAS/ACCESS Interface to MYSQL cannot be loaded. The libmysql code appendage could not be loaded. I realize that it should work with 5.0, and I had 9.1.3 working with 5.0 previously. Which is why this is so confounding. Why is it not working with 9.2? Can I assume you have this installed and running? What exact version of MySQL are you running? And, if I may, how many KB is your libmysql.dll file?
From: Joe Kelley on 15 Oct 2009 11:48 yeah, this looks like a problem with libmysql.dll. Since it worked with 9.2, I assume it is in your Path? --Joe On Thu, 15 Oct 2009 08:25:04 -0700, Chris T <chris.tinnon(a)GMAIL.COM> wrote: >The standard error: > >ERROR: The SAS/ACCESS Interface to MYSQL cannot be loaded. > The libmysql code appendage could not be loaded. > >I realize that it should work with 5.0, and I had 9.1.3 working with >5.0 previously. Which is why this is so confounding. Why is it not >working with 9.2? > >Can I assume you have this installed and running? What exact version >of MySQL are you running? And, if I may, how many KB is your >libmysql.dll file?
From: Chris T on 15 Oct 2009 12:19
Oh yea. I'll just paste here the summary of what I've sent to tech support. MySQL Installation Directory: C:\MySQL MySQL Version: 5.0.86 for Win64 C:\MySQL\Bin\libmysql.dll - 2,541 KB SAS Installation Directory: C:\Program Files\SAS Installed SAS Version: 9.2 (TS2M0) C:\Program Files\SAS\SASFoundation\9.2\access\sasexe\sasiomyl.dll - 342 KB C:\Program Files\SAS\SASFoundation\9.2\access\sasexe\sasmyl.dll - 147 KB C:\Program Files\SAS\SASFoundation\9.2\access\sasexe\uwyl0225.dll - 120 KB Running sysget('path'); returns: C:\MySQL\bin;C:\Program Files\SAS\SASFoundation\9.2;C:\Perl64\bin;c: \program files (x86)\i magemagick-6.4.0-q8;C:\Program Files (x86)\Windows Resource Kits\Tools \;C:\WINDOWS\system32 ;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Program Files (x86)\Dell\SysMgt \RAC5;C:\Program Fil es (x86)\Dell\SysMgt\oma\bin;C:\Program Files\SAS\SharedFiles\Formats |