IIS 7/ SQL Server 2005

[suarve]

Hi,

I driving myself crazy here. Have just installed vista home premium 64 bit along with sql server 2005 express. I'm trying to simplay connect to the database locally using classic asp, but am running into loads of problems. I think it may be something to do with IIS 7 and all the increased security but can't be sure. By connection string is below:

strConn="Provider=SQLOLEDB;Server=MEH\SQLEXPRESS,720;Database=Links;Uid=ultrono;Pwd="

set objConn = Server.CreateObject("ADODB.Connection")
strSQL = "SELECT * FROM Links;"
objConn.Open strConn
Set objRS = Server.CreateObject("ADODB.Recordset")
objRS.Open strSQL, objConn, 3, 3

I keep getting a erros when the page loads saying i have added a trusted users and sometimes that the sql server does not exist or access is denied.

I running out of things to try tbh, so can some kind soul suggest something? Basically, whatever user i try to login as i get access denied erros.

thanks

 

[suarve]

Anyone?

Have googled this so much and come up with nothing at all

 

[suarve]

Finally got it working.

Now found out vista 64 doesn't support OLE DBconnections like MS Access. ffs

EDIT: you have to change IIS to work in 32 bit mode apparently (this worked for me). From the cmd prompt:

cd %windir%\Inetpub\AdminScripts
cscript.exe adsutil.vbs set W3SVC/AppPools/Enable32BitAppOnWin64 True