Interesting thing is happening with my SQL database..   I have been using

ODBC to connect to my SQL database but now i have decided to go to OLEDB.



after lots of fiddleing around with the connection string i get it to

connect but cant do anything with it



for example i retrieve user information from a form and then go to insert

it into a table with the following script...and the the following error



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





connection = "Provider=MS Remote; Remote Server=sqldata.abac.com; Remote

Provider=SQLOLEDB; database=mydatabase;UID=myusername;PWD=mypassword;"

conn.Open connection



StrSQl = "insert into users (username, password, first, last, address,

city, state, country, gender, income, zipcode, age, fax, company,

telephone, icq) values ('" & username & "', '" & password & "', '" & fname

& "', '" & lname & "', '" & address & "', '" & city & "', '" & state & "',

'" & country & "', '" & gender & "', '" & income & "', '" & zipcode & "',

'" & age & "', '" & fax & "', '" & company & "', '" & telephone & "', '" &

icq & "');"

conn.Execute StrSql





conn.close

set conn = nothing



THis is the error i recieve



Microsoft ADO/RDS error '800a1004' 

Business object cannot be created. 

/register/thanks.asp, line 36 



I dont knwo what is going on.. i have try to mess with the connection

string but nothing happens.. I get this same error whether i use a

recordset or this insert command.. thanks.



Brad