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 >>
Don't see what you're looking for? Search DevelopmentNow.com.
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 >>
|