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 2006

Accessing Oracle from within SQL Server
Posted by Paul Anderson at 6/28/2006 12:00:00 AM
Using Oracle's Heterogeneous Services, it's possible to gain access to SQL Server tables via ODBC. Is the reverse possible? Does SQL Server have the ability to read/write from/to an Oracle table using ODBC? Is there anything to install? Or is this functionality that comes with SQL Server? ...more >>

jet oledb from tsql
Posted by Nick Thompson at 6/23/2006 3:19:01 AM
I wish to create a new access database each week whos name includes the curent date, then to create 7 tables in the database eg '27 Jul 2006.mdb' one for each day I then wish to insert rows into these tables, currently I use managed adox & ado to do this, is it possible to use tsql to get ...more >>

PROGRESS import of field freezes SQL Server
Posted by Philippe at 6/16/2006 4:04:02 AM
hi, I've got a SQL 2005 with an odbc connection to a PROGRESS database. We can transfer data from the progress to the sql but there is 1 field we can not transfer. This field, proclaimed by the PROGRESS administration, is a field wich can contain an empty string or up to 8 characters. Bu...more >>

Transaction cannot start while in firehose mode!
Posted by Ole Martin at 6/8/2006 2:37:02 AM
Hi! I get this message when I try to change a record: Transaction cannot start while in firehose mode! Anyone now how to solve this problem? I can read/write to my table, but I cant change records. Help much appretiated, Thanks Ole Martin...more >>

Error when importing data from AS/400 - appeared after SP1
Posted by dr at 6/7/2006 12:00:00 AM
I cannot transfer a list of tables from AS/400 to SQL 2005, in SQL Server Import and Export Wizard. This is what happends: In SQL server Import and Export wizard, I choose IBM AS400 OLE DB Provider, with Properties: Data Source: (IP adress of my AS/400) User name, password: (My username/...more >>

MSSQL 2005 Enterprise vs. Standard edition
Posted by Jodie at 6/6/2006 6:14:01 PM
Hi All, What is the different between MSSQL 2005 Enterprise and Standard edition. Thanks Jodie...more >>

When Microsoft release MSSQL 2005
Posted by Jodie at 6/6/2006 9:15:01 AM
Just a question about MSSQL 2005- When MSSQL 2005 released by Microsoft. Are there a lot of users using this MSSQL 2005? Thanks, Jodie...more >>

Linked Server to DBC Data
Posted by REM7600 at 6/5/2006 8:12:35 AM
Hi All, I'm having trouble setting up a linked server OR using an OpenRowset = operation from SQL Server against once of the DBC files from one of our = vendors. =20 I can get connected through a DSN using Microsoft Access without trouble = but when trying to set up a linked server on the s...more >>




DevelopmentNow Blog