vb prototype

[Eric Clapton]

Can anyone please help me to build the VB code connect to a SQL 2000 server?
If you can give me a prototype, that will be very helpful? Thanks.

[EricJ]

have a look here
http://msdn.microsoft.com/library/de...ml/daab-rm.asp

hope it helps

eric

"Eric Clapton" <no*****@bk.com> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl...

Can anyone please help me to build the VB code connect to a SQL 2000 server? If you can give me a prototype, that will be very helpful? Thanks.

[Neil Fallon]

Add a reference to the MS ActiveX data object 7 and the MS Data Binding
Collection. Then paste this code behind a button:

Dim oConn As New ADODB.Connection

oConn.Provider = "sqloledb"
oConn.Properties("Prompt") = adPromptAlways
oConn.Open "Network Library=DBMSSOCN;" & _
"Data Source=;" & _
"Initial Catalog=;"
Neil

"Eric Clapton" <no*****@bk.com> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl...

Can anyone please help me to build the VB code connect to a SQL 2000 server? If you can give me a prototype, that will be very helpful? Thanks.

[Jorge]

Hi

http://www.connectionstrings.com/index.asp

Kind Regards
Jorge

-----Original Message-----
Can anyone please help me to build the VB code connect to a SQL 2000 server?If you can give me a prototype, that will be very helpful? Thanks.

.

[Herfried K. Wagner [MVP]]

* "Eric Clapton" <no*****@bk.com> scripsit:

Can anyone please help me to build the VB code connect to a SQL 2000 server?
If you can give me a prototype, that will be very helpful? Thanks.

<http://www.connectionstrings.com/>

--
Herfried K. Wagner [MVP]
<http://dotnet.mvps.org/>

[Cor]

And now the rest Herfried,

Can anyone please help me to build the VB code connect to a SQL 2000 server? If you can give me a prototype, that will be very helpful? Thanks.

The least there is needed is
dim conn as SqlClient.SqlConnection = ("the connection string you get from
the link from Herfried).

:-))

Cor

[Jeff Johnson [MVP: VB]]

"Eric Clapton" <no*****@bk.com> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl...

Can anyone please help me to build the VB code connect to a SQL 2000 server? If you can give me a prototype, that will be very helpful? Thanks.

Please decide which version of VB you want to use (VB6 or previous vs.
VB.NET) and then refrain from crossposting to inappropriate groups. The
*.vb.* groups are for VB6 and earlier; the *.dotnet.* groups are for (what
else?) .NET.

[Mike Fellows]

are you still playing guitar?

"Eric Clapton" <no*****@bk.com> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl...

Can anyone please help me to build the VB code connect to a SQL 2000 server? If you can give me a prototype, that will be very helpful? Thanks.

[Herfried K. Wagner [MVP]]

Cor,

* "Cor" <no*@non.com> scripsit:

Can anyone please help me to build the VB code connect to a SQL
2000 server?
If you can give me a prototype, that will be very helpful? Thanks.

The least there is needed is
dim conn as SqlClient.SqlConnection = ("the connection string you get from
the link from Herfried).

LOL... I am sure the OP has a brain too ;-).

--
Herfried K. Wagner [MVP]
<http://dotnet.mvps.org/>