ODBC

<i><b>Originally posted by : Martin (martin.joabsson@rejlers.se)</b></i><br /><br />We have been going through the tutorial, but we have a big problem. We want to use ASP+ to build our product, a webbased thing that has several different DBconnections. <br />And we started to try to make the simpliest connection to our ODBC-configured DBs. But the tutorial examples are working directly with MS SQL Server and we don´t want to use that.<br /><br />Please, give me the smallest codeexample u can make to test an ODBCconnection with ASP+.<br /><br />We used to work with another CGIprog language that didn´t have these open and instanciate things. Just ODBC connections directly and simple...<br /><br />Martin

<i><b>Originally posted by : Doug Seven (doug.seven@codejunkies.net)</b></i><br /><%@ Import Namespace="System.Data" %><br /><%@ Import Namespace="System.Data.ADO" %><br /><script language="vb" runat=server><br />Sub Page_Load(Source As Object, E As EventArgs)<br /> Dim cn As ADOConnection<br /> cn = New ADOConnection("DSN=Pubs;UID=sa;PWD=;")<br /> cn.Open()<br />End Sub<br /></script><br /><br />______________________________________<br />Doug Seven, MCSD<br />CodeJunkies.Net / ASPNextGen.com<br />doug.seven@codejunkies.net<br /><br />Two new sites are coming, dedicated exclusively to ASP+. Stay tuned for www.ASPNextGen.com and www.theFutureOfASP.com, both brought to you exclusively by CodeJunkies.Net. Tentative launch - August 16, 2000<br /><br />http://www.codejunkies.net<br /><br />"Between two evils, I always choose the one I haven't tried."<br />--Mae West<br /><br /><br />------------<br />Martin at 8/11/2000 3:39:25 AM<br /><br /><br />We have been going through the tutorial, but we have a big problem. We want to use ASP+ to build our product, a webbased thing that has several different DBconnections. <br />And we started to try to make the simpliest connection to our ODBC-configured DBs. But the tutorial examples are working directly with MS SQL Server and we don´t want to use that.<br /><br />Please, give me the smallest codeexample u can make to test an ODBCconnection with ASP+.<br /><br />We used to work with another CGIprog language that didn´t have these open and instanciate things. Just ODBC connections directly and simple...<br /><br />Martin