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