recordset failure with odbc server
Posted on 2004-04-06
im using vb.net and i have set up a remote odbc connection kinda like this
conn.ConnectionString = "DSN=path;Server=myServer;uid=User;pwd=pass"
i can connect to the server just fine, but when i pass an SQL statement to get a recordset, thats when I get problems. the error that comes up says that i have invalid SQL syntax.
the only problem is that i do not have invalid SQL syntax. when i run the same exact query in access, it works jsut fine.
btw, im using ado to connect to the odbc server.....if anyone knows howto do it in ado.net id also entertain that idea.