Mark A Matte
markamatte at hotmail.com
Thu Apr 2 11:49:08 CDT 2009
Hello All, This is from a co-worker...he is moving his app from Access to MySQL...and is having issues with the remote connections( any database type) on the new server. Any ideas? Thanks, Mark A. Matte >From web pages, I cannot connect to any remote database, regardless of the DB Engine (Informix, SQL Server, MS Access, etc.), regardless if I use a connection string or connect via ODBC. However, if I script in VB and compile as an EXE, connections work fine; I've pulled data from the remote DB's using that method. So I know the server, itself, is correctly resolving connections to remote DB's... and that the problem is related to IIS. I've researched and found references to some XML configuration files that can impact this..."machine.config" and "web.config", maybe "security.config"... things that are new and peculiar to ASP.NET, but the references are not clear as to how to use them to change this behaviour. _________________________________________________________________ Rediscover Hotmail®: Get e-mail storage that grows with you. http://windowslive.com/RediscoverHotmail?ocid=TXT_TAGLM_WL_HM_Rediscover_Storage1_042009