Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

New to ASP!

Status
Not open for further replies.

Smitty020

MIS
Jun 1, 2001
152
US
I'm new, Very New, to ASP. I'm using ASPXP. Whenever I add a ASP to my website, then I goto the website and click on the link, it says, "Data Source Name not found and no default driver specified" What do I need to do?

Also, where do I need to put my database?

Any help would be much appreciated!

Smitty020
 
I found it easier to have my database in my webfolder. Your problem is in your connection string it sounds. Why dont you show the code that you are using and then we can see if its that or not.

Joanne
 
This is the code that I wrote! I just don't know what I need and where it goes.

<%


Dim page, tbl
Set page = Server.CreateObject (&quot;ASPXP2.WebPage&quot;)
Set tbl = page.WebTables.Add

With tbl
.BorderWidth = 3
.CellSpacing = 1
.OddEvenColorStyle = mtOECSColumnsOnly
.Fields.Add &quot;EMPMTG_ID&quot;, &quot;EMPMTG_ID&quot;
.Fields.Add &quot;MTG_ID&quot;, &quot;MTG_ID&quot;
.Fields.Add &quot;EMP_ID&quot;, &quot;EMP_ID&quot;
.Fields.Add &quot;ATT_STATUS&quot;, &quot;ATT_STATUS&quot;
.DataSource.SQLQuery = &quot;SELECT * FROM Employees&quot;
.Connect Safety1
.Show
End With

Set tbl = Nothing
Set Page = Nothing

%>

If you could maybe explain where I need to have some of these things I would really appreciate it!

Thanks for your help,

Smitty020
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top