Hi James, Is your server name correct in the string below? Looks like you are using incorrect server name. If you don't give full server name, then the server has to be registered with ODBC management tool so that it can be picked up automatically.
Regards, Alok From: James Mathew [via R] [mailto:ml-node+s789695n4699208...@n4.nabble.com] Sent: Wednesday, November 05, 2014 5:04 AM To: Jadhav, Alok (KFET 63) Subject: Re: why RODBC on windows 7 with Sybase, returns garbage? Hi Alok and all, I am trying to connect to sybase from R with the RODBC package. I am using native sybase driver "Adaptive server Enterprise" and using the following example code. conn <- sprintf("driver=Adaptive server Enterprise;server=PHKSESMD01;database=smd_live;uid=temp_user;password=temp_pass;port=2301") chan <- odbcDriverConnect(conn) x <- sqlQuery(chan,sql,as.is=as.is) odbcClose(chan) However I am not able to connect to the database and I get the following error. 1: In odbcDriverConnect(conn) [RODBC] ERROR: state IM002, code 0, message [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified 2: In odbcDriverConnect(conn) : ODBC connection failed Any tips will be greatly appreciated. ________________________________ If you reply to this email, your message will be added to the discussion below: http://r.789695.n4.nabble.com/why-RODBC-on-windows-7-with-Sybase-returns-garbage-tp4607986p4699208.html To unsubscribe from why RODBC on windows 7 with Sybase, returns garbage?, click here<http://r.789695.n4.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=4607986&code=YWxvay5qYWRoYXZAY3JlZGl0LXN1aXNzZS5jb218NDYwNzk4NnwxMTg4ODMyMzg0>. NAML<http://r.789695.n4.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml> =============================================================================== Please access the attached hyperlink for an important el...{{dropped:14}} ______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
