[R] why RODBC on windows 7 with Sybase, returns garbage?

[Alok Jadhav]

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+s789695n4699208h81 at 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}}