MySQL connect.

[shenniko]

Hi All,

Need a little bit of help...

Im trying to connect to a MySQL database though SAS, apparenly the MySQL connect Engine isnt installed, but the ODBC engine is.

So the connection would need to be done though that..

I've tried to connect using the below:-

libname tastedb ODBC datasrc="orf-mysql1.brinkster.com" user=username password=password;

and am getting the below error :-

ERROR: CLI error trying to establish connection: [unixODBC][Driver Manager]Data source name not found, and no default driver specified

ERROR: Error in the LIBNAME statement.

I've searched for the above error, and the only referance i can find to it, is it might be a firewall issue.. So is there anyway to bypass the firewall?

Also i cant really get IT in work to help me as this is for my own personal use and not work releated

Thanks in advance

Shenn

 

[krispi]

Not sure whether this will help any, this is not my code, I can't claim to fully understand it - it's some I inherited. All I know is this connects to a SQL db through SAS:

libname DBO odbc noprompt=

"Driver={SQL Server};
Server=servername;
Uid=userID;
Pwd=Password;"
;

proc sql;
connect to odbc (noprompt="Driver={SQL Server};
Server=Servername;
Uid=userID;
Pwd=Password;");


If there's anything you may be able to use then go ahead!

 

[ChrisW75]

Also, the ODBC data source might be defined in the wrong place. I usually do mine as File DSNs when I define them. For some reason windows offers you the "User DSN" tab first, but most apps seem to use the File DSN area instead.

Chris
Business Analyst, Code Monkey, Data Wrangler.
SAS Guru.