[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL S

RobertFanney · Apr 28, 2012

hi all I have got this problem while accessing the database. can anyone help me. thanks in advance and my code is as follows it is a web application in asp.net sai gopal <%@ Page Language="VB" Debug="True"%> <HTML> <HEAD> <script runat="server"> Dim rs 'As ADODB.Recordset Dim sql As String Dim db 'As ADODB.Connection Dim con As String dim OFFSET dim DocumentSpec dim MaptoInternalId dim DocumentType dim s1 dim s2 dim s3 dim inbountDocumentSpec dim outbountDocumentSpec dim MapID dim DocumentTypeID dim DocumentTypeInstanceID dim Map </script>  <% DocumentTypeID = Request.Form("h12") DocumentTypeInstanceID = Request.Form("h2") MapID = request.Form("h3") inbountDocumentSpec = Request.Form("inbountdocspec") outbountDocumentSpec = Request.Form("outbountdocspec") Map = Request.Form("MapName") if inbountDocumentSpec <> "" Then sql = "EXEC SP_DocumentSpecification_Create " & DocumentTypeID & "," & MaptoInternalID & "," & MapID 'Response.Write sql db = Server.CreateObject("ADODB.Connection") db.Open(con) ' rs = nothing rs = Server.CreateObject("ADODB.RecordSet") 'Response.Write sql rs.Open( sql, db, 3, 3) db.close End If %> </HEAD> <body vlink="#808080" alink="#808080" link="#ff0063" bgcolor="#ffffff" background="./logoe24.jpg"> <center> Inbount and Outbount Document Specification Page <FORM id="Form1" name="login" action="http://localhost/WebApplication1/Test081002.aspx" method="post" runat="server"> <TABLE id="Table1" cellSpacing="1" cellPadding="1" width="280" border="0" height="185"> <tr> <td> <asp:textbox id=h12 maxLength=50 runat="Server" Visible="false" Width="31"/> <tr> <td>Inbount Document Specification</td> </tr> <TR> <TD> <% rs=Server.CreateObject ("ADODB.RecordSet") s1=request.Form("h12") sql="Select DocumentTypeID,InternalDocSpec from DocumentType" rs.Open(sql,con) %> <asp

ropDownList ID="inbountdocspec" Width="146" Runat="server"/> <% if not rs.eof then rs.movefirst do while not rs.eof %> <ASP:LISTITEM selected="True" value=http://aspmessageboard.com/archive/index.php/'<%=rs.fields("DocumentTypeID")%>'> <%=rs.fields("InternalDocSpec")%> </ASP:LISTITEM> <% rs.movenext loop else %> <% end if rs=nothing %> </TD> </TR> <tr> <td> <asp:textbox id="h2" maxLength=50 runat="Server" Visible="false" Width="31"/> </td> <tr> <td>Outbount Document Specification</td> </tr> </tr> <TR> <td> <% rs=Server.CreateObject("ADODB.RecordSet") s2=request.Form("h2") sql="Select DocumentTypeInstanceID,DocSpec from DocumentTypeInstance" rs.open(sql,con) %> <asp

ropDownList ID="outbountdocspec" Width="146" Runat="server"/> <% if not rs.eof then rs.movefirst do while not rs.eof %> <ASP:LISTITEM selected="True" value='<%=rs.fields("DocumentTypeInstanceID") %>'> <%=rs.fields("DocSpec") %> </ASP:LISTITEM> <% rs.movenext loop else %> <% end if rs=nothing %> </td> </TR> <tr> <td> <asp:textbox id="h3" maxLength=50 runat="Server" Visible="false" Width="31"/> </td> <tr> <td>Map</td> </tr> </tr> <TR> <td> <% rs = Server.CreateObject("ADODB.RecordSet") s3=request.form("h3") sql="Select MapID, MapName from Map" rs.Open(sql,con) %> <asp

ropDownList ID="MapName" Width="146" Runat="server"/> <% if not rs.eof then rs.movefirst do while not rs.eof %> <ASP:LISTITEM selected="True" value='<%=rs.fields("MapID") %>'> <%=rs.fields("MapName") %> </ASP:LISTITEM> <% rs.movenext loop else %> <% end if rs=nothing %> </td> </TR> <tr> <td align="right"> <input type= submit id="Submit1" runat="server" > </td> </tr> </TABLE> </FORM> </center> </body> </HTML> .NET code. Where on earth did you get it? It's really just ASP code with some .NET'tish bits in it! Rather than help you work through that code, my suggestion is that you go and buy a good book on how to code ASP .NET pages. Also, have a look through the online tutorials: http://www.asp.net/Tutorials/quickstart.aspxmy doubt is the database is not accessed to the above said file i have included a inclusive file which contains following info. where can i include that file instead of inc tag. the file is adodb.inc <% '''''''''''''''''''''''''''''''''' OFFSET=850 con = "PROVIDER=MSDASQL;" con = con & "DRIVER=SQL Server;" con = con & "SERVER=localhost;" con = con & "UID=sa;" con = con & "PWD=dbadmin;" con = con & "DATABASE=B2BBroker;" '''''''''''''''''''''''''''''''''' %> sai gopalThe ASP.NET architecture provides the Web.config file to store certain application data - such as connection strings! Specifically, there is a special element in the Web.config file called <appSettings> which lets you store keyed values. There's an article on 4Guys about it, I'd highly recommend that you search for it and give it a good read

hi me again I am looking at those website u have given me i am sending u a link of the web site and i have some doubt in it. It matches my doubt. ok. plz go through this site and solve my doubt http://samples.gotdotnet.com/quickstart/util/srcview.aspx?path=/quickstart/aspplus/samples/webforms/intro/Intro10.src And my doubt starts from this code onwards where server="(local)NetSDK. ......." ok MyConnection = New SqlConnection("server=(local)NetSDK;database=pubs;Trusted_Connect ion=yes") MyCommand = New SqlDataAdapter("select * from Titles where type='" + Category.SelectedItem.Value + "'", myConnection) as far my code is concerned i wrote the connection in another .inc file. my .inc file is as follows <% '''''''''''''''''''''''''''''''''' OFFSET=850 con = "PROVIDER=MSDASQL;" con = con & "DRIVER=SQL Server;" con = con & "SERVER=w9f00038;" con = con & "UID=sa;" con = con & "PWD=dbadmin;" con = con & "DATABASE=pubs;" '''''''''''''''''''''''''''''''''' %> ok plz solve my problem where i have made mistake. sai gopalWell, you are using an OLEDB connection string. The example is using a string configured for the .NET SQL managed provider. They're completely different.

[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL S

RobertFanney

New Member