Archived Months
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
November 2007
all groups > sql server connect > april 2006 > threads for april 8 - 14, 2006

Filter by week: 1 2 3 4 5

"Stored Procedure" working every 5 minute, how?
Posted by Tark Siala at 4/13/2006 7:59:41 PM
hi i working on SQL2000, and want to make "Stored Procedure" that's working every 5 mibute, without making any calling. how i can make that ? -- Best Regards Tark M. Siala Development Manager INTERNATIONAL COMPUTER CENTER (ICC.Networking) Mobile: +218-91-3125900 E-Mail: ...more >>


SQL.Net connection in VS2005 from local IIS to local SQLExpress
Posted by harry at 4/12/2006 11:19:35 AM
Suddenly my trusted connection no longer works in VS. I try to create a new one and recieve this: "Database schema could not be retrieved for this connection. Please make sure the connection settings are correct and the database is online Login failed for user ''. The user is not associated ...more >>

ISQL query fails after reboot
Posted by Richard Tracy at 4/12/2006 7:50:02 AM
Good morning we are having a wierd issue with our Windows 2003 server and SQL 2000 sp4 server. From the client side we use isql queries. When we reboot the server the isql queries that are larger then 512 bytes will fail from both the client or from the sql server itself smaller ones will wo...more >>

Linked Server Error
Posted by madeelaslam at 4/12/2006 12:29:01 AM
DearAll group menbers, I am using SQL Server 2005 and 2000. I want to link SQL Serve 2005 with 2000. When i use linked server configuration i get this message. OLE DB provider "SQLNCLI" for linked server "linked_server_name" returned message "Login timeout expired". OLE DB provider "SQ...more >>

Connecting to SQL Server Express in XP Home
Posted by McHenry at 4/11/2006 4:19:22 PM
I have SQL Server Express up and running on a PC, accessed via an ADP I would like another PC on the LAN to do the same. On the local machine everything works well, however the other machine cannot connect. I am using a trusted connection and the remote machine appears to be trying to c...more >>

::FN_DBLOG() - Problem in retreiving [row data]
Posted by Hillel at 4/11/2006 8:21:16 AM
Subj: ::FN_DBLOG() - Problem in retreiving [row data] Hello While attempting to retrieve [row data] column using ::FN_DBLOG an empty '0x' value is passed back: select [Current Lsn], [row data] from ::fn_dblog(null,null) The retrived record does contain row data. It can be seen when usin...more >>

CurrentProject.IsConnected is reporting on what?
Posted by SteveInBeloit at 4/11/2006 7:49:02 AM
Does CurrentProject.IsConnected tell me that the ADP is connected to the SQL database, or that it sees the network? I have an ACCESS ADP connecting to a SQL db via a wireless network. I thought I would check CurrentProject.IsConnected to see if I had lost connection due to out of wireless ...more >>

#Deleted appears in all SQL2000 linked tables in Access2003
Posted by Seth at 4/11/2006 5:39:01 AM
I have a database on a SQL2000 server that I am trying to connect for viewing in Access 2003 with the client running Windows 2000. I have created the connection, but when I try to view the tables, I get "#Deleted" in all the rows, for both tables. I installed the latest MS Jet Driver to no a...more >>



Re-establishing link to SQL from ACCESS XP (wireless)
Posted by SteveInBeloit at 4/10/2006 1:40:02 PM
Hi, I am developing an ACCESS ADP that links to MS SQL, the SQL is on a server, the ACCESS links to it via a wireless network. When it goes out of wireless range, I will lose the link to the database. Is there a standard way to have it re-link effortlessly (quickly) when it comes back into ...more >>

?? Turning Off TCP/IP Client Has No Effect ??
Posted by Alan Foxmore at 4/10/2006 1:38:29 AM
Hi Everyone, I was doing some testing with client configuration and I'm seeing something I don't understand. Let me explain the setup. My setup involves a single machine running "SQL Server Express 2005". As you probably know, SSE includes the "SQL Server Native Client". I run the "SQL Serv...more >>


DevelopmentNow Blog