Trying to submit the following code:<BR><BR><%@ Import Namespace="System.Data.SqlClient" %><BR><%@ Page Language="VB" Debug="true" %><BR><script language="VB" runat="server"><BR><BR> Sub Page_Load(Sender As Object, E As EventArgs)<BR> <BR> If Not Page.IsPostBack Then<BR> state.Items.Add("CA")<BR> state.Items.Add("IN")<BR> state.Items.Add("KS")<BR> state.Items.Add("MD")<BR> state.Items.Add("MI")<BR> state.Items.Add("OR")<BR> state.Items.Add("TN")<BR> state.Items.Add("UT")<BR> End If<BR> <BR> End Sub<BR><BR> Sub ShowAuthors(Sender As Object, E As EventArgs)<BR> <BR> Dim con As New SqlConnection("Data Source=TestMe; Initial Catalog=pubs; UID=sa; PWD=")<BR> Dim cmd As SqlCommand<BR> Dim qry As String<BR> <BR> con.Open()<BR> <BR> qry = "select * from authors where state='" & state.SelectedItem.Text & "'"<BR> cmd = New SqlCommand(qry, con)<BR> <BR> DataGrid1.DataSource = cmd.ExecuteReader()<BR> DataGrid1.DataBind()<BR> <BR> con.Close()<BR> <BR> End Sub<BR> <BR></script><BR><BR><form runat="server"><BR><BR> State: <asp
ropDownList id="state" runat="server" /><BR> <BR> <asp:Button Text="Show Authors" OnClick="ShowAuthors" runat="server"/><BR><BR> <p/> <BR> <aspataGrid id="DataGrid1" runat="server"/><BR><BR></form><BR><BR>Get the following Error:<BR>Exception Details: System.Data.SqlClient.SqlException: SQL Server does not exist or access denied.<BR><BR>And i am using Beta2version with MDAC2.6Did you define the "TestMe" as a system DSN somewhere? Try using either (local) if it is on the same machine as your .NET code or just using the IP address of the machine.TestMe has been defined within SystemDSN - Do you mean use (local) when defining the server field?? Also is there any problems with using MDAC 2.6 as i saw on Microsoft site certain versions of 2.6/2.7 are not compatible with SQL Server7Try One of these connection statements<BR><BR>Select Case (mvCONNTYPE)<BR> Case "1" ' For MS SQL Only<BR> ' myCONNS = New SqlConnection("server=DBS-P4;database=testMSSQL;Trusted_Connection=yes")<BR> myCONNS = New SqlConnection("server=DBS-P4;uid=sa;pwd=test;database=testMSSQL")<BR> myCOMDS = New SqlDataAdapter(mvSQL, myCONNS)<BR><BR> Case "2" ' For Other SQL or MS SQL<BR> ' myCONN = New OleDbConnection("PROVIDER=SQLOLEDB;Data Source=DBS-P4;Initial Catalog=testMSSQL;Trusted_Connection=yes")<BR> myCONN = New OleDbConnection("PROVIDER=SQLOLEDB;Network Library=DBMSSOCN;Data Source=DBS-P4;Initial Catalog=testMSSQL;User ID=sa;Password=test")<BR> myCOMD = New OleDbDataAdapter(mvSQL, myCONN)<BR><BR> Case "3"<BR> Dim mvPATH As String ' For Access Jet 4.o Database<BR> mvPATH = Server.MapPath("/webdbx/testJET.mdb")<BR> myCONN = New OleDbConnection("Provider=Microsoft.JET.OLEDB.4.0;Data Source=" & mvPATH & ";User ID=;Password=;")<BR> ' myCONN = New OleDbConnection("Provider=Microsoft.JET.OLEDB.4.0;Data Source=c:Inetpubwwwrootwebdbx estJET.mdb;User ID=;Password=;")<BR> myCOMD = New OleDbDataAdapter(mvSQL, myCONN)<BR><BR> Case Else<BR> ERRMSG.Text = "Please select a database connection"<BR> Exit Sub<BR> End SelectHmm...if you made a system DSN it should be able to use that. But yea, you can type in (local) with the ()'s or the IP address if the SQL is on another server. Might be good for ruling out DSN issues.<BR><BR>Not sure about the MDAC versions, I know .Net asks you or forces you to upgrade but not sure which one it makes you use. I am using SQL 2K so don't know much about SQL 7.I've tried Matt's suggestion but still get the same problem<BR>And yet if u try it through VB orASP3.0, it works fine<BR><BR>Am i correct in assuming you need:<BR> 1) ASP.NET version beta2<BR> 2) MDAC version >2.6
ropDownList id="state" runat="server" /><BR> <BR> <asp:Button Text="Show Authors" OnClick="ShowAuthors" runat="server"/><BR><BR> <p/> <BR> <aspataGrid id="DataGrid1" runat="server"/><BR><BR></form><BR><BR>Get the following Error:<BR>Exception Details: System.Data.SqlClient.SqlException: SQL Server does not exist or access denied.<BR><BR>And i am using Beta2version with MDAC2.6Did you define the "TestMe" as a system DSN somewhere? Try using either (local) if it is on the same machine as your .NET code or just using the IP address of the machine.TestMe has been defined within SystemDSN - Do you mean use (local) when defining the server field?? Also is there any problems with using MDAC 2.6 as i saw on Microsoft site certain versions of 2.6/2.7 are not compatible with SQL Server7Try One of these connection statements<BR><BR>Select Case (mvCONNTYPE)<BR> Case "1" ' For MS SQL Only<BR> ' myCONNS = New SqlConnection("server=DBS-P4;database=testMSSQL;Trusted_Connection=yes")<BR> myCONNS = New SqlConnection("server=DBS-P4;uid=sa;pwd=test;database=testMSSQL")<BR> myCOMDS = New SqlDataAdapter(mvSQL, myCONNS)<BR><BR> Case "2" ' For Other SQL or MS SQL<BR> ' myCONN = New OleDbConnection("PROVIDER=SQLOLEDB;Data Source=DBS-P4;Initial Catalog=testMSSQL;Trusted_Connection=yes")<BR> myCONN = New OleDbConnection("PROVIDER=SQLOLEDB;Network Library=DBMSSOCN;Data Source=DBS-P4;Initial Catalog=testMSSQL;User ID=sa;Password=test")<BR> myCOMD = New OleDbDataAdapter(mvSQL, myCONN)<BR><BR> Case "3"<BR> Dim mvPATH As String ' For Access Jet 4.o Database<BR> mvPATH = Server.MapPath("/webdbx/testJET.mdb")<BR> myCONN = New OleDbConnection("Provider=Microsoft.JET.OLEDB.4.0;Data Source=" & mvPATH & ";User ID=;Password=;")<BR> ' myCONN = New OleDbConnection("Provider=Microsoft.JET.OLEDB.4.0;Data Source=c:Inetpubwwwrootwebdbx estJET.mdb;User ID=;Password=;")<BR> myCOMD = New OleDbDataAdapter(mvSQL, myCONN)<BR><BR> Case Else<BR> ERRMSG.Text = "Please select a database connection"<BR> Exit Sub<BR> End SelectHmm...if you made a system DSN it should be able to use that. But yea, you can type in (local) with the ()'s or the IP address if the SQL is on another server. Might be good for ruling out DSN issues.<BR><BR>Not sure about the MDAC versions, I know .Net asks you or forces you to upgrade but not sure which one it makes you use. I am using SQL 2K so don't know much about SQL 7.I've tried Matt's suggestion but still get the same problem<BR>And yet if u try it through VB orASP3.0, it works fine<BR><BR>Am i correct in assuming you need:<BR> 1) ASP.NET version beta2<BR> 2) MDAC version >2.6