Re: How to enter data in a SQL database (SQL Server 2000)?
- From: v-phuang@xxxxxxxxxxxxxxxxxxxx ("Peter Huang" [MSFT])
- Date: Mon, 03 Oct 2005 07:43:07 GMT
Hi Mark,
In vb6 we use ADO to access Database( we can access many kinds of
database), e.g. oracle, access , sql server, the different is that we need
to use different provider,connection string.
e.g. the string below will use the SQLOLEDB provider to connect to a
sqlserver.
"Provider=SQLOLEDB;Data Source=MySQLServer;" _
& "Integrated Security=SSPI;Initial Catalog=pubs"
Here are a few links for your reference.
HOWTO: Use Bound Controls with an ADO Recordset (190371)
http://support.microsoft.com/default.aspx?scid=KB;EN-US;190371
INFO: Using ActiveX Data Objects (ADO) via Visual Basic
http://support.microsoft.com/default.aspx?scid=kb;EN-US;168335
Here is link about ADO for starter.
ActiveX Data Objects 2.8 Start Page
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/
dasdkadooverview.asp
ActiveX Data Objects (ADO)
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/
mdmscsection1_ado.asp
Best regards,
Peter Huang
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.
.
- References:
- Prev by Date: Re: errors in italian
- Next by Date: RE: How to enter data in a SQL 2000 server database from excel?
- Previous by thread: Re: How to enter data in a SQL database (SQL Server 2000)?
- Next by thread: How to: replace value in Datagrid? [ADO/Recordset]
- Index(es):
Relevant Pages
|
