problem in connecting sql server
hello
i am new to sql server and .net programing here is a problem i got
while trying to connect sql server over internet
Dim conect As New SqlConnection("data source =202.154.228.184;net =
'dbmssocn';database = pmec ; user id = sa;password = sa ")
but the following exception is thrown
"sql server does not exists or access denied"
kindly help me solve this problem, i need to solve it badly
thanks
.
Relevant Pages
- Re: Best Pratice-Remore ADO Access
... > end app will be installed on clients and the SQL Server ... > use the Internet to move data back and forth. ... >> data over a WAN connection to a SQL Server. ... >> INSERT clause would be the most efficient method, ...
(microsoft.public.vb.database.ado) - Re: remoting vs. direct sql connection
... I'd say that you should never expose your SQL Server directly to the ... Internet -- the security risks are simply far too great. ... Using either a web service or remoting will also somewhat help in relieving ... Remoting logically uses a connection per ...
(microsoft.public.dotnet.framework.remoting) - Re: SQL CE Setup 101... C#
... the Internet Url. ... We have seen issues when we give IP address in internet ... Try using the sql server instance name. ... > // Create the Local SSCE Database subscription. ...
(microsoft.public.sqlserver.ce) - Re: MDB vs ADP
... So whilst in many cases it can be very slow using an adp / mdb to connect to ... a sql server over the net you can make it work. ... > MDB and ADP over the Internet; not only when loading 1000 records but also ...
(microsoft.public.access.adp.sqlserver) - Re: HELP! SQL Server Stops my Internet !!!!
... up the key first just in case) ... Jasper Smith (SQL Server MVP) ... > shares Internet Connection. ... > internet access and makes my hub crazy! ...
(microsoft.public.sqlserver.setup) |
|
