Member Avatar for Cruize_Invades

my connection string goes like this...

Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=MyDB;Data Source=mysource

I am using windows authentication, iis 7 and Classic ASP to to connect to SQL express 2008.
Using UDL i can connect to my SQL.
I can also connect to my SQLExpress when i am running my Database management studio.

my problem is that i cannot connect to my datasource and response "Cannot open database "mysource" requested by the login. The login failed." upon connecting via asp pages.

I have tried setting my IIS7 to use windows authentication but the problem is that i don't want to go trhough the usual login page that prompts and created my own login pages that is connected to my AD.

Can anyone help me?

Regards.

  • 5 Contributors
  • 5 Replies
  • 184 Views
  • 3 Months Discussion Span
  • Latest Post Latest Post by rajendra.parmar
Member Avatar for naziatarannum

Have u created the datasource(database driver)?
if not, then create it.

Member Avatar for Cruize_Invades

Have u created the datasource(database driver)?
if not, then create it.

yes I have already created one.

Member Avatar for yonker 
connstr="Driver={SQL Server}; Server=adnew.db.5580462.hostedresource.com; Database=adnew; Uid=adnew; Pwd=Whwit123;"
conn.open connstr
Edited by kvprajapati because: Added [code] tags. Encase your code in: [code] and [/code] tags.
Member Avatar for marteen

i use this script to connect my mdb file

Dim con
    con = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" &  Server.MapPath("file.mdb")
Edited by marteen because: n/a
Member Avatar for rajendra.parmar

It is right

my connection string goes like this...

Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=MyDB;Data Source=mysource

I am using windows authentication, iis 7 and Classic ASP to to connect to SQL express 2008.
Using UDL i can connect to my SQL.
I can also connect to my SQLExpress when i am running my Database management studio.

my problem is that i cannot connect to my datasource and response "Cannot open database "mysource" requested by the login. The login failed." upon connecting via asp pages.

I have tried setting my IIS7 to use windows authentication but the problem is that i don't want to go trhough the usual login page that prompts and created my own login pages that is connected to my AD.

Can anyone help me?

Regards.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.