sql server - Changed database context to 'sqldbname' error with classic asp -


theres been few questions far know/believe don't me @ all. code working fine previously. reason stopped. sql server version 2012. specific error is: 

 [microsoft][odbc sql server driver][sql server] changed database context 'sqldbname'

my asp code:

<!--#include file="connv.inc"--> <% n=request.form("total") response.write(n)  x = 0 n-1 ttitle=request.form("title_"&x) title=replace(ttitle, "'", "''") id=request.form("id_"&x) views=request.form("vviews_"&x) likes=request.form("vlikes_"&x) description=request.form("vdescription_"&x)  sql="insert tbl_videos(videotitle, videoid, videolikes, videoviews, videodescription, swamcompatible) values ('"&title&"', '"&id&"', '"&likes&"', '"&views&"', '"&description&"', '0')" connv.execute(sql) response.write(sql&"<br>") next %>  <html> <head> <title> updating tables </title> </head> <body>  </body> </html>  <!--#include file="closeemv.inc"-->

connv.inc code:

<% set connv = server.createobject("adodb.connection") connv.open "driver={sql server}; server=52.2.8.73; uid=myuid; pwd=mypwd; database=sqldbname" %>

try replacing connv.inc code below part,

<% set connv = server.createobject("adodb.connection") connv.open "provider=sqloledb; data source=52.2.8.73; initial catalog=sqldbname; user id=myuid; password=mypwd" %>

-

Comments

Post a Comment