I want to Register a Dsn Name for the ODBC in System DSN,through Visual Basic Code. I'am able to register in User DSN through V.B Code, but i'am not able to register in System DSN through VB Code.
This i want to do, because i'am developing an intranet based application with SQL Server 6.5 as the backend using Active X Controls.
So after registering the OCX Controls in the Server, suppose if i'am accessing the file which is in the server. The application is not loaded in IE browser, this is because it looks for the Local System DSN, which i have not configured.
If i'am configuring the System DSN in the local machine, i'am able to access the application throught IE. But it should be such that without configuring in the client's 32 bit odbc, i should able to access the application..
This is possible only if i write to configure through the VB Code itself, and before registering the ocx control in the server.