Thank you for your help.

Amy

Thanks for the reply ~

Is there anything that needs to be done on the SQL server or the server sitting on the DMZ?

From what I have read, it...

Thanks Mike. I'll try using the file dsn.

Thank you all for your replies -

I tried connecting to my access db with the odbc connection and it did not work. My linked tables are working fine. All...

Hi Jo, thanks for the reply.

I am not sure I understand what you mean. When I create my DSN, should I not be using the SQL Server...

Steve -

Thanks for the suggestion. If the time synch doesn't work, I'll be sure to try this.

I think the time synch is the issue.

I am receiving an error in the event viewer of the domain controller referencing time synch. The error message is as follows.

"This...

Thanks for the reply...

I checked the event log and there are some errors. They say that windows cannot obtain the domain controller name.

I am able to see the domain controller...

You can try increasing the number of characters per column displayed in query analyzer.  Go to Tools -> Options -> Results.

Hope this helps.

The problem I am encountering happens when I don't use bcp. The xml file contains carriage returns and line feeds without bcp.  I am looking for a way to generate an xml...

I have been successful creating an xml file using bcp.  However, I now need to have a sql query return an xml file in memory, not to an actual file. ...

Thank you so much for all of your help!!!  The -r switch worked great.

Thanks for the advice about using the text file and the dos copy.  The was able to created the xml document that I wanted to.  However, I am still experiencing...

Thank you for your help...I really appreciate it.  Thanks for the tip about using ADO.  However in my situation, I think bcp is the best way for me to go.

I...