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

Server doesn't exist

 
   Database Help (Home) -> Programming RSS
Next:  replace the character {  
Author Message
tjina

External


Since: Oct 07, 2008
Posts: 1



(Msg. 1) Posted: Tue Oct 07, 2008 4:57 pm
Post subject: Server doesn't exist
Archived from groups: microsoft>public>sqlserver>programming (more info?)

I'm trying to create a report with Crystal reports on a Windows Vista
machine. When i try to add the Database ,which is on a windows server 2003,
using a Oledb connection i'm getting the following error.
[dbnetlib][ConnectonOpen(Connect()).]Sql server does not exist or access
denied, followed by the error."login failed Catalog information cannot be
retrieved"
Also, when i run a vb App connecting to the database using MDAC OLEDB i
getting the same error.

I have to say that creating the report and running the app from other client
machines doesn't give me that error. On the server ; TCP/IP connectivity and
remote connections is enabled.

Please help.

 >> Stay informed about: Server doesn't exist 
Back to top
Login to vote
sloan

External


Since: Jan 10, 2008
Posts: 204



(Msg. 2) Posted: Wed Oct 08, 2008 9:53 am
Post subject: Re: Server doesn't exist [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Save yourself alot of trouble and go to the PUSH method for Crystal Reports.

PULL method (which is what most people do because its "easy") is subject and
prone to issue like this.


"tjina" <stjinaton.TakeThisOut@nagico.com> wrote in message
news:%23ZTE89LKJHA.1012@TK2MSFTNGP04.phx.gbl...
> I'm trying to create a report with Crystal reports on a Windows Vista
> machine. When i try to add the Database ,which is on a windows server
> 2003,
> using a Oledb connection i'm getting the following error.
> [dbnetlib][ConnectonOpen(Connect()).]Sql server does not exist or access
> denied, followed by the error."login failed Catalog information cannot be
> retrieved"
> Also, when i run a vb App connecting to the database using MDAC OLEDB i
> getting the same error.
>
> I have to say that creating the report and running the app from other
> client
> machines doesn't give me that error. On the server ; TCP/IP connectivity
> and
> remote connections is enabled.
>
> Please help.
>
>
>
>

 >> Stay informed about: Server doesn't exist 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
SELECT CASE WHEN EXIST - Hello everyone I have a case statement that returns 0 or 1. Here is an example: SELECT (SELECT CASE WHEN EXIST( SELECT * FROM TABLE1) THEN 1 ELSE 0 END) This works fine but what if I want to check if another table has any rows also? My simple mind..

xml.exist bug ? - Hi I found a strange inconsistency with xml.exist consider the following example (adventureworks) I are four queries, the last three should combined should be the same result as the first but are not. using xml.exits = 0 in the where clause returns all ...

efficiency of IN vs select count(*) vs an exist statement - I've been trying to figure out which of the following queries is actually more efficient, Does anyone have any perspective on this? Using an In: SELECT [X] WHERE [Y] IN (SELECT TOP 1 Z FROM [Table2] ...

Multiple if exist Stored Procedure Problem - Why the following stored procedure does not work? I can't really see the error myself, and could this procedure be wrote more effectively??? any help would be greatly appreciated! CREATE PROCEDURE AddChurchAndType ( @Name varchar(100), @Address..

Can there be more than 1 table with the same name as long .. - Is it possible to have [Admin].[Members] and [Contracts].[Members] in the same table? Or do the tables have to be called something totally different?
   Database Help (Home) -> Programming All times are: Pacific Time (US & Canada) (change)
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 ]