|
|
|
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 Creating a Package in SQL Server (T-SQL) Posted by Aparna at 3/31/2004 10:56:09 PM Hello
Can we create a new Package in SQL Server (T-SQL). Oracle has the option of creating a new package using 'CREATE PACKAGE'
Is SQL Server has anything similar to this....more >>
ODBC Connection Problem Posted by Brent at 3/31/2004 6:41:08 PM Hello
I have a user who is attempting to connect to SQL Server Enterprise 2000 SP3a running on Windows 2000 Server. The client has WIndows NT 4.0 with MDAC 2.8. The problem is that when I attempt to create the ODBC link , I receive the following error
"connection failed
sqlstate '01000'
sql ...more >>
SQL or FoxPro Posted by Jacky Luk at 3/31/2004 5:48:37 PM Hi all,
Our company currently has no Database servers, neither centralized ones like
SQL Servers or standalone/P2P ones like Foxpro. And in terms of Spreadsheet
programs like Excel, can it take over, because of the data size is quite
small (Excel 2000 with Macros), those database engines? We'm j...more >>
books on odbc Posted by William Kossack at 3/31/2004 9:31:12 AM At one point I had the odbc 3.5 developers guide but I had to leave that
behind as a result of a layoff.
Now after several years I find I'm getting back into odbc but when I
search I find that all books on odbc are out of print. Some are still
available like the 3.5 developers guide but har...more >>
Equivalant Exception for DUP_VAL_ON_INDEX for SQL Server Posted by Aparna at 3/31/2004 3:21:06 AM Hello
We are in the process of migrating the Oracle database to SQL Server. We need the help on the Exception Handling in SQL Server
The existing Oracle stored procedure is using the Exception DUP_VAL_ON_INDEX, which raises when the duplicate values gets inserted in the Indexed column. (typciall...more >>
Login failed for user 'Null' Posted by boydmt NO[at]SPAM yahoo.com at 3/30/2004 10:48:47 AM I'm attempting to connect to a SQL Server named 'SQL1' using ODBC. In
doing so, I receive an error stating the login has failed for user
'null'. I don't believe this to be a SQL permissions issue because
the user in question can successfully connect to 'SQL1' from another
pc. Also, I don't th...more >>
Restricting ODBC access to SQL Server 2000 database Posted by JB at 3/30/2004 6:39:14 AM Is there a way to restrict an ODBC connection to the
database?
I.E. only allow ODBC access to a database if from a
specific VB application. Do not allow the DSN to connect
using Access, Excel, etc.
Thanks,
JB...more >>
Table Locking Posted by SMK at 3/29/2004 3:51:09 PM Is there some fuction that allows me to put different types of locks on a table
For example, I would like to lock a table for writing, but allow other applications to read from the table
Thanks for any help
Steven...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
ODBC error Posted by PorkyJr at 3/29/2004 10:22:44 AM
Problem: I came in this morning, and our SQL server's IP address was
changed from a static to dynamic IP. I changed it back, but not sure if
that is the cause of the problem I am having.
Running some reports in Access 2000 that queries through ODBC to our SQL
Server 2k. We are getting a...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |