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