SQL error in HQ Admin File Configuration.
Personal Finance Forum Index Personal Finance
Talk about personal finance: tax, stocks, retirement, funds, and financial software.
Investing Blog
 
 FAQFAQ   MemberlistMemberlist     RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 
 
Google
 
Web pftalk.com
SQL error in HQ Admin File Configuration.

 
Post new topic   Reply to topic    Personal Finance Forum Index -> POS
Author Message
SBGSG-CCL
Guest
Posted: Tue Oct 11, 2005 6:55 am    Post subject: SQL error in HQ Admin File Configuration. Reply with quote
Hi
I have installed HQ Administrator, HQ Manager onto client PC. The HQ
database has been set up int he server. In HQ Administrator, after I enter
the server, log in id , password and database. I encountered SQL error "Error
: 21472209999 Method '~' or object '~' failed (Source ADODB. coonection)"
when I click "Test Database Connection".

In HQ Administrator, if I click file -> Connect to same server and same
database -> succesfully connected with no error. However, if I try to run a
query such as "select * from item", the same error message as above will
apear.

Sometimes, another error meesage will appear "Error #3706, Provider not
found. It may not be properly isntalled. (Source : ADODB. Connection)", when
we try to test database connection.

We have tried unstalling RMs and rebooting the PC, but same errors appeared
each time we tried to "Test Database Connection".

We had no problems at all with another PC with the same specs.

Has anyone encountered this before? Would greatly appreciate some
enlightenment.

Thank you in advance

Back to top
ozzie
Guest
Posted: Tue Oct 11, 2005 7:42 am    Post subject: RE: SQL error in HQ Admin File Configuration. Reply with quote
Sounds almost like MDAC isn't installed properly or something like that.

"SBGSG-CCL" wrote:

Quote:
Hi
I have installed HQ Administrator, HQ Manager onto client PC. The HQ
database has been set up int he server. In HQ Administrator, after I enter
the server, log in id , password and database. I encountered SQL error "Error
: 21472209999 Method '~' or object '~' failed (Source ADODB. coonection)"
when I click "Test Database Connection".

In HQ Administrator, if I click file -> Connect to same server and same
database -> succesfully connected with no error. However, if I try to run a
query such as "select * from item", the same error message as above will
apear.

Sometimes, another error meesage will appear "Error #3706, Provider not
found. It may not be properly isntalled. (Source : ADODB. Connection)", when
we try to test database connection.

We have tried unstalling RMs and rebooting the PC, but same errors appeared
each time we tried to "Test Database Connection".

We had no problems at all with another PC with the same specs.

Has anyone encountered this before? Would greatly appreciate some
enlightenment.

Thank you in advance
Back to top
SBGSG-CCL
Guest
Posted: Tue Oct 11, 2005 7:59 am    Post subject: RE: SQL error in HQ Admin File Configuration. Reply with quote
Hi

Can you suggest how I can check MDAC?

"ozzie" wrote:

Quote:
Sounds almost like MDAC isn't installed properly or something like that.

"SBGSG-CCL" wrote:

Hi
I have installed HQ Administrator, HQ Manager onto client PC. The HQ
database has been set up int he server. In HQ Administrator, after I enter
the server, log in id , password and database. I encountered SQL error "Error
: 21472209999 Method '~' or object '~' failed (Source ADODB. coonection)"
when I click "Test Database Connection".

In HQ Administrator, if I click file -> Connect to same server and same
database -> succesfully connected with no error. However, if I try to run a
query such as "select * from item", the same error message as above will
apear.

Sometimes, another error meesage will appear "Error #3706, Provider not
found. It may not be properly isntalled. (Source : ADODB. Connection)", when
we try to test database connection.

We have tried unstalling RMs and rebooting the PC, but same errors appeared
each time we tried to "Test Database Connection".

We had no problems at all with another PC with the same specs.

Has anyone encountered this before? Would greatly appreciate some
enlightenment.

Thank you in advance


Back to top
ozzie
Guest
Posted: Tue Oct 11, 2005 8:02 am    Post subject: RE: SQL error in HQ Admin File Configuration. Reply with quote
actually I am not sure how...apart from trying to get your hands on the
latest mdac and install it??

"SBGSG-CCL" wrote:

Quote:
Hi

Can you suggest how I can check MDAC?

"ozzie" wrote:

Sounds almost like MDAC isn't installed properly or something like that.

"SBGSG-CCL" wrote:

Hi
I have installed HQ Administrator, HQ Manager onto client PC. The HQ
database has been set up int he server. In HQ Administrator, after I enter
the server, log in id , password and database. I encountered SQL error "Error
: 21472209999 Method '~' or object '~' failed (Source ADODB. coonection)"
when I click "Test Database Connection".

In HQ Administrator, if I click file -> Connect to same server and same
database -> succesfully connected with no error. However, if I try to run a
query such as "select * from item", the same error message as above will
apear.

Sometimes, another error meesage will appear "Error #3706, Provider not
found. It may not be properly isntalled. (Source : ADODB. Connection)", when
we try to test database connection.

We have tried unstalling RMs and rebooting the PC, but same errors appeared
each time we tried to "Test Database Connection".

We had no problems at all with another PC with the same specs.

Has anyone encountered this before? Would greatly appreciate some
enlightenment.

Thank you in advance
Back to top
Jeff
Guest
Posted: Wed Oct 12, 2005 12:03 am    Post subject: Re: SQL error in HQ Admin File Configuration. Reply with quote
The MDAC version checker;
http://tinyurl.com/755wh

The latest MDAC;
http://tinyurl.com/btezw

--
*
"ozzie" <ozzie@discussions.microsoft.com> wrote in message
news:2DA4FADB-4692-4BBD-B418-FCC745633B47@microsoft.com...
actually I am not sure how...apart from trying to get your hands on the
latest mdac and install it??

"SBGSG-CCL" wrote:

[quote]Hi

Can you suggest how I can check MDAC?

"ozzie" wrote:

Sounds almost like MDAC isn't installed properly or something like that.

"SBGSG-CCL" wrote:

Hi
I have installed HQ Administrator, HQ Manager onto client PC. The HQ
database has been set up int he server. In HQ Administrator, after I
enter
the server, log in id , password and database. I encountered SQL error
"Error
: 21472209999 Method '~' or object '~' failed (Source ADODB.
coonection)"
when I click "Test Database Connection".

In HQ Administrator, if I click file -> Connect to same server and
same
database -> succesfully connected with no error. However, if I try to
run a
query such as "select * from item", the same error message as above
will
apear.

Sometimes, another error meesage will appear "Error #3706, Provider
not
found. It may not be properly isntalled. (Source : ADODB.
Connection)", when
we try to test database connection.

We have tried unstalling RMs and rebooting the PC, but same errors
appeared
each time we tried to "Test Database Connection".

We had no problems at all with another PC with the same specs.

Has anyone encountered this before? Would greatly appreciate some
enlightenment.

Thank you in advance[/quote]
Back to top
SBGSG-CCL
Guest
Posted: Fri Nov 11, 2005 8:29 am    Post subject: RE: SQL error in HQ Admin File Configuration. Reply with quote
hi Jeff&Ozzie

Thanks for your help.

The MDAC was corrupted, once our client run repair from XP CD, the problem
was resolved.

"SBGSG-CCL" wrote:

Quote:
Hi
I have installed HQ Administrator, HQ Manager onto client PC. The HQ
database has been set up int he server. In HQ Administrator, after I enter
the server, log in id , password and database. I encountered SQL error "Error
: 21472209999 Method '~' or object '~' failed (Source ADODB. coonection)"
when I click "Test Database Connection".

In HQ Administrator, if I click file -> Connect to same server and same
database -> succesfully connected with no error. However, if I try to run a
query such as "select * from item", the same error message as above will
apear.

Sometimes, another error meesage will appear "Error #3706, Provider not
found. It may not be properly isntalled. (Source : ADODB. Connection)", when
we try to test database connection.

We have tried unstalling RMs and rebooting the PC, but same errors appeared
each time we tried to "Test Database Connection".

We had no problems at all with another PC with the same specs.

Has anyone encountered this before? Would greatly appreciate some
enlightenment.

Thank you in advance
Back to top
 
Post new topic   Reply to topic    Personal Finance Forum Index -> POS All times are GMT
Page 1 of 1

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

Credit Repair - Personal Finance Directory


AddThis Feed Button
Contact Us
New Topics Powered by phpBB