>Hey guys is there a way to connect to SQL Server database without having to set up an ODBC connection on each computer ??? I'm Using SQL Server 6.5, soon 7 as soon as i sort out the error i get when i try to upgrade.

You can use a DSN-Less connection:

Con_Handle=SQLSTRINGCONNECT("driver={SQL Server};server="+m.sql_servername+";uid="+alltrim(m.sql_user)+";pwd="+alltrim(m.sql_pass)+";database="+m.sql_db+";AutoTranslate=no;Regional=no;QuotedId=no;AnsiNPW=no")