I have 2 networks network A and B both networks are running SBS 2003.  
On Network A I have installed SQL 2005  
On Network B I have Yardi SQL
Both the networks are being controlled by SBS 2003.  What I would like to do

Hi at all,
I have a database on a sqlserver 7.0. I access to it via odbc api. So i need
t change the name od a table. Is there a way via SQL* api functions to
change the name of a table?

    I have an C++ application that uses ODBC to access SQL server. The
application invokes the SQLAllocHandle() function to:
1. Get an Environment handle (Created only once)
  SQLAllocHandle(SQL_HANDLE_ENV, SQL_NULL_HANDLE, &env)

I hope this is the correct forum for this question.  I'm posting here because
I suspect an ODBC or OLE DB setting is at the root of this problem.  I have a
very long string value, 2512 characters, that I need to store in the database
to retrieve later.  No matter what I try, ...

I really appreciate if someone could help me with this problem.  Actually i
m trying to create a crystal report using stored procedure which uses temp
table.  First time when i created the report using this stored procedure it
worked and it still works.  But when i tried to ...

     I am having problem while restoring database to another SQL Server. I
receives below given message. My both SQL Servers are 7.0.
MESSAGE
SQL DMO (ODBC SQL  Stae 42000)

I have seen one other poster with a similar symptom, but noone was able
to help them. Perhaps this posting will get better results
I have a very simple java method that does the following:
Code:

Does SQL Server 2000 Personal Edition or SQL Server 2000 Developer Edition
have connection limitations compared to SQL Server 2000 Enterprise Edition?
Specifically, should a database running SQL Server 2000 Developer's Edition
(or Personal Edition) on a Windows XP Professional ...

We just setup a new Windows 2003 server and we can't use System DSNs.
If we setup user DSNs they work just fine, but everytime we try to use
a System DSN it can't be found.
Does anyone have any suggestions?

i have an access MDB linked by ODBC to SQL2k.
I get a strange behaviour when i do an INSERT INTO to a local Mdb table
from  "LEFT OUTER JOINED" SQL tables.
If the related table hasn't related record to the first table,

hi...
If any MS DTC sample application is available.
Want to know how different modules (MS DTC,
Transaction Mgr & Resource Mgr etc) work together and

My project currently is this: Migrating access reports to sharepoint
and sqlserver. I didn't not pick the enviornment, I'm merely attempting
it.
Is there any information about connecting these two? Is there anyway to

I have an SQL Server database that uses 'datetime' fields. I want to write
to these with SQLBindParameter(). What SQL type should I specify?
If I use SQL_TYPE_TIMESTAMP I get errors from SQLExecute() and
SQLGetDiagRec() states that there is an overflow.

I have the ODBC tracing enabled on my development machine using the
"default" tracing DLL.
I thought it was just our applications causing this, but I'm also seeing
this when using isqlw (SQL Query Analyzer).

Our company only allow the use of Merant 3.60 32-bit Sybase ODBC Driver
(Version) for connection to Sybase Sybase 12.5.3 DB  on Sun OS 5.3)
I have a stored procedure on Sybase 12.5 ASE which
a) Select 'dummy'