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 > july 2005

SQL server connection in a wireless atmosphere
Posted by awj at 7/29/2005 5:48:01 PM
We are running a dedicated program that uses SQL server in an ad hoc invironment between multiple laptops. The OS is Windows 2K pro. The problem we are having is that the SQL connection is being lost even though the wireless connection is intact. Does anyone have an idea what may be causing t...more >>

Data from Excel into SQL
Posted by Paul Smith at 7/29/2005 12:00:00 AM
Please excuse the cross posting I was not sure which newsgroup would produce the required advice. I have a requirement to update a SQL table with data from an Excel worksheet. Can anyone suggest the best way to do this....ADO????? PWS ...more >>

Troubles to connect sql server 2000 on winXp-sp1
Posted by luismiqui at 7/28/2005 7:06:02 PM
I cant connect my sql server by ODBC to some pcs with WinXP-SP1 Anyone know how I can accomplish this? I have Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Desktop Engine on Windows NT 5.0 (Build 2195: Service Pack 4)...more >>

utility to stress test
Posted by Edgar -MBNS.NET at 7/28/2005 4:20:03 PM
is there a util from Microsoft to test the sql server to find out how many clients it can take w/o significant drop in performance? ...more >>

Access Front-End
Posted by HSP at 7/21/2005 8:27:04 AM
We have a system which uses an Access front end linked to a SQL 2000 database If we were to move the SQL database onto a new server then would it just be a case of editing the ODBC settings on each client to point to the new SQL server? ...more >>

[Microsoft][ ODBC SQL Server Drive ] Timeout expired
Posted by Manish Acharya at 7/18/2005 3:34:02 PM
I am running a VB application which makes connection to the SQL server database using DSN connection using ODBC. This application pulls data using stored procedure. The application does not insert / delete / update data. The application was working fine since it has been installed (more tha...more >>

Error "Cannot start transaction while in firehose mode" in terminal server hosted legacy application...
Posted by SammyBar at 7/16/2005 2:33:50 PM
Hi all, We have a legacy client-server client application (developed with Centura SQL Windows/32) that connects to a SQL Server 2000 database. In our LAN it works without mayor flaws. Recently we added support to some remote offices by using W2K terminal server. The decision was not to allo...more >>

Strange SP Problem
Posted by Neil at 7/14/2005 12:00:00 AM
I have a strange situation. I have a stored procedure that is hanging upon execution, but only some machines and not others. The db is an Access 2000 MDB using ODBC linked tables and a SQL 7 back end. The sp is executed as a pass-through. The sp is fairly simple: UPDATE CUSTOMER SET Las...more >>



Profiler defaults to master database
Posted by Bruce D. Meyer at 7/13/2005 8:50:34 AM
I am not even sure I can do what I am hoping but, I need to debug a complex sql query. I was hoping to be able to load it in profiler and step through it. oddly, right off the bat it errors out telling me the table I am referencing is not found in the database master, which is correct. My ODBC c...more >>

Transaction Log filling up
Posted by myaffee at 7/12/2005 11:49:09 AM
Hi, we have an application that is sending a large number of insert statements (>5000) through ODBC to a SQL Server 2000 database. Apparently this is causing the transaction log for that database to fill up which then causes the web site that depends on that database to crash. We keep increa...more >>

SQL Beta Problem
Posted by victorsk at 7/12/2005 8:50:01 AM
Hello, I am trying to connect to a SQL Beta Database from Mapinfo using Integrated Windows authenication, but I am getting error: Connection failed: SQLState: '08001' SQL Server Error: 11001 [Microsoft][SQL Native Client]Client unable to establish connection Connection failed: SQLState:...more >>

SQLDriverConnect crash
Posted by JUNK at 7/11/2005 12:00:00 AM
I tried to connect to a local SQL server database using SQLDriverConnect in a VC++ project, on a Windows 2003 OS. It is an unicode project. Everytime the code reaches SQLDriverConnect it crashes. try catch block did not work. I tried to pick up some samples from websites and found that none of ...more >>

Writing custom odbc driver.
Posted by avijit at 7/9/2005 12:08:01 PM
Hi I am trying to write a custom odbc driver for one of my application. The application is called data mediator which mediates between various datasources . I have already developed JDBC driver for this application. Now I want to develop ODBC driver so that any ODBC compliant application can ...more >>

ODBC SQL Server Driver[Shared Memory]ConnectionW
Posted by trans53 at 7/9/2005 3:35:38 AM
Hi all, question for you please : We have client app. running on the same server as SQL and using LPC as a network library. Very often we have the error message bellow and application just crash. What can be a problem in this case.Your help is greatly appreciated. Thanks. 2005/06/07 12...more >>

problem with large number of inserts
Posted by myaffee at 7/6/2005 9:27:02 PM
We have an application that is connecting to our SQL 2k server remotely via ODBC and sending a large number of individual insert statements. Apparently this is causing problems with the transaction filling up on the sql database the inserts are being sent to. To solve the problem, we set the t...more >>

Time Out Issue
Posted by Travis at 7/5/2005 7:30:01 PM
Hi , I create a ODBC for SQL Server 2000 and use VB 6 to connect it. When I pass it the sql query in vb and process the recordset , I am getting an error "Microsoft ODBC SQL Server Driver Timeout expired". Where can I set the time out in the ODBC ? TQ. -- Travis Tan...more >>


DevelopmentNow Blog