|
|
|
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 DSN and ODBC Posted by skc at 6/21/2004 7:08:16 AM A user creates forms in dBase5.7 and now uses a SQL2000
database on our network to access tables via dBase.
He has made an application that requires an ODBC DSN
(System DSN) to be created on the local machine and this
gets posted to a config file called BDE Configuration
(part of dBase) a...more >>
Rowguid Posted by Helen Stein at 6/18/2004 11:41:08 AM Rowguid column ( globally unique identifier) was added to all tables in the
database. What may cause that?
Thanks for help in advance.
...more >>
Added text field to database. New entries not equal to "" ??? Posted by Noozer at 6/17/2004 8:11:20 PM Hi!
I'm accessing an MS Access database from an ASP server.
I just added a new text column (field) to one of my tables. I have not added
any data to this new field in any of the rows.
I read the field in and compare it to "" and it's coming up as false.
How do identify the empty fields?...more >>
Connect Access to SQL Server AND Local ODBC Connection Posted by Shawn Oatley at 6/16/2004 8:27:05 PM I have a customer that wants me to create a database and use a back end of
SQL Server (hosted on the Internet for his site). This would normally be
easy to create the front end with an ADP and continue life as normal. But,
in order to connect his accounting program to this program that I am
cr...more >>
Invalid Cursor State Posted by George at 6/16/2004 6:47:09 PM Hi all.
I have a procedure in my database whose code is more or less the
following:
CREATE PROCEDURE Fnt ( @Name nvarchar(20) ) AS
declare @number1 int;
declare @number2 int;
CREATE TABLE #Table1
(
ValueRet int,
)
set @number1=(select SUBSTRING( pol, 1 , 2 ) from table where...more >>
.NET Performance - Native vs OLE DB Posted by Robby White at 6/16/2004 6:33:02 PM Using a local instance of SQL Server 2000 and .NET I have managed to insert 4000 rows across multiple tables using the OLE DB provider in 11 seconds but when using the native provider it takes 13 seconds.
I was under the impression the native provider should enhance performance not decrease it? ...more >>
ODBC connection to a seperate machine Posted by Steve Grosz at 6/16/2004 10:35:31 AM I'm curious, can you set up a ODBC connection on one server, that points
to another computer on the network where the database is? I've tried
the computer name as //server2, but it doesn't seem to find it, yet, I
can get to it via the RDC within WinXP Pro.
Thanks,
Steve...more >>
SQL 2000 ERROR Posted by aniruddha at 6/15/2004 4:18:13 AM
Hi
I'm running peoplesoft 8.8 on MS-SQL 2000 SP3. When I try
to access my peoplesoft application I get some error like
"SQL error. Stmt #: 651 Error Position: 0 Return: 8601 -
[Microsoft][ODBC SQL Server Driver][SQL Server] fetch: The
fetch type refresh not allowed with forward only curso...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
|
| home · blog · groups | Questions? Comments? Contact the dn |