Archived Months
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
April 2007
May 2007
June 2007
July 2007
August 2007
November 2007
March 2008
all groups > dotnet odbc.net > recent posts

OleDbCommandBuilder generated statements
Posted by Nico at 4/17/2008 3:31:05 PM
Hi, here is my situation: I fill up a dataset with two tables(with already data in it) inside. I attach this dataset to a dataadapter so I can write any inserted objects in the dataset into my database. Then I use the OleDbCommandBuilder to get an insertcommand based on the selectcommand. Th...more >>


GC.Collect() not cleaning memory, how to find out what references to lots of memory still exist?
Posted by DR at 4/15/2008 2:03:55 PM
GC.Collect() not cleaning memory, how to find out what references to lots of memory still exist? When all my processign is done i set everything to null and then: GC.Collect(); and then GC.WaitForPendingFinalizers(); but it still shows that my process takes 400 MB of memory. Is there any ea...more >>

PerformanceCounterCategory.Create() takes 3 minutes to add a new category!! How come? What can cause this?
Posted by DR at 4/10/2008 12:25:44 PM
PerformanceCounterCategory.Create() takes 3 minutes to add a new category!! How come? What can cause this? ...more >>

RE: Intermittant Access Violation reading Oracle CLOB column
Posted by v-wywang@online.microsoft.com ( at 4/1/2008 11:04:16 AM
Hello Metro, Have you resolved the issue so far? We haven't heard from you a couple of days. If the issue still persists, could please let us know which odbc driver you are using in the application? In my opinion, this should be an ODBC driver issue. Please feel free to let us know, if ...more >>

RE: Intermittant Access Violation reading Oracle CLOB column
Posted by v-wywang@online.microsoft.com ( at 3/28/2008 11:13:45 AM
Hello Metro, As far as I know, System.Data.Common.UnsafeNativeMethods.IRowset.GetData() method will call ODBC driver to retrive data from oracle database. This issue should related with Oracle Db Driver. Could you let me know which odbc driver you are using for connection Oracle database? ...more >>

Intermittant Access Violation reading Oracle CLOB column
Posted by Metro Sauper at 3/27/2008 7:14:35 PM
We have an application that gets intermittant access violation errors reading from an Oracle table that contains a CLOB column. If the application runs again, with no changes, it will run to completion. The problem is not associated with a single table. We have gotten it on different tables. ...more >>

Intermittant Access Violation reading Oracle CLOB column
Posted by Metro Sauper at 3/27/2008 11:05:37 AM
We have an application that gets intermittant access violation errors reading from an Oracle table that contains a CLOB column. If the application runs again, with no changes, it will run to completion. The problem is not associated with a single table. We have gotten it on different tabl...more >>

How to create a dbf file so that it can be opened in Excel
Posted by sahil at 3/27/2008 1:07:33 AM
Can any one please help me out. I am creating a dbf file for FoxPro with this connection m_ConnOLEDB = new OleDbConnection("Provider=Microsoft.Jet.OLEDB. 4.0;Data Source=" + strIniOutPath + ";Extended Properties=dBASE IV"); strCreate = "Create Table " + strDBFName + "("; ...more >>



ODBCConnection.Close() takes 2 hours
Posted by Lawrence at 3/5/2008 2:20:00 PM
Hello, this is my first question here, my apologies if this is the wrong forum. I'm working on a application that uses ODBC connections to a remote Informix database. Once in a while my logs indicate that an OdbcConnection.Close() command takes 2 hours to return. That's exactly 2 hours to ...more >>

MySQL - Error on adding a new data source
Posted by Vanessa at 2/21/2008 12:15:03 PM
Hi All! I'm working on Visual Studio 2008 Pro and when I add a new data source from a MySQL database via ODBC I get the following error: <'table'..'field'> Could not get column information for database object named 'table'..'field' Does anyone have this problem? What could I do to so...more >>

MAINFRAME Training with IBM Certification and JOB GUARANTEE:
Posted by harsha at 2/20/2008 9:05:28 PM
MAINFRAME Training with IBM Certification and JOB GUARANTEE: Mainframe industry has shortage of people. Mainframe Education gives you the competitive advantage you'll need to succeed in an exciting, leading-edge career in Enterprise Systems. KASSHKU is proud to announce Mainframe Training ...more >>

Can not connect to MYSQL - Enterpriseservices.wrapper.dll error
Posted by DavidProgrammer at 1/15/2008 11:36:03 AM
I have a vb.net app that has been running for several months. This week, it will not start up on any of the forms that connect to the MYSQL database except for Crystal Reports which still works fine. When I try to load the data into a data adapter, I get the message: Can not load file or assembly...more >>

.net-Oracle 9i compatibility
Posted by Techeek at 1/6/2008 7:57:00 AM
I wanted to know if .net code can extract the oracle error code and error message that an SP returns from Oracle 9i. I mean to say in my SP if i raise an exception by raise_application_error how will the .net Data Access layer extract the SQLERRM and SQLCODe from the SP ? -- techeek http://...more >>

RE: VFPODBC.DLL: "ERROR [S1000] [Microsoft][ODBC Visual FoxPro Driver]Variable ' ' is not found."
Posted by MichMat at 12/23/2007 12:55:50 AM
I have the same exact problem, has anyone figgured out the solution From http://www.developmentnow.com/g/22_2004_12_0_0_10054/VFPODBC-DLL-ERROR-S1000-MicrosoftODBC-Visual-FoxPro-DriverVariable----is-not-found-.ht Posted via DevelopmentNow.com Group http://www.developmentnow.com...more >>

lalonde
Posted by Michael Lalonde at 12/14/2007 3:40:50 PM
Michael Lalonde was friends with his mum after winning the lottery and almost got killed by an army of birds because his leg hurt and everyone felt very sympathetic. Then Michael Lalonde ran around like a lunatic, he went around killing rats with plastic bombs and as if it were a miracle he ...more >>

Reading trailing spaces in csv file
Posted by NInad at 12/6/2007 1:08:00 PM
I am reading a .csv file using ODBC driver in .NET System.Data.Odbc.OdbcConnection conn; System.Data.Odbc.OdbcDataAdapter da; DataTable dt = new DataTable(); string connectionString = @"Driver={Microsoft Text Driver (*.txt; *.csv)};Dbq=c:\Work;FMT=CSVDelimited;"; conn = new System.Data.Od...more >>

Enfin une salle de réception spacieuse
Posted by satfever@msn.com at 12/2/2007 3:19:14 PM
Pour toutes vos fêtes, anniversaires, mariages, ainsi que tous événements privés. Tels séminaires, conventions... Une salle spacieuse, toute équipée à votre disposition. Contenance de 20 à 300 personnes assises. Demandez votre dossier complet et gratuit par e mail. Contact : satfever@msn....more >>

Enfin une salle de réception spacieuse
Posted by satfever@msn.com at 11/19/2007 11:25:11 AM
ca y est, elle est enfin accessible à tous. Une salle de réception ou de concert pouvant acceuillir jusqu'à 250 personnes assises. Pour plus d'infos et un dossier complet, nous contacter à satfever@msn.com <center><table border="0" cellpadding="0" cellspacing="0" style="border-collapse: coll...more >>

Re: odbc version info hard to find
Posted by Laurenz Albe at 11/6/2007 9:00:21 AM
In comp.databases.postgresql Joe Stateson <jstateson@swri.edu> wrote: > I wish to put the version numbers of various drivers in an about box for my > web app. I can easily find the sql server version from a connection: > [...] > > However, there is no version for the odbc driver. I was ex...more >>

odbc version info hard to find
Posted by Joe Stateson at 11/5/2007 3:13:58 PM
I wish to put the version numbers of various drivers in an about box for my web app. I can easily find the sql server version from a connection: OdbcConnection oc = new OdbcConnection(WebConfigurationManager.ConnectionStrings["acqlibdbConnectionString"].ToString()); oc.Open(); string strV...more >>

Unable to start TSQL Debugging. Could not attach to SQL Server Process on 'srvname'. The RPC server is unavailable.
Posted by DR at 10/24/2007 7:38:36 PM
Unable to start TSQL Debugging. Could not attach to SQL Server Process on 'srvname'. The RPC server is unavailable. I get this error when I try to run a SQL Server Project with a CLR stored Procedure in it. The target DB is SQL Server 2005 and im using VS 2005. I simply create a new SQL Ser...more >>

ODBC access to a 2.5 native Navision DB (technical 3.7)
Posted by jhlarsen NO[at]SPAM gn.com at 10/22/2007 12:00:00 AM
Hi I need to connect to an old Navision database through ODBC. Does anyone know what I need to do/install? Thanks John ...more >>

Fatloss computer program
Posted by Angel vasquez at 10/15/2007 7:29:06 PM
I have been using this computer program for a couple weeks now and i am very pleased with the results so far. its a software fatloss program, if your looking for a diet/weightloss plan i reccomend you check this place out first: http://fatloss9.50webs.com ...more >>

HP Desktop for sale!
Posted by pbdude at 10/14/2007 4:03:39 AM
Hi, I have an unused HP Pavilion with the fallowing specs: # Processor: AMD Athlon 64 X2 4000+ (2.1GHz, 2000MT/s System Bus) # Memory: 2048MB PC2-5300 DDR2 SDRAM memory (2x1GB) (expandable to 8 GB (4 x 2 GB) (64-bit OS)/ 4 GB (4 x 1 GB) (32-bit OS)) # Hard Drive:320GB 7200RPM SATA 3G (3.0 Gb/s...more >>

ODBC and autocommit
Posted by Mads Bondo Dydensborg at 9/21/2007 12:37:14 PM
Hi there Does anyone know: What is the correct behaviour of an ODBC driver, if an transaction is started, and autocommit is enabled? I have a driver, that turns off autocommit, when a transaction is started, but does not enable it, when transactions are through. Is that correct? An...more >>

Re:retrieving list of tables
Posted by connection at 9/16/2007 9:58:00 PM
"J T" wrote: > I needed the same thing, and this post helped me. > > thanks > Jd > ...more >>

ODBC questions - Infopath - MsAccess Purchase ORder project
Posted by Stav at 8/20/2007 3:14:05 PM
I started a purchase order project that will allow a few employees to access a purchase order over the network. They will each be running infopath as their client. Each employee also has MS Access 2003 or 2007 installed on their PC's. I'm new at INFOPATH but I easily created a purchase o...more >>

Re:retrieving list of tables
Posted by J T at 8/8/2007 2:27:20 PM
I needed the same thing, and this post helped me. thanks Jd...more >>

Summing up numeric values using Oracle or T-SQL query
Posted by deepak at 8/6/2007 5:04:02 AM
Also, the <InProgress> tag can be on any place like Tag 1: <S><Unassigned>3</Unassigned><Assigned>1</Assigned><Dispatched>20</Dispatched><Jeopardy-NotAccepted>74</Jeopardy-NotAccepted><Accepted>1073</Accepted><InProgress>6424</InProgress></S> Tag 2: <S><Unassigned>3</Unassigned><Assigned>...more >>

Summing up numeric values using Oracle or T-SQL query
Posted by deepak at 8/6/2007 4:32:02 AM
Hi All, How to sum up the following numeric numbers in <In Progress> tag using T-Sql or Oracle query.There are thousands of tags rows in a column in the table. i need sum of numeric value present in the <InProgress> tag e.g. 2 tags shown below Tag 1: <S><Unassigned>3</Unassigned><Ass...more >>


DevelopmentNow Blog