Archived Months
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
all groups > sql server odbc > february 2004 > threads for february 15 - 21, 2004

Filter by week: 1 2 3 4

Provider not found
Posted by Allen Bruce Anderson at 2/21/2004 5:57:51 PM
Sorry for the cross-posting, but I'm not really sure in which newsgroup this should be posted. Anyway... I have SQL Server 2000 with SP3 installed on my computer. I'm able to use Query Analyzer to open tables on the various databases running under SQL Server, but whenever I try to do so with...more >>


Please Help with ODBC SQL Authentication
Posted by Randy Chow at 2/20/2004 9:29:01 PM
Hello everyone, I am trying to setup a ODBC source using SQL Authentication. When I finish my settings and test the connection, the connection is successful. But, when I click the finish to exit out of the configure option of the ODBC source, and then go back into the ODBC DSN, the password is ...more >>

SQL with Sybase
Posted by Anatoli Dontsov at 2/20/2004 7:09:46 PM
Hi, All SQL2000/sp3 and Sybase 11.5 There is a SP on Sybase CREATE PROC sp_test @t VARCHAR(32) = 'default string' AS SELECT @t I want execute that from SQL SELECT * FROM OPENROWSET('MSDASQL', 'MySybase';'uid';'pwd', 'exec sp_test') works file. But with the parameter it fails ...more >>

Ordinal 29 not found in odbcbcp.dll
Posted by Pat at 2/20/2004 8:56:10 AM
Our Webserver(win 2000) recently crashed and they were able to get it back by using the Exchange2000 restore disk. Since they restored, sql server(2000)/IIS 5.0 is not functioning. We are unable to run an asp page on the website, htm, html are the only pages that will load in the browser...more >>

newbie question on SQL Server, ODBC
Posted by jp23 NO[at]SPAM myway.com at 2/19/2004 1:11:10 PM
Hi, I'm trying to access a MS SQL Server db from a CGI (pure C program). Which is the most efficient (fast, incl. fetching many records on a search term) ...using embedded SQL in C, ODBC or any other methods? Any suggestions? Jon...more >>

SQL_Server_does_not_exist_or_access_denied
Posted by Brian Burgess at 2/19/2004 10:51:32 AM
Hi all, Apologies for the cross-post. Just wasn't sure where to put this one: I'm getting this error sporadically on an ADO connection. When it happens I also cannot connect through the Enterprise Manager (or anything else!). The environment is SQL Server 2000 running on Windows 2000 Ad...more >>

JSP connection string to SQL 2000
Posted by JasonHuang8888 at 2/18/2004 5:58:18 PM
Hi, What will be the connection string in the JSP to SQL Server 2000? Thanks. Jason...more >>

Login failed
Posted by mzarbei NO[at]SPAM yahoo.com at 2/18/2004 9:08:30 AM
Hi To All i Have Encountered Such A Problem In SQLserver2k Any One To Help ME Technical Information (for support personnel) Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D) [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'MZZ\IUSR_MZZ'. /ostandari...more >>



Table copy (DST)
Posted by Chris Savedge at 2/17/2004 3:43:02 PM
I'm trying to copy a table from one database to another using the DST wizard. Everything works find until the last step.......at that point I get an error that says "Error at destination for row number 1. Errors encountered so far in this task: 1. Line 1: Incorrect syntax near 'Collate'. " Alt...more >>

ODBC to linked server
Posted by Frederick G. Pierz at 2/17/2004 2:32:02 PM
I have created a linked server using an OLE DB service in a SQL Server 2000 database running on Windows NT 4. I can see all the tables and views of the linked server in Enterprise manager, but when I go to a client machine and try to setup a DSN to the linked server using an SQL Server driver ...more >>

SQL server ODBC Open speed!
Posted by hostran at 2/17/2004 2:12:02 PM
I use Open(dbOpenDynaset,Sql,dbSeeChanges); to open the SQL server ,lt's very slowly, Are there any ways to accelerate ? ...more >>

ODBC Error
Posted by Rose at 2/17/2004 10:18:36 AM
Hello, I=B4m having a problem with an specific client. When the=20 user try to connect to our application, the following=20 message appears: Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80040E57) [Microsoft][ODBC SQL Server Driver][SQL Server]String or=20 binary data would be...more >>

Occasional "Timeout expired" message - on SP that should take 1 second
Posted by Beverley at 2/16/2004 9:10:27 AM
Hi there, I've got something kind of weird going on. I have a stored procedure that normally takes less than one second to execute, but it has started taking over 30 seconds from time to time. The SP is called by an ASP page on a web server, running on a separate machine. The database ser...more >>

ODBC ACCESS
Posted by domed at 2/16/2004 7:44:55 AM
I have a VIEW SQL connected to an other database. How I can connect this VIEWS in ACCESS inserting one key in runtime? --- Posted using Wimdows.net NntpNews Component - Posted from SQL Servers Largest Community Website: http://www.sqlJunkies.com/newsgroups/...more >>

Cannot open SQL Server Table
Posted by Mark A. Sam at 2/15/2004 10:31:41 PM
Hello, Can a SQL Server table become corrupted? The tables are linked to an Access DB and I cannot open the main Order table from Access. I am connected to the system remotely via Terminal Server and do not have Enterprise manager available. I can't imagine what the issue could be otherwi...more >>


DevelopmentNow Blog