error msg on odbc

[wanabee]

hi all i have just installed sql 2005 and trying to launch my server but getting a strange error in ODBC can someone take a look at screenie plz.


www.bandet.org.uk/confused.jpg

 

[-Luke-]

Could always try the famous search button. (think admins should make that button bright pink or some thing..)

http://www.lomcn.co.uk/forum/showthread.php?t=65548&highlight=query+alive

This topic seems simaler to your problem hope it helps

Are you bring bandet server back up ?

 

[wanabee]

cheers for your input but the error is with odbc as stated above not with the keep alive this is happening because the database cant connect.

i have searched the forums and could not locate a thread which has had either the same or similar problem to the one i am currently experiancing.

 

[barney79]

Looking carefully at your screenie i notice it says SQL server does not exist or access denied :/ im not ver familier with SQL 2005 but have you set it up right using ur host name and correct SQL password???
for example
SQL HOST= HOME-PC\SQLEXPRESS
SQLUSER= <$Username>
SQLPASS= <$password used during installation>

 

[wanabee]

no you put it like that it makes sense i quess i should have looked here earlier as i have just put sql 2000 back on and server worked DOH

 

[barney79]

Yer in the !setup txt in M2Server it says SQLtype mssql u need to change tht to mysql and then change the Sql host from either 127.0.0.1 or (local) to what i put in my last post but its what ever your Pc is called.

 

[-Luke-]

Have u managed to sort your problem out ? if not let us know.

Again.. are you bringing bandet back ? if so count me in :thumbup2: