Hi there

I'm trying to connect to an MS SQL Server db on one server with my asp files on another server. This I can do fine using an include file with the following code:

<%
    Set con = Server.CreateObject("ADODB.Connection")

    con.Open = "Provider=SQLOLEDB; Data Source = 100.100.100.100; Initial Catalog = db_golf; User Id = db_user; Password=123456"

%>

All details in the above are fictitious! However on some of my asp pages I want to make some changes to the database - either editing or adding etc and I use the following code for this:

set rs = server.createobject("ADODB.Recordset")
    rs.open "SELECT * FROM Fixtures", Application("golf_ConnectionString"), 1, 3

    rs.AddNew()

etc etc

but what I'm stuck on is what I need to change the Application("golf_ConnectionString") to -

do I need to add some code to the include file so that it knows what
("golf_ConnectionString") is??

Many thanks

Adam

Adam!!

Stmt1> rs.open "SELECT * FROM Fixtures", Application("golf_ConnectionString"), 1, 3

the connection string made by above in ur case(con.Open = "Provider=SQLOLEDB; Data Source = 100.100.100.100; Initial Catalog = db_golf; User Id = db_user; Password=123456" )

wont reflect "Stmt1" ,because it is using connection string from application variable.

if you want to use ur newly created connection string
then u must pass it to rs.open method to reflect

Other alternative is that u can lock the application varaible and set the new connection string ,then unlock it

Hope this will help you






Cheers :)

vinod

Hi Vinod

thanks for your reply which is much appreciated.

That's exactly it - I need to pass the new connection string to the rs.open method but I'm not sure how to do it - i.e the syntax etc. Can you help?

Thanks in anticipation

Adam

<%
    Set con = Server.CreateObject("ADODB.Connection")

    con.Open "Provider=SQLOLEDB; Data Source = 100.100.100.100; Initial Catalog = db_golf; User Id = db_user; Password=123456"


set rs = server.createobject("ADODB.Recordset")
    rs.open "SELECT * FROM Fixtures",con , 1, 3
%>
http://www.w3schools.com/ado/ado_display.asp

http://psacake.com/web/ho.asp
hope this will help you

Cheers :)

vinod