| Groups | Blog | Home |
|
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 |
Connections Posted by Juan Carlos at 12/23/2003 8:50:46 AM Hi
I'm testing the connection's states to check if my
application has to reconnect again and I'm in doubt
because when I restart the server or stop DB's service my
connection keeps open.
What does it happen?? I suppose that my connection would
be broken or closed.
Regards...more >>
dBASE webservice Posted by Sander at 12/19/2003 12:23:24 PM Hi,
I'm trying to access a dBASE database from my webservice. When debugging the
webservice in my browser (on the server) everything works perfectly.
However when I try to use the webservice from my console application, I
don't seem to have sufficient rights to create a lock file, hence this
...more >>
SQL Server Desktop Installation Posted by Curt Emich at 12/17/2003 9:39:53 PM I recently bought a copy of Visual C#.NET Deluxe Learning addition. I was
under the impression that this comes with SQL Server Desktop Engine. I
installed everything I should have (I think), but when I type the commands
to grant access to SQL at the DOS prompt, it tells me that SQL Server
does...more >>
Could not find installable ISAM Posted by dave at 12/17/2003 8:14:24 AM I am trying to open a Excel spreadsheet with the
following code:
Dim strConn As String
= "Provider=Microsoft.Jet.OleDb.4.0;" _
& "datasource =
C:\Inetpub\wwwroot\Metrolina\Data\Metrolinatest.xls;" _
& "Extended Properties=Excel 8.0;"
Dim objConn As New OleDbConnection(s...more >>
Problem with Microsoft.Data.ODBC and connection pooling Posted by Mac at 12/16/2003 2:33:43 PM Hi,
I have a data component which takes the logon details from a web app and
appends them to a dsn which I use as my connection string.
A connection is then opened, a small query executed, then closed. I have
disabled connection pooling for the database driver in question.
try
{
//Open ...more >>
fail to connect informix by odbc.net, but i can do it through ado Posted by sky at 12/15/2003 10:29:30 PM a strange question, i can connect the informix database in
visual basic 6.0, the driver is informix cli 2.5, ado 2.6.
but i can't connect by odbc.net, the same db server, the
same odbc driver, so much as i can't connect by ado, not
ado.net in vs.net, but i can see the data in server
expl...more >>
Disposing of connections Posted by Peter Jones at 12/12/2003 12:06:23 PM Our RDB database is running out of connections so I have inserted a
finalizer and implement IDisposable in a data layer class to dispose of all
ODBC data connections. These seems to fix the problem - the connections
correctly drop. HOWEVER, on testing, every 2nd time the dispose code
executes,...more >>
Connections and Commands Posted by Robby at 12/9/2003 4:37:44 PM I am creating a model for generic connections and
commands, and at this level there doesnt seem any
difference between a command wether its oracle, odbc,
oledb or sql, can I just use the idb interfaces directly
to access varying clients rather than accomadate all the
client types.
for e...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Generic Connection String Posted by Tim Marsden at 12/8/2003 12:35:38 PM Hi,
I need to present the user with a list of Tables from a database.
After they have selected the table I need to present them with a list of
Fields.
After they select the Fields they require, I need to use an ODBCDataReader
to retrieve the Data. It NEEDS to be an ODBCDataReader.
I cannot...more >>
You cannot use an OLE DB provider for ODBC drivers. Posted by Corey M at 12/7/2003 1:23:17 PM I can create a data connection in the Server Explorer to
MySQL databases, using the "Microsoft OLE DB Provider for
ODBC Drivers" and have installed ODBC.NET. Test
Connection verifies the ability to connect. I cannot see
my databases using any other providers. Things get weird
here, and ...more >>
output parameter problem Posted by karahan celikel at 12/1/2003 1:03:31 AM When I try to execute a command using ODBC.net provider, it gives the
following error:
{"ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1:
Incorrect syntax near '('." }
Code:
OdbcConnection conn = new OdbcConnection("DSN=...");
conn.Open();
OdbcCommand cmd = new...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |