• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 345
  • Last Modified:

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
0
pclarke7
Asked:
pclarke7
  • 3
  • 3
1 Solution
 
Carl TawnSystems 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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
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

Featured Post

[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now