Re: Need connection code

From: nithin (nithin_at_discussions.microsoft.com)
Date: 10/31/04


Date: Sat, 30 Oct 2004 22:01:01 -0700

the connection code for sql is as follows
<%@imports system.data%>
<%@imports.system.sqlclient%>
dim cnn as sqlconnection
cnn = new sqlconnection("connection string")
cnn.open()

the connection string can be obtained by creating a udl file .
to do so just open a notepad and save it with a ".udl " extension.
now open it move to connection tab, select the db and click test connection
. if the test connection succeeds, open the file using a notepad and just
copy paste the strng given

"Victor Koch" wrote:

> Hi Vinod
>
> http://www.able-consulting.com/ADO_Conn.htm
>
>
> --
> Víctor Koch From Argentina.
>
>
> "Vinod" <Vinod@discussions.microsoft.com> escribió en el mensaje
> news:492DDB34-5A30-4B72-A091-659CEAD279CF@microsoft.com...
> > Hi,
> > can some body send me connection code for ado.net with oracle and sql
> > also any project guide line so that I can make a dummy project in vb.net
> >
> > thanks
> > my e-mail address is vinod_103@yahoo.com
>
>
>



Relevant Pages

  • Re: Concurrent database access in SQL 2005 Mobile
    ... Please stick to having an "dummy" connection in Open State. ... SQL CE/Mobile has a background thread that flushes the changes ... they run for long hours and we have not seen memory leaks so far. ... then opens his work forms and it's in ...
    (microsoft.public.sqlserver.ce)
  • Re: Concurrent database access in SQL 2005 Mobile
    ... Please stick to having an "dummy" connection in Open State. ... So it is a kind of asynchronous commit which happens every 10 ... I am not sure of this claim as we have many applications built on SQL CE ... then opens his work forms and it's in ...
    (microsoft.public.sqlserver.ce)
  • Re: perplexing SQL authentication from ASP.net issue
    ... the sql must be local or sql standard secuirty must be used. ... > directory security is set to Integrated Windows Authentication only. ... > I've tried a variety of connection strings. ... > connection string that VS.net uses. ...
    (microsoft.public.sqlserver.security)
  • Re: SQL.Net connection in VS2005 from local IIS to local SQLExpres
    ... my connection string is: ... SQL2005 server name is LANDON\SQLEXPRESS ... I can log into SQL Server 2005 and look at the tables. ...
    (microsoft.public.sqlserver.connect)
  • Access 2003 adp/proxy security - A substitute for SYSTEM_USER()
    ... We need a way for SQL to know the nt username that initiated the proxy ... Many stored procedures and views use a UDF that also depends on ... SyUserLogin and use HostIDand HostName() to find the right row. ... We've played with the Connection dialog settings, ...
    (microsoft.public.sqlserver.connect)