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 >>
Don't see what you're looking for? Search DevelopmentNow.com.
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 >>
|