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

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

  
   Database Forums (Home) -> Client RSS
Next:  sql learning  
Author Message
Absolutely

External


Since: Jun 08, 2005
Posts: 4



(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: Nov 21, 2007
Posts: 82



(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: Jun 08, 2005
Posts: 4



(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" wrote in message

> 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:
login failed db-library network - I am getting this error when loggin in to our application connecting only to a specific server. We were experiencing some "db connection or not enabled errors" previously and to solve the problem I installed the SQL Client Network Ulitities a...

driver's sqlallochandle on sql_handle_env failed - i have just installed sql clinet (Microsoft SQL Enterprise Manager Microsoft Corporation Version: 8.0) on windows XP sp2 . whenever i try to reg new sql servers through Enterprise Mgr it gives me this error . it looks like its associated with ODBC ...

SSMS "open table" - When I first loaded SQL SERVER 2005 onto my test box, I've noticed that on a few tables I was able to right-click on a table and select "open table" and it would open the table, but this wouldn't work on all tables. I don't recall which tab...

does anyone know how to open access by todays date using sql - Hi Can anyone point me in the right direction here, I would like to open a table in access 2003 by date. I have an asp web page which needs to read data from a table with each days today's date (which ever day that is) then a new table is created with..

[Microsoft][ODBC SQL Server Driver][SQL Server]Login faile.. - We changed from sql 7 to 2000, crissis mode. One use with a laptop keeps getting the error when connecting to the sql server. SQL 2000 latest, mixed mode. Laptop xp pro latest, mdac is latest. I looked up sql server 26000 and 18452. I was not able to....
   Database Forums (Home) -> Client 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 ]