Hi,
I am editing asp pages that did connect to access to now connect to sql 2005. I started using Microsoft Visual Web Developer and can create a new site, drag and drop the connection string, set it up, do a data view and everyting is great. The problem is someone else before me set up the Access and ASP pages. They are not very complex but I don't have a lot of time to figure out what he did and recreate the pages. Can someone show me how to change the code below to connect to a sql 2005 database? This will be across the net so I suppose the connection string will be tcpip?? Lets call the ip 0.0.0.0 , the database database, the user user, and the password pass.
<%
set cn=server.createobject("ADODB.connection")
cn.open "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE="&server.mapPath("database.mdb")
set r=server.createobject("adodb.recordset")
%>
I am editing asp pages that did connect to access to now connect to sql 2005. I started using Microsoft Visual Web Developer and can create a new site, drag and drop the connection string, set it up, do a data view and everyting is great. The problem is someone else before me set up the Access and ASP pages. They are not very complex but I don't have a lot of time to figure out what he did and recreate the pages. Can someone show me how to change the code below to connect to a sql 2005 database? This will be across the net so I suppose the connection string will be tcpip?? Lets call the ip 0.0.0.0 , the database database, the user user, and the password pass.
<%
set cn=server.createobject("ADODB.connection")
cn.open "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE="&server.mapPath("database.mdb")
set r=server.createobject("adodb.recordset")
%>