There is no option like the picture has.

Even it has not solve the problem by changing the query problem

But there is no option in the default database drop down?

ya i hav used system dsn only.Following are the steps

i had open the ODBC Data Source Administrator,select the system DSN,

given the name as "asp"

then at server at had write...

this is my asp code:

dim connection,qry,rs

set connection=CreateObject("ADODB.Connection")

connection.ConnectionString = "DSN=asp"

connection.open()

qry="insert into tbl_registration values(' " & name & "','" & address & "','" & city & "', '" & state & "','"...

Thanks a lot for your help 🙂

But it shows an error at:

Dim affectedRows As Long = cmd.ExecuteNonQuery(CommandBehavior.CloseConnection)

The error is executenonquery cannot accept this argument.