1. a connection string for ms access:
con.open "provider=microsft.jet.oledb.4.0;
data source=c:\emp.mdb;
user id=admin;
password=;"
2. connection string for sqlserver
con.open('provider=sqloledb;
data sourace=223.245.56.78; ' ip address or computer name
initial catalog=empdata; 'this is the database name
user id=sa;password=xxxxxx;
integrated security=SSPI;
persist security info=False;"
3. connection stariang to use a text file as database in vb6?
con.open("provider=microsoft.jet.oledb.4.0;
data source=c:\emp.txt;
extended properties=""text;HDR=Yes;FMT=delimited"""
4. connection string in vb6 for using ms access and app.math:
str="provider=microsoft.jet.oledb.4.0; data sourace=" & app.path * "\emp.mdb;
persist security info=flase"