Here is your problem: MM_TrackoftheWolf_STRING = "dsn=DSN Name;uid=User Id;pwd=Password;"
No space between Id;pwd Unless that is what happened when you copied and paste it Thank you, Todd Williamsen, MCSE home: 847.265.4692 Cell: 847.867.9427 -----Original Message----- From: Nick Boldt [mailto:[EMAIL PROTECTED]] Sent: Monday, December 03, 2001 3:19 PM To: [EMAIL PROTECTED] Subject: RE: Viewing table data in a webpage using ASP Here is the connection code I use to view record information from a table. I'm using Dreamweaver Ultradev 4 to help with some of the basic coding. I am using MyODBC. <% MM_TrackoftheWolf_STRING = "dsn=DSN Name;uid=User Id;pwd=Password;" set ship_address = Server.CreateObject("ADODB.Recordset") ship_address.ActiveConnection = MM_TrackoftheWolf_STRING ship_address.Source = "SELECT * FROM customershipping" ship_address.CursorType = 0 ship_address.CursorLocation = 1 ship_address.LockType = 3 ship_address.Open() ship_address_numRows = 0 %> <% Dim Repeat1__numRows Repeat1__numRows = -1 Dim Repeat1__index Repeat1__index = 0 ship_address_numRows = ship_address_numRows + Repeat1__numRows %> Nick Boldt Computer Network Administrator Track of the Wolf Elk River, MN 55330 Tel: 763-633-2500 Fax: 763-633-2550 [EMAIL PROTECTED] -----Original Message----- From: Christopher R. Jones [mailto:[EMAIL PROTECTED]] Sent: Monday, December 03, 2001 3:07 PM To: Nick Boldt Subject: Re: Viewing table data in a webpage using ASP If you have MyODBC installed and working you should be able to view the records. I have a number of WEB pages that display MySQL data using ASP/ADO. You should send an example of you ASP script to the group to help clarify your problem. >Hi, > >I'm trying to view the records of a table in on a webpage, but nothing >is showing up. I can add records to the table from the page but cannot >view, update or delete them. > >I'm using Windows 2000 and IIS 5.0 > >I'm new to MySql and would greatly appreciate any help anyone can give >me. > >Nick Boldt >Computer Network Administrator >Track of the Wolf >Elk River, MN 55330 >Tel: 763-633-2500 Fax: 763-633-2550 > > >--------------------------------------------------------------------- >Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > >To request this thread, e-mail <[EMAIL PROTECTED]> >To unsubscribe, e-mail <[EMAIL PROTECTED]> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Christopher R. Jones, P.Eng. 14 Oneida Avenue Toronto, Ontario M5J 2E3 Tel. 416 203-7465 Fax. 416 203-8249 Email [EMAIL PROTECTED] --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
