Visual Basic 6 to SQL Server 2000

[AjGrace]

Hi!

Im a Beginner in SQL server and I need to know how to connect to it using Visual Basic 6.0 using Ado connection..Tha nks In Advance guys!

[hariharanmca]

Hi!

Im a Beginner in SQL server and I need to know how to connect to it using Visual Basic 6.0 using Ado connection..Tha nks In Advance guys!

you can connect through connection string

Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;password=foxglove;Initial Catalog=Dinning;Data Source = (LOCAL)

[AjGrace]

you can connect through connection string

Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;password=foxglove;Initial Catalog=Dinning;Data Source = (LOCAL)

Thanks...I Really Appreciate your Help.. But Can I ask another Question..?
Can I use that connection in Public for example I will use the command "call"

Ex

Public Sub OpenConn()

strconn = "DSN=dbprac " ' this is an Access Database

Set db = New ADODB.Connectio n

With db
.CursorLocation = adUseClient
.ConnectionStri ng = strconn
.Open
End With

End Sub

So Everytime that I need the connection in database I just Call OpenConn. Thanks For Helping me..

[sachinkale123]

Thanks...I Really Appreciate your Help.. But Can I ask another Question..?
Can I use that connection in Public for example I will use the command "call"

Ex

Public Sub OpenConn()

strconn = "DSN=dbprac " ' this is an Access Database

Set db = New ADODB.Connectio n

With db
.CursorLocation = adUseClient
.ConnectionStri ng = strconn
.Open
End With

End Sub

So Everytime that I need the connection in database I just Call OpenConn. Thanks For Helping me..

YEs this is the anothere way to connect...

[sachinkale123]

Thanks...I Really Appreciate your Help.. But Can I ask another Question..?
Can I use that connection in Public for example I will use the command "call"

Ex

Public Sub OpenConn()

strconn = "DSN=dbprac " ' this is an Access Database

Set db = New ADODB.Connectio n

With db
.CursorLocation = adUseClient
.ConnectionStri ng = strconn
.Open
End With

End Sub

So Everytime that I need the connection in database I just Call OpenConn. Thanks For Helping me..

This is the another way to connect ...
Sometimes it gives great flexibility in changing servername etc...
but if DSN file is not installed then connection meight get failed..

[ck9663]

This is the another way to connect ...
Sometimes it gives great flexibility in changing servername etc...
but if DSN file is not installed then connection meight get failed..

here's a good link.,...

http://www.connections trings.com/