|
Linking an Sql view ask for unique field
using TransferDatabase for Linking an Sql view
poping up a window asking to select the field with unique fileld
how can i avoid this?
...
Wed, 29 Dec 2004 17:31:24 +0200
|
link tables to sql server by code
using access 2000
how i can link a table from sql server by code?
...
Wed, 29 Dec 2004 16:44:35 +0200
|
Memo filed in SQL-server with Access 97
I am using Access 97 as the front end and SQL Server 2000 on the back end. I
have a few fields in SQL that have more than 255 chars. The fields are
defined in SQL as nvarchar with a size of 1000. However, when I open the
linked table in Access, it only shows the field with 255 chars. It shows
#Error in othe ...
Tue, 28 Dec 2004 18:15:17 +0100
|
SQL server access problem
I'm running SQL2000 on an Win2k box also running IIS.
I would think it would be faster to connect using a "localhost" type of
connection rather than a machine name but I haven't been able to get the
syntax. For security conecrns we changed the default port.
The Connection string I am using for my web apps ...
Tue, 28 Dec 2004 07:47:03 -0800
|
Error selecting text from a SQL database
Hello,
I have an application that used an access database and I am currently
migrating to SQL Server. The s ...
Thu, 23 Dec 2004 20:49:31 GMT
|
SQL Disconnects Intermittenly During Day
I have two users who are being disconnected from the server intermitently
during the day. We're running Access 2000 and Great Plains. It appears that
the odbc connections are stepping on each other somehow.
The error message is Connection Failed: Sqlstate 01000.
[Microsoft][ODBC SQL Server Driver][TCP/IP So ...
Thu, 23 Dec 2004 10:27:06 -0800
|
access and sql
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 for it! ...
Tue, 21 Dec 2004 13:19:40 -0800
|
Access Violation in SQLSRV32.DLL
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 down the
cause of ...
Thu, 16 Dec 2004 11:03:16 -0800
|
Query Analyzer and ODBC
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 as well. Howeve ...
Wed, 15 Dec 2004 14:37:11 -0800
|
Stored procedure performance mystery
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
Table #4: 3
The ...
Wed, 15 Dec 2004 12:18:08 +0200
|
Error Executing DTS package from SP with ODBC connection
I have a stored procedure create for the sole purpose of launching a DTS
package. I can post the SQL later if necessary.
The problem is that I have multiple DTS packages that I would like to
execute in a SP. The sole purpose for this is that we have data stored and
being used in a foxpro database and I a ...
Tue, 14 Dec 2004 16:25:00 -0600
|
Linking tables to Access Front end
I have been given the task of converting an access database back end to
an sql server back end and then linking these tables to the access
front end.
Exporting the back end tables to SQL server was fine, however there is
a problem with the autonumber field on a table. This field was exported
correctly, SQL serv ...
Tue, 14 Dec 2004 07:20:46 -0600
|
Excel 200 zero-size window?
Running Excel 2000 under Win98, the standard (non-maximised) Window size
seems to have become zero.
In other words, when starting Excel either by running excel.exe (from
shortcut or directory display) or by clicking on an .XLS file, an entry
appears in the taskbar, but no window opens on the screen. Right- ...
Mon, 13 Dec 2004 17:39:01 -0000
|
Error updating records in ADO disconnected recordset
I need urgent help solving a problem updating records in disconnected
recordsets.
The application characteristics are as follows:
The database resides in SQL 2000, running on Windows 2003 Sever
The application is written in VB 6 and uses ADO
I use MDAC 2.8 to manage connection to the SQL Server
The appl ...
Sun, 12 Dec 2004 21:17:02 -0800
|
Problem importing data from Interbase using DTS
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 (tables ar created) t ...
Sun, 12 Dec 2004 13:59:24 +0100
|