|
|
|
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 |
CodeAssist Err:35602 Key is not unique in collection Posted by Tark Siala at 4/30/2006 8:50:04 PM hi
i use CodeAssist application from Shredian Company.
its good application to make VB/SQL Code from any Database (Code Generator).
but now when i connect to SQL2000 Database by ODBC and open any table in
database i have this error:
35602 Key is not unique in collection
any one know why? ...more >>
ODBC system DSN Issue Posted by Shahin at 4/26/2006 4:45:02 AM Hi,
I have a problem with SQL 2005, ODBC Connection,
I did create a ODBC conection with user DSN to a SQL 2005 database, and
there is a 3rd party aplication that we use to access that SQL database every
thing went fine.
I did create ODBC connection with System DSN to the same Database but ...more >>
MS-SQL AND ACCESS LINKED TABLE PROBLEM (#ERROR FIELDS) (cross) Posted by Savas Ates at 4/25/2006 5:09:23 PM I have 3 tables with relations in MSSQL and try to link it to my access
database. But my fields returns with #ERROR .. I didnt find any solution ..
HEre is the my codes.
if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[TBL_PRODUCTS]') and OBJECTPROPERTY(i...more >>
bcp_bind and SQL DATETIME type Posted by Michael C# at 4/25/2006 1:30:44 PM Hi all,
I'm working on a simple ODBC API bulk load application and I've run
into a problem. I am binding variables in memory and sending the rows
as prescribed in the ODBC 3.0 API Reference and on MSDN. Everything
works fine for SQL VARCHAR and SQL INTEGER data types; however, I run
into is...more >>
SQLBulkOperations Posted by Mike C# at 4/24/2006 10:08:37 PM Anyone know where you can find a VC++ wrapper for SQLBulkOperations; in
particular Insert operations.
Thanks
...more >>
Catastrophic Failure Posted by Craig B at 4/23/2006 5:40:01 PM I have a site that has had 70+ pc with msaccess frot end connected to sql2000
server back end. This site has been in production for 12 months.
With in the last week we have experienced an increasing frequency of
-2147418113 Catastrophic Failure errors. The application writes data from a
...more >>
how i can connect to table in SQL? Posted by Tark Siala at 4/19/2006 5:30:13 PM hi
i working on VB6 + SQL2000
i have table called (tblBuffer)
and want do something in my application everytime table added new record
(its like trigger in SQL)
thats mean if someone add new record to this table, this table call my
application to do some event.
now i made small monitor (w...more >>
Problem freeing resources used by SQLPrimaryKeys Posted by Shannon Cayze at 4/19/2006 8:56:06 AM Hello all,
First of all, I'm a little inexperienced with the odbc32.dll API's and
not too familiar with all the details of their usage. I have a list of
tables in the database and I'm iterating over that list and building
the primary key for each table. When I perform the iteration my
machine...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Loss of Decimals Upon Link to Access Posted by Mike C at 4/19/2006 8:11:02 AM Hi. I have an Access DB that's linked to a SQL DB view. The SQL view is based
on a table which has some data types as float. I created a view on the table.
The view shows me units of a product divided by units of all products. The
results are expressed in the view as decimals. So, for example,...more >>
Extended Stored Procedure: Loopback connection Posted by Hans Stoessel at 4/19/2006 12:00:00 AM Hi
How can I create a loopback connection? I havn't a DSN and want make a
connection to the SQL server in my Extended Stored Procedure. As I see I can
read the user and the password in my Extended Stored Procedure, but i havn't
the DSN. Can I make a (local) connection without a DSN?
I want ...more >>
Unable to create login instance--why? what it means? Posted by JuJuBeed at 4/17/2006 9:12:22 PM When I try to install SQL Server 2000 Desktop Engine, I get the BPsetup
error that says "Unable to Create a login instance." Then when I click ok it
says "Unable to Add system server role." Then when I click ok it says
"Unable to add login and grant access to database." Then it aborts setup.
...more >>
ODBC Linked Server Security Problem - Anybody? Posted by Datamover at 4/12/2006 11:33:53 AM Hi all,
I'll provide as much detail as I can. I have read many messages
regarding this topic, but I just can't seem to follow them in my
specific case. Sorry I'm so dumb...
Here goes:
1) I have a Microsoft SQL Server 2005 installed in mixed mode (NT
security plus standard SQL secur...more >>
ADODB.Recordset Invalid Column Name VB6 Posted by samshollow NO[at]SPAM yahoo.com at 4/11/2006 6:21:57 AM I'm trying to limit the recordset retuned in the sub below by a
variable called vcnumber. I'm not sure what the problem is but I keep
getting the error "Invalid Column Name" when I set sqlstring to "select
* from vc_names where vc_case_number =" & vcnumber. If I don't try to
limit the recordse...more >>
SQLS 2000 Record Locking Problems (VC++) Posted by Arnie at 4/7/2006 4:26:04 PM Sorry for the wordiness.
VC++ 8.0, XP Pro SP2, etc. We're porting from Borland C++
Builder/ADO to VC++/ODBC. This worked fine with BCB/ADO.
First, the rationale. We have a number of 'batch' (console) apps
that can not be run at the same time due to possible conflicts in
DB tables. Th...more >>
HELP: ODBC Registry Error Posted by Steven Woody at 4/5/2006 6:29:51 PM Hi,
some registry entries about sql server odbc driver was accidently
deleted by me. now, in the driver page of odbc data source administor,
i can not found the sql server driver in the list. for the reason, the
SQL Server 2000 can not complete its installation normally, and the
problem is ...more >>
where to find MS SQL odbc driver ? Posted by Steph at 4/5/2006 12:00:00 AM Hello,
I want to install MS SQL odbc driver on several client machines during
a setup process, to access data located on a sql server.
I can't find on microsoft web site, any odbc driver for MS SQL.
What do I have to install ? MDAC ??
Is there a standard package for setup process ? (I only n...more >>
HELP!---Stored Procedure in ASP Posted by segis bata at 4/3/2006 1:37:17 PM Hello everyone,
I'm writing you because I need help in something that's taking too long. =
I want to build a Stored Procedure to be accessed by an ASP page and I =
need that Stored Procedure to do a couple of things:
1.. Depending on parameters sent by the ASP page, do a SELECT =
statement ...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |