What I have to check for working?? | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

What I have to check for working??

Hi,i have may smool Community based on Access Database,i want change access to sql server, because now is very slow caused too many user join.<br />I hope that you understand my English…[<img src=’/community/emoticons/emotion-11.gif’ alt=’8)’ />]<br /><br /><b>My site is Asp Nuke 1.4 free portal, know? is a Asp site, it uses this connection</b>:<br /><font color="red">sDBConnection = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=%DBpath%%DBname%%DBext%;User ID=%USERID%;Jet OLEDB<img src=’/community/emoticons/emotion-2.gif’ alt=’:D‘ />atabase Password=%PASSWORD%<img src=’/community/emoticons/emotion-4.gif’ alt=’;P’ />ersist Security Info=False;Mode=Share Deny None;"</font id="red"><br /><br /><b>I would like to know, what to change in my site to work with Sql server 2000,<br />particularly the string connection and if I have need to change other code in my site.</b><br /><br />I already have ready and update the database from access to sql server 2000, but my site doesn’t connect.<br /><br /><br />Are to the first experiences with sql server [V], you have patience <br /><br /><br />Utente Italiano.<br /<a target="_blank" href=http://www.cristianorisorse.com>http://www.cristianorisorse.com</a>
http://www.connectionstrings.com/ MeanOldDBA
[email protected] When life gives you a lemon, fire the DBA.