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 > may 2006

Could not allocate space for object 'Table' in database 'database_name' because the 'PRIMARY' filegroup is full.
Posted by s.klaren NO[at]SPAM gmail.com at 5/30/2006 2:35:12 AM
Hello, We have a problem with a "primary group is full" error, this is a well known problem found by Google but the only thing is that the solutions or problems with low diskspace is not our problem. Also solutions related to hotfixes wouldn't do the trick. As we have SQL Server 2000 SP4 runn...more >>


Data Transformation.
Posted by Sami at 5/29/2006 4:41:02 PM
Hello, I want to do some data transformation from one Database to another. My source DB is a MS SQLServer to which I can connect using OLEDB/SQLnative. My destination DB is a different type of database to which I can connect using Connection Manager. But for data transformation I need a dest...more >>

Remote connect and encounter SQL Server does not exist or access denied.
Posted by winwin at 5/29/2006 1:55:34 AM
Hi, I have tried to remote access my SQL server (from remote host to our localserver) but there is an error as below: Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not exist or access denied. When I try...more >>

ODBC drivers not listed in SS2005 import wizard
Posted by Mike at 5/26/2006 1:29:02 PM
I'm trying to import an RBASE table into SQL Server 2005. In 2000, the RBASE ODBC driver was listed in the drop down list of the import wizard. It is not listed in the 2005 wizard. Is there a fix for this? Thanks, Mike ...more >>

ODBC DataSource name problem
Posted by Jodie at 5/26/2006 9:57:01 AM
Hi All We have an application which is used the ODBC Data Source to comunicate with the database. So during the installation of the product the installation creating the database name like : VAPost and server = datasource name which is 'VAPost' not the real server name in the Microsoft SQL ser...more >>

Backward compatiblity in sqlserver 05 Enterprise edition
Posted by Zen at 5/24/2006 2:54:58 PM
Hi, I believe I'm running into a backward compatibility issue with the sqlserver 05 Enterprise edition. I restored a database from sqlserver 2000 to my new sqlserver 2005. Both of my .net project and Access gets time-out errors (running remotely) when they try to access to a table that I h...more >>

ODBC Data Source
Posted by Steven at 5/23/2006 8:01:03 AM
I hope that I am being a real dunce about this. Using SSIS, I create an ODBC data connection to our transactional system, from which we build our data warehouse. In the data flow, when I go to add the data source, I find nothing that will reference the ODBC data connection. Suggestions? ...more >>

ODBC connection.
Posted by Sami at 5/23/2006 12:00:00 AM
Hello I can create a ODBC connection to another database which is not SQL Server. But when I want to choose a Integration Service Destination connection I am not given any ODBC connection type. I would like to transfer and transform data from a SQL Server database to a seperate database to whi...more >>



SQLFreeHandle Deadlock Issue?
Posted by Hector Santos at 5/18/2006 6:04:08 PM
We have a 5-6 year old SQL ODBC wrapper DLL for ODBC 2.0 basically wrapping ODBC 2.0 functions to easier usage in our application. It works for many years, no complaints, no leaks reported etc. But now that I am revisiting it to add some new functionality to it, I am finding that under VS 6.0...more >>

Communication link failure
Posted by saikosounds NO[at]SPAM gmail.com at 5/16/2006 3:17:49 AM
Hello We are using Access 2003 (SP2) to access a remote SQL 2000 database, using ODBC with MDAC 2.8 This is an intermittent problem and it occurs on all the clients (mostly winXP Pro) The problem is that from time to time, the ODBC connection fails and we get one of several errors: ODBC...more >>

nvarchar field error
Posted by jackyshi3333 NO[at]SPAM yahoo.com.cn at 5/16/2006 2:29:11 AM
My application uses ODBC3 to connect to sql server.And in one table a field is of type nvarchar. When I fetch the data, there is problem with Arabic and Korean words but not with Chinese or Japanese. I have searched for the information but with no useful help.Did someone encounter the problem an...more >>

NaN and SQL 2000
Posted by David at 5/15/2006 11:28:24 AM
Hi, I'm tried to insert a double.NaN (C#) into a float column in SQL 2000 (8.0). When I check the " select count(*) ", it retuns the count of all the records i've tried to insert into the table until now. Right... But, when i try to " select * ", it returns all records, less that one i ha...more >>

ODBC on SQL 2005
Posted by Axel at 5/15/2006 12:00:00 AM
Hi, I need to set up an ODBC Connection to a Navision DB. Under SQL 2000 I used the regular ODBC driver and it worked fine. With SQL2005 I just can select ".net Framework Data Provider for ODBC" and I can't get the connection up and running. Does there exist any other ODBC drivers which wo...more >>

ODBC Bulk Update
Posted by Mike C# at 5/14/2006 11:30:12 PM
Anyone know where I can find source code sample for the SQL BulkOperations Update by Bookmark. The one sample I found on Microsoft's website is incomplete and somewhat inaccurate. Does anyone know where I can find a working example somewhere? I was able to successfully get the Bulk Add (S...more >>

ODBC Connections
Posted by Simon at 5/12/2006 1:49:02 AM
I have a network with 6 machines sitting on it. All PC`s are configued in the same way. 5 of the machines connect to a SQL server via ODBC with no problems. The sixth PC however does not connect to the server giving the following :- Connection Failed SQL State '01000; SQL Server Error: ...more >>

SQL_TIMESTAMP_STRUCT.fraction > 0
Posted by AAO at 5/11/2006 5:16:02 PM
Does anybody know how to bind parameter of type SQL_TIMESTAMP_STRUCT to datetime columns in such a way that execution ({call XXX(?)) will not give me "Invalid precision value" if I specify SQL_TIMESTAMP_STRUCT.fraction > 0. It seems that if bind directly to SQL_TIMESTAMP_STRUCT there is no way...more >>

Extended Stored Procedure: Get the current db of the client
Posted by Hans Stoessel at 5/8/2006 2:41:59 PM
Hi Is there a way to get the current database of the client who calls my Extended Stored Procedure? I have written a DLL in Visual Studion 2005 for the SQL server 2003 in C/C++ using the functions srv_*. Thanks. Hans ...more >>

Change servername based on logon server
Posted by Ben at 5/8/2006 10:33:55 AM
Hi We are to use an application on two replicated sites, the application uses a user dsn. We propose to use a reg file attached to a logon script to amend the server name so that users with laptops can move transparently between sites. Is this the best method or is there another? Thank...more >>

[Q]Problems related to the MySQL linked Server.
Posted by ÀÌ»ó¼ö at 5/1/2006 12:00:00 AM
Dear everyone. I have two questions about the linked server for the MySQL. I need to connect to the MySQL DB from the my SQLServer 2000 SP4 on the Windows 2000 standard Edition(MDAC 2.8) So, I made a linked server at the SQLServer. I worked well, but I faced with some problem. 1. Query met...more >>


DevelopmentNow Blog