Hello
I am trying to import tables with data from Access to SQL.
The problem occures when the Primary keys and identity are not being saved
and i need to do it manually.

I'm writing an Access 2003 ADP project and need to connect to a remote
Microsoft SQL Server 2000 database. I'm unable to connect, and I'm pretty
certain the problem is in the "server name" field. I get this error:
"Test connection failed because of an error in initializing ...

I have port forward 1433 on the firewall and tried to connect remotely to
the server but could not get it to connect.
Is there anything that I have to enable from the server?  Any tool to test
this?

I'm trying to create an ODBC DSN from client A to server B via the
control panel applet.  I receive the "Server does not exist or access
denied".

I have c# application that uses SQL SERVER  databases.
The problem is that after I close all connections to a database in order to
make actions (detach, copy or delete) on the current database I get a
message saying that the database still has connections.

I have a strange connection error that I believe is related to security. But
I need some advice.
I need to know what are exactly the permissions needed to establish a linked
server connection through network using integrated security.

when i am connecting the sql server in windows 2003 using the sql analyser the following error occurs
Server: Msg 17, Level 16, State 1
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not exist or access denied.
the authentication mode is mixed.

I am having a security problem configuring a linked server to an access mdb
file when the user is Windows Authenticated.  I have the connection setup for
all logins to use the admin account with no password.  This works with no
problems when logged into SQL Server with a SQL ...

I have a linked server pointing to a folder where foxpro tables exist.
The tables are listed when I click on the linked server/tables.
However I get this error when in query analyer I say: select * from
vfplinked...clients

Hello..
I found some articles like the one below from the gurus on this site..
***************************************************************************************************************
Understanding this topic is one of the most important steps you can take to

Until recently (stopped working this week) I have been able to backup my sql
database (on a windows 2000 server) to a mapped network drive(mapped to
another 2000 server). I am a user on both servers (administrator). I can see
the the drive in explorer. I can access the files.

I have Sybase 12.5.2 Database running in another domain.
I am currently working in a different domain under SQL 2000. I need to call
a stored procedure in Sybase by passing some input parameters and expect
some outptu parameters.

   We have a client-server application written in VB 6.0 that connects to a
SQL Server instance on the local network.  We're interested to know if we are
able to use our same VB 6.0 application but connect to a SQL Server that is
hosted on a web domain.  That is, if we have our ...

I am experiencing performance problems with an aplication running over a SQL
Server 2000 Database. The server that holds SQL Server has 2.8 GB of RAM
memory. When there are just on or two users working, the aplication
performance is suportable, but when more users are using the ...

How can I connect to database from a remote computer in the same domain?
I developed many database applications using Access, but now I need a code
snippet to make some of my existing application to run in a remote Sql server
with the same structure (databases, views)....and I ...