November 2, 2009 at 3:23 am
Hello,
i am looking for a small advice because i face a problem with a asp web page. Here are the infos.
I have a web asp page ( NOT asp.net) and i transfer the database to sql2005 from sql2000. The reason was that i wanted to work with SQL2005 mirroring.
Everything went fine until the time that i need to work with a connection string that automaticy make the failover for the website.
I take a code tha MS gives but that code has to do with .net sites and not simple asp.
So pls if anyone can help me with that it will be great for me.
I read somewhere that mirroring and simple asp cannot work cause there is no code for that. Is tha true?
Ty all for your time.
November 2, 2009 at 3:26 am
hi,
in asp your app is using an odbc connection.
when you migrated u, need to modify the odbc to look at the new server/instance
November 2, 2009 at 3:33 am
shanu.hoosen (11/2/2009)
hi,in asp your app is using an odbc connection.
when you migrated u, need to modify the odbc to look at the new server/instance
My problem has to do with the autimatica failover connection string. If i connect directly to any of the 2 servers, i dont have any problem. I am looking a way to make the site undestand that the SQL1 is down and the SQL2 is working.
for asp.net there is a code for the mirrorng automatic failover, similar to this:
Data Source=myServerAddress;Failover Partner=myMirrorServerAddress;Initial Catalog=myDataBase;Integrated Security=True
But i cannot find a code that can work with simple asp page.
November 2, 2009 at 10:04 pm
It looks fine - are you using the SQL Native Client? I don't know if any other ODBC/OLE drivers support failover partner.
November 9, 2009 at 5:07 am
matt stockham (11/2/2009)
It looks fine - are you using the SQL Native Client? I don't know if any other ODBC/OLE drivers support failover partner.
Yeap i used SQL native client and works perfect.
Ty all.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply