Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Client’s_connection_behaving_dif

 
   Database Forums (Home) -> Connect RSS
Next:  unable to access sql 2005 database - in middle of..  
Author Message
Mark D Langdon

External


Since: Feb 10, 2008
Posts: 1



(Msg. 1) Posted: Sun Feb 10, 2008 9:17 pm
Post subject: Client’s_connection_behaving_dif
Archived from groups: microsoft>public>sqlserver>connect (more info?)

I have an application that connects to a SQL 2000 server though a File based
DSN located on a file server. The application behaves fine untill I install
MS Office it then returns no data from any queries that the application
requests. I have looked at the following.

Microsoft Data Access Components (MDAC) is version 2.5 Sp3 before the Office
install.

After the Office install MDAC is version 2.8 Sp1

When I look at the queries in Profilers the following is displayed

This Works
Exec sp_prepare @P1 output, NULL, N’SELECT Exitem_Desc FROM vtblProcess4
WHERE vtblProcess4.Exitm_No = ‘’39006590’’’,1

This does not Work
Exec sp_prepare @P1 output, NULL, N’SELECT Exitem_Desc FROM vtblProcess4
WHERE vtblProcess4.Exitm_No = ‘’39006590’’’

Am I looking at the right area with MDAC, is there any way to make the newer
version backwards compatible?

Thanks for any help,
Mark.

 >> Stay informed about: Client’s_connection_behaving_dif 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Client software - I have several developers that want access to my SQL server and I was wondering instead of giving them Remote desktop access to access Enterprise manager. I am going to install the SQL client tools locally on their PC. My SQL server is behind a..

will a client application using ado.net get an exception i.. - will a client application using ado.net get an exception if the command is executing a stored procedure that does a RAISEERROR in its tsql?

?? Turning Off TCP/IP Client Has No Effect ?? - Hi Everyone, I was doing some testing with client configuration and I'm seeing something I don't understand. Let me explain the setup. My setup involves a single machine running "SQL Server Express 2005". As you probably know, SSE includes th...

Client connect to SQL SERVER 2000 - Hello, I have one SQL Server 2000 that has been installed into a domain, having allowed "Windows and SQL Server" authentication and using as connectivity options Named Pipes and TCP/ip - 1433 On every client computer that is ...

Connectivity errors from the client - Hello! We are getting intermittent '[Microsoft][ODBC SQL Server Driver][DBNETLIB]General network error. Check your network documentation' error from the client connected to SQL Server 2005 SP1 64-bit. I have noticed errors similar to one below in...
   Database Forums (Home) -> Connect All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]