|
|
|
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 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 |
Filter by week: 1 2 3 4 5 SQL datetime to C tm Posted by Leon McCalla at 11/21/2003 10:29:44 PM can I import a datetime field from SQL to a tm structure without going to a
string first?
ODBC mentions timestamps and SQL uses datetime. I'm having difficulty
understanding what I should do to import/export from a C tm structure to an
SQL datetime field and visa versa. right now I have to con...more >>
connection going to sleep?? Posted by Steve at 11/21/2003 1:50:57 PM Ok, here's the scenario. On a Windows 2003 Server I have MSSQL 2000
installed. On another test server I have Windows 2003 server, IIS 6 and
Coldfusion installed. There has been an account created in SQL and assigned
permissions. My coldfusion web site makes multiple calls to the database
ser...more >>
Uncommitted Reads via ODBC Posted by MarkTiller at 11/20/2003 6:05:37 AM Hi All,
Does anybody know a way to get an ODBC connection (or SQL
Server User) to do all it's reads uncommitted short of
rewriting all the Select Statements (This is what I'm
trying to avoid)
Any help greatly appreciated.
Regards
Mark...more >>
Again on date data-type Posted by Villi Bernaroli at 11/19/2003 5:43:14 PM Is it possible to receive empty dates instead of 01-01-1900
for NULL date fields (since SQL server does not accept empty
date fields)?
I'm receiving 01-01-1900 instead of empty date, otherwise
I can receive NULL values but I can not use them due to
my environment.
I tried with the ISNULL SQL s...more >>
How to get value of identity autoincrement field from SQL seerver Posted by Villi Bernaroli at 11/19/2003 5:32:13 PM Hi
I'm using a VFP8 cursoradapter to connect to a remote SQL server
database via ODBC. I have a cursor which comes from a single
table in the SQL server DB, and this table contains an identity
(autoincrement) field. This table has not a unique index, apart
from the identity field.
When I add a...more >>
SQL DMO error Posted by Ionut Ceausu at 11/19/2003 3:01:17 PM I want to make a backup of an sql server using sql dmo. When I execute this
line I obtain the 80040c81 error .
hr = m_pBackup->SQLBackup(server.m_pSrv);
I search all over the internet byt this error code is not documented
..Anybody have any ideea?
P.S On other machine work fine....
...more >>
Linked Table Manager Posted by Andrew Agbay at 11/19/2003 12:21:45 PM I have SQL tables linked in Access and they work fine.
However, if I run the linked table manager on the SQL
tables, I am informed that the links refreshed. When I
open the tables, they are read-only. If I delete the
tables and re-link them, they work fine again.
Any ideas why this occur...more >>
ODBC to SQL2000 & Crystal Reports 8.5 (left outer join) Posted by Josh at 11/19/2003 10:56:37 AM I'm having a problem understanding why my left outer join
in a crystal reports isn't returning expected results.
According to documentation in crystal and sql a left outer
join will return all the records in the left table
regardless if there is or isn't a match in the right
table. Below...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Help Request PLEASE =8^0 ODBC connection failed (to sql tables) Posted by Maureen at 11/18/2003 10:43:11 PM Hello all,
I am struggling to reconnect an Access97 mde file from our EDI application
to a new sql database I have created a system DSN and manually linked the
tables removing the "dbo_" Of the 12 linked tables 10 open fine
(querys/forms realted to them are operating without error) The other...more >>
Problem with Access 2000 Front-end & SQL 2000 Back-end Posted by Mike Edwards at 11/18/2003 12:49:14 PM Further to my post on a problem on connectiong to SQL 2000 database's using
Access 2000 as a front-end (see below), as the Access 2003 version is
working correctly, should the Access 2003 Runtime version with the developer
extensions work in just the same way ?
Anyone using Access 2003 Runtime...more >>
odbc performance Posted by eddie wang at 11/18/2003 12:08:34 PM #1. We have the ASP here on Houston server and it takes
about 15 seconds to retrive 50 row table from Oklahoma via
MS ODBC driver for Oracle 2.5.
#2. But, we have the ASP here on Oklahoma server and
it only takes about 3 seconds to retrive same 50 row table
from Oklahoma via MS ODBC d...more >>
how to get the number of rows returned by a select statement in SQL server 2000 Posted by Vishal Prabhu at 11/17/2003 2:44:29 PM Hi,
How can I determine the number of rows returned by a select statement in
SQL server 2000? I do not want to use ' select count(*)...'
the code would be -
retcode = SQLExecDirect(hstmt, (SQLCHAR *)sql_stmt, SQL_NTS);
/* get row count*/
// code to get the number of rows selected.
w...more >>
how to determine the number of rows returned by select statement in SQL server 2000 Posted by vprabhu NO[at]SPAM uci.edu at 11/17/2003 2:39:08 PM Hi,
Is there any way I can determine the number of rows returned by a
select statement without using ' select count(*)...'
the code would be -
/* sql_stmt - a select statement.*/
retcode = SQLExecDirect(hstmt, (SQLCHAR *)sql_stmt, SQL_NTS);
/* get the number of rows retrieved.*/
// co...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |