|
|
|
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 |
SQL Server does not exist or access denied Posted by hal at 3/31/2006 9:31:01 PM How do I resolve the Micosoft SQL Server Login Error Message Prompts:
Connection fail:
SQLState: 08001
SQL Server ERROR: 17
{Microsoft}{ODBC SQL Server Driver} {TCP/IP Sockets} SQL Server does not
exist or access denied
Regards,
Hal...more >>
Error reading a linked Excel spreadsheet Posted by Harolds at 3/29/2006 11:45:41 AM This problem just started happening (though the process had been working
without a problem for several months):
SQL to create link:
--if the link exists drop it
IF EXISTS (SELECT srvname FROM master.dbo.sysservers srv WHERE srv.srvid !=
0 AND srv.srvname = N'Excel')
EXEC master.dbo.sp_dr...more >>
SQL Query and Distinct Posted by Nicolas at 3/22/2006 5:56:06 PM What should be the SQL Query syntax to get the result:
Basicaly it's a dinstinct on "Name" but the DocUNID is always quicking in
Query not working: SELECT DISTINCT sysEnum.Name, sysEnum.docUNID FROM
sysEnum ORDER BY sysEnum.Name ASC;
Desired Results:
{F77A1DCD-3948-4761-B38F-C5DD0A823196} ...more >>
Variable SQL Statements pulling from a cell in Excel Posted by Preacher Man at 3/22/2006 11:38:01 AM I have a situation that I hope someone can give me a good answer to. Please
bear with me as I try to explain my needs.
My goal is to have an Excel spreadsheet that pulls from a SQL database and
the the query pulls from a variable in the Excel sheet. For example let's
say I am pulling Sale...more >>
SQLConfigDatasource with user name and Password Posted by shubtech NO[at]SPAM gmail.com at 3/22/2006 9:16:19 AM I am trying to use Delphi to create a DSN programatically using the
SQLConfigDatasource function and that seems to work fine.
However when I try to create a DSN using a specific user name and
password it does not work.
Is there a way to create a DSN with a user name and Password?
What I...more >>
Preferred Access ODBC Linking Method Posted by DBG at 3/22/2006 8:00:30 AM Is the preferred Access 2003 method CreateTableDef or TransferDatabase and why?
Thanks!
-David...more >>
SQLExecute return code for stored procedure. Posted by Offspring at 3/20/2006 3:36:31 PM Hello,
For SQL Server 2000, if the stored procedure threw an error and there
was a result set available, the return code from the ODBC call
SQLExecute was SQL_SUCCESS_WITH_INFO. However, with SQL Server 2005,
return code is SQL_ERROR. Has anyone else encountered this problem? Is
this a bug or...more >>
MySQL Linked Server Posted by Curtis at 3/16/2006 5:07:27 PM I am trying to linka MySQL database to SQL 2005, but I am not sure what I
need to do.
I have set up a DSN using the MySQL driver. I get lost when I try and create
the linked server in SQL 2005. Can someone please outline the steps to create
the linked server. Should the MySQL driver show up...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
NEWBE Posted by tony at 3/15/2006 9:17:29 AM I have web forms on my site that store data in an sql dbase.
I have a DATE column that i would like to store each date, that each request
was submitted. The only function that i found to automatically populate that
field was TIMESTAMP... any ideas on how i can autopopulate just the DATE
...more >>
Access / SQL Server currency datatypes Posted by Simon Lampert at 3/14/2006 12:00:00 AM When linking a SQL server 2000 table to Access 2003 using the standard MS
ODBC driver (2000.85.1117.00) fields with a datatype money and smallmoney
are blank in Access.
If I use a DataDirect ODBC driver the money fields are displayed correctly.
Any Idea if there is a MS ODBC driver that ...more >>
Linking to FoxPro files from SQL Server Posted by Teri Welch at 3/10/2006 12:53:19 PM Hello,
We are fairly new to SQL Server and and hope someone can help us. From SQL
Server we need to link to FoxPro tables in the accounting (SBT) system. We
started to setup a Linked Server but didnt get very far. For example if we
wanted to link to a FoxPro Product table called PROD we would ...more >>
Connection string with a Select Statement Posted by Preacher Man at 3/10/2006 11:19:38 AM Is it possible to use and ODBC connection string within a Select Statement?
If so what would the syntax be?
...more >>
Access 2003 and SQL 2005 Mary Chipman? Posted by DBG at 3/10/2006 6:30:27 AM Hi-
I've been doing a lot of research on the best way to integrate SQL Server
2005 and Access. Many of Mary's suggestions to others lead me to these
decisions, so maybe she will comment? What I've learned has lead me to the
following conclusions:
Use linked tables to SQL 2005 for gener...more >>
creating a link server into oracle Posted by Liam Mac at 3/9/2006 8:31:31 AM Hi Folks,
Pretty new to linked servers, however I need to create a linked server from
MS SQL Server 2000 into Orcale database sitting on a UNIX platform. I already
have successfull DTS application which takes info from the Orcale database
into MS SQL, using third party Oracle driver via DSN...more >>
Convert VARCHAR to money value Posted by Woodies_46 NO[at]SPAM hotmail.com at 3/7/2006 8:32:18 PM Ok i know this is simple but i just don't know the syntax. What I have
is a bunch of values and i want to be able to display them as money
values with a $ in front.
eg.
16000000
1000
160000
TO THIS
$16,000,000.00
$1000.00
$16,000.000
I'm using MS SQL 2000
Cheers
...more >>
SQL server stops responding to new connections Posted by Darío_Alejandro_Guzik at 3/7/2006 11:14:18 AM Hi!
I'm having a problem in a customer's netwok:
We have an application that connects to a SQL Server from multiple
terminals via ODBC, but sometimes (I don't know why) the server stops
responding to new connections. The terminals that already had an open
connection works fine, but ...more >>
How does databse driver manager know the application is "Unicode aware" ? Posted by qhe at 3/7/2006 12:00:00 AM Hi, all:
My VC6 MFC application is recognized as a Unicode application by the driver
manager, so when I read nchar fileds in MS SQL Server database, the
SQL_WCHAR does not convert to SQL_CHAR, and the application ASSERT failure
at CRecordset::GetDefaultFieldType function.
But I don't have ...more >>
SQL Server 2000 Timeout Posted by Stephan at 3/5/2006 1:25:30 PM Hi,
In query designer there are times when I go to run a query and I get a
timeout error. Any ideas how to set the timeout property for so that the
query will run to completion without timing out.
Thanks in advance.
Steph...more >>
SQL 2005 Failing Backups Because it Exits The Query Prematurely Posted by ESPNSTI at 3/1/2006 12:33:21 PM Hi,
PROBLEM:
We've encountered a problem in testing with our application being unable to
perform a backup successfully in SQL 2005.
This same application (which uses ODBC) is able to backup SQL 7.0 and SQL
2000 databases through the same user stored procedure without problems.
What a...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |