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 ???

My Asp.net application can't connect to the SQL server from the app
server, but an asp page and I can connect to the SQL server, the server
also can't connect to a database in other machine.
Tks,

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 ...

We are planning to start warehousing some of the data that currently resides
on an as400 (using DB2) on a MSSQL 2000 server.  Has anyone monitoring this
group gone through such a project?

I have a list of CustomerID's that I need to oull address information from a
linked Oracle database.
I can query individual numbers from query analyzer. However I would like to
have my list of CustomersID's be automatically processed through the

i tired my best to get answer of my issue but no one helped me in ORacle OTN
newsgroups , please if you know how can ORacle Forms 6i can connect with SQl
Server 2000, kindly write.
Thanks

Can anybody please help me how to set up a conncetion between IIS & SQL
Server on seperate machine.
1. Domain is same
2. I've tried as per the article 176380, but we are facing some problem on

I have an access DB (2000) with links to tables in SQL server.
If I go back to my original DB and add a field, it doesn't show in the
Access list. I have to delete the link and then re-connect it.
Is there a better way of dealing with this?

I need to retrieve a value from linked server (oracle) and store it into a
local variable of a stored procedure .
The only solution that I have found is to use a tempTable (the query is
parametrized so I need to create a string variable with the full query):

We've been running a web app for months now, and then suddenly, that web server could not connect to the remote SQL instance anymore.  We are using a standard TCP configuration with SQL default port.  No alias is used.  We use the SQL instance name (as opposed to IP) to connect.

Is there a way to allow a client PC connect to my default SQL instance on an
XP Pro SP3 machine without turning off the Windows Firewall?

Is there a type 4 JDBC driver for SQL Server 6.5?  I see that the latest
driver does not support SQL Server 7.0 but appearently you can still use it.  
Is this the same with 6.5?
Thank You.

One of my user tried to pull data out of SQL Server into
Excel sheet via Microsoft ODBC SQL Server driver. She got
the following error: ( The data volumn is small with 700
rows. )

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;

I want my application's Installer to automatically install the SQL
Connectivity on machine in which the Connectivity does not exist. For this i
require a Stand-Alone installer (to be called from my Installer if
connectivity is not found).