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

Old code not able to connect to unicode instance
Posted by John at 9/25/2007 12:00:00 AM
Hi, I have a program written in C/C++ compiled with MS Visual Studio 6.0 that fails to connect to a french SQL Server instance (probably a 2005 instance) with "SQL Server does not exist or access denied". I can connect to the instance with SQL Server Management Studio with no problems. ...more >>


OLEDB-ODBC-iSeries linked server. Select is fine, Create-Update-Delete do not work
Posted by Dmitry Duginov at 9/24/2007 1:04:04 PM
I have AS400 database attached as a linked server to my SQL2005: EXEC master.dbo.sp_addlinkedserver @server = N'THE', @srvproduct=N'THE', @provider=N'MSDASQL', @datasrc=N'THE' "THE" is the ODBC DSN pointing to the specific ip. I have no problems retrieving the data from the linked serve...more >>

restrict delete permission
Posted by Sang Nguyen at 9/24/2007 10:30:01 AM
i have the odbc connection connected to our SQL databasse via sql user account through MS access Frontend and having problem controling the delete function of the account. In SQL i am only allow the account to read, insert,update and denied delete on the database and tables. However, the ...more >>

Linking Access 2003 to SQL 2005
Posted by BackthePack at 9/19/2007 1:24:00 PM
I have read numerous posts on this topic, but to no avail. I have several Windows XP Pro desktops (SP2) and a new server running Server 2003 (SBS) with the full version of SQL 2005. I have a split MS Access program with the FE residing on the desktops and the BE on the server. The Access pr...more >>

ODBC & Remote SQL Server
Posted by pradeep at 9/17/2007 10:07:47 PM
Hello, How to create system DSN (ODBC) on windows 2003 for SQL Server located on remote machine ? Please, guide me. Bye. ...more >>

MSSQL2005 64 bit + Client ODBC
Posted by Markco Wong at 9/7/2007 12:00:00 AM
Hi, If I have a Intel x86 64 bit server, installed Win2003 64bit OS + MSSQL2005 64 bit version, and the client running Intel "Core2 Duo" (32 bit), installed WinXP Prof, is the client able to connect to MSSQL2005 64 bit Database thro ODBC drivers? Thanks. ...more >>

Fastest Fetch for Client Application
Posted by stork at 9/6/2007 12:45:21 PM
I'm a total luddite and am writing a brand new C++ ODBC application for numerical analysis against a SQL Server database. I'm not using MFC or ATL or any foundation classes whatsover. It's just C++, my little ODBC wrapper (and a thin one at that), and a few things I wrote to do lots of multithr...more >>

error setting up ODBC for remote sqlexpress database
Posted by ruth at 9/5/2007 9:08:00 PM
I am using SQL Server Express and have a database on the server. I have no trouble setting up the ODBC for the local machine. It works fine. When I try to set it up on another computer to access the database on the server, after the screen which asks for a login and a bit of a wait, I get erro...more >>




DevelopmentNow Blog