chrometweaks.org

How do I connect to a sql server database on iPage in asp.net?

Click Here To View All Answers...


Got a quick question: How do I connect to a sql server database on iPage in asp.net? Hoping for any answer or 2. Another question... Hello, I am a newbie and have been working on my os site. I wanted to use the USPS function but got an error stating that the rates were wrong contact the admin. So I went to the contributions and downloaded a USPS label cont. It had me modify the english.php by adding some lines to the bottom of it.

Then I uploaded a order.php file that was packaged with the contribution.

I tried to restore these files from my backup but I still get the same errors. Here is a link to my site.

Http://lockettb.host...mmerce/catalog/.

Thanks in advance.

Karla..

Comments (68)

I would like to know the answer too. Anyone here know what is the right answer to your question. I'll do some Googling and get back to you if I discover an useful answer. You should email the people at iPage as they probably can answer it..

Comment #1

It appears your problem exists in catalog/includes/languages/english.php. Please paste it here...

Comment #2

This is from line 60 on down. Thanks for your help!.

// footer text in includes/footer.php.

Define('FOOTER_TEXT_REQUESTS_SINCE', 'requests since');.

// text for gender.

Define('MALE', 'Male');.

Define('FEMALE', 'Female');.

Define('MALE_ADDRESS', 'Mr.');.

Define('FEMALE_ADDRESS', 'Ms.');.

// text for date of birth example.

Define('DOB_FORMAT_STRING', 'mm/dd/yyyy');.

// categories box text in includes/boxes/categories.php.

Define('BOX_HEADING_CATEGORIES', 'Categories');.

// manufacturers box text in includes/boxes/manufacturers.php.

Define('BOX_HEADING_MANUFACTURERS', 'Manufacturers');.

// whats_new box text in includes/boxes/whats_new.php.

Define('BOX_HEADING_WHATS_NEW', 'What's New?');.

// quick_find box text in includes/boxes/quick_find.php.

Define('BOX_HEADING_SEARCH', 'Quick Find');.

Define('BOX_SEARCH_TEXT', 'Use keywords to find the product you are looking for.');.

Define('BOX_SEARCH_ADVANCED_SEARCH', 'Advanced Search');.

// specials box text in includes/boxes/specials.php.

Define('BOX_HEADING_SPECIALS', 'Specials');.

// reviews box text in includes/boxes/reviews.php.

Define('BOX_HEADING_REVIEWS', 'Reviews');.

Define('BOX_REVIEWS_WRITE_REVIEW', 'Write a review on this product!');.

Define('BOX_REVIEWS_NO_REVIEWS', 'There are currently no product reviews');.

Define('BOX_REVIEWS_TEXT_OF_5_STARS', '%s of 5 Stars!');.

// shopping_cart box text in includes/boxes/shopping_cart.php.

Define('BOX_HEADING_SHOPPING_CART', 'Shopping Cart');.

Define('BOX_SHOPPING_CART_EMPTY', '0 items');.

// order_history box text in includes/boxes/order_history.php.

Define('BOX_HEADING_CUSTOMER_ORDERS', 'Order History');.

// best_sellers box text in includes/boxes/best_sellers.php.

Define('BOX_HEADING_BESTSELLERS', 'Bestsellers');.

Define('BOX_HEADING_BESTSELLERS_IN', 'Bestsellers in<br>&nbsp;&nbsp;');.

// notifications box text in includes/boxes/products_notifications.php.

Define('BOX_HEADING_NOTIFICATIONS', 'Notifications');.

Define('BOX_NOTIFICATIONS_NOTIFY', 'Notify me of updates to <b>%s</b>');.

Define('BOX_NOTIFICATIONS_NOTIFY_REMOVE', 'Do not notify me of updates to <b>%s</b>');.

// manufacturer box text.

Define('BOX_HEADING_MANUFACTURER_INFO', 'Manufacturer Info');.

Define('BOX_MANUFACTURER_INFO_HOMEPAGE', '%s Homepage');.

Define('BOX_MANUFACTURER_INFO_OTHER_PRODUCTS', 'Other products');.

// languages box text in includes/boxes/languages.php.

Define('BOX_HEADING_LANGUAGES', 'Languages');.

// currencies box text in includes/boxes/currencies.php.

Define('BOX_HEADING_CURRENCIES', 'Currencies');.

// information box text in includes/boxes/information.php.

Define('BOX_HEADING_INFORMATION', 'Information');.

Define('BOX_INFORMATION_PRIVACY', 'Privacy Notice');.

Define('BOX_INFORMATION_CONDITIONS', 'Conditions of Use');.

Define('BOX_INFORMATION_SHIPPING', 'Shipping & Returns');.

Define('BOX_INFORMATION_CONTACT', 'Contact Us');.

// tell a friend box text in includes/boxes/tell_a_friend.php.

Define('BOX_HEADING_TELL_A_FRIEND', 'Tell A Friend');.

Define('BOX_TELL_A_FRIEND_TEXT', 'Tell someone you know about this product.');.

// checkout procedure text.

Define('CHECKOUT_BAR_DELIVERY', 'Delivery Information');.

Define('CHECKOUT_BAR_PAYMENT', 'Payment Information');.

Define('CHECKOUT_BAR_CONFIRMATION', 'Confirmation');.

Define('CHECKOUT_BAR_FINISHED', 'Finished!');.

// pull down default text.

Define('PULL_DOWN_DEFAULT', 'Please Select');.

Define('TYPE_BELOW', 'Type Below');.

// javascript messages.

Define('JS_ERROR', 'Errors have occured during the process of your form.nnPlease make the following corrections:nn');.

Define('JS_REVIEW_TEXT', '* The 'Review Text' must have at least 'REVIEW_TEXT_MIN_LENGTH' characters.n');.

Define('JS_REVIEW_RATING', '* You must rate the product for your review.n');.

Define('JS_ERROR_NO_PAYMENT_MODULE_SELECTED', '* Please select a payment method for your order.n');.

Define('JS_ERROR_SUBMITTED', 'This form has already been submitted. Please press Ok and wait for this process to be completed.');.

Define('ERROR_NO_PAYMENT_MODULE_SELECTED', 'Please select a payment method for your order.');.

Define('CATEGORY_COMPANY', 'Company Details');.

Define('CATEGORY_PERSONAL', 'Your Personal Details');.

Define('CATEGORY_ADDRESS', 'Your Address');.

Define('CATEGORY_CONTACT', 'Your Contact Information');.

Define('CATEGORY_OPTIONS', 'Options');.

Define('CATEGORY_PASSWORD', 'Your Password');.

Define('ENTRY_COMPANY', 'Company Name:');.

Define('ENTRY_COMPANY_ERROR', '');.

Define('ENTRY_COMPANY_TEXT', '');.

Define('ENTRY_GENDER', 'Gender:');.

Define('ENTRY_GENDER_ERROR', 'Please select your Gender.');.

Define('ENTRY_GENDER_TEXT', '*');.

Define('ENTRY_FIRST_NAME', 'First Name:');.

Define('ENTRY_FIRST_NAME_ERROR', 'Your First Name must contain a minimum of 'ENTRY_FIRST_NAME_MIN_LENGTH' characters.');.

Define('ENTRY_FIRST_NAME_TEXT', '*');.

Define('ENTRY_LAST_NAME', 'Last Name:');.

Define('ENTRY_LAST_NAME_ERROR', 'Your Last Name must contain a minimum of 'ENTRY_LAST_NAME_MIN_LENGTH' characters.');.

Define('ENTRY_LAST_NAME_TEXT', '*');.

Define('ENTRY_DATE_OF_BIRTH', 'Date of Birth:');.

Define('ENTRY_DATE_OF_BIRTH_ERROR', 'Your Date of Birth must be in this format: MM/DD/YYYY (eg 05/21/1970)');.

Define('ENTRY_DATE_OF_BIRTH_TEXT', '* (eg. 05/21/1970)');.

Define('ENTRY_EMAIL_ADDRESS', 'E-Mail Address:');.

Define('ENTRY_EMAIL_ADDRESS_ERROR', 'Your E-Mail Address must contain a minimum of 'ENTRY_EMAIL_ADDRESS_MIN_LENGTH' characters.');.

Define('ENTRY_EMAIL_ADDRESS_CHECK_ERROR', 'Your E-Mail Address does not appear to be valid - please make any necessary corrections.');.

Define('ENTRY_EMAIL_ADDRESS_ERROR_EXISTS', 'Your E-Mail Address already exists in our records - please log in with the e-mail address or create an account with a different address.');.

Define('ENTRY_EMAIL_ADDRESS_TEXT', '*');.

Define('ENTRY_STREET_ADDRESS', 'Street Address:');.

Define('ENTRY_STREET_ADDRESS_ERROR', 'Your Street Address must contain a minimum of 'ENTRY_STREET_ADDRESS_MIN_LENGTH' characters.');.

Define('ENTRY_STREET_ADDRESS_TEXT', '*');.

Define('ENTRY_SUBURB', 'Suburb:');.

Define('ENTRY_SUBURB_ERROR', '');.

Define('ENTRY_SUBURB_TEXT', '');.

Define('ENTRY_POST_CODE', 'Post Code:');.

Define('ENTRY_POST_CODE_ERROR', 'Your Post Code must contain a minimum of 'ENTRY_POSTCODE_MIN_LENGTH' characters.');.

Define('ENTRY_POST_CODE_TEXT', '*');.

Define('ENTRY_CITY', 'City:');.

Define('ENTRY_CITY_ERROR', 'Your City must contain a minimum of 'ENTRY_CITY_MIN_LENGTH' characters.');.

Define('ENTRY_CITY_TEXT', '*');.

Define('ENTRY_STATE', 'State/Province:');.

Define('ENTRY_STATE_ERROR', 'Your State must contain a minimum of 'ENTRY_STATE_MIN_LENGTH' characters.');.

Define('ENTRY_STATE_ERROR_SELECT', 'Please select a state from the States pull down menu.');.

Define('ENTRY_STATE_TEXT', '*');.

Define('ENTRY_COUNTRY', 'Country:');.

Define('ENTRY_COUNTRY_ERROR', 'You must select a country from the Countries pull down menu.');.

Define('ENTRY_COUNTRY_TEXT', '*');.

Define('ENTRY_TELEPHONE_NUMBER', 'Telephone Number:');.

Define('ENTRY_TELEPHONE_NUMBER_ERROR', 'Your Telephone Number must contain a minimum of 'ENTRY_TELEPHONE_MIN_LENGTH' characters.');.

Define('ENTRY_TELEPHONE_NUMBER_TEXT', '*');.

Define('ENTRY_FAX_NUMBER', 'Fax Number:');.

Define('ENTRY_FAX_NUMBER_ERROR', '');.

Define('ENTRY_FAX_NUMBER_TEXT', '');.

Define('ENTRY_NEWSLETTER', 'Newsletter:');.

Define('ENTRY_NEWSLETTER_TEXT', '');.

Define('ENTRY_NEWSLETTER_YES', 'Subscribed');.

Define('ENTRY_NEWSLETTER_NO', 'Unsubscribed');.

Define('ENTRY_NEWSLETTER_ERROR', '');.

Define('ENTRY_PASSWORD', 'Password:');.

Define('ENTRY_PASSWORD_ERROR', 'Your Password must contain a minimum of 'ENTRY_PASSWORD_MIN_LENGTH' characters.');.

Define('ENTRY_PASSWORD_ERROR_NOT_MATCHING', 'The Password Confirmation must match your Password.');.

Define('ENTRY_PASSWORD_TEXT', '*');.

Define('ENTRY_PASSWORD_CONFIRMATION', 'Password Confirmation:');.

Define('ENTRY_PASSWORD_CONFIRMATION_TEXT', '*');.

Define('ENTRY_PASSWORD_CURRENT', 'Current Password:');.

Define('ENTRY_PASSWORD_CURRENT_TEXT', '*');.

Define('ENTRY_PASSWORD_CURRENT_ERROR', 'Your Password must contain a minimum of 'ENTRY_PASSWORD_MIN_LENGTH' characters.');.

Define('ENTRY_PASSWORD_NEW', 'New Password:');.

Define('ENTRY_PASSWORD_NEW_TEXT', '*');.

Define('ENTRY_PASSWORD_NEW_ERROR', 'Your new Password must contain a minimum of 'ENTRY_PASSWORD_MIN_LENGTH' characters.');.

Define('ENTRY_PASSWORD_NEW_ERROR_NOT_MATCHING', 'The Password Confirmation must match your new Password.');.

Define('PASSWORD_HIDDEN', 'HIDDEN');.

Define('FORM_REQUIRED_INFORMATION', '* Required information');.

// constants for use in tep_prev_next_display function.

Define('TEXT_RESULT_PAGE', 'Result Pages:');.

Define('TEXT_DISPLAY_NUMBER_OF_PRODUCTS', 'Displaying <b>%d</b> to <b>%d</b> (of <b>%d</b> products)');.

Define('TEXT_DISPLAY_NUMBER_OF_ORDERS', 'Displaying <b>%d</b> to <b>%d</b> (of <b>%d</b> orders)');.

Define('TEXT_DISPLAY_NUMBER_OF_REVIEWS', 'Displaying <b>%d</b> to <b>%d</b> (of <b>%d</b> reviews)');.

Define('TEXT_DISPLAY_NUMBER_OF_PRODUCTS_NEW', 'Displaying <b>%d</b> to <b>%d</b> (of <b>%d</b> new products)');.

Define('TEXT_DISPLAY_NUMBER_OF_SPECIALS', 'Displaying <b>%d</b> to <b>%d</b> (of <b>%d</b> specials)');.

Define('PREVNEXT_TITLE_FIRST_PAGE', 'First Page');.

Define('PREVNEXT_TITLE_PREVIOUS_PAGE', 'Previous Page');.

Define('PREVNEXT_TITLE_NEXT_PAGE', 'Next Page');.

Define('PREVNEXT_TITLE_LAST_PAGE', 'Last Page');.

Define('PREVNEXT_TITLE_PAGE_NO', 'Page %d');.

Define('PREVNEXT_TITLE_PREV_SET_OF_NO_PAGE', 'Previous Set of %d Pages');.

Define('PREVNEXT_TITLE_NEXT_SET_OF_NO_PAGE', 'Next Set of %d Pages');.

Define('PREVNEXT_BUTTON_FIRST', '&lt;&lt;FIRST');.

Define('PREVNEXT_BUTTON_PREV', '[&lt;&lt;&nbsp;Prev]');.

Define('PREVNEXT_BUTTON_NEXT', '[Next&nbsp;&gt;&gt;]');.

Define('PREVNEXT_BUTTON_LAST', 'LAST&gt;&gt;');.

Define('IMAGE_BUTTON_ADD_ADDRESS', 'Add Address');.

Define('IMAGE_BUTTON_ADDRESS_BOOK', 'Address Book');.

Define('IMAGE_BUTTON_BACK', 'Back');.

Define('IMAGE_BUTTON_BUY_NOW', 'Buy Now');.

Define('IMAGE_BUTTON_CHANGE_ADDRESS', 'Change Address');.

Define('IMAGE_BUTTON_CHECKOUT', 'Checkout');.

Define('IMAGE_BUTTON_CONFIRM_ORDER', 'Confirm Order');.

Define('IMAGE_BUTTON_CONTINUE', 'Continue');.

Define('IMAGE_BUTTON_CONTINUE_SHOPPING', 'Continue Shopping');.

Define('IMAGE_BUTTON_DELETE', 'Delete');.

Define('IMAGE_BUTTON_EDIT_ACCOUNT', 'Edit Account');.

Define('IMAGE_BUTTON_HISTORY', 'Order History');.

Define('IMAGE_BUTTON_LOGIN', 'Sign In');.

Define('IMAGE_BUTTON_IN_CART', 'Add to Cart');.

Define('IMAGE_BUTTON_NOTIFICATIONS', 'Notifications');.

Define('IMAGE_BUTTON_QUICK_FIND', 'Quick Find');.

Define('IMAGE_BUTTON_REMOVE_NOTIFICATIONS', 'Remove Notifications');.

Define('IMAGE_BUTTON_REVIEWS', 'Reviews');.

Define('IMAGE_BUTTON_SEARCH', 'Search');.

Define('IMAGE_BUTTON_SHIPPING_OPTIONS', 'Shipping Options');.

Define('IMAGE_BUTTON_TELL_A_FRIEND', 'Tell a Friend');.

Define('IMAGE_BUTTON_UPDATE', 'Update');.

Define('IMAGE_BUTTON_UPDATE_CART', 'Update Cart');.

Define('IMAGE_BUTTON_WRITE_REVIEW', 'Write Review');.

Define('SMALL_IMAGE_BUTTON_DELETE', 'Delete');.

Define('SMALL_IMAGE_BUTTON_EDIT', 'Edit');.

Define('SMALL_IMAGE_BUTTON_VIEW', 'View');.

Define('ICON_ARROW_RIGHT', 'more');.

Define('ICON_CART', 'In Cart');.

Define('ICON_ERROR', 'Error');.

Define('ICON_SUCCESS', 'Success');.

Define('ICON_WARNING', 'Warning');.

Define('TEXT_GREETING_PERSONAL', 'Welcome back <span class="greetUser">%s!</span> Would you like to see which <a href="%s"><u>new products</u></a> are available to purchase?');.

Define('TEXT_GREETING_PERSONAL_RELOGON', '<small>If you are not %s, please <a href="%s"><u>log yourself in</u></a> with your account information.</small>');.

Define('TEXT_GREETING_GUEST', 'Welcome <span class="greetUser">Guest!</span> Would you like to <a href="%s"><u>log yourself in</u></a>? Or would you prefer to <a href="%s"><u>create an account</u></a>?');.

Define('TEXT_SORT_PRODUCTS', 'Sort products ');.

Define('TEXT_DESCENDINGLY', 'descendingly');.

Define('TEXT_ASCENDINGLY', 'ascendingly');.

Define('TEXT_BY', ' by ');.

Define('TEXT_REVIEW_BY', 'by %s');.

Define('TEXT_REVIEW_WORD_COUNT', '%s words');.

Define('TEXT_REVIEW_RATING', 'Rating: %s [%s]');.

Define('TEXT_REVIEW_DATE_ADDED', 'Date Added: %s');.

Define('TEXT_NO_REVIEWS', 'There are currently no product reviews.');.

Define('TEXT_NO_NEW_PRODUCTS', 'There are currently no products.');.

Define('TEXT_UNKNOWN_TAX_RATE', 'Unknown tax rate');.

Define('TEXT_REQUIRED', '<span class="errorText">Required</span>');.

Define('ERROR_TEP_MAIL', '<font face="Verdana, Arial" size="2" color="#ff0000"><b><small>TEP ERROR:</small> Cannot send the email through the specified SMTP server. Please check your php.ini setting and correct the SMTP server if necessary.</b></font>');.

Define('WARNING_INSTALL_DIRECTORY_EXISTS', 'Warning: Installation directory exists at: 'dirname($HTTP_SERVER_VARS['SCRIPT_FILENAME'])'/install. Please remove this directory for security reasons.');.

Define('WARNING_CONFIG_FILE_WRITEABLE', 'Warning: I am able to write to the configuration file: 'dirname($HTTP_SERVER_VARS['SCRIPT_FILENAME'])'/includes/configure.php. This is a potential security risk - please set the right user permissions on this file.');.

Define('WARNING_SESSION_DIRECTORY_NON_EXISTENT', 'Warning: The sessions directory does not exist: 'tep_session_save_path()'. Sessions will not work until this directory is created.');.

Define('WARNING_SESSION_DIRECTORY_NOT_WRITEABLE', 'Warning: I am not able to write to the sessions directory: 'tep_session_save_path()'. Sessions will not work until the right user permissions are set.');.

Define('WARNING_SESSION_AUTO_START', 'Warning: session.auto_start is enabled - please disable this php feature in php.ini and restart the web server.');.

Define('WARNING_DOWNLOAD_DIRECTORY_NON_EXISTENT', 'Warning: The downloadable products directory does not exist: 'DIR_FS_DOWNLOAD'. Downloadable products will not work until this directory is valid.');.

Define('TEXT_CCVAL_ERROR_INVALID_DATE', 'The expiry date entered for the credit card is invalid.<br>Please check the date and try again.');.

Define('TEXT_CCVAL_ERROR_INVALID_NUMBER', 'The credit card number entered is invalid.<br>Please check the number and try again.');.

Define('TEXT_CCVAL_ERROR_UNKNOWN_CARD', 'The first four digits of the number entered are: %s<br>If that number is correct, we do not accept that type of credit card.<br>If it is wrong, please try again.');.

/*.

The following copyright announcement can only be.

Appropriately modified or removed if the layout of.

The iPage site theme has been modified to distinguish.

Itself from the default osCommerce-copyrighted.

Theme..

For more information please read the following.

Frequently Asked Questions entry on the osCommerce.

Support site:.

Http://www.oscommerc...php/faq,26/q,50.

Please leave this comment intact together with the.

Following copyright announcement..

*/.

Define('FOOTER_TEXT_BODY', 'Copyright &copy; 2003 <a href="http://www.oscommerce.com" target="_blank">osCommerce</a><br>Powered by <a href="http://www.oscommerce.com" target="_blank">osCommerce</a>');.

?>..

Comment #3

The error is here:.

// whats_new box text in includes/boxes/whats_new.php.

Define('BOX_HEADING_WHATS_NEW', 'What's New?');.

You have to escape double and single quotation marks out in the text, like this:.

// whats_new box text in includes/boxes/whats_new.php.

Define('BOX_HEADING_WHATS_NEW', 'What\'s New?');.

HTH,.

Terry.

This post has been edited by.

TerryK.

: 04 May 2004, 18:20..

Comment #4

You have got a few in there !!.

Your whats new should be.

Define('BOX_HEADING_WHATS_NEW', 'What\'s New?');.

You js_reviews_text should be.

Define('JS_REVIEW_TEXT', '* The \'Review Text\' must have at least 'REVIEW_TEXT_MIN_LENGTH' characters.n');.

You should get a text editor with colour coding..

Comment #5

And your next error will be here.

Define('JS_REVIEW_TEXT', '* The 'Review Text' must have at least 'REVIEW_TEXT_MIN_LENGTH' characters.n');.

Should be.

Define('JS_REVIEW_TEXT', '* The \'Review Text\' must have at least 'REVIEW_TEXT_MIN_LENGTH' characters.n');..

Comment #6

Hello, I am a newbie and have been working on my os site. I wanted to use the USPS function but got an error stating that the rates were wrong contact the admin. So I went to the contributions and downloaded a USPS label cont. It had me modify the english.php by adding some lines to the bottom of it. I did the same to filenames.php. Then I uploaded a order.php file that was packaged with the contribution.

I tried to restore these files from my backup but I still get the same errors. Here is a link to my site.

Http://lockettb.host...mmerce/catalog/.

Thanks in advance.

Karla..

Comment #7

The error message tells you that the problem is at line 79 of your /catalog/includes/languages/english.php file. Can you post your code from around line 60 through 85 or so and maybe we can help you spot the error..

Terry..

Comment #8


This question was taken from a support group/message board and re-posted here so others can learn from it.