I am trying to connect from a microsoft server usingvbscript on .asp pages to a mysql database on a linux system



strconn=strconn & "SERVER=spruc.he.net;DATABASE=uksh;"

strconn=strconn & "UID=uk;PWD=508jgwcz;"

mySQL="select * from users"

dim conntemp, rstemp

set conntemp=server.createobject("adodb.connection")

response.write strconn

conntemp.open strconn

set rstemp=conntemp.execute(mysql)


is the code i am using but the following error message comes up,

PROVIDER=MSDASQL;DRIVER={SQL Server};SERVER=spruc.he.net;DATABASE=uk;UID=uksh;P WD=508jgwcz;

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC SQL Server Driver][Named Pipes]Specified SQL server not found

i have tried using the "MySQL ODBC 3.51 Driver"

but less luck

can anyone help