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 > december 2004

link tables to sql server by code
Posted by Sam at 12/29/2004 4:44:35 PM
using access 2000 how i can link a table from sql server by code? ...more >>


localhost is not mapped to server name
Posted by masoud bayan at 12/29/2004 3:32:57 PM
Hi, It is a long time that I have been using my box and have some .NET apps running on it which use a connection string with Server=localhost and I have not had any problem yet. Today I have updated my box Windows with recent HotFixes (well I am not 100% sure it is the reason of this probl...more >>

Error selecting text from a SQL database
Posted by mageos at 12/23/2004 8:49:31 PM
Hello, I have an application that used an access database and I am currently migrating to SQL Server. The software is designed to use Odbc object found in the .Net framework version 1.1. I have a simple select statement that is driving me nuts. It works fine with the Access databases b...more >>

access and sql
Posted by vincent arntjen at 12/21/2004 1:19:40 PM
hey, i want to use access as a back-end database and sql as front-end . i already made the entire access db but not the db in sql ! how do i start ??? THANKS IN ADVANCE *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded fo...more >>

Access Violation in SQLSRV32.DLL
Posted by Bennie at 12/16/2004 11:03:16 AM
I have run into an issue with attempting to process a large result set returned by SQL Server 2000. This issue disappears when we reduce the amount of data in the database that is available to the query by deleting records and reappears when we add the data back. I've been able to narrow dow...more >>

Query Analyzer and ODBC
Posted by BrianM at 12/15/2004 2:37:11 PM
Greetings, Can the Query Analyzer be used to connect to a DB2 database on an AS/400 via a Rumba ODBC connection? I created the ODBC connection in the System DSN section of my ODBC Data Sources. I can use PROC SQL statements in SAS with it and the Borland Database Engine can use it just fine...more >>

Stored procedure performance mystery
Posted by Magnus Österberg at 12/15/2004 12:18:08 PM
My application fetches a batch of data through a web service and writes 1000 entities per batch to a SQL Server 2000 database. There are 4 tables in every batch. There are the following number of SQL commands executed per average of every batch; Table #1: always 1 Table #2: 5 Table #3: 5 Ta...more >>

SQLServer 2000 from unix solaris 2.8 server
Posted by Notre compte nouveau compte FREE at 12/14/2004 10:51:41 PM
I want to access to SQLServer 2000 database in intel platform from unix solaris 2.8 server. Where can i find the ODBC drivers for Solaris 2.8 ? Famille KNICKREHM-JACQUES KNICKREHM-JACQUES Coralia, Lorena, Nicolas, Thomas Bettina et Pascal mail : knickrehm.jacques@free.fr 10, rue du Présiden...more >>



Linking tables to Access Front end
Posted by Friel at 12/14/2004 7:20:46 AM
I have been given the task of converting an access database back end t an sql server back end and then linking these tables to the acces front end. Exporting the back end tables to SQL server was fine, however there i a problem with the autonumber field on a table. This field was exporte cor...more >>

Problem importing data from Interbase using DTS
Posted by Anders K. Jacobsen [DK] at 12/12/2004 1:59:24 PM
Hi im trying to import a old Interbase 6 database using MSSQL 2000 DTS import wizard. Im using Firebird / Interbase 1.5 ODBC driver as provider for the Interbase. Everything works perfect if i choose to import one table at a time. But if i choose 2 or more the wizards excutes the DDL (tabl...more >>

Import HTML and Tab delimited into SQL
Posted by Eric at 12/9/2004 3:29:01 PM
Hi, I need to import files from either HTML or Tab delimited format into SQL Server. I imagine this would involve DTS and/or a DSN, but I'm not sure of the details. I'm able to standardize the filename and directory using code, so that's not a problem. Any ideas?...more >>

80004005 ODBC SQL Server Driver shared memory or TCP/IP sockets er
Posted by tapman at 12/4/2004 1:33:01 AM
Hi all, I have been getting these errors on simple ASP code on my web site: |80004005|[Microsoft][ODBC_SQL_Server_Driver][TCP/IP_Sockets]ConnectionWrite_(send()). |80004005|[Microsoft][ODBC_SQL_Server_Driver]Timeout_expired |80004005|[Microsoft][ODBC_SQL_Server_Driver][Shared_Memory]SQL_Se...more >>

Missing Connection Objects
Posted by Jason at 12/2/2004 9:23:06 AM
Hello, I installed MS Office 2003 and SQL Server 2000. However, when I went to create a DTS pkg, I found that the following connection objects are missing: Excel, Access, Dbase5, HTML, Paradox Can someone please tell me what is going on? I am wondering if it has something to with MDA...more >>

Connection management
Posted by Pedro Jose Caceres at 12/1/2004 8:26:08 PM
hello, I'm using Visual Foxpro and ODBC / sql server 2000. How should i manage conections ? opening and closing it on each form ? or opening at the begining of application and closing it at application finish ? Thanks ...more >>

Linked table with percentages
Posted by SharonInGa at 12/1/2004 6:41:09 AM
I'm using Access as a front end to a SQL table. What format do I need to put the SQL fields in to appear as percentages in Access....more >>


DevelopmentNow Blog