DSN with ASP.NET

shelleyqfrossq · Apr 28, 2012

Can anyone show me an example of using a dsn with ASP.NET? The book I have says you can just put it in the connection string as "dsn=whatever". When I try this I receive an error saying "Unknown connection option in connection string: dsn". Any ideas? Thanks"dsn=whatever" is fine. The problem is in the "whatever" variable. What's the text in this variable look like? What lanuage are you using? Languages can be case sensitive. Try "DSN=mydsn" What are you using sql or oledb ... oledb written in VB.NET oConnection = New OleDbConnection("DSN=mydsn;") sql written in VB.NET oConnection = New SQLDbConnection("DSN=mydsn;") Aaron   'set up connection dim myConnection as new OleDbConnection("Provider = ????;" & _ "DSN=NISLDATA") Data is Visual FoxPro DBC I can not get the Provider correct? the closest I can get is an ISAM Error. Can AnyOne help?I dunno what they've done, but they obvoiusly know something I don't, 'cause I've never been able to get a DSN to work via OleDb. Perhaps someone can enlighten us. I *have* however, found that DSNs work beautifully when using ODCB. I downloaded and installed Microsoft.Data.Odbc, then created a new connection like so... dim Conn as New OdbcConnection("DSN=MyDSN") And it all worked smashingly.I get Compilation Error Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately. Compiler Error Message: BC30002: Type is not defined: 'OdbcConnection' Source Error: Line 10: Line 11: 'set up connection Line 12: dim myConnection as New OdbcConnection("DSN=NISLData") Assume I need Microsoft.Data.Odbc I can't find on MSN Downloads Do you remember where you found it? Thanks for the help. http://msdn.microsoft.com/downloads/default.asp?URL=/downloads/sample.asp?url=/MSDN-FILES/027/001/668/msdncompositedoc.xmlI did find that site. I did have that dll on my computer and still get the error. Any Ideas? I put Microsoft.Data.Odbc.dll in my C:inetpubwwwrootin directory. Now, here is the page: <%@ Assembly Name="Microsoft.Data.Odbc" %> <%@ Page Language="VB" debug="true" %> <%@ Import Namespace="System.Data" %> <%@ Import Namespace="Microsoft.Data.Odbc" %> <script runat="server"> Sub Page_Load(obj As Object, e AS EventArgs) dim Conn as New OdbcConnection("DSN=MyDSN") dim Cmd As New OdbcCommand _ ("SELECT MyField FROM MyTable", Conn) dim objReader As OdbcDataReader Conn.Open objReader = Cmd.ExecuteReader While objReader.Read Response.Write(objReader.GetString(0) & " ") End While Conn.Close() End Sub </script> <html><body> </body></html> And presto! It worked beautifully.<%@ Assembly Name="Microsoft.Data.Odbc" %> <%@ Page Language="VB" %> <%@ Import Namespace="System.Data" %> <%@ Import Namespace="Microsoft.Data.Odbc" %> <script runat="server"> Sub Page_Load(obj As Object, e AS EventArgs) dim Conn as New OdbcConnection("DSN=MyDSN") dim Cmd As New OdbcCommand _ ("SELECT MyField FROM MyTable", Conn) dim objReader As OdbcDataReader Conn.Open objReader = Cmd.ExecuteReader While objReader.Read Response.Write(objReader.GetString(0) & " ") End While Conn.Close() End Sub </script> <html><body> </body></html>This is what it did error is at bottom. I tried usind DSN and Directly pointing to the data file. Also tried dll in two places. Debug command does not seem to work? ' Access with ' http://jimsbox/tyaspnet/day9/listing9.8C.aspx ' Microsoft.Data.Odbc.dll in in //jimsbox/tyaspnet/day9/ also tried ' c:inetpubwwwrootin <%@ Assembly Name="Microsoft.Data.Odbc" %> <%@ Page Language="VB" Debug="true" %> <%@ Import Namespace="System.Data" %> <%@ Import Namespace="Microsoft.Data.Odbc" %> <script runat="server"> Sub Page_Load(obj As Object, e AS EventArgs) dim Conn as New OdbcConnection("DSN=SoccerData") 'dim Conn as New OdbcConnection("Provider=Microsoft.data.odbc;" & _ ' "Data Source=C:vfp7appssoccer2000data
isldata.dbc") dim Cmd As New OdbcCommand _ ("SELECT lname FROM Names", Conn) dim objReader As OdbcDataReader Conn.Open objReader = Cmd.ExecuteReader While objReader.Read Response.Write(objReader.GetString(0) & " ") End While Conn.Close() End Sub </script> <html><body> </body></html> Server Error in '/' Application. -------------------------------------------------------------------------------- File or assembly name System, or one of its dependencies, was not found. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.IO.FileNotFoundException: File or assembly name System, or one of its dependencies, was not found. Stack Trace: [FileNotFoundException: File or assembly name System, or one of its dependencies, was not found.] ASP.Listing9_8b_aspx.Page_Load(Object obj, EventArgs e) +0 System.Web.UI.Control.OnLoad(EventArgs e) +67 System.Web.UI.Control.LoadRecursive() +73 System.Web.UI.Page.ProcessRequestMain() +394 Debug=true ...No qoutes. Then see what it gives you...File or assembly name System, or one of its dependencies, was not found. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.IO.FileNotFoundException: File or assembly name System, or one of its dependencies, was not found. Source Error: The source code which generated this unhandled exception can only be shown when compiled in debug mode. To enable this, please follow one of the below steps, and then re-request the URL: 1) Add a "Debug=true" directive at the top of the file which generated the error. Example: <%@ Page Language="C#" Debug="true" %> this is the code: ' Access with ' http://jimsbox/tyaspnet/day9/listing9.8B.aspx <%@ Assembly Name="Microsoft.Data.Odbc" %> <%@ Page Language="VB" debug=true %> <%@ Import Namespace="System.Data" %> <%@ Import Namespace="Microsoft.Data.Odbc" %> doesn't seem to matter if there are quotes or not around true Hmmm...Where is your Microsoft.Data.Odbc.dll?' Access with ' http://jimsbox/tyaspnet/day9/listing9.8B.aspx I have tried bin in tyaspnet/day9/ and tyaspnet/day9/bin/ and c:inetpubwwwrootin all with same results Tried ????.aspx file in c:inetpubwwwroot with dll in d:inetpubwwwrootin Same results It was dumb. I finally realized I was working with the beta copy of asp.net from the book. I downloaded the current version and service pack 1 and whala it works. Thanks for you help.

DSN with ASP.NET

shelleyqfrossq

New Member