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 > january 2004 > threads for january 1 - 7, 2004

Filter by week: 1 2 3 4 5

ISQL - problem
Posted by Michael K at 1/7/2004 11:08:46 PM
Not sure if this is the right place for this posting, sorry didn't find anything better. Anyway here is my problem. Trying to move from SQL7 to SQL2000. Some of processes using isql by shelling batches with isql from several machines. Here how it looks like; isqlrun.bat path =\\SERVER7\...more >>


Creating odbc dsn's
Posted by Sean at 1/7/2004 4:18:34 PM
I'm like to create some sql server odbc dsn's by using a script. does anybody know if can this be done,,, ...more >>

ODBC Connection Hangs after 15 minutes of non-use
Posted by Bob at 1/7/2004 3:23:30 PM
I have several workstations that login to a WIN_2000 Server and Connect just fine to a SQL-2000 Server (different machines) over a dedicated VPN..... They have a x.x.2.1 addressing scheme and we have x.x.1.1 addressing scheme. Everything works beautifully for a while. My application runs a Mai...more >>

SQLPutData problems with new version of SQL server drivers
Posted by Charles Gamble at 1/7/2004 6:41:03 AM
Hi, We are getting problems when using SQLPutData with SQL Server 2000. Our system uses C++ COM objects resident in COM+. We are getting unhandled exceptions in Release builds of our COM objects only when we call SQLPutData with more than 2 columns being set via the putdata mechanism. ...more >>

Importing Data Throught ASP
Posted by Anubis at 1/6/2004 11:47:23 PM
Hello, I've been trying to work with code to import data from a "flat file" (.csv) into a SQL 2000 table. I'm not that well versed in SQL and was wondering is it was possible using OPENROWSET or something similar? I've tried using OPENROWSET and encountered the error "Ad hoc access to OLE...more >>

Stored Procedure permissions issues
Posted by cb at 1/6/2004 4:54:59 PM
I have a user who is upgrading her workstation. On her windows 2000, Office 2000 machine the applications work fine. On her WinXP OfficeXP box, the application opens up, but eventually suffers a permission error on a storeprocedure. What gives? She is logging in as the same AD user who has r...more >>

Please help-ODBC Error
Posted by Lucy at 1/5/2004 6:41:10 PM
Folks - please, I desperatly need your help and ideas We recently installed a SQL Server in our DMZ. The DMZ servers are part of a DMZ workgroup and not a part of our internal domain I must have an ODBC connection between this SQL Server and my PC so I am able to use MS Access Version XP to rev...more >>

QueryTimeout Property problem
Posted by Anita at 1/5/2004 2:50:58 PM
Hi All, I have a problem with QueryTimeout property. When I set cn.QueryTimeout = 2 (not zero) and the time out really come then no runtime error appears (I expect run time 3669, execution canceled). This makes my application works wrong. If I set cn.QueryTimeout = 0 then it works. Bu...more >>



Out Of Memory
Posted by Amanda at 1/5/2004 12:24:02 PM
I'm trying to connect to a SQL database with an ODBC connection. When I try to access the database I get an "Out of Memory" error from Microsoft Access. It won't load anything. Any Ideas?...more >>

Text Editor
Posted by Rose Roland at 1/4/2004 6:00:19 AM
Do I need Front Page to manipulate text. I have Excel and just installed MSSQL on my computer. I just want to manipulate text to output Hello World....more >>


DevelopmentNow Blog