|
|
|
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 |
Client-Side Database Mirroring Details Posted by GMouzourou at 7/27/2006 5:43:03 AM Hi,
I've been tasked with investigating different methods of achieving database
redundancy.
In doing so, I'm currently in the process of writing a test application to
prove that Database Mirroring in SQL Server 2005 is a suitable solution.
Of the established requirements I'm finding dif...more >>
SQL Server 2005: Cannot convert {fn CURDATE()} to "datetime" datatype Posted by Michael Bruegmann at 7/25/2006 4:09:23 PM Hi,
trying to use a simple statement "select * from example where fromdate <=
{fn curdate()}" and getting error 242.
The column "fromdate" in table "example" has the "datetime" datatype.
so why the conversion is not possible?
greetings
Michael Bruegmann
Nord-Soft GmbH
...more >>
SQL Server 2005: Why those "GetData" and "Transaction" restrictions? Posted by Michael Bruegmann at 7/24/2006 5:31:49 PM Hi,
I am a software developer trying to get an application run against SQL
Server 2005. The application once was written to connect to IBM DB2, Sybase
ASA or Oracle via ODBC. Now a new customer wants it to run with SQL Server
2005.
I have problems with two ristrictions of SQL Server 2005...more >>
SQLPrepare with SQLFetchScroll???? Can it be done? Posted by kjuliff NO[at]SPAM gmail.com at 7/24/2006 2:30:43 PM The snippet of example code below os how I'm setting up a select with
a where clause.
I don't want to have a loop to get all the rows and I read about
SQLFetchScroll. But for the life of me I can't work out how I can get
all the qualifying rows from this SQLFetchScroll.
It seems to me tha...more >>
SQLBindParameter - parameters 8 and 10 Posted by kjuliff NO[at]SPAM gmail.com at 7/21/2006 3:52:05 PM I'm new to UNIXodbc but I would like to find a simple example of a row
returned from a select
This is my code
long fnum;
........
<other relevant statements here>
ret = SQLPrepare(stmt1,"SELECT filename from picfiles where filenumber
= ?", SQL
_NTS);
ret= SQLBindParameter(stmt1, 1, S...more >>
Connectivity to FoxPro (dbf) from SQL 2005 on x64 Windows 2003 Posted by Paul in Denver at 7/21/2006 10:58:01 AM I have installed SQL Sever 2005 on an x64 bit machine running Windows 2003.
When I go to the ODBC Data Source Administrator, and click on the Drivers
tab, it only shows:
SQL Native Client
SQL Server
I would like it to show the "other" drivers that I see in other
installations - to connec...more >>
HELP!!! - Problem with hints... Posted by segis bata at 7/19/2006 11:44:01 AM Hello everyone,
I'm having this problem, I'm trying to run a query that consists of six
tables and one view (all joined together)
When I run it without anything on the where (or just one criteria in the
where clause) works just fine, but if I run it with two criteria in the
where clause ...more >>
Cannot make ODBC connection to SQL Express 05 Server from Win 2000 Server Posted by Hiltie at 7/13/2006 6:17:27 PM I've got a web server running Windows 2000 Server that I need to make an
ODBC connection to a new SQL Express 2005 server running on Windows Server
2003. Using every logical combination I can think of I cannot make an ODBC
connection from this web server. I've tried this from another server on...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Linked View to SQL Server DB Posted by Outdone at 7/5/2006 7:23:02 AM I am using a linked view created in the SQL Server database. However, when I
run it I get the following error.
ODBC--call failed.
[Microsoft][ODBC SQL Server Driver]Invalid character value for cast
specification (#0)
The help for this message indicates that it may be a network proble...more >>
Query constantly failing. Posted by Jonny at 7/5/2006 4:41:02 AM Hi Guys,
I am trying to do a simple bill run on one of our SQL servers and it keeps
terminating prematurely with the following error:
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead (recv()).
Server: Msg 11, Level 16, State 1, Line 0
General network error. Check your network do...more >>
Issue in binding a varchar field to a structure element Posted by Uma - Chellasoft at 7/5/2006 12:00:00 AM Hai,
I am working with VC++ console application. For SQLServer DB accessing, I am
using ODBC connectivity.
I am facing problem while binding the columns of the result set to
individual elements of the structure.
For example,
struct Sample
{
char e1;
short e2;
}s1;
For ...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |