Database connectivity on WEB
-
i am using VB 6 as front-end and SQL Server 2000 as back-end, we have one web site that having database to store the daily activities of the marketing executives. i've to connect my VB6 forms to database which is in the net and generate the reports. im using ADO as database connectivity. How to connect my ADO connetion object to web database. what will be the connection string
-
i am using VB 6 as front-end and SQL Server 2000 as back-end, we have one web site that having database to store the daily activities of the marketing executives. i've to connect my VB6 forms to database which is in the net and generate the reports. im using ADO as database connectivity. How to connect my ADO connetion object to web database. what will be the connection string
Hi, ajith, Best practice to put your database on the web is using ASP(Active Server Pages) which runs on the VBScript. Since , I do not know any way to connect VB forms on the web, I can assure, ASP will do all the job for you. There is no different connection string.. You need a IIS server, SQL Server. I advice you to install IIS and then type "http://localhost/" in the URL ( Address bar in Internet explorer). You will get ASP help. You need to read manual for ADO also, refer MSDN. Best way to connect using a ODBC connection, So set up a ODBC connection for your SQL Server - Database(Ex: DSN=testSQL) Create Coonection as follows <% Conn = Server.CreateObject("ADODB.Connection") Conn.Open "DSN=testSQL",, Rs = Server.CreateObject("ADODB.Resultset") Rs.Open SQL,Conn,3,3,1 '''''''''''''''''' Do your work Rs.Close Conn.Close Happy programming love2code