Database Connection Question.

[witly]

Hello every, I haven't been here for 2 days. and I got a question recently. My friend David has Visual Basic 2005 and SQL Server 2005. And he wants to know the steps for Database connection. Really appreicate your help..:D :D

[sainsalex]

Try these steps:
(Both uses ADO Connection)

• For Microsoft SQL Database
• With DB
• .ConnectionTimeout = 60
• .Open "Driver={SQL Server};Server=srv_za_database...
• End With

• For Microsoft Access Database
• Private DB as New Connection
• With DB
• .Provider="Microsoft.jet.oledb... (Access 2000)
• .ConnectionString = "c:\Test.mdb"
• .Open
• End with