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 > june 2007

ODBC Data Source Administrator
Posted by thePriest at 6/29/2007 2:13:02 AM
Hi all, hope you can help? I have created a system DSN in the usual way using the above ODBC tool (I am trying to create a connection to our Open Accounts package using the OpenEdge 10.1A driver). I provide the host name, the port number and the database name, the user ID and password and tes...more >>

Problem with decimal scale using SQLBindParameter and SQL_C_NUMERIC
Posted by Mark Yudkin at 6/24/2007 12:00:00 AM
SQL Server 2005 SP2 I am trying to pass in native decimals with non-zero scale as parameters using SQL_NUMERIC_STRUCT. Retrieving decimals works fine (SQLGetStmtAttr, then SQLSetDescRec) (cf KB222831). I tried calling SQLBindParameter giving the scale in DecimalDigits. The value is passe...more >>

Invalid identifier/column names after Upsize Access data to SQL Se
Posted by didub at 6/22/2007 7:54:04 AM
I have been asked to maintain an Access 2000 database which is a code front end linked by ODBC to a SQL Server 2005 back end. (Originally the data was in an Access database but was later moved to SQL Server 2005 by the Upsizing tools.) Some tables have column names which do not conform to ...more >>

Chart lists different builds of SQL Server and MDAC needed
Posted by Peter at 6/19/2007 7:31:35 PM
I want to find out which build of MDAC is required by different build of SQL Server 2000 and 2005. Also, are all the keywords listed in the link below supported by all the MDAC used for SQL Server 2000 and 2005? Are the acceptable values for the keywords same for both 32bit and 64bit drive...more >>

sql server connections
Posted by Wendy Elizabeth at 6/17/2007 9:00:01 PM
I would like to know how to automate the following two processes with excel: 1. I would like to take data that is obtained from sql server 2000 queries results and load the detail data onto excel spreadsheets. 2. I would also like to take data that is obtained from sql server 2000 query re...more >>

Suppressing ODBC pop up error
Posted by at 6/16/2007 4:05:21 AM
Hi there, I have a client-server application that periodically connects to an Access database on a network. My netowrk sometimes goes down and there is an ODBC failure to connect. This results in an ODBC error pop up window. I am interested in suppressing this pop up, catching the exception a...more >>

Distrubuting ODBC DSN record to domain computers
Posted by volkans80 NO[at]SPAM gmail.com at 6/9/2007 3:54:56 AM
How Can i distrubute my ODBC DSN record to my domain computers? ...more >>

SQL server database access from VC++
Posted by Manjree Garg at 6/6/2007 2:33:00 AM
Hi I am new to SQL server and ODBC. I am trying to retrieve SQL server database using VC++ (using VS.net). I am using SQLConnect to connect to the SQL server. My code contains SQLAllocEnv(&henv); SQLAllocConnect(henv,&hdbc); rc=SQLConnect(hdbc,chr_ds_name,SQL_NTS,NULL,0,NULL,0);...more >>




DevelopmentNow Blog