Hi I would like to ask what are the steps how to create odbc connection without going to control panel but just using the codes to connect access to sql tables. thanks.
Hi I would like to ask what are the steps how to create odbc connection without going to control panel but just using the codes to connect access to sql tables. thanks.
I don't know if this link will help but it is at least something.
is that it? i dont need to go to control panel anymore to create the odbc?
Here is a VBscript to do this.
Try this using ADO when connecting to Microsoft SQL Server.
Code:Dim Conn As ADODB.Connection Set Conn = New ADODB.Connection Conn.ConnectionString = "Driver={SQL Server};Description=sqldemo;SERVER=127.0.0.1;UID=LoginID;PWD=Password; DATABASE=Database_Name;" Conn.Open
thank you for your reply. i will try your suggestions.