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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by thesimpsonator

  1. thesimpsonator

    default database permissions and subsequent connection issues

    right, so i think i got off to a bad start with my first foray into using a database with my site!! update: have now purchased a sql database from my hosting company, created the database in the management panel, giving it a password etc. then recreated a dsn for the database, making sure it...
  2. thesimpsonator

    default database permissions and subsequent connection issues

    no i havent' been able to connect that way yet, only way i've 'accessed' the database, is by setting my testing server details the same as my main ftp and then i can see the databases listed when selecting a dsn settings to connect with sql server management studio are one of the things asked...
  3. thesimpsonator

    default database permissions and subsequent connection issues

    thanks for the speedy reply, i'm using the following connection string: <% ' FileName="Connection_odbc_conn_dsn.htm" ' Type="ADO" ' DesigntimeType="ADO" ' HTTP="false" ' Catalog="" ' Schema="" Dim MM_xxx_STRING MM_xxx_STRING = "dsn=xxx;" %> didn't think any userid/password was needed with it...
  4. thesimpsonator

    default database permissions and subsequent connection issues

    Hi folks, thought it was something to do with my connection code etc that i was having trouble connecting to the database i have on my site, however think it's more something to do with permissions on the database itself. to load the database i had to load the mdf onto the database partition...
  5. thesimpsonator

    sql server access issue?!

    well think this is more to do with my database and permissions on it!!!! must be something i've done when i've added the database to sql server management studio!
  6. thesimpsonator

    sql server access issue?!

    they recommended against it, but wouldn't help with what i should be using instead!!
  7. thesimpsonator

    sql server access issue?!

    just phoned them again to see what i can do, waiting on a call back. it's redstation. don't know anyone else with them that i can contact to see how they do it!! they basically told me that it was a coding error at my end and that that wasn't something they deal with!
  8. thesimpsonator

    sql server access issue?!

    thanks blondebier, have already spoken with them and they were about as much use as a chocolate teaspoon!!
  9. thesimpsonator

    sql server access issue?!

    as i mentioned, the connection seems to work ok as i can see all the table aspects etc in my recordset without having to put in any passwords etc, its just an issue on the live page giving me the error shown!
  10. thesimpsonator

    sql server access issue?!

    hi, thanks for the speedy reply, i'm using a dsn thats created and hosted with our hosting company, i've no control over the sql server at all other than the creation of dsn's. using an include on each page, which then uses the following code from the include file; <% '...
  11. thesimpsonator

    sql server access issue?!

    sorry think i should have put this in the setup/admin for sql forum but don't know how to change it!! sorry.
  12. thesimpsonator

    sql server access issue?!

    hi guys, having trouble with connection to sql server and looking for a bit of help. seem to get the connection working ok as i can see the table etc for creating recordset but i get the following error on page when i try accessing the database via a webpage; Microsoft OLE DB Provider for ODBC...
  13. thesimpsonator

    dsn connection issue

    thanks for that, i've got the connection pretty much sorted now although i've got a permissions? issue!! i'll start a post about it elsewhere. cheers
  14. thesimpsonator

    dsn connection issue

    Hi guys, not sure if i'm in the right forum or not for this but sure someone will sort that out if I aint!! :D have a website that i've started hosting with a new hosting company. we've now added a database to the site which we never had before. using DW8 to try to connect to the database but...
  15. thesimpsonator

    roaming profiles issue win2000Server

    yeah well that's what i'd have thought, but it defo got rid of the files. i forgot i'd taken a backup onto a portable harddrive last week so i had a relatively recent copy that i've managed to use now so not such a big issue.......

Part and Inventory Search

Back
Top