R help - Nov 2014 - why RODBC on windows 7 with Sybase, returns garbage?

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