old asp: connection strings

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"




                       
   
Thank you spending your time here.
If possible you; can leave some comments or suggestions.
Thanks a lot once again.
Google Search
Disclaimer and Copy Right