asked on

SQL Server 2005 not accepting comma's in network paths.

We have an application with a MS Access front-end and a SQL Server 2005 back-end database. One of our forms allows a user to store documents electronically by simply clicking a button and identifying a pathname to store the document. We have found that SQL Server 2005 does not like a comma in the pathname (example: C:\Documents\Jones, Karen) and will leave the system just "hanging" if a user tries to identify such a path. Mind you, this works fine in our older application which had a SQL Server 2000 back-end database.

I've search the internet trying to find any issues and need to know if anyone has heard of this problem and how we might work around it. Changing the path's is not really an option.

ASKER CERTIFIED SOLUTION

appari

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds. No credit card required.

See answer

hou-pasupport

ASKER

I'm sorry appari....I should have stated this earlier. I'm not a developer and am trying to help troubleshoot this for our development group. They have not heard of this issue either so we're all "banging our heads" to figure it out. I don't have the SQL statement and can't get it until at least tomorrow.

SOLUTION

SrinivasK

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds. No credit card required.

See answer

SOLUTION

rwbaskette

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds. No credit card required.

See answer

hou-pasupport

ASKER

It's definitely the comma. The space does not appear to have any negative effect whatsoever.

I appreciate the feedback from everyone and I'm going to give points for each as this is a very hard thing without the SQL and these ideas are definitely valid for additional troubleshooting.

Thanks everyone