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!
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!
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;
<%
'...
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...
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...
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
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.