Run-time error '-2147467259 (80004005)'

[Nexus]

strCnn
= "Provider=SQLOLEDB;server=Main;uid=sa;pwd=;database=Olym
pia"

This is part of my codes. When i run it, the error
[DBNETLIB][ConnectionOpen(Connect()).]SQL Server does not
exist or access denied.

Why does this error occur? Is it because in my
database "Olympia", under Users, there isn't a user call
sa?

Are there any other possible reasons?
Thanks

 

[Dan Artuso]

Hi,
Well, where is your database server?
Is it really a computer called 'Main' ?
Can you ping Main from a command prompt?
What happens if you put the IP address in instead?

 

[Nexus]

Hi, my database server is in this computer named
server1 . Thus i changed my codes to
strCnn
= "Provider=SQLOLEDB;server=server1;uid=sa;pwd=;database=O
lympia"

but the error still appear.

-----Original Message-----
Hi,
Well, where is your database server?
Is it really a computer called 'Main' ?
Can you ping Main from a command prompt?
What happens if you put the IP address in instead?

--
HTH
Dan Artuso, Access MVP


"Nexus" <[email protected]> wrote in

message news:[email protected]...

strCnn
= "Provider=SQLOLEDB;server=Main;uid=sa;pwd=;database=Olym
pia"

This is part of my codes. When i run it, the error
[DBNETLIB][ConnectionOpen(Connect()).]SQL Server does not
exist or access denied.

Why does this error occur? Is it because in my
database "Olympia", under Users, there isn't a user call
sa?

Are there any other possible reasons?
Thanks

.

 

[Dan Artuso]

The first thing you should do when this happens is open a command prompt
and try to Ping your server. If you can't ping it using the name, try it with the IP address.

Also, you shouldn't have a blank password for the sa account. Your server will be hacked in no
time if it's connected to the outside world.

Post back with the results of the Ping.

--
HTH
Dan Artuso, Access MVP

Hi, my database server is in this computer named
server1 . Thus i changed my codes to
strCnn
= "Provider=SQLOLEDB;server=server1;uid=sa;pwd=;database=O
lympia"

but the error still appear.

-----Original Message-----
Hi,
Well, where is your database server?
Is it really a computer called 'Main' ?
Can you ping Main from a command prompt?
What happens if you put the IP address in instead?

--
HTH
Dan Artuso, Access MVP


"Nexus" <[email protected]> wrote in

message news:[email protected]...

strCnn
= "Provider=SQLOLEDB;server=Main;uid=sa;pwd=;database=Olym
pia"

This is part of my codes. When i run it, the error
[DBNETLIB][ConnectionOpen(Connect()).]SQL Server does not
exist or access denied.

Why does this error occur? Is it because in my
database "Olympia", under Users, there isn't a user call
sa?

Are there any other possible reasons?
Thanks

.

 

[Nexus]

Here's the ping result-

Ping statistics for 192.168.0.8:
Packets: Sent = 4, Recieved = 4, Lost = 0 <0% loss>,
Approximate round trip times in milli-seconds:
Minimum = 0ms, Maximum = 0ms, Average = 0ms


Another thing is, sa is pointing to which account? the
account in that particular database? or?..where can i
chnage the particulars or sa?

-----Original Message-----
The first thing you should do when this happens is open a command prompt
and try to Ping your server. If you can't ping it using

the name, try it with the IP address.

Also, you shouldn't have a blank password for the sa

account. Your server will be hacked in no

time if it's connected to the outside world.

Post back with the results of the Ping.

--
HTH
Dan Artuso, Access MVP


"Nexus" <[email protected]> wrote in

message news:[email protected]...

Hi, my database server is in this computer named
server1 . Thus i changed my codes to
strCnn
= "Provider=SQLOLEDB;server=server1;uid=sa;pwd=;database=O
lympia"

but the error still appear.

-----Original Message-----
Hi,
Well, where is your database server?
Is it really a computer called 'Main' ?
Can you ping Main from a command prompt?
What happens if you put the IP address in instead?

--
HTH
Dan Artuso, Access MVP


"Nexus" <[email protected]> wrote in

message news:[email protected]...

strCnn

= "Provider=SQLOLEDB;server=Main;uid=sa;pwd=;database=Olym

pia"

This is part of my codes. When i run it, the error
[DBNETLIB][ConnectionOpen(Connect()).]SQL Server

does
not

exist or access denied.

Why does this error occur? Is it because in my
database "Olympia", under Users, there isn't a user call
sa?

Are there any other possible reasons?
Thanks


.

.

 

[Dan Artuso]

Hi,
Okay, try using the IP address instead of the name in your connection string.
sa is an admin account. It can do anything to any database. That's why it's
so important to have a strong password.
You can use Enterprise Manager (one of the client tools) to change the password.

Did you set up this SQL Server? Maybe the sa account does not have a blank password
and that's why you are getting the error?

--
HTH
Dan Artuso, Access MVP

Here's the ping result-

Ping statistics for 192.168.0.8:
Packets: Sent = 4, Recieved = 4, Lost = 0 <0% loss>,
Approximate round trip times in milli-seconds:
Minimum = 0ms, Maximum = 0ms, Average = 0ms


Another thing is, sa is pointing to which account? the
account in that particular database? or?..where can i
chnage the particulars or sa?

-----Original Message-----
The first thing you should do when this happens is open a command prompt
and try to Ping your server. If you can't ping it using

the name, try it with the IP address.

Also, you shouldn't have a blank password for the sa

account. Your server will be hacked in no

time if it's connected to the outside world.

Post back with the results of the Ping.

--
HTH
Dan Artuso, Access MVP


"Nexus" <[email protected]> wrote in

message news:[email protected]...

Hi, my database server is in this computer named
server1 . Thus i changed my codes to
strCnn
= "Provider=SQLOLEDB;server=server1;uid=sa;pwd=;database=O
lympia"

but the error still appear.



-----Original Message-----
Hi,
Well, where is your database server?
Is it really a computer called 'Main' ?
Can you ping Main from a command prompt?
What happens if you put the IP address in instead?

--
HTH
Dan Artuso, Access MVP


message strCnn

= "Provider=SQLOLEDB;server=Main;uid=sa;pwd=;database=Olym
pia"

This is part of my codes. When i run it, the error
[DBNETLIB][ConnectionOpen(Connect()).]SQL Server does
not
exist or access denied.

Why does this error occur? Is it because in my
database "Olympia", under Users, there isn't a user
call
sa?

Are there any other possible reasons?
Thanks


.

.