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 >>
Don't see what you're looking for? Search DevelopmentNow.com.
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 >>
|