Search results for query: *

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...

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...

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...

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...

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!

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

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!

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

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!

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; <% '...

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

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...

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

...and as such can't create any recordsets etc.. so kind of at a dead end! [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '*userid*' i've contacted the hosts and reached a dead end with them as well, they're adamant there's a coding issue in my connection which is as...

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.......

Hi guys, I was mucking about with setting up roaming profiles on our network yesterday, and started with my own (should have, with hindsight, created a test profile!) anyway, i seem to have managed to wipe all my documents!!! our network is set up as such that all users docs are stored in...

meant to add they have a demo option as well so you can have a look at it and see how easily customisable etc..... you can create links to shop items from other pages in your site and everything

i just signed up for hosting with hostway.co.uk and they have a pretty good customisable merchant option. i've signed up for it too, you should check it out hosting including the merchant option is about £240/yr

i'm assuming it all tested ok when you created the flash button??

Hi folks, fairly new to this dsn-less stuff and can't get it to work! got connection string from hosting company, and ammended to include my details, ie userid, database name, server name etc. .. However i keep getting syntax error when i try to access the pages using the connection. the...