I have an asp.net-mvc that that connects to a sybase IQ DB. It works locally but when I deploy it, I get an error saying:
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified]
This webpage connect to a sybase DB using the:
ODBCConnection
class. I don't see any other external dlls that seems to be references that weren't there before.
My connection string is (NOTE: i am replacing the actual info with []):
const string CONN_STRING = "DSN=SybaseDB;Eng=[DBNAME];Links=tcpip(Host=[server];Port=[MyPort]);UID=[username];PWD=[pwd];";
Can anyone give me any insight to what could be missing o开发者_Python百科n the web server to get this to work?
You might need to configure the ODBC driver on the server.
You need to create the DSN ODBC connection on the remote server.
精彩评论