| 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 ODBC Timeout Linked to Optimizer? Posted by ITFred at 3/26/2004 11:53:00 AM I have been struggling with an MSSQL problem for a couple of weeks and
hope this is something someone else has already solved.
In my situation, I have a VB interactive front-end on multiple machines
accessing a SQL2K database through ODBC over TCP/IP. It has been in
service
for over 2 ye...more >>
Syntax for ODBC Sql Statements Posted by SMK at 3/26/2004 10:41:09 AM Is there a certain way ODBC will accept variables and if statements in one call
For example:
If I want to update a table, first to check if the entry exists in the table, if so update, if not insert
Is this possible
Thanks for any help
Steve...more >>
SQL Server Nasty Error (3624) when attaching database Posted by yen-nhi.le NO[at]SPAM thepalmtreegroup.com at 3/26/2004 8:42:23 AM Hi everybody,
Yesterday I was unable (frusttratingly) to attach the
single file (.mdf) db in any ways I found from this world
and e-world. Then I figureed out I had to install SP3.
Now I have my SQL Server 2000 updated with SP3, and tried
to attach the db (both files .mdf and .ldf) using ...more >>
ODBC, Excel, SQL Server Posted by Sharon at 3/24/2004 4:02:20 PM I have a user accessing SQL Server 2000 data through Excel
and MSQuery...we have used ODBC DSN with no probs. It is
only this user with an issue, so very specific to their
setup somehow.
Example databases called A and B.
User had ODBC DSN set up to default database A.
We want it to be B....more >>
Hosted MSSQL DB Posted by Terry VanDuzee at 3/24/2004 7:18:54 AM Hello
Perhaps someone can suggest a solution.
I have a Domain (on the net -- Hosted). It allows me to have an MS SQL DB.
The DB is created (the host creates the db).... but how can I actually
design/administer it from my computer at home? Do I need special software?
I know the host does not ...more >>
sql convert dies on nulls Posted by Waz at 3/23/2004 2:00:26 PM Hello,
I have a problem with an sql script doing a conversion
for example
select CONVERT(decimal(25,2), amount) as amount from mytable
The problem arises when there is a null or blank value for the column as
expected it bombs out.
I cant change the data in the table as it is too late...more >>
SQL Server does not exist or access denied Posted by MPasha at 3/23/2004 5:25:19 AM Any Help??
Error occurs while connecting thru QE or trying to
register in EM
Server: Msg 17, Level 16, State 1 [Microsoft][ODBC SQL
Server Driver][Named Pipes]SQL Server does not exist or
access denied...more >>
which conformance level sqlserver 2000 odbc driver support Posted by zhangsn98 at 3/22/2004 7:01:07 PM Could you tell me which conformance level sqlserver 2000 odbc drive
support
Core,Level1 or Level 2
and whichconformance level sql92 languange support
Thank you for your help...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
error 1069 Posted by Haas at 3/22/2004 12:14:32 PM When trying to access the sql server database I am
receiving the following error:
An error 1069 - (This service did not start due to logon
failure) occurred while performing this service operation
on the MSSQLServer sevice.
Any help would be greatly appreciated!!!...more >>
Unable to instantiate ODBC Environment Error Posted by Mickey at 3/22/2004 11:46:59 AM I run SQL 2000 with Allaire/Macomedia ColdFusion 4.5.1. I
just today received a strange error and my web server
slowed to a crawl and then locked up. I got this error in
the logs: ODBC Error Code = ()<P><P> Unable to
instantiate environment for 'ODBC.' Any thoughts?...more >>
SQL-DMO Error Posted by Jim at 3/22/2004 5:34:54 AM We recently upgraded from version 6.5 to 2000. During the
process the WIzard did not complete. It apparently build
all selected databases but did not migrate the data. The
last line in the smmarylog reads "Preparing SQL-DMO for
upgrade=0". At any rate we decided to press on with the
upgrad...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |