i have this code it works using DSN but when i dont use dsn it dosent 

dim conn

set conn=server.CreateObject ("ADODB.CONNECTION")

conn.Open "DSN=dsn1;UID=sa;"

dim rsuser

set rsuser=server.CreateObject ("ADODB.RECORDSET")

rsuser.Open "INSERT INTO test (name,id) VALUES ('"&Request.Form ("nam")

&"','"&Request.Form ("id")&"')",conn

the other code is



dim conn

set conn=server.CreateObject ("ADODB.CONNECTION")

conn.Open "Provider=SQLOLEDB; Data Source=local; Initial Catalog=fadi;User ID=sa;"

dim rsuser

set rsuser=server.CreateObject ("ADODB.RECORDSET")

rsuser.Open "INSERT INTO test (name,id) VALUES ('"&Request.Form ("nam")

&"','"&Request.Form ("id")&"')",conn

i dont whay it dosnt work any help please 

Why doesn't it work? What is the error generated?



Ceers

Ken



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

----- Original Message -----

From: "fadi" <fadirh@u...>

To: "ASP Database Setup" <asp_database_setup@p...>

Sent: Sunday, July 15, 2001 1:54 PM

Subject: [asp_database_setup] help in this code





: i have this code it works using DSN but when i dont use dsn it dosent

: dim conn

: set conn=server.CreateObject ("ADODB.CONNECTION")

: conn.Open "DSN=dsn1;UID=sa;"

: dim rsuser

: set rsuser=server.CreateObject ("ADODB.RECORDSET")

: rsuser.Open "INSERT INTO test (name,id) VALUES ('"&Request.Form ("nam")

: &"','"&Request.Form ("id")&"')",conn

: the other code is

:

: dim conn

: set conn=server.CreateObject ("ADODB.CONNECTION")

: conn.Open "Provider=SQLOLEDB; Data Source=local; Initial Catalog=fadi;User

ID=sa;"

: dim rsuser

: set rsuser=server.CreateObject ("ADODB.RECORDSET")

: rsuser.Open "INSERT INTO test (name,id) VALUES ('"&Request.Form ("nam")

: &"','"&Request.Form ("id")&"')",conn

: i dont whay it dosnt work any help please

it give me erorr on this line conn.Open "Provider=SQLOLEDB; Data Source=local; 

Initial Catalog=fadi;User

 ID=sa;" ole object  error

> it give me erorr on this line conn.Open "Provider=SQLOLEDB; Data 

Source=local; 

> Initial Catalog=fadi;User

>  ID=sa;" ole object  error



---------------------------------------------------



Ive never used SQL before, but isnt initial Catalog the name of the 

database??? maybe try fadi.mdb or whatever extension SQL uses..



Also, try changing Datasource to the path of the DB



eg. Data Source=C:\inetpub\wwwroot\database

Initial Catalog=Fadi.msde 



etc



I dont know weather that would work or not, try throwing in a slash like 

so if it doesn work --> C:\inetpub\wwwroot\database\



After that, i dont know, maybe ken would



Regards,



Spoon

When connecting to a SQL database you connect to the SQL server rather than

a specific file.  For your datasource have you tried either entering the

server name (even though its local) or localhost.





What is the verbage of the error?





-----Original Message-----

From: kumars@i... [mailto:kumars@i...]

Sent: Monday, July 16, 2001 12:12 PM

To: ASP Database Setup

Subject: [asp_database_setup] Re: help in this code





> it give me erorr on this line conn.Open "Provider=SQLOLEDB; Data 

Source=local; 

> Initial Catalog=fadi;User

>  ID=sa;" ole object  error



---------------------------------------------------



Ive never used SQL before, but isnt initial Catalog the name of the 

database??? maybe try fadi.mdb or whatever extension SQL uses..



Also, try changing Datasource to the path of the DB



eg. Data Source=C:\inetpub\wwwroot\database

Initial Catalog=Fadi.msde 



etc



I dont know weather that would work or not, try throwing in a slash like 

so if it doesn work --> C:\inetpub\wwwroot\database\



After that, i dont know, maybe ken would



Regards,



Spoon

thank u all