I have a CF shopping cart package that runs on an access database but
then lets me upgrade it to SQL. It's all done in the shopping cart scripts
but it never completes correctly. I'm having difficulty figuring out if
this shopping cart or CF is causing a problem I'm having because it's like
my server works fine for a couple days and then goes down hard.
When we installed our SQL software on our webserver, we then tried to
apply the service patches and one of them changed the server name to LOCAL
which is causing some type of problem so that even my access databases are
losing their datasource connection in Cold Fusion and I'm forced to reboot
the server to get them back. When I manually edited the dataconnection and
changed it from LOCAL to my real server name, the SQL database is OK instead
of giving me an error, but every time I run the script to upgrade, it reads
in from the system that the server name is LOCAL instead of the real one.
Can someone tell me why this happens and if there's a way to prevent or fix
it? I can't locate where SQL will let me change the name LOCAL back to my
server name.
Thanks,
Oak
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
