SQL SERVER_ASP VBSRIPT_CONNECTION
Tech-Archive recommends: Fix windows errors by optimizing your registry
Date: Tue, 1 Mar 2005 15:20:36 +0200
i have one database with sql server
i want with asp vbsript to connect with database
my code is
<%
Dim conn
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "Provider=SQLOLEDB; Data Source = (local); Initial Catalog =
Northwind; User Id = sa; Password="
If conn.errors.count = 0 Then
Response.Write "Connected OK"
Else
Response.Write "Connection Not ok..."
End If
%>
something is ish't ok
i dont show nothing in the internet explorer
thanks
Relevant Pages
- Re: DetachDB problems - DMO
... comes up - I haven't run any program I know that hits the database. ... I also changed the default database to master ... No matter what - it seems like there is always a connection to the Northwind ...
(microsoft.public.sqlserver.programming) - Re: ADO Connection Timeout
... so what happens when a connection failure forces one station to revert ... to a local database? ... Further, you *will* have contention issues, Jet does not support record ... to the central server, but you are willing to live with periods where it ...
(microsoft.public.data.ado) - Re: ADO Connection Timeout
... When the first test is run, the results are stored in the central database. ... to the central server, but you are willing to live with periods where it ... i.e. a local database or even a text file. ... to function until the connection can be restored to the server. ...
(microsoft.public.data.ado) - Re: ADO Connection Timeout
... to the central server, but you are willing to live with periods where it ... i.e. a local database or even a text file. ... to function until the connection can be restored to the server. ...
(microsoft.public.data.ado) - Re: ADO Connection Timeout
... much rather write stored procedures and use server side cursors. ... local database, it is vital that I get the information to a central server. ... Once the connection is restored, ...
(microsoft.public.data.ado) |
|
