Access to SQL Server (smart card application connection to SQL Server)
[473 byte] By [kalvin] at [2007-11-19 1:58:42] 
I had an on going project to create a smart card application for a college here in Malaysia. I was told that MS Access would do fine as I am quite well versed in it. But now the requirements have changed and my client now wants it MS SQL Server 2000. I would appreciate it someone could let me know how to connect MS SQL Server 2000 to my VB6-compiled application. Or if anyone has a better idea on how should I overcome this please reply. I would appreciate it. Thank you.
# 1 Re: Access to SQL Server (smart card application connection to SQL Server)
Have you tried msdn.microsoft.com and looking at the connection strings for MSSQL Server 2000. I do believe you can d'load the Online books for SQL Server 2000.Vanaj at 2007-11-9 13:38:56 >
# 2 Re: Access to SQL Server (smart card application connection to SQL Server)
Are you using ADO to connect to Access, if so you just change the connection string.The following will give you the connection strings:
ADO connection strings ( http://www.able-consulting.com/ADO_Conn.htm)
HTH
jp140768 at 2007-11-9 13:39:56 >
