connection to access file fails

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Ado
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - Connection Strings Hi, I'm creating an application that has to connect sequentially to different tadabases. I added all the connection strings to app.config and I'm itterating through them in the following manner: foreach (ConnectionStringSettings connStringSettings in ConfigurationManager.ConnectionStrings) { ........ connection = new SqlConnection(connStringSettings.ConnectionString); ......... } and I get: connStringSettings.ConnectionString = "data source=.\\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true" which is completly different from what I have in my connection string. I don't even know where this values is comming from. But if I do ConfigurationManager.ConnectionStrings["MyConnString1"].ToString(), ConfigurationManager.ConnectionStrings["MyConnString2"].ToString() I get the correct values from app.config. Where is the \\SQLEXPRESS connections string comming from and how can I itterativly get the correct connection string values? Thanks Tag: connection to access file fails Tag: 129717
  - 2
    - Update an Access Query from Vb.net (Help!!) Hi, I need to update an access sql sentence in my access database from vb.net, I have a query saved in my database, for example "MyQuery1" This "MyQuery1" have inside an sql sentence, for example "select * from MyTable", in my vb.net I need to update this query by another one, for example "select * from MyTable2", does anyone know how to do this??? Thanks. Tag: connection to access file fails Tag: 129716
  - 3
    - VB 2005 The record cannot be deleted or changed because table YYY includes related records I have a simple parent child table setup using MS Access I keep getting this error The record cannot be deleted or changed because table YYY includes related records I am not updating the primary key or changing it. I looked at the code in the Dataset.Designer.vb For some reason the primary key is trying to update in the updateCommand. I assume this is why I keep getting this error How can I get the code generator to not add the primary key to the Update Statement? Or if i manually edit the update statement how can i make the code generator leave it alone? Thanks Tag: connection to access file fails Tag: 129713
  - 4
    - concatenate two columns in a DataTable Hi I have a DataTable and I would lika to concatenate two columns so that can dispaly this new column in a DropDown box. (Firstname and Lastname). How can I do this? Thanks Julia Tag: connection to access file fails Tag: 129698
  - 5
    - VS 2005 Connection String Problems I created datasets and tableadapters using drag and drop and am using a mdb that is included in the project for development of a C# application. However, the release version of the software must be able to point to different datasource locations. There must be an economical way to do this, however I have not been able to determine the correct procedure. Is there a way to do this? Thanks, Duane Tag: connection to access file fails Tag: 129690
  - 6
    - With DataDirectory Keyword: CrystalReports.Load, CrystalReports.SetDataSource Yields Password Prompt Which You Can Cancell And Still See Report! How To Stop Prompt Hello, the steps that I did to get to my current question are: I began to use the keyword DataDirectory and the next line of code. When I ran the application, I would be asked for a Login ID and password. If I clicked the cancell button on that Login window I would not see the report at all. CrystalReport1.Load(Application.StartupPath & "\..\..\CrystalReport1.rpt") So, I eventually tried the following 2 line code sequece. This time if I pressed the cancell button on the Login window it would show the report. CrystalReport1.Load(Application.StartupPath & "\..\..\CrystalReport1.rpt") CrystalReport1.SetDataSource(Employee_DatabaseDataSet) Question: The last 2 lines of code will display the report and I'm pleased with that. But, how can I stop the Login prompt? I want to just open the report without being asked for Login ID or password. If I change the Load to any of the next two lines nothing happens differently from the just using the two lines above. CrystalReport1.Load(Application.StartupPath & "\..\..\CrystalReport1.rpt", CrystalDecisions.Shared.OpenReportMethod.OpenReportByDefault) CrystalReport1.Load(Application.StartupPath & "\..\..\CrystalReport1.rpt", CrystalDecisions.Shared.OpenReportMethod.OpenReportByTempCopy) Trying to finish-up a project, Christopher Lusardi Tag: connection to access file fails Tag: 129688
  - 7
    - Diffference between DataSet and DataTable Hi Friends, Can you tell the difference between Dataset and Datatable.... Dayaa Tag: connection to access file fails Tag: 129680
  - 8
    - XSD File and Database View hi Guys! i've faced very very strange problem. i don't know whether it is a problem or its the feature of the .net 2.0. I'd made some Dataset using XSD file. in this XSD files i've created 3 tables and defined some constraint in them. i generated Data Adapter and everything was working fine. Then i made change in the database. i added one column in the one of the table and renamed the table and also created the view with the previous name of the table so that my dataset work correctly. but what surprised me is, my dataset didnt work. yeah, i spent hours to find out the problem but all my R&D failed. after lots of R&D i drop the view and again renamed the table and everything started working back. and that surprised me. My conclusion on this is : -- if you have enforced constriant in the Dataset XSD files, then do remember to modifiy tables in the file as you modify them in the database -- XSD file doesnt work with views. i mean if you have constraint enabled then XSD failes to work with view as it only requires physical tables so that constraint can be enfored. I want your vies on my experienced because this is something i cant find it anywhere and only experienced developers can tell me why, what and how on this problem. please let me know if there is something i'm missing. thanks, Lucky Tag: connection to access file fails Tag: 129678
  - 9
    - Please help with some code. There is an error in the line marked XXX Could someone put it right for me? Many thanks, Adrian. using System; using System.Drawing; using System.Collections; using System.ComponentModel; using System.Windows.Forms; using System.Data; using System.Data.SqlClient; namespace WindowsApplication2 { public class Form1 : System.Windows.Forms.Form { #region Windows Form Designer generated code private System.Windows.Forms.ListBox listBox1; private System.ComponentModel.Container components = null; public Form1() { InitializeComponent(); } protected override void Dispose( bool disposing ) { if( disposing ) { if (components != null) { components.Dispose(); } } base.Dispose( disposing ); } private void InitializeComponent() { this.listBox1 = new System.Windows.Forms.ListBox(); this.SuspendLayout(); // // listBox1 // this.listBox1.Location = new System.Drawing.Point(16, 8); this.listBox1.Name = "listBox1"; this.listBox1.Size = new System.Drawing.Size(784, 238); this.listBox1.TabIndex = 0; // // Form1 // this.AutoScaleBaseSize = new System.Drawing.Size(5, 13); this.ClientSize = new System.Drawing.Size(816, 266); this.Controls.Add(this.listBox1); this.Name = "Form1"; this.Text = "Form1"; this.Load += new System.EventHandler(this.Form1_Load); this.ResumeLayout(false); } #endregion [STAThread] static void Main() { Application.Run(new Form1()); } private void Form1_Load(object sender, System.EventArgs e) { using (SqlConnection my_connection = new SqlConnection("server = fred\\sqlexpress; database = TrialDB; Integrated Security = TRUE;")) { string query = "SELECT Column_one, Column_two, Column_three FROM dbo.Table_1 "+ "SELECT Column_one, Column_two, Column_three FROM dbo.Table_2"; using(SqlDataAdapter my_adapter = new SqlDataAdapter(query,my_connection)) { using(DataSet data_set = new DataSet()) { my_adapter.TableMappings.Add("Tab", "bdo.Table_1"); my_adapter.TableMappings.Add("Tab1", "bdo.Table_2"); my_adapter.Fill(data_set,"Tab"); DataTable my_table = data_set.Tables["Tab"]; string display_string = string.Empty; foreach(DataRow row in my_table.Rows)XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX { for(int x = 0; x < 3; x++) { display_string += '\t' + (row.ItemArray[x].ToString()); } listBox1.Items.Add(display_string); display_string = string.Empty; } } } } } } Tag: connection to access file fails Tag: 129677
  - 10
    - how to check the value of a field on each row? Hi, The aspx file contains a datasource and a gridview. The (only) field is a boolean type (true/false). Now, when the value of the field is 'true' something must happen (e.g. Response.Write("this is true") ). So i used the server-event 'GridView1_RowCreated' but how can i check the value of the field on each row? I tried this code below, but it doesn't work ... Thanks Phil <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\mydb.mdb" ProviderName="System.Data.OleDb" SelectCommand="SELECT field1 from mytable"></asp:SqlDataSource> <asp:GridView ID="GridView1" runat="server" DataSourceID="SqlDataSource1" <Columns><asp:BoundField DataField="myfield" /> </Columns> </asp:GridView> The code-behind: Protected Sub GridView1_RowCreated(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewRowEventArgs) Handles GridView1.RowCreated Dim a As Object a = GridView1.Columns(5) If a.Equals(True) Then Response.Write("ok") End If End Sub Tag: connection to access file fails Tag: 129676
  - 11
    - ODP.Net Connection String Hi all, As I understand when using ODP.Net we have to provide in connection string Data Source as the Net Service Name. Is there any way I can connect without specifying the Data Source as I dont want to install Oracle client manually and create Net Service on each client machine. Thanks, Nits. Tag: connection to access file fails Tag: 129673
  - 12
    - Reading - Parsing Records From An LDAP LDIF File In .Net? Reading - Parsing Records From An LDAP LDIF File In .Net? I am in need of a .Net class that will allow for the parsing of a LDAP LDIF file. An LDIF file is the standard format for representing LDAP objects. I need to be able to read the records from an LDIF file into .Net. There exists a Perl module that will do exactly this called Net::LDAP::LDIF but I am wanting to port my code over to .Net and cannot find anything with similar LDIF functionality. I would like to avoid having to write my own .Net class to read the LDIF file and create record objects. I am sure I am not that only person that needs to do this that is using .Net. Does there exist a .Net class that will read LDIF files? Is there a third party .Net class that can be purchased that can read an LDIF file? Any help would be appreciated, Jean-Marie Vaneskahian jean@vaneskahian.com Tag: connection to access file fails Tag: 129671
  - 13
    - timeout question Hello, I have a connection string that looks like: "SERVER=MyServer;DATABASE=MyDatabase;UID=Myuser;Connect Timeout=900;" However, when I try to run the following, it times out after MUCH less than 15 minutes: Private Sub RunUpdateTransaction(ByVal UpdateSQL As String, ByVal UpdateConn As SqlConnection) Dim trnDeleteQuery As SqlTransaction = UpdateConn.BeginTransaction(IsolationLevel.Serializable, "DeleteQuery") Dim cmdDeleteQuery As New SqlCommand(UpdateSQL, UpdateConn, trnDeleteQuery) Try Dim iUpdated As Integer iUpdated = cmdDeleteQuery.ExecuteNonQuery 'trnDeleteQuery.Rollback() trnDeleteQuery.Commit() Catch ex As Exception Throw ex Finally If Not cmdDeleteQuery Is Nothing Then cmdDeleteQuery.Dispose() If Not trnDeleteQuery Is Nothing Then trnDeleteQuery.Dispose() End Try End Sub My delete query looks like: DELETE FROM Table1 WHERE MyID IN (1,2,3,4,5); DELETE FROM Table2 WHERE MyID IN (1,2,3,4,5) However, there are about 32000 values in my where. Running a SELECT query in SQL Server Query Analyzer with the same WHERE clause took about 8 minutes. Thanks, Eric Tag: connection to access file fails Tag: 129663
  - 14
    - Using SMO with Oracle? All, Microsoft has Sql Server Management Object (SMO) for use with Sql Server databasess. Is there something simliar for using ADO.NET with an Oracle database? Thanks in advance. Tag: connection to access file fails Tag: 129662
  - 15
    - SQL Parameterized insert Problem (variable already declared) Hello, I have the following code (vb.net) below. I'm just taking an array and pushing it into an sql (MS) database. However, it keeps giving me the following error: "InsertFileRecords: The variable name '@cn' has already been declared. Variable names must be unique within a query batch or stored procedure." If I get rid of CN, then the next one down will give me the error. I don't get it; I don't have the variable declared globally anywhere, or in any calling functions. So what gives? What's wrong with my code? Thanks in advance!! Sub InsertFileRecords(ByVal contacts As String(,), ByVal strOU As String) Dim Sql, strDN, strError, strNick, strName, sqlGet As String Dim rowsaffected As Integer Dim iIndex1 As Integer Dim sqlCMD As New SqlClient.SqlCommand Dim contactInfo As contactStruct sqlCMD.CommandType =3D CommandType.Text sqlCMD.Connection =3D sqlConnection1 prgsInsert.Value =3D 0 prgsInsert.Maximum =3D UBound(contacts) Sql =3D "INSERT INTO Tradoc.dbo.Incoming (cn, filecn, mailNickName, filemailNickName, " _ & " targetAddress, fileproxy, fileDisplayName, givenName, initials, sn, title, telephonenumber," _ & " company, department, physicalDeliveryOfficeName, l, st, postalCode, co, ou, dn, adspath, " _ & " description)" _ & " VALUES (@cn,@filecn,@mailNickName,@fileMailNickName,@targetAddress,@fileproxy, " _ & " @fileDisplayName, @givenname,@initials,@sn,@title,@telephoneNumber,@company,@department, " _ & " @physicalDeliveryOfficeName,@l,@st,@postalCode,@co,@ou,@dn,@adspath,@descri= =ADption)" opensql(1) sqlCMD.CommandText =3D Sql For iIndex1 =3D 0 To UBound(contacts) contactInfo =3D csv2ContactStruct(iIndex1, contacts, strOU) Try 'sqlCMD.Parameters.Add(New SqlParameter("@objectClass", SqlDbType.VarChar, 50)).Value =3D "contact" sqlCMD.Parameters.Add(New SqlParameter("@cn", SqlDbType.VarChar, 100)).Value =3D contactInfo.CN sqlCMD.Parameters.Add(New SqlParameter("@filecn", SqlDbType.VarChar, 100)).Value =3D contactInfo.fileCN sqlCMD.Parameters.Add(New SqlParameter("@mailNickName", SqlDbType.VarChar, 100)).Value =3D contactInfo.mailNickName sqlCMD.Parameters.Add(New SqlParameter("@fileMailNickName", SqlDbType.VarChar, 100)).Value =3D contactInfo.fileMailNickName sqlCMD.Parameters.Add(New SqlParameter("@targetAddress", SqlDbType.VarChar, 400)).Value =3D contactInfo.targetaddress sqlCMD.Parameters.Add(New SqlParameter("@fileProxy", SqlDbType.VarChar, 500)).Value =3D contactInfo.fileProxy sqlCMD.Parameters.Add(New SqlParameter("@filedisplayname", SqlDbType.VarChar, 400)).Value =3D contactInfo.fileDisplayName sqlCMD.Parameters.Add(New SqlParameter("@givenName", SqlDbType.VarChar, 100)).Value =3D contactInfo.givenName sqlCMD.Parameters.Add(New SqlParameter("@initials", SqlDbType.VarChar, 50)).Value =3D contactInfo.initials sqlCMD.Parameters.Add(New SqlParameter("@sn", SqlDbType.VarChar, 100)).Value =3D contactInfo.sn sqlCMD.Parameters.Add(New SqlParameter("@title", SqlDbType.VarChar, 400)).Value =3D contactInfo.title sqlCMD.Parameters.Add(New SqlParameter("@telephoneNumber", SqlDbType.VarChar, 50)).Value =3D contactInfo.telephoneNumber sqlCMD.Parameters.Add(New SqlParameter("@company", SqlDbType.VarChar, 400)).Value =3D contactInfo.company sqlCMD.Parameters.Add(New SqlParameter("@department", SqlDbType.VarChar, 400)).Value =3D contactInfo.department sqlCMD.Parameters.Add(New SqlParameter("@physicalDeliveryOfficeName", SqlDbType.VarChar, 400)).Value =3D contactInfo.physicalDeliveryOfficeName sqlCMD.Parameters.Add(New SqlParameter("@l", SqlDbType.VarChar, 50)).Value =3D contactInfo.l sqlCMD.Parameters.Add(New SqlParameter("@st", SqlDbType.VarChar, 50)).Value =3D contactInfo.st sqlCMD.Parameters.Add(New SqlParameter("@postalcode", SqlDbType.VarChar, 50)).Value =3D contactInfo.postalCode sqlCMD.Parameters.Add(New SqlParameter("@co", SqlDbType.VarChar, 50)).Value =3D contactInfo.co sqlCMD.Parameters.Add(New SqlParameter("@ou", SqlDbType.VarChar, 400)).Value =3D contactInfo.OU sqlCMD.Parameters.Add(New SqlParameter("@dn", SqlDbType.VarChar, 400)).Value =3D contactInfo.DN sqlCMD.Parameters.Add(New SqlParameter("@adspath", SqlDbType.VarChar, 400)).Value =3D contactInfo.adsPath sqlCMD.Parameters.Add(New SqlParameter("@description", SqlDbType.VarChar, 200)).Value =3D contactInfo.description rowsaffected =3D sqlCMD.ExecuteNonQuery() Catch e As Exception logit("InsertFileRecords: " & e.Message) Debugger.Break() Finally Sql =3D "" prgsUpdate(UBound(contacts)) End Try 'Else prgsUpdate(UBound(contacts)) 'End If Next 'iIndex1 =3D 0 To UBound(contacts) closesql(1) sqlCMD.Dispose()=20 'ds =3D Nothing=20 End Sub Tag: connection to access file fails Tag: 129655
  - 16
    - The variable name has already been declared error - SQL parameter insert Hello, I have the following code (vb.net) below. I'm just taking an array and pushing it into an sql (MS) database. However, it keeps giving me the following error: "InsertFileRecords: The variable name '@cn' has already been declared. Variable names must be unique within a query batch or stored procedure." If I get rid of CN, then the next one down will give me the error. I don't get it; I don't have the variable declared globally anywhere, or in any calling functions. So what gives? What's wrong with my code? Sub InsertFileRecords(ByVal contacts As String(,), ByVal strOU As String) Dim Sql, strDN, strError, strNick, strName, sqlGet As String Dim rowsaffected As Integer Dim iIndex1 As Integer Dim sqlCMD As New SqlClient.SqlCommand Dim contactInfo As contactStruct sqlCMD.CommandType = CommandType.Text sqlCMD.Connection = sqlConnection1 prgsInsert.Value = 0 prgsInsert.Maximum = UBound(contacts) Sql = "INSERT INTO Tradoc.dbo.Incoming (cn, filecn, mailNickName, filemailNickName, " _ & " targetAddress, fileproxy, fileDisplayName, givenName, initials, sn, title, telephonenumber," _ & " company, department, physicalDeliveryOfficeName, l, st, postalCode, co, ou, dn, adspath, " _ & " description)" _ & " VALUES (@cn,@filecn,@mailNickName,@fileMailNickName,@targetAddress,@fileproxy, " _ & " @fileDisplayName, @givenname,@initials,@sn,@title,@telephoneNumber,@company,@department, " _ & " @physicalDeliveryOfficeName,@l,@st,@postalCode,@co,@ou,@dn,@adspath,@description)" opensql(1) sqlCMD.CommandText = Sql For iIndex1 = 0 To UBound(contacts) contactInfo = csv2ContactStruct(iIndex1, contacts, strOU) Try 'sqlCMD.Parameters.Add(New SqlParameter("@objectClass", SqlDbType.VarChar, 50)).Value = "contact" sqlCMD.Parameters.Add(New SqlParameter("@cn", SqlDbType.VarChar, 100)).Value = contactInfo.CN sqlCMD.Parameters.Add(New SqlParameter("@filecn", SqlDbType.VarChar, 100)).Value = contactInfo.fileCN sqlCMD.Parameters.Add(New SqlParameter("@mailNickName", SqlDbType.VarChar, 100)).Value = contactInfo.mailNickName sqlCMD.Parameters.Add(New SqlParameter("@fileMailNickName", SqlDbType.VarChar, 100)).Value = contactInfo.fileMailNickName sqlCMD.Parameters.Add(New SqlParameter("@targetAddress", SqlDbType.VarChar, 400)).Value = contactInfo.targetaddress sqlCMD.Parameters.Add(New SqlParameter("@fileProxy", SqlDbType.VarChar, 500)).Value = contactInfo.fileProxy sqlCMD.Parameters.Add(New SqlParameter("@filedisplayname", SqlDbType.VarChar, 400)).Value = contactInfo.fileDisplayName sqlCMD.Parameters.Add(New SqlParameter("@givenName", SqlDbType.VarChar, 100)).Value = contactInfo.givenName sqlCMD.Parameters.Add(New SqlParameter("@initials", SqlDbType.VarChar, 50)).Value = contactInfo.initials sqlCMD.Parameters.Add(New SqlParameter("@sn", SqlDbType.VarChar, 100)).Value = contactInfo.sn sqlCMD.Parameters.Add(New SqlParameter("@title", SqlDbType.VarChar, 400)).Value = contactInfo.title sqlCMD.Parameters.Add(New SqlParameter("@telephoneNumber", SqlDbType.VarChar, 50)).Value = contactInfo.telephoneNumber sqlCMD.Parameters.Add(New SqlParameter("@company", SqlDbType.VarChar, 400)).Value = contactInfo.company sqlCMD.Parameters.Add(New SqlParameter("@department", SqlDbType.VarChar, 400)).Value = contactInfo.department sqlCMD.Parameters.Add(New SqlParameter("@physicalDeliveryOfficeName", SqlDbType.VarChar, 400)).Value = contactInfo.physicalDeliveryOfficeName sqlCMD.Parameters.Add(New SqlParameter("@l", SqlDbType.VarChar, 50)).Value = contactInfo.l sqlCMD.Parameters.Add(New SqlParameter("@st", SqlDbType.VarChar, 50)).Value = contactInfo.st sqlCMD.Parameters.Add(New SqlParameter("@postalcode", SqlDbType.VarChar, 50)).Value = contactInfo.postalCode sqlCMD.Parameters.Add(New SqlParameter("@co", SqlDbType.VarChar, 50)).Value = contactInfo.co sqlCMD.Parameters.Add(New SqlParameter("@ou", SqlDbType.VarChar, 400)).Value = contactInfo.OU sqlCMD.Parameters.Add(New SqlParameter("@dn", SqlDbType.VarChar, 400)).Value = contactInfo.DN sqlCMD.Parameters.Add(New SqlParameter("@adspath", SqlDbType.VarChar, 400)).Value = contactInfo.adsPath sqlCMD.Parameters.Add(New SqlParameter("@description", SqlDbType.VarChar, 200)).Value = contactInfo.description rowsaffected = sqlCMD.ExecuteNonQuery() Catch e As Exception logit("InsertFileRecords: " & e.Message) Debugger.Break() Finally Sql = "" prgsUpdate(UBound(contacts)) End Try 'Else prgsUpdate(UBound(contacts)) 'End If Next 'iIndex1 = 0 To UBound(contacts) closesql(1) sqlCMD.Dispose() 'ds = Nothing End Sub Tag: connection to access file fails Tag: 129653
  - 17
    - Transaction limitations I am updating a table of a few million records with a update file i.e based on the data in the update file, I am updating my records. My code throws an error everytime it reaches a particular record. The record is fine, logic is fine. If I use the same code with a file that has data for only that record to be updated, it works fine. I wonder if there is a limit to the number of SQL statements that can be contained in one transaction or number of operations that a transaction can hold. Thanks, Tag: connection to access file fails Tag: 129651
  - 18
    - Where to Lock when updating a DataTable Hi, I have an C# app which uses a Dataset which contains multiple DataTables as an in memory database. (Currently the dataset is not connected to a database.) The app is multi threaded and adds/update rows in the various tables. Currently I lock the Dataset on each modification - but am I locking at the right (most efficent) level? Could I just lock at the DataTable or even just the row? or can I do without locks? TIA swin Tag: connection to access file fails Tag: 129648
  - 19
    - How to filter by Month using Dataview.RowFilter Hello, My Code: dvM1.RowFilter = "DATEPART(Month, Datum) = " + Monat.Month + " AND DATEPART(Year, Datum) = " + Monat.Year; But DATEPART is not a ADO Functions? Can someone help me? Tag: connection to access file fails Tag: 129647
  - 20
    - Run SQL against DataView Object Hi, I have a requirement in a current project to show the effect of a particular SQL Statement on a given database table. The statement will only effect one row but could be an UPDATE, DELETE or an INSERT command. The user should see the table row before and after for an UPDATE, a new row for an INSERT and the row to be removed for a DELETE command. I intend to represent a copy of the table before and after the query has been run (without affecting the database) as a DataView object. Does anyone know whether there is any built in functionality for executing raw SQL statements against ADO.NET objects? My current plan (not find anything more suitable) involves creating a function which would parse the SQL statement as a string and determine the target table and the type of query (it would always start with either INSERT, DELETE or UPDATE). It would then locate the WHERE clause which could easily be applied to a DataView of the table. Has anyone else ever come across something like this before? I am relatively new to .NET and am not sure whether they would be a more elequent/faster approach. Any views would be greatly appreciated! I am writing the application in C# although that is probably irrelevant here. Thanks! Andrew Tag: connection to access file fails Tag: 129646
  - 21
    - Simple Multiple Row Insert Question Hi everyone, I have a pretty simple situation and I'm hoping that someone could give me some advice on the best way to handle it. I need to insert a whole load of rows into SQL Server 2005 using ado.net. I use custom business objects to represent the rows. So for example, in this specific case, I have a big collection of "Booking" objects. I also have a stored procedure called CreateBooking. My question is - assuming that I need to import say, 7000 rows in one go, is simply looping through the Bookings collection and calling the Stored Procedure for each booking the best way to do things? Is there some other way to get that much data into the database without constantly calling the stored procedure 7000 times. I use the same connection each time, but still, it seems a bit clumsy. I was wondering if there is a better way. Many thanks to anyone who can advise... Simon PS: I really need to use ADO.net to do this - importing by some other mechanism isn't going to be possible in this instance Tag: connection to access file fails Tag: 129640
  - 22
    - SqlBulkCopy with SQL2005 Column encryption Hi, Can the SqlBulkCopy class in .NET 2.0 be used in conjunction with SQL Server 2005's native column encryption? Many Thanks, Andy Tag: connection to access file fails Tag: 129636
  - 23
    - Programatically unique Hi, I have have dataset on the client side and I would like to set it up so that it cant take data entered that isnt unique on two columns. There is obviously the unique property of each column , but they work indepedant, im looking for something that will be unique on more than one column. Thanks Tag: connection to access file fails Tag: 129635
  - 24
    - Issue with Command Timed out with data adapter When i try to fill a dataset with a adapter am setting the command timed out to 15 seconds. but the querry is not timing out after 15 seconds. what may be the issue? Code i am using ------------------ SqlConnection objConn = new SqlConnection("Connection string"); objConn.Open(); SqlCommand objComand = new SqlCommand("select * from table1", objConn); //Query will execute for 20 miniutes objComand.CommandTimeout = 15; //This is not working SqlDataAdapter sqlAdapter = new SqlDataAdapter(objComand); //create a new dataset to hold our data DataSet ds = new DataSet(); sqlAdapter.Fill(ds); Tag: connection to access file fails Tag: 129631
  - 25
    - ADO.Net- Anyone know of a way to find all databases on my computer? I'd like to find all the databases on my computer. In other words, would like to find information similar to the info shown in Server Explorer in Visual Studio .Net. Anyone know of a way of doing this? Tag: connection to access file fails Tag: 129625
- Next
  - 1
    - Created Dataset with two tables - How do I populate at runtime? In VS 2005, I created a dataset with the dataset designer that has two tables that have a parent-child relationship (which I also added in the designer). Each table gets data from a stored procedure. I want to populate the dataset at runtime, passing in a parameter from another control on the form, then pass the dataset to a crystal report. And that is what I haven't figured out - how to populate the dataset at run time. Can someone point me in the right direction? thanks -- dchman Tag: connection to access file fails Tag: 129610
  - 2
    - Programatically call extended stored procedure? Hi, C# / .NET Framework 1.1 I would like to query extended stored procedure like stored procedure... However, I found that CommandType property does not have Extended Stored Procedure value..... I tried something like.. SqlConnection con = new SqlConnection(....); SqlCommand command = new SqlCommand('xp_blahblahblah", con); command.CommandType = CommandType.StoredProcedure; ..... ... command.ExecuteScalar(); However, it always throw exception saying "Could not find store procedure xp_blahblahblah".... Is there any way I can use the extended stored procedure programatically? Thanks. ..................................................................TJ Tag: connection to access file fails Tag: 129609
  - 3
    - How do I compare 2 UniqueIdentifier Guids? Hello. I have two databases, both of which store an objectGUID (from a contact object) in a UniqueIdentifier Column. How can I search a value picked up in one (using sqlreader) to a value in the other table? For example, using the following: "SELECT * FROM table1 Where objectGUID = '" & sqlReader3("guid") & "'" This just tells me that I cannot compare objects. How do I cast them, and what is the syntax for the sql command? Thanks in advance! Tag: connection to access file fails Tag: 129605
  - 4
    - newbie question I have a collection of objects that can be bound directly as a data source into a DataViewGrid... works great, but now I can't figure out how to get the columns sorted in the order that I want, or how to hide certain columns. Is this possible? Paul Tag: connection to access file fails Tag: 129604
  - 5
    - number of recs from select Hi all, I am trying to figure out how to retrieve the number of records resulting from a select. I tried executereader but the object does not contain the number iof records retrieved. Any suggestions? Thanks, Carlos Tag: connection to access file fails Tag: 129603
  - 6
    - question about client callback and gridview Hi, I read about client callback and i have a question. Assume the option "sorting" is set in a gridview. Each time the user clicks on a fieldname, the data are sorted. My question is: are the data on each click fetched from the server, or are they 'cached' on the client-side and so avoiding a lot of transferts between server and browser? If not 'cached', would it not bebetter to use the client callback technology? Thanks for explanation Chris Tag: connection to access file fails Tag: 129599
  - 7
    - SP w/ parameter using a DAL Hi, I am using the enterprise DAL that I downloaded from Microsoft. I am trying to create a data table based SP with a passed parameter but I keep getting a null exception error. I thought it was set-up correctly but it doesn't appear data table is being populated. The code below is what I have written but confused on the issue. Any help or suggestion is greatly appreciated. I am new to C# and .Net so I am going through growing pains Error: An unhandled exception of type 'System.NullReferenceException' occurred in classlibrary1.dll Mark private void cbPyramid_SelectedIndexChanged(object sender, System.EventArgs e) { DataTable dt = new DataTable(); int i; Department dsDept = new Department(cbPyramid.Text); dt = dsDept.Get_Dept; cbDept.Items.Clear(); for (i = 0; i < dt.Rows.Count; i++) { cbDept.Items.Add(dt.Rows["Dept"]); } } //Business object code #region Private Members private DataSet _dsDept; #endregion #region Public Properties public DataTable Get_Dept { get { return _dsDept.Tables[0]; } } #endregion #region Public Methods public Department(string Pyramid) { //This will establish the database connection Database db = DatabaseFactory.CreateDatabase("Test"); //This will allow you to call a SP and use parameters DBCommandWrapper dbc = db.GetStoredProcCommandWrapper("usp_Inv_GetDepartment"); dbc.AddInParameter("@pyramid", DbType.String, Pyramid); db.ExecuteDataSet(dbc); } #endregion } Tag: connection to access file fails Tag: 129598
  - 8
    - Informix Drivers I am using Informix ODBC to connect to my POS database. It works fine and shows all the tables in Excel but when I connect to the ODBC in Visual Web Developer it says Test Successed but doesn't show any tables or other information. Any help on getting Informix working with Visual Web Developer. Thanks. Tag: connection to access file fails Tag: 129594
  - 9
    - SQLTransaction IsolationLevel questions Hello, Sorry for posting this in more than one place, I meant to put it in this newsgroup, not m.p.d.f.aspnet... I have a VB.NET subroutine similar to the following: Private Sub RunUpdateTransaction(ByVal UpdateSQL As String, ByVal UpdateConn As SqlConnection) Dim trnDedupe As SqlTransaction = UpdateConn.BeginTransaction(IsolationLevel.ReadCommitted, "Dedupe") Dim cmdDedupe As New SqlCommand(UpdateSQL, UpdateConn, trnDedupe) Try Dim iUpdated As Integer iUpdated = cmdDedupe.ExecuteNonQuery trnDedupe.Rollback() Catch ex As Exception Throw ex Finally If Not cmdDedupe Is Nothing Then cmdDedupe.Dispose() End Try End Sub UpdateSQL looks like: INSERT INTO MyTable1(Field1, Field2)(SELECT Field1, Field2 FROM MyTable1 WHERE MyId1 = 123); UPDATE MyTable2 SET MyID1 = (SELECT MAX(MyID1) FROM MyTable1) WHERE MyID1 = 123 AND MyID2 = 456; I have a breakpoint on trnDedupe.Rollback(). I then switched to Query Analyzer and tried to run a query SELECT * FROM MyTable1 WHERE MyID1 = (SELECT MAX(MyID1) FROM MyTable1) I started this query before I stepped away from my desk and it's been running for 2-1/2 hours. Should I try another type of IsolationLevel other than ReadCommitted. It looks like ReadCommitted might be good to prevent someone else from inserting a record into MyTable1 in between my INSERT and UPDATE. From the documentation: -------------------------------------------------------------------------------------- ReadUncommitted: Shared locks are held while the data is being read to avoid dirty reads, but the data can be changed before the end of the transaction, resulting in non-repeatable reads or phantom data. ReadUncommitted: A dirty read is possible, meaning that no shared locks are issued and no exclusive locks are honored. RepeatableRead: Locks are placed on all data that is used in a query, preventing other users from updating the data. Prevents non-repeatable reads but phantom rows are still possible. -------------------------------------------------------------------------------------- If I'm reading the documentation correctly, it looks like I might want to use ReadUncommitted for my testing and ReadUncommitted when I'm using the application in production to prevent inserts between my INSERT and UPDATE. Would any of the other IsolationLevels be useful? Thanks, Eric Tag: connection to access file fails Tag: 129592
  - 10
    - Need help with Case-sensitive queries in SQLServer 2000 I need to retrieve records just as they are and enforce case-sensitivy. For example, my query return 'E1234' in place of 'e1234'. I want to return exactly what is in the table. How do I do that? Thnaks mo Tag: connection to access file fails Tag: 129590
  - 11
    - Bindingsource c# Hi there, are there any good reference examples for using a bindingsource object ? I new to ado.net and trying to create a simple maintenance app on an sql mobile database. I created a datasource and then dragged a table onto my form (Detail mode). Where to go from there ? thanx in advance. Tag: connection to access file fails Tag: 129587
  - 12
    - New to ASP.Net, Cascading DropDown List in Detail View...Please help A) Destination Table with 4 Fields. 1) Last Name 2) First Name 3) State 4) Zip Code. B) Look up table State/Zip Code with 2 Fields 1) State 2) Zip Code. I created a DetailView Form in Asp.net to Insert/Update Destination Table. Destination Table's State and Zip Code Fields are converted from Bound Column to Item/Edit/Insert Template, Created 2 Drop Down Lists, DDLState and DDLZIP. I am using '<%# Bind(...)%>' for both of them. Also, I do have 2 SQLDatasource for DDL's (i.e. SqlState for DDLState and SqlZip for DDLZIP). My Intention is very simple: When user select State Name from DDLState DropDownList List (example: NJ), in DDLZIP Dropdown list it must show only Zip Codes from that State. In order to Change the Value of DDLZIP, users must Change the Value of DDLState. Basically DDLZIP is Child/Dependant of DDLState. I did correctly setup proper reference to DDLState in SelectedParameters, Control Parameters, PropertyName in SqlZip (SqlDataSource for DDLZIP). This Cascading dropdown logic does work Fine in a Form without a DetailView. I tested it. But I am having hard time to implement this within Detail View. Any Complete Example (i.e. Form with Subs) will be highly appreciated. I will be glad if this example is based on NorthWind Database. Thanks a lot for your time and efforts. - Sam Tag: connection to access file fails Tag: 129584
  - 13
    - Validating Data using Typed Dataset Hi! All, How can i validate data filling into a typed dataset? e.g. Say I am importing data from a flat file into a typed dataset. I want to validate that each data entering into the dataset are in match with the dataset Schema and if any error i want to log the same row and move to execute the next row. How do I do this?? Regards, Baren Tag: connection to access file fails Tag: 129583
  - 14
    - Datasets fundamental Hi there! I'm very new to dot net envirnoment and have little bit understanding. Due to some reason, I need to work straight forward on datasets and webservices and xml. I don't have much hold on the same but would appreciate if someone put lights on the given questions: a) How datasets which has passed by value can be retreived from cache? b) How would one know whether datasets is containing any records or not? Is there any way to test the same? Please let me know via coding. c) How long datasets will store in server memory? d) How to create a dataset and publish it in cache? Beside this, I do have other questions which will not fall into this group like : 1) How to map datasets records to update a MYSQL Server? Please help me out. With Thanks! Shyam Tag: connection to access file fails Tag: 129581
  - 15
    - PLEASE tell me how to handle RowUpdated with/against a typed dataset I have searched and searched and searched and sear.. anyway, you get the idea. I am trying desperately to figure out how, in "C++/CLI" (Managed C++/2005) to handle the RowUpdated event in my code but can not find an answer that works. I either get the always fun "error C3767: 'FrameWorks::eclipseDataSetTableAdapters::RepairDataTableAdapter::Adapter::get': candidate function(s) not accessible" error, or other various errors. Apparently, my strongly typed RepairDataTableAdapter does NOT expose anything that even looks like RowUpdated. So, given that, I thought ok, I'll do it the hard way, and try to deal with this with untyped .. objects. So I've tried to create an adapter that would expose RowUpdated, but then I wanted to get the existing insert, update, ... commands from my typed adapter so that I wouldn't completely redo all my database code. Well, that didn't work either because those objects are also not exposed. Not even read-only! This is what led to the error above. Is there SOMEONE, ANYONE out there who can tell me how the frell to handle RowUpdated with a typed adapter? I'm begging here. Thanks, Scott "Cmdr. Beavis" F. Tag: connection to access file fails Tag: 129574
  - 16
    - Open DataReader associated with this Command which must be closed first. Hello, I'm getting the a "There is already an open DataReader associated with this Command which must be closed first" error message in the following scenario. The message seems misleading, since the command isn't associated with the datareader, but the connection is. Is there any way to get this work work without closing my DataReader? Thanks, Eric ------- Dim conn As SqlConnection Dim cmd As SqlCommand Dim drTests As SqlDataReader strTestQuery = BuildTestSQL() cmd = New SqlCommand(strTestQuery, conn) drTests = cmd.ExecuteReader Dim iDataRowCounter As Integer = 0 Do While drTests.Read Dim strTest2SQL As String strTest2SQL = BuildTest2SQL() RunUpdateTransaction(strTest2SQL, conn) Loop Private Sub RunUpdateTransaction(ByVal UpdateSQL As String, ByVal conn As SqlConnection) Dim cmdTest As New SqlCommand(UpdateSQL, conn) Try Dim trnTestTest As SqlTransaction trnTestTest = conn.BeginTransaction(IsolationLevel.ReadCommitted, "TestTest") Dim iUpdated As Integer iUpdated = cmdTest.ExecuteNonQuery 'TODO:Change rollback tran to Commit trnTestTest.Rollback() 'trnTestTest.Commit() Catch ex As Exception Throw ex Finally If Not cmdTest Is Nothing Then cmdTest.Dispose() End Try End Sub Tag: connection to access file fails Tag: 129564
  - 17
    - Generating a collection from a data set table Hi, I have a strongly typed dataset with 2 tables: Orders and OrdersDetails, that have a parent-child relationship by OrderId. I want to be able to work sequentually on each row in Orders and in OrderDetails in the following manner: foreach (TableRow HeadRow in Orders.Rows) { ... foreach(TableRow DetRow in OrdersDetails.Rows) { ..... } } My question is how can I make sure the inner foreach works only on the Rows that have the same OrderId (the OrderId from the outter foreach) Thanks Tag: connection to access file fails Tag: 129563
  - 18
    - Good way to do lookups I want to have a a set of "records" (i.e. would have used a Recordset in the VB6 world) that contains a list of say 500 short string values to lookup and then 500 short strings to replace them with when found. What I'm going to use this record set for is to lookup the parts of a street address and replace them with standard abbreviations. What I could use guidance with is the best object to use for this record set which will be used for lookups. Tag: connection to access file fails Tag: 129562
  - 19
    - merge not working I'm trying to handle concurrency updating errors in my app - vb.net 2003, ado.net 1.1. I have a datatable with the data the user pulled and then changed ("dtMain") and another that I filled after the updates failed, with the most current data in the database ("dtConflict"). I am allowing the user to decide on a row-by-row basis how to handle the update. When I try to merge a particular row's current values (from "dtConflict") into the main table ("dtMain") nothing is happening. Here is the code (I added dtMain to a dataset "dsBig" in order to access the Merge method, which is still unavailable to me on a datatable as I'm in ado.net 1.1): Dim row As DataRow = CType(objCurrencyManager.Current, DataRowView).Row Dim rowConflict As DataRow = dtConflicts.Rows.Find(row(0)) if blnPreserve = True then dsBig.Merge(New DataRow() {rowConflict}, True, MissingSchemaAction.Ignore) else dsBig.Merge(New DataRow() {rowConflict}) end if row.ClearErrors() The merge does not throw an exception but neither does it get the new values. This code is basically taken from David Sceppa's Microsoft ADO.NET (Core Reference). Tag: connection to access file fails Tag: 129561
  - 20
    - AutoIncrement and MultiStep OLE DB Hello this error starts to really go o nmy nerves. I Searched the i net but found no solution for it. Maybe you can help. My problem is, that i want to convert an Access-DB into a SQL-Server DB (i cant use the tools, because this should work also on systems which only have the MSDE and no access). The error ocurres when the "AutoIncrement" Property is set to true and i try to add the Table to the SQL-Server-DB (e.g. Catalog). The only solution i found for a similar problem, is that the catalog has to be set prior to the properties are manipulated. I do this, but still it doesnt work. I use MDAC 2.8, SQL-Server 2000 What am i missing??? Thanks Matthias This is the code (C#): protected void CloneColumn(ADOX.Table refTable, ref ADOX.Table destTable, string refColumnName, string destColumnName, ref ADOX.Catalog catDest) { ADOX.Column newColumn = new ADOX.ColumnClass(); newColumn.ParentCatalog = catDest; newColumn.Name = destColumnName; newColumn.Type = refTable.Columns[refColumnName].Type; if (newColumn.Type==ADOX.DataTypeEnum.adDate) newColumn.Type= ADOX.DataTypeEnum.adDBTimeStamp; newColumn.DefinedSize = refTable.Columns[refColumnName].DefinedSize; UpdateColumnProperties(refTable.Columns[refColumnName], ref catDest, ref newColumn, Common.Constant.listOfSupportedProperties, "created"); destTable.Columns.Append( newColumn, newColumn.Type,newColumn.DefinedSize); } protected void UpdateColumnProperties( ADOX.Column referenceColumn, ref ADOX.Catalog catDest, ref ADOX.Column targetColumn, string[] listOfSupportedProperties, string actionMsgString) { Array listOfSupportedPropertiesArray = (Array)listOfSupportedProperties; System.Collections.ArrayList listOfSupportedPropertiesArrayList = new System.Collections.ArrayList (listOfSupportedPropertiesArray); System.Collections.IEnumerator propertyEnumerator = null; propertyEnumerator = referenceColumn.Properties.GetEnumerator(); propertyEnumerator.Reset(); string propertyName = ""; while (propertyEnumerator.MoveNext()==true) { try { for(int i=0;adoConnDest.Errors.Count>0;i++) { string errorStr=adoConnDest.Errors[i].Description; } propertyName = ((ADOX.Property)propertyEnumerator.Current).Name; if(listOfSupportedPropertiesArrayList.Contains(propertyName)) // check the property name with the allowed properties { try { Object oldObj = targetColumn.Properties[propertyName].Value; Object newObj = referenceColumn.Properties[propertyName].Value; if(newObj!=null) { if( newObj.Equals(oldObj)==false ) // check if an update is neccessary { if (newObj.ToString().StartsWith("\"")) { newObj=newObj.ToString().Replace("\"","'"); } targetColumn.Properties[propertyName].Value = newObj; Object changedObj = targetColumn.Properties[propertyName].Value; // for debugging if(oldObj!=null) Common.MessageLogger.getInstance().WriteLogMessageToFile("\tColumn property '" + propertyName + "' ("+oldObj.ToString()+"<>"+newObj.ToString()+") "+actionMsgString+"."); else Common.MessageLogger.getInstance().WriteLogMessageToFile("\tColumn property '" + propertyName + "' (null<>"+newObj.ToString()+") "+actionMsgString+"."); } } } catch(Exception error) { Common.MessageLogger.getInstance().WriteLogMessageToFile("Exception catched during updating property '" +propertyName+"':"+ error.Message); } } for(int i=0;adoConnDest.Errors.Count>0;i++) { string errorStr=adoConnDest.Errors[i].Description; } } catch(Exception error) { Common.MessageLogger.getInstance().WriteLogMessageToFile("Exception catched during updating property '" +propertyName+"':"+ error.Message); } Control.GenericEpxUpdateTool.getInstance().GetMainForm().IncreaseProgressBar(); } } Tag: connection to access file fails Tag: 129559
  - 21
    - Migration from ADO to ADO.Net with SqlClient I am trying to get to terms with the use of updating through a data adaptor in VS 2005. The application allows the user to create forms and add fields and tables to the database and so the code has to be generic. In ADO, one can read the record,change the value and simply update: RecordSet.Fields(FieldName)=SomeValue RecordSet.Update I can update a DataSet in a similar way, but how do I get the chages back to the database? The data adaptor needs an UpdateCommand, but I cant find any information about what this should be like. Any help would be welcome. -- John Austin Tag: connection to access file fails Tag: 129558
  - 22
    - Oracle- and ODBC Provider missing in Visual Studio Express 2005 Hello, I have Visual C# Express 2005 and Oracle 10g installed. After some problems with different versions of Oracle including a restoring of a system restore-point I now have the following problem: When I try to add a data source to my project I can only select Access-File via OLEDB or Local MSSQL Server file via .NET provider. As far as I know there should also be an Oracle and an ODBC Provider available, but they are missing. I tried to install everything new including the NET-2.0-framework, but still the same problem. Somewhere I read, that in the machine.config file the available providers are listed, but there are all 4 present. Does anyone know what to do? Thanks in advance Sascha Tag: connection to access file fails Tag: 129548
  - 23
    - SQL Migration - Varchar 8000 in SQL 2005 Hello, We have migrated a sql server 2000 database to sql server 2005, this was done through scripts (table, stored procedures and data). To access this database we are using an ASP.Net 2.0 application which uses the sqlhelper Aplication Block to connect to the database. Everything works fine except one Stored Procedure which has an OUT varchar(8000) parameter. We use the following .Net Code to execute the stored procedure this stored procedure: aParams[2] = sSerDatos.GetParameter("@DominiosMenu", DbType.String, 8000); aParams[2].Direction = ParameterDirection.Output; sSerDatos.ExecuteNonQuery("VM_SDominiosMenu", aParams) When we invoque the sqlcommand we get this sqlexception: The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Parameter 3 ("@DominiosMenu"): Data type 0xE7 has an invalid data length or metadata length. If we change the DbType.String Size to 4000 in the .Net code everything works, this same procedure works correctly in SQL Server 2000 with the same .Net code. Any help would be appreciated. Thanks, Sam Tag: connection to access file fails Tag: 129542
  - 24
    - How to change encoding for XML Column I am updating an xml column in SQLServer 2005, but it always gives me an error "XML parsing: line 1, character 38, unable to switch the encoding" my csharp is like the following cmd.Parameters.Add("@xml", SqlDbType.Xml); cmd.Parameters["@xml"].Value =xmldata; My xml have the following line "<?xml version="1.0" encoding="UTF-8"?>..." If I remove this line, everything is OK, looks like the SQLParameter is set to UTF-16 and my xml data is set to UTF-8, how do I make SQLParameter take UTF-8? I did not see any properties under SQLParameter to change the encode. Please advice. Thanks in advance. John Tag: connection to access file fails Tag: 129540
  - 25
    - Connection Pool Time Out Hi all, I have the following scenario: App1: Asp.Net Application that shows reports from some SQL DB App2: Asp.Net WebService with two services exposed for clients, and a single â??Checkerâ?? in the Application object that checks every some time (normally 2 or 3 minutes) for conditions in the same DB, and insert some values in it using a transaction. When the time spans completes, the checker retrieves via a SqlDataReader the ready items and make the insertions as shown: SqlDataReader reader = GetReadies(); try { // do something // initialize the transaction â??transâ?? and the connection â??conâ?? try { // insert using the transaction trans.Commit(); } catch(Exception ex) { trans.Rollback(); throw ex; } finally { trans.Dispose(); con.Close(); } } finally { reader.Close(); } In the web application I have few pages that get information from the DB, and after a few retrievals, I got this error: â??Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached.â?? So I review all code searching for unclosed datareaders or connections, for nothing. I use SQLHelper in the web application and I always retrieve datasets, anyway, I checked that all connections were closed. Then I review the code in the webservice app, I think it is correct, isnâ??t it? Even though I didnâ??t found unclosed connections, I started to watch the .Net CLR Data performance object with the object Current # pooled connections. The graph never goes over 7 connections; it oscillates between 5 and 8. I also started a new trace in the SQLProfile to see if it audits logout events occurs. And still, after a while browsing in the asp.net application, I receive the same error. Note: the max pool size is set to 100 explicitly. Any idea of the cause? Thank you very much. Tag: connection to access file fails Tag: 129539

Hi guys,

I added to a form an oldbconnection to connect to an Access file (access
2000), using the wizard I select the MDB file but when i test it i got an
error "Invalid authorization specification".
The user name is the default Admin, and no password.
What am I missing??
the data source is "Microsoft Access Database File (OLE DB)"

TIA

Top

Re: connection to access file fails by Cor

Cor
Sat Jun 10 00:58:58 CDT 2006

Fanor,

It can be an authorization inside the acces table. Typical a problem Paul
Clement is mostly answering.

I don't know if he is in the weekend active, I thought the answer was
already in the first message of this message thread.

http://groups.google.com/group/microsoft.public.dotnet.framework.adonet/search?group=microsoft.public.dotnet.framework.adonet&q=password+paul&qt_g=1&searchnow=Search+this+group

I hope this helps,

Cor

"fanor" <xfponce@hotmail.com> schreef in bericht
news:us0KyQCjGHA.4512@TK2MSFTNGP04.phx.gbl...
> Hi guys,
>
> I added to a form an oldbconnection to connect to an Access file (access
> 2000), using the wizard I select the MDB file but when i test it i got
> an error "Invalid authorization specification".
> The user name is the default Admin, and no password.
> What am I missing??
> the data source is "Microsoft Access Database File (OLE DB)"
>
> TIA
>
>
>

Top

Re: connection to access file fails by Paul

Paul
Mon Jun 12 12:40:30 CDT 2006

On Fri, 9 Jun 2006 20:26:08 -0400, "fanor" <xfponce@hotmail.com> wrote:

¤ Hi guys,
¤
¤ I added to a form an oldbconnection to connect to an Access file (access
¤ 2000), using the wizard I select the MDB file but when i test it i got an
¤ error "Invalid authorization specification".
¤ The user name is the default Admin, and no password.
¤ What am I missing??
¤ the data source is "Microsoft Access Database File (OLE DB)"

This doesn't look like a Jet/Access error. It looks more like an error from the SQL Server provider.

When using the wizard did you select the correct Data Source on the Add Connection dialog. It
defaults to Microsoft SQL Server Database File. You need to click on the Change button to select
Microsoft Access Database file.

Paul
~~~~
Microsoft MVP (Visual Basic)

Top