asp And database connection problem

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View

I have a this code and it works:

dim conn
set conn=Server.CreateObject("ADODB.Connection")
conn.Open "C:\Inetpub\wwwroot\databse.mdb"
dim rs
set rs = Server.CreateObject("ADODB.recordset")
rs.Open "select * from tabela" , conn


and i have this one that does't work what is the cath??

Dim adoCon
Dim strCon
Dim rsCheckUser
Dim strAccessDB
Dim strSQL
Dim strUserName
strUserName = Request.Form("txtUserName")
strAccessDB = "users"
Set adoCon = Server.CreateObject("ADODB.Connection")
strCon = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" &
adoCon.Open strCon
Set rsCheckUser = Server.CreateObject("ADODB.Recordset")

Thanks for help

Re: asp And database connection problem

Writing in news:alt.www.webmaster
 From the safety of the T-Com cafeteria

Quoted text here. Click to load it

Well 'doesn't work' is a common error and has been well documented since  
the dawning of the industrial revolution.  Can you be a little more  

In any event, you are using different provider strings, I'd start looking  

Quoted text here. Click to load it

Good luck

William Tasso

Save the drama
for your Mama.

Site Timeline