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 > december 2003 > threads for december 22 - 28, 2003

Filter by week: 1 2 3 4 5

ODBC
Posted by Ricardo at 12/27/2003 5:08:01 AM
When trying to open a link from the main Web Page of TimberHunt I get the following information: Microsoft OLE DB Provider for ODBC Drivers error '80040e07' [Microsoft][ODBC SQL Server Driver][SQL Server]Error converting data type varchar to numeric. /timber_trade/comp_trade_board.asp, ...more >>


SQL Question
Posted by Shelly at 12/26/2003 8:55:29 PM
I have been attempting to access a database that I have been able to use regularly prior to September 2003. I have tried to resolve this problem through tech support at Microsoft as well as the OEM. I have been unable to find a solution that is more than just temporary. The error msg re...more >>

General SQL Error - Native SQL Error 10040
Posted by microsoft at 12/26/2003 3:23:34 PM
I am getting an error connecting to my goldmine account when I attempt to login after I was messed up something in my ODBC administrator. When I click on Goldmine, I get a DATABASE ERROR BOX General SQL error Native SQL error:10040 Context: openDatabase MSSQL: xxxxxx.dbo.SPFILES 1. Al...more >>

ODBC Select Data Source in Crystal reports - continuously prompts
Posted by microsoft at 12/26/2003 1:41:50 PM
I've created an ODBC entry for crystal reports. When I go to refresh and run a report, it always prompts me with a select data source and SQL server is at the bottom of the list under dBase, Excel and MS Access Database. If I select it, the report runs. How do I have it automatically choose th...more >>

ODBC/SQL M$ EXCEL 97 vs XP
Posted by JimmieD at 12/26/2003 5:55:00 AM
Any ideas appreciated... Users can export to Excel97 but cannot using ExcelXP. Get error: "unknown token received from sql server" Have patched SQL & OfficeXP locally to current M$ levels. ODBC connects no problem. I'm a tech, not a programmer, so any ideas really appreciated. Jim...more >>

Very Big Table Problem
Posted by Murtix Van Basten at 12/25/2003 4:45:32 PM
HI all, I am trying to migrate a database from mysql to mssql2k. I use myODBC to connect to mysql server to pull the database from DTS and insert in to sql server. But in mysql server, there is one huge table. Size of it is 1.3 GB and more than 12 million rows. While I try with DTS, i...more >>

changinh DB of stored procedure
Posted by David Potahisnsky at 12/24/2003 2:06:01 PM
I have a stored procedure that as one of parameters receiving the database. I need to change the database that SQL statement in store procedure working on according to parameter. I cant find any solution except fill naming and rewiring whole statement depend on parameter or building SQL statem...more >>

SQL ODBC problem
Posted by cslee NO[at]SPAM masterfox.com.sg at 12/24/2003 1:33:05 AM
Dear Sir, We have install a database software which require connectivity to SQl Server. After installing teh software we can no longer evoke ODBC under win 2K Pro. Error message " Setup routine for SQL Server ODBC driver could not be loaded due to system code 126" . We would appreciate...more >>




DevelopmentNow Blog