| 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 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 Altered SQL table locked for edits in Access 2002 front-end Posted by Bek at 12/20/2003 1:53:56 PM I have altered SQL tables and then relinked them to a
Access 2002 front-end and receive the following
message "The Microsoft Jet Database engine stopped the
process because you and another user are attempting to
change the same data at the same time"
When the SQL table is altered there ar...more >>
uninstall sql server odbc driver Posted by Anthony at 12/20/2003 9:55:11 AM How do i uninstall the sql server odbc driver? After
having uninstalled microsoft sql server 2000, its odbc
driver is still there and it is conflicting with other
pieces of software on my machine
thanks...more >>
ODBC LIKE clause does not work - SQL Server *BUG* Posted by Angelo Kalpakis at 12/20/2003 8:01:49 AM Hi All:
I think there is a problem with the LIKE clause in a
SELECT statement. I am using the latest SQL Server 2000
(ver 8.00.760) and Visual C/C++ 6.00 (with SP3) on
Windows XP.
I created an ODBC connection and tied into a database
containing a customer table. The following piece of ...more >>
Error in restoring database Posted by Jun at 12/20/2003 1:17:08 AM Hi!
I would like to ask for help regarding the error message
that I always encounter when I'm trying to restore a
database:
ODBC SQLState: 42000
The database you are attempting to restore was backed up
under a diffferent sort order ID (205) than the one
currently running on this serve...more >>
Linked Server and Distributed Transactions Posted by Mark at 12/19/2003 11:47:08 AM We have a developer that is trying to do a distributed
transaction using a View that in turn uses a Linked
Server.
The Linked server is the MSSQL 2000 server, so both
databases reside on the same server.
She is receiving the following error:
[Microsoft][ODBC SQL Server Driver][SQL Server]...more >>
Non blocking query on a table in SQL Server 2000 Posted by Vishal Prabhu at 12/19/2003 11:31:41 AM Hi Folks,
How can I invoke a non blocking ODBC query on a table in a SQL Server
database. Our current design requires the method invoking the query to
'return' immediately after invoking the query. The results of the query
should be put in a globally accessible location.
I think SQLFetch is...more >>
Non blocking query call Posted by vprabhu NO[at]SPAM uci.edu at 12/19/2003 11:18:43 AM Hi Folks,
How can I invoke a non blocking ODBC query on a table in a SQL Server
database. Our current design requires the method invoking the query to
'return' immediately after invoking the query. The results of the
query should be put in a globally accessible location.
I think SQLFetch is...more >>
=> Table Properties - Data in table read only Posted by Rhpnda Fischer at 12/18/2003 5:55:56 AM Hello,
============================================
(1) I have added a new table to my database:
============================================
CREATE TABLE SupplierComments
(
supplier varchar(30) NOT NULL REFERENCES Suppliers
([supplier]),
comments varchar (256),
supplierCmtDat...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Sql Server Timeout expired Posted by indika Gamage at 12/17/2003 10:50:52 PM Hi
i'm trying to connect to sql server from client pc, every time gave me
msg Unable to connect to server [XXXXXX]
ODBC : Msg 0 ,Level 16 , state 1
[Microsft][ODBC: SQL ServerDriver] Timeout Expired
Pls help !!!
*** Sent via Developersdex http://www.developersdex.com ***
Don't ...more >>
Turn Off Temporary Stored Procedures on 6.5 Posted by Nick DeVore at 12/16/2003 8:36:03 AM Hi,
I have a unique (don't we all) situation with Macintoshes talking to my SQL
6.5 server using the very old Visigenic's drivers. Anyway, the problem is
that the driver is ignoring the "UseProcForPrepare" flag so all my Macs are
creating session temporary stored procedures. Needless to say ...more >>
ODBC Setup Posted by Rajesh at 12/15/2003 11:52:17 PM I have downloaded MS SQL Server for Desktop to upsize my
access database to SQL Server database.
The upsizing is successful and when I setup the DSN
connection. It gives the following error :
Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D)
[Microsoft][ODBC SQL Server Driver][S...more >>
SQL Server 2000 & ODBC Connection Posted by HELP at 12/15/2003 11:19:19 PM When creating a new DSN conection to SQL Server 2000 using
SQL Server Authentication, user databases do not show up
in the default database list. How ever I can access user
databases with SQL Authentication login through SQL
enterprise and Query analyser. Please advice....more >>
Req: how to deploy a SQL Client Alias to multiple clients Posted by Silvio Accomando at 12/15/2003 8:51:15 PM Hi there,
I'm looking for a quick way to setup/deploy an SQL alias on multiple
clients?
Due to an hw upgrade, we are moving our cluster to a new server, and we need
to setup on multiple clients a new SQL Client Alias and an ODBC System DSN.
I found that Sql Client Alias configuration are st...more >>
COM+ won't accept Identity for Admin account Posted by Tom at 12/15/2003 2:56:17 PM People haven't answered my post on 'dev.component', 'programming.component',
etc. I don't know where else to post this..
Hello.
Somehow my Component Services is all messed up on our productions site.
Normally, in test and all other environments I need to click "Identity" in
Com+ and put ...more >>
[Microsoft][ODBC SQL Server Driver]Timeout expired Posted by Siva at 12/15/2003 2:44:10 PM Hi,
Our web applications are using COM objects to call sps in
SQL server. We are getting a lot of timeout errors. If
you know why this happens and any fixes pls let me know.
The error looks like following:
[Microsoft][ODBC SQL Server Driver]Timeout expired...more >>
Runtime Error 3197- ..... Same data at the same time Posted by Synergy at 12/15/2003 9:43:44 AM I have an unbound form to add new inventory items to a table. With the
Access Backend this was fine. Now the backend is SQL Server. The Field
[invID] was orignally a Primary Key/Auto Number field in Access. It is now
an Int field. I also added a field sqlID as a Primary Key Identity Insert
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |