ODBC Connection via ASP
-
:rolleyes: Hi All, I am trying to retrived data from SQL server in my asp page via ODBC connection. I have done the ODBC connection via administration tool. MY Code is: <% dim oConn, strSQL, rstMovie, Records set rstMovie = Server.CreateObject("ADODB.RECORDSET") Set oConn = Server.CreateObject("ADODB.Connection") oConn.Open "Provider=MSDASQL; Driver={SQL SERVER}; SERVER=localhost; database=Movie2002; UID=test; PWD=test;" strSQL = "Select * From tbl_movie" rstMovie.Open strSQL,oConn,adOpenForwardOnly,adLockReadOnly %> when I am trying to view the page on the browser the error message is 'page cannot be displayed'. The error message relates to ODBC connection I think. Can anybody help?!! Many Thanks. Bravo Two Zero A pen is mighter then a sword.
-
:rolleyes: Hi All, I am trying to retrived data from SQL server in my asp page via ODBC connection. I have done the ODBC connection via administration tool. MY Code is: <% dim oConn, strSQL, rstMovie, Records set rstMovie = Server.CreateObject("ADODB.RECORDSET") Set oConn = Server.CreateObject("ADODB.Connection") oConn.Open "Provider=MSDASQL; Driver={SQL SERVER}; SERVER=localhost; database=Movie2002; UID=test; PWD=test;" strSQL = "Select * From tbl_movie" rstMovie.Open strSQL,oConn,adOpenForwardOnly,adLockReadOnly %> when I am trying to view the page on the browser the error message is 'page cannot be displayed'. The error message relates to ODBC connection I think. Can anybody help?!! Many Thanks. Bravo Two Zero A pen is mighter then a sword.
-
:-D Many Thanks Bravo Two Zero A pen is mighter then a sword.