|
|
|
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 |
How do I use SELECT on a column with datatype TEXT? Posted by gene.ellis NO[at]SPAM gmail.com at 12/20/2005 11:33:49 AM Hello. I using a simply SELECT statement to retrieve some data from a
SQL SERVER via an ODBC connection. I had to go from VARCHAR to TEXT
because the amount of data. Anyway, my SQL statements worked just fine
when I was using VARCHAR, but now since I am using TEXT, I am only
receiving part of th...more >>
Linked SQL Server table in Access Posted by Max Yaffe at 12/19/2005 12:47:39 PM Why does the ODBC Link Table utility prepend "dbo_" to each table I've
linked into an Access database? I realize dbo stands for database
owner, but why is this an issue? Can I get it to drop the "dbo_"?
Thanks
Max...more >>
sql server 2000 Posted by Wendy Elizabeth at 12/14/2005 9:43:02 PM The database that I just started to work with has a simple recovery model.
The actual production database is 5 gigs while the transaction log table is
98 gigs. I can not figure out how the transaction log became so large. There
has never been a backup taken of the transaction log. How can the...more >>
data shown in form is #deleted Posted by Sam at 12/12/2005 12:33:35 PM when user leave's the application for while connection to server stops
and data shown in form is #deleted
how to prevent it?
sam
...more >>
configure odbc to retry connection when cluster failover Posted by Nik at 12/12/2005 9:46:03 AM Hi,
We have a bought in VB6 application that uses ODBC to connect to a sql
server 2000 database. We have moved the database to a windows 2k3 cluster and
now need to look at the client surviving failover.
Basically if I have the client connected to the virtual instance then fail
the "live" ...more >>
Migrating to SQL 2003 Posted by Neil at 12/12/2005 9:00:40 AM We are running SQL 7, using Access 2000 as a front end. Our network person
is wanting to migrate to Windows 2003 (we're currently on Windows 2000), and
wants to know if we should migrate to SQL 2003 at the same time. Are there
major changes between SQL 7 and SQL 2003, and how hard of a task wo...more >>
How to create Link Server ODBC DBase Posted by David Parenteau at 12/8/2005 1:21:02 PM Hi,
I tried a lot of things to connect a linked server to an ODBC for dBase IV
and I didn't get any successfull result. I have the path, the files names and
sysadmin access to my SQL server. I got a lot confused on all connection
string that news group use to connect to an ODBC for dBase. D...more >>
Problem with ODBC Posted by Robert Beaubien at 12/8/2005 10:32:51 AM Some combination of installing Visual Studio Team Architect and/or SQL 2005
Online books and tools, I can no longer link to tables in a SQL server from
Access. The ODBC datasources window will not come up. Anyone heard of
this? Where can I ask this question to get some help?
Thanx,
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Help; ASP web site, IIS 6.0, Server 2003, SQL server 2000 Posted by ARMS at 12/2/2005 11:41:03 AM Hi
I,m new to Server 2003 and I'm moving an ASP website to it.
This is what I have; an basic ASP web site that connects to a "SQL server
2000" database on Windows XP box, using IIS.
Now I have moved the site to Server 2003, on IIS 6, but I'm still using "SQL
Server 2000"
However I can't ge...more >>
Reading BLOBs from SQL Server 2000 Posted by Arnie at 12/2/2005 9:14:42 AM I'm reading columns from a table, including an image column. The
image column is not bound because I don't yet know the size of
the BLOB. The problem is that I can't get the ODBC driver to
stop reading the unbound column on SQLFetch(). It appears to
read the BLOB, all 50MB worth and then thro...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |