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

ADO Error in AdoConnection::open failed to create Connecti..

  
   Database Help (Home) -> Client RSS
Next:  cannot display chinese  
Author Message
Absolutely

External


Since: Jan 31, 2008
Posts: 2



(Msg. 1) Posted: Thu Jan 31, 2008 3:55 pm
Post subject: ADO Error in AdoConnection::open failed to create Connection COM Instance
Archived from groups: microsoft>public>sqlserver>clients (more info?)
Getting the subject event in the event viewer when trying to connect to a
SQL2005 database from a workstation. My other workstations are not having
this problem, so I'm sure it's related to this machine, but just can't
figure it out. It's an XP Pro SP2 machine. Protocol is TCP/IP. Can make
ODBC connection to the server without issue.

Other thing that is interesting is that when creating an ODBC connection the
SQL server shows up twice in the listing when selecting the server to
connect to. None of the other machines that work are doing this.

The specific application in question is GoldMine Premium Edition.

 >> Stay informed about: ADO Error in AdoConnection::open failed to create Connecti.. 
Back to top
Login to vote
Sean McCown

External


Since: Jan 23, 2008
Posts: 60



(Msg. 2) Posted: Fri Feb 01, 2008 12:17 pm
Post subject: RE: ADO Error in AdoConnection::open failed to create Connection COM I [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
In the ODBC have you tried selecting the 'other' server?


--
Read my book reviews at:
www.ITBookworm.com

Blog Author of:
Database Underground -- http://weblog.infoworld.com/dbunderground/
DBA Rant – http://dbarant.blogspot.com




"Absolutely" wrote:

> Getting the subject event in the event viewer when trying to connect to a
> SQL2005 database from a workstation. My other workstations are not having
> this problem, so I'm sure it's related to this machine, but just can't
> figure it out. It's an XP Pro SP2 machine. Protocol is TCP/IP. Can make
> ODBC connection to the server without issue.
>
> Other thing that is interesting is that when creating an ODBC connection the
> SQL server shows up twice in the listing when selecting the server to
> connect to. None of the other machines that work are doing this.
>
> The specific application in question is GoldMine Premium Edition.
>
>
>
>
>

 >> Stay informed about: ADO Error in AdoConnection::open failed to create Connecti.. 
Back to top
Login to vote
Absolutely

External


Since: Jan 31, 2008
Posts: 2



(Msg. 3) Posted: Sat Feb 02, 2008 6:30 am
Post subject: Re: ADO Error in AdoConnection::open failed to create Connection COM I [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Yes, and it didn't matter. Got it fixed finally. Apparently it was a hosed
MDAC, as reinstalling this solved the problem. Took a little while to
figure out how to do this with an XP that had SP2 embedded in the install,
but all better now.




"Sean McCown" <SeanMcCown.TakeThisOut@discussions.microsoft.com> wrote in message
news:C5506829-4311-4553-AFBF-438A9419D075@microsoft.com...
> In the ODBC have you tried selecting the 'other' server?
>
>
> --
> Read my book reviews at:
> www.ITBookworm.com
>
> Blog Author of:
> Database Underground -- http://weblog.infoworld.com/dbunderground/
> DBA Rant - http://dbarant.blogspot.com
>
>
>
>
> "Absolutely" wrote:
>
>> Getting the subject event in the event viewer when trying to connect to a
>> SQL2005 database from a workstation. My other workstations are not
>> having
>> this problem, so I'm sure it's related to this machine, but just can't
>> figure it out. It's an XP Pro SP2 machine. Protocol is TCP/IP. Can
>> make
>> ODBC connection to the server without issue.
>>
>> Other thing that is interesting is that when creating an ODBC connection
>> the
>> SQL server shows up twice in the listing when selecting the server to
>> connect to. None of the other machines that work are doing this.
>>
>> The specific application in question is GoldMine Premium Edition.
>>
>>
>>
>>
>>
 >> Stay informed about: ADO Error in AdoConnection::open failed to create Connecti.. 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Administrator logon rejected with ODBC Drivers error '8004.. - I'm running SQL Server 2000 under Windows 2000 Advanced Server. Authentication is set up as Windows Only. The Administrator account for the server is set up as an SQL user (this is done by default). I'm using the following ASP code to log onto a sample...

sqlTransaction Complete Error-dataype was image now varbin.. - Hi, This is being called in a C# loop within an ado.net transaction from C# 1.1 code. It is used to write large file data to a SQL Server database in chunks, rather than in one go. I had the stored procedure below, which worked until the image..

OLEDB: Prepared cmd with NULL input param for NOT NULL INT.. - Provider: SQLOLEDB Version: SQL Server 2000 8.00.760 Script for creating table: CREATE TABLE [dbo].[ADRVERTRETER] ( <font color=purple> ; [ROWID] [timestamp] NULL ,</font> <font color=purple> ; [ROWVERTRETER] [int] NO...

[MS Design Tools] - Class not registered.&quot; - On a Windows 2000 pro workstation I am using SQL 2000 enterprise manager I am trying to return all rows, I get the error message "An unexpected error happened during this operation. [MS Design Tools] - Class not registered." I have reinstall...

Need help choosing front end for SQL Server - I've been working on an Access 97 database that's pretty much reached it's limit in terms of performance and reliability. Although it supports relatively few users (5-10 concurrent) it contains a lot of data (around 30 tables, some with several million..
   Database Help (Home) -> Client 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 ]