ADO or RDO
-
Hi, I want to make such a software in which i want to connect my SQL database situated on a remote server to the software residing in my PC. So is there any other apporoach other then creating the DSN and using it with ADO? Please tell me to be a professional software developer should i develope command over VB of VC++ Regards
-
Hi, I want to make such a software in which i want to connect my SQL database situated on a remote server to the software residing in my PC. So is there any other apporoach other then creating the DSN and using it with ADO? Please tell me to be a professional software developer should i develope command over VB of VC++ Regards
Think that you may be misunderstanding things here a little. If you specify a DSN in an ADO conneciton string, the conneciton will actually go through the ODBC driver / layer. However, if you specify a connection string of the format:
strConnString = "Provider = SQLOLEDB;Database=; Datasource="Then the OLEDB provider for SQLServer will be used to connect to the machine specified by and the database specified by . You'll also have ot provide a UID and PWD though.