ODBC Connection to non SQL server

Hello,
I have an application which uses ODBC connections to various databases successfully (eg. DB2 database on iseries) I now need to access a .CSV file on a remote printer server which, is not a SQL server, but I am having problems finding a driver for this. I am able to successfully remote to this server using "Remote Desktop Connection" however I need to be able to do this programmatically and retrieve and update details on a CSV file called "Users&Printers". I looked at "Microsoft Text Driver (*.txt, *.csv) " - however this does not seem to have any remote server connection options available.  I need to be able to connect to the server and access the file which is in a folder (C:\Documents and Settings\All Users\Application Data\Optio\OECI\7.7\samples\Users&Printers). Appreciate any suggestions.

regards
Pat
LVL 1
pclarke7Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Carl TawnConnect With a Mentor Systems and Integration DeveloperCommented:
Are you not able to share the folder on the remote server, and map to it?
0
 
pclarke7Author Commented:
Hi Carl,
no the users will not have mapped drives. I have had a comment elsewhere about using WebClient to access/update the file. Are you familiar with WebClient ?

regards
Pat
0
 
Carl TawnSystems and Integration DeveloperCommented:
WebClient won't really help in your case, because it requires a Http listener to connect to. Which mean you would have to run IIS on your server, with a virtual directory pointing to the location of the CSV file.

But even that would only provide read access directly. To modify the file you would need to pull it to the client, modify it, and then push it back to the server again.
0
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
pclarke7Author Commented:
Thanks Carl,
any suggestions about the best method of reading & Updating a file on a remote server without mapping a drive ?

regards
Pat
0
 
Carl TawnSystems and Integration DeveloperCommented:
Do you have a login that can connect to directly to the remote folder. i.e. Can you connect to \\your-server\c$\Documents and Settings\All Users\Application Data\Optio\OECI\7.7\samples\Users&Printers, rr can you create a domain account that you can use to connect?

If you can't then you are going to need an intermediate service to provide access to the file - which could be an HTTP or FTP server. But anything other than direct access will require a download/modify/upload process.
0
 
pclarke7Author Commented:
Hi Carl,
I have gone with your suggestion - thanks. Just 1 point. I could have multiple users using the application and they could have mapped different drives to the Server. Is there any easy way in c# for the application to look at their mapped drives and automatically select the correct one via the description ?

regards
Pat
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.