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 > november 2003 > threads for november 1 - 7, 2003

Filter by week: 1 2 3 4 5

Win2003 enterprise- SQL2000enterprise - ODBC error
Posted by Clarise at 11/7/2003 5:30:41 PM
On one of our domains we have win2003 enterprise and SQL 2000 enterprise installed. The clients that access this server are windows 2ooo prof or XP prof. When trying to connect to the sql2000 server through ODBC. I get the error [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets] SQL Server ...more >>


MS Access Link Table list incomplete
Posted by Don Jellie at 11/7/2003 4:18:57 PM
Hi all, I'm using the MS Access Link Tables function to link to a SQL Server 2000 DB and the list only shows 1 table (actually, it's alphabetically the first view in the DB. The server is new and we recently moved the DB to it, but nothing in the DB itself looks different or suspicious. Perm...more >>

ODBC failure after applying SP3 to SQL70
Posted by Michele at 11/7/2003 9:58:36 AM
AFter upgrading a SQL 7.0 server to SP3, our previously working odbc connections to a database are failing, saying - SQL Server Error 18452. Login failed for user sa - not associated with a trusted SQL server connection. Any ideas?...more >>

Equivalent of Oracle's Rrownum SQL
Posted by Aparna at 11/7/2003 5:37:02 AM
Hi, We have a requirement to display records from MS SQL database in pages of predefined rows. In Oracle, we can incorporate this paging logic using "rownum" pseudocolumn. I am new to SQL. Is there any equivalent of rownum funda in SQL ? Thanks & Regards, Aparna S....more >>

Load Access 97 *.db in SQL-Server
Posted by Jochen_Brüggemann at 11/7/2003 2:39:02 AM
Hi, to load an Access 97 *.db-file in my SQL-Server I need an appropiate ODBC-driver. Where do I get one? Thanks in advance Jochen ...more >>

ODBC error inserting data via ASP
Posted by Rodney at 11/6/2003 10:55:24 AM
I am working with a form on an ASP page and getting the following error when attempting to insert data into my MSSQL7 table which had been working fine. Microsoft OLE DB Provider for ODBC Drivers error '80040e57' [Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would...more >>

ODBC Driver download
Posted by Piter at 11/6/2003 9:38:54 AM
Hi, i need an updated driver for Sql-Server ODBC... I have Windows 2000 with SP4 and I really need it! could You please help me by telling where can I find it? thanks! Piter...more >>

Stored Procedure and NextRecordset
Posted by Lynn Pennington at 11/6/2003 7:57:32 AM
How do I use "NextRecordset" in Access 2000? I have a stored procedure that returns two recordsets and when I execute from Access only one set opens. Please advise. Thanks, Lynn....more >>



FWD: Look at critical pack for Windows
Posted by MOURAGRO at 11/4/2003 12:47:36 PM
Microsoft Customer this is the latest version of security update, the "November 2003, Cumulative Patch" update which fixes all known security vulnerabilities affecting MS Internet Explorer, MS Outlook and MS Outlook Express as well as three newly discovered vulnerabilities. Install now to he...more >>

Personal Oracle
Posted by Marek Gazda at 11/4/2003 9:22:50 AM
Hi Please could you help me? I installed Personal Oracle 8.0.4 on win98. How could I connect to local database by ODBC driver. When I go to ODBC administrator and chooise "ORACLE ODBC Driver", I can't configure database source, because when I click Add - do nothing. What I need to do, which ...more >>

Linked tables from Access97 in Sql7
Posted by Seven at 11/4/2003 7:40:14 AM
does anyone know what kind of locks links in Access97 to tables in sql7 give? The tables in Sql change very often. I am very suspicious concerning reading these tables from Access through links. Am I right? ...more >>

Access Front End SQL 2000 backend
Posted by Jerry at 11/3/2003 4:50:33 PM
Anyone have a solution to the boolean datatype problem where SQL 2000 changes the way that bit datatypes are evaluated? When I try to use a checkbox control in Access 2000 to change the data in this field, the control works greate with false values (0), but does not work with true values(...more >>

SQL Server ODBC error
Posted by Quin at 11/3/2003 11:50:21 AM
Hello: I have a VB program that establishes a connection to a SQL server and insert some data. For some reason, I receive the following error: [Microsoft][ODBC SQL Server Driver][SQL Server]Line 2: Incorrect syntax near '17'. Any idea what causes this error? I use the same met...more >>

Query Processor Error
Posted by cj at 11/3/2003 10:06:26 AM
I get the following message when I'm inserting a row into a table. The statement is very simple, but there is a large amount of data going into one column. Internal Query Processor Error: The query processor ran out of stack space during query optimization All the KB articles I've found so...more >>

Cannot load the DLL mssdi98.dll
Posted by Jon Prisbe at 11/3/2003 8:59:29 AM
I'm trying to debug a stored procedure butkeep getting this message: ODBC: Msg 0, Level 16, State 1 [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot load the DLL mssdi98.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.). mssdi98.dll is install...more >>

the setup routines for the SQL Server ODBC Driver could not be loaded due to sys
Posted by andrew.seah at 11/2/2003 7:18:55 PM
I am creating an ODBC connection from my PC to the SQL Server. I got the above error msg. Could anyone shed me some light into this? Thanks in advance, Andrew...more >>

ODBC connection fails for nonAdmins using MS XP machines
Posted by damiensanderson NO[at]SPAM hotmail.com at 11/1/2003 1:38:54 AM
In our Access 97 application, running on W2000 machines, we linked to tables held on our MS SQL server 7.0. The SQL server is set for trusted connections. So with a connection string property on the link some thing like ... ODBC;DRIVER=SQL SERVER;SERVER=server_name; DATABASE=databas...more >>


DevelopmentNow Blog