I have inherited a web application with an Access backend (yes I know).
我继承了一个带有Access后端的Web应用程序(是的,我知道)。
I need to get this thing deployed asap to a shared hosting provider. Unfortunately, it's not as easy as I imagined as hosts tend to lock down access to Access databases (AFAICT).
我需要将此事件尽快部署到共享托管服务提供商。不幸的是,它并不像我想象的那么容易,因为主机倾向于锁定对Access数据库(AFAICT)的访问。
I have a shared account with GoDaddy - I have enabled Access database use, and created a DSN.
我有一个GoDaddy共享帐户 - 我启用了Access数据库,并创建了一个DSN。
The application has references to the database connection string littered throughout it. Is using DSNs simply a matter of changing the connection string to be the path of the DSNs?
应用程序引用了遍布它的数据库连接字符串。使用DSN只是将连接字符串更改为DSN的路径吗?
Any help much appreciated.
任何帮助非常感谢。
1 个解决方案
#1
Been a while since I did this, but you should just be able to change the connection string to DSN=MYDSNNAme
我这么做了一段时间,但你应该能够将连接字符串更改为DSN = MYDSNNAme
I would try it locally first though.
我会先在本地尝试一下。
Obviously if you are going to go to this trouble, replace each occurance with a variable, so if you need to do it again it will be easier :)
显然,如果你要解决这个问题,用变量替换每个出现,所以如果你需要再做一次就会更容易:)
#1
Been a while since I did this, but you should just be able to change the connection string to DSN=MYDSNNAme
我这么做了一段时间,但你应该能够将连接字符串更改为DSN = MYDSNNAme
I would try it locally first though.
我会先在本地尝试一下。
Obviously if you are going to go to this trouble, replace each occurance with a variable, so if you need to do it again it will be easier :)
显然,如果你要解决这个问题,用变量替换每个出现,所以如果你需要再做一次就会更容易:)