| View previous topic :: View next topic |
| Author |
Message |
Asking
Guest
|
 Posted: Sat Feb 26, 2005 12:53 pm Post subject: how to run ado application on a client to connect MsSQL (it |
 |
|
hi all,
I designed some forms by using ADO component and I installed the application
on a client (client os: winXP Prof)
ADO components should access to MsSQL server on a win2000 server. But the
application which is installed on a client couldn't run and it gives me
below an error;
" [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access
denied."
How to solve this problem?
By the way;
1. MsSQL is installed SQL Server and Windows Authentication mode
2. qtintf70.dll is on the client
3. I installed MDAC 2.8 on the client (!)
Thanx a lot
|
|
| Back to top |
|
 |
Asking
Guest
|
| Posted: Sun Feb 27, 2005 2:44 pm Post subject: Re: how to run ado application on a client to connect MsSQL |
|
|
SQL server is running (because I connected the server by my notebook which
desinged forms)
I wrote IP address as Server Name in connection string
"Brian Bushay TeamB" <BBushay (AT) Nmpls (DOT) com> wrote
| Quote: |
I designed some forms by using ADO component and I installed the
application
on a client (client os: winXP Prof)
ADO components should access to MsSQL server on a win2000 server. But the
application which is installed on a client couldn't run and it gives me
below an error;
" [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or
access
denied."
How to solve this problem?
Either the Server specified in the connection string can't be found or SQL
server isn't running
--
Brian Bushay (TeamB)
[email]Bbushay (AT) NMPLS (DOT) com[/email]
|
|
|
| Back to top |
|
|
Guest
|
| Posted: Sun Feb 27, 2005 3:18 pm Post subject: Re: how to run ado application on a client to connect MsSQL |
|
|
Try writing the server name and not the IP
"Asking" <asking (AT) ispro (DOT) net.tr> wrote
| Quote: | SQL server is running (because I connected the server by my notebook which
desinged forms)
I wrote IP address as Server Name in connection string
"Brian Bushay TeamB" <BBushay (AT) Nmpls (DOT) com> wrote in message
news:vb8221dunttbh1599qk36n492ng6pef57c (AT) 4ax (DOT) com...
I designed some forms by using ADO component and I installed the
application
on a client (client os: winXP Prof)
ADO components should access to MsSQL server on a win2000 server. But
the
application which is installed on a client couldn't run and it gives me
below an error;
" [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or
access
denied."
How to solve this problem?
Either the Server specified in the connection string can't be found or
SQL
server isn't running
--
Brian Bushay (TeamB)
[email]Bbushay (AT) NMPLS (DOT) com[/email]
|
|
|
| Back to top |
|
|
Asking
Guest
|
| Posted: Fri Mar 04, 2005 7:19 pm Post subject: I solved this problem by SQL Client network setting.. Thank |
|
|
"Brian Bushay TeamB" <BBushay (AT) Nmpls (DOT) com> wrote
| Quote: |
SQL server is running (because I connected the server by my notebook
which
desinged forms)
I wrote IP address as Server Name in connection string
Are you sure you did not install SQL server as an Instance?
for instances the server needs to be referred to as
serverName/InstanceName
--
Brian Bushay (TeamB)
[email]Bbushay (AT) NMPLS (DOT) com[/email]
|
|
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
