Receiving a Communication Link Failure ODBC

Hi All,
I have a client using SQL Server 7.0 Sp3, and they have
clients connecting to it via ODBC (32) bit driver, some of
them are receiving a error message of communication Link
failure. They have MDAC 2.7.1 installed, they tried using
TCP/IP, and Name pipes, the error keeps happening.
If you have any ideas it would greatly be appreciated.
Thanks
ScottCan you ping the sql server when they receive the error?

Rebuild database in a SQL server

Hello,
Had a system failure and the disk volume, where all
databases were resided on, was gone.
SQL application is on a different disk volume, and there
is BAK copy for master, msdb and a user database.
Who can share his/her experience or lead me to tech info
links to rebuild the database?
Thanks in advance.
EricYou might want to pay the $250.00 or so for tech support to walk you thru
this:
http://support.microsoft.com/default.aspx?scid=fh;EN-US;sql SQL Support
http://www.mssqlserver.com/faq/general-pss.asp MS PSS
But here are some links that may help along with the BooksOnLine help file:
http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers
Andrew J. Kelly
SQL Server MVP
"Eric Chen" <eric.chen@.broadvision.com> wrote in message
news:2b4301c33f56$c01fe940$a401280a@.phx.gbl...
> Hello,
> Had a system failure and the disk volume, where all
> databases were resided on, was gone.
> SQL application is on a different disk volume, and there
> is BAK copy for master, msdb and a user database.
> Who can share his/her experience or lead me to tech info
> links to rebuild the database?
> Thanks in advance.
> Eric
>

ReadWriteDeleteMessageFile FAILURE with SQL Server Mobile Server Agent Diagnostics

Hi all.

Is there a difference with sql replication between sql server 2005 64bit and sql server 2005 32bit?

Both are on a Windows 2003 server. One is 32 bit and the other one is 64 bit.

The first time I set up sql replication (test environment), it was on a 32 bit sql server. This worked fine.

The second time I wanted to set up replication (live environment), it was on a 64 bit sql server. This didn't worked fine.

I can't call the sqlcesa30.dll file on the 64bit server with IIS. So I called the dll via a remote IIS server.

This worked but gave me the following error when calling the following URL:

http://domain/PDASYNC/sqlcesa30.dll?diag

SQL Server Mobile Server Agent Diagnostics

2007/07/31 14:26:55

General Information Item Value Server Name domain URL /PDASYNC/sqlcesa30.dll Authentication Type Anonymous Server Port 80 HTTPS off Server Software Microsoft-IIS/6.0 Replication Allowed RDA Allowed Logging Level 0

Impersonation and Access Tests Action Status ErrorCode Impersonate User SUCCESS 0x0 ReadWriteDeleteMessageFile FAILURE 80070003

SQL Server Mobile Modules Test Module Status ErrorCode Version SQLCERP30.DLL SUCCESS 0x0 3.0.5207.0 SQLCESA30.DLL SUCCESS 0x0 Unknown

Reconciler Test Reconciler Status ErrorCode 9.0 Database Reconciler SUCCESS 0x0 8.0 Database Reconciler FAILURE 0x8007007E

SQL Server Module Versions Module Version sqloledb.dll 2000.86.1830.0 9.0 replrec.dll 2005.90.2047.0 9.0 replprov.dll 2005.90.2047.0 9.0 msgprox.dll 2005.90.2047.0 8.0 replrec.dll 2000.80.760.0 8.0 replprov.dll 2000.80.760.0 8.0 msgprox.dll 2000.80.760.0

After seeing this I looked up what ReadWriteDeleteMessageFile could mean. It appeared to be some NTFS acces problem. But when I checked the security settings, it all seemed to be ok.

Has anyone any idea what else to check? Or is sure that I must have done something wrong?

Thanks in advance,

Arjan

Hello,

Currently there are some issues with server tools on 64 bit machines. I think, we can get 64 bit SQL CE, sometime, in near future.

Thanks

Udaya.

|||

Ok, thnx.

We currently got it working through a 32bit webserver