|
![]()
I have uploaded a vb.net web project onto a host webserver. I am trying to chagne my connection string so that it wil connect to my Access database that is now on the host server in under the webroot/data/demo.mdb. The problem is they set it up as a DNS. I don't know how to set up my connection string to access the database the connection string they gave me has DNS = dgfmed.demo and my connection string now looks like
add name="DemoConnectionString" connectionString="Provider=Microsoft.Jet... Source=dgfmed.demo;Database=Demo.mdb;Per... Security Info=False;" providerName="System.Data.OleDb" />
There servers only support asp 1.3 and i cant just load up the database in my app_data folder and access it directly I have to keep it as a DNS. How can I make this connection string work I am totally lost on this issue.
Connectin string for an access database set up as DSN?
Try using something like this (assuming no password needed):
Provider=MSDASQL.1;Persist Security Info=False;Data Source=<name of the DSN>
Connectin string for an access database set up as DSN?
You should be able to program your DSN (data source name) access into a component file within your .net application - domain, database name, password.
You need to supply the following info to your hosting company to configure on their server:
Domain Name
Database Name
Database Type
DSN Prefix (eg. MyDatabase_domainname_com)
Make sure your asp/asp.net services are turned on before you request the DSN setup - this may include having one .asp file in your public hosting area before you are allowed to request the service.
|
