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 > august 2004 > threads for august 22 - 28, 2004

Filter by week: 1 2 3 4 5

Connection to ODBC without a DSN
Posted by Tony at 8/27/2004 3:53:47 PM
Is it possible to connect to an ODBC driver (e.g. SQL Server or Oracle) directly without having to create a DSN before hand. This would be great as dumb users can't handle creating a DSN. Would be nice if I could ask them SQL Server or Oracle, server name, user name and password only and progr...more >>


String data, right truncation
Posted by Leon McCalla at 8/27/2004 11:54:15 AM
after executing a Stored procedure that returns about 10 strings I get a "String data, right truncation" error in ODBC. how do I know which string was too long? Leon ...more >>

Compatibility of ODBC 2000 vs ODBC 2003
Posted by chanjo at 8/27/2004 11:22:15 AM
Will there be a compatibility issue between my client ODBC version 2000.80.194 and the SQL server 2003....more >>

Mainframe file import
Posted by AlexB at 8/25/2004 6:01:01 PM
I am hoping to import a file exported from mainframe (packed decimal) into a SQL Server database. Is it possible and if so, what is the best way to accomplish this? Thanks in advance....more >>

Nested Transaction between ADO.NET and T-SQL
Posted by SK at 8/25/2004 5:25:03 PM
I am writing an application that calls numbers of stored procedure wrapped in an ADO.NET transaction. Some of the stored procedure implements T-SQL transactions. Is it safe to call Stored Procedure like this or there is potential of data corruption. Have anyone seen any document or article...more >>

create same Database connection on multiple computers
Posted by #'ak at 8/24/2004 4:37:13 PM
Hi, is there a possibility to create automaticaly a ODBC database connection on the multiple client computers (equal for all of them), in ex. on windows 2000 Profesional or XP? And secont thing. Is there a possibility to automaticaly change all of the ODBC connections without changing one by on...more >>

MDAC version
Posted by Ian at 8/24/2004 1:47:27 PM
Hi How can I find out what version of MDAC is installed on a Machine. And would there be any problem with me installing both MDAC 2.7 and 2.8 on the same machine Ian ...more >>

not function
Posted by Michel at 8/23/2004 6:08:26 PM
I'd like to do the following query update myTable set myField = not (myField) But it looks like not isn't a function. How can I write this? Thank you ...more >>



Importing views from Oracle
Posted by Scott at 8/23/2004 1:49:01 PM
I've been able to import tables successfully from Oracle to a SQL Server database. However, when I try to import views from Oracle it wants to import them as tables in SQL Server. Any ideas how I can import views as views from Oracle to SQL Server?...more >>

Help with MS Access Error Trap
Posted by rob at 8/23/2004 10:04:54 AM
Please excuse if you feel this is posted in wrong group (I have posted in Access groups as well)... I do know there is at least some some cross-over base here that may help... I am trying to establish links from Ms Access to tables in a SQL server database. There is an Access table (tblLinkMa...more >>

ODBC security parameters
Posted by stevesklar at 8/23/2004 7:12:42 AM
We have several machines where multiple people login. Normally we set the ODBC to 'with NT auth with network login id' When we change it from this to 'SQL server auth asking for login id/pwd' our Visual Basic apps no longer work. Our VB apps do have a login screen & pwd and that string...more >>

Transfer data from progress to SQL, character field format
Posted by Ofer at 8/23/2004 2:44:05 AM
Hi All, I am using OpenLink's ODBC in order to transfer data from Progress Data Server into the SQL. When trying to transfer a field which has a character format on the Progress Server, the DTS transfer only the first 8 characters of this field. The format of the field in the progress databa...more >>


DevelopmentNow Blog