Software

Ask something
Discussion Locked

Creating a "File DSN"

0 helpful
6 replies

by techrific

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Howdy all, here is the deal....

We have an old RIS with oodles of data on it that we sometimes need to access.

a new machine that we need to setup the ODBC stuff on so that it can access it. (it is SQL server box)

I have no experience here, I dont know what I am doing...

I see on another machine the drivers that are installed, so i installed them....

but the "File DSN" I cant seem to add, I look on one of the other machines and see there are like 5 .DSN files, but they say non sharable, for example...

"Excel Files (not sharable).dsn"
"dBASE Files (not sharable).dsn"
"FoxPro Files (not sharable).dsn"
"MS Access 97 Database (not sharable).dsn"
"Text Files (not sharable).dsn"

Anyone know how I can re-create these so that I can make it work on the new PC?

Or at least tell me what I should be looking for to figure out how to configure?

THX!!!!

Sozo

6 replies

by dkmc00

On the File DSN tab on the new PC, click on the 'Add' button and then add the necessary files
from the new window.

by techrific

In order to avoid answers like above..... when I try to add the "file DSN" it opens up a new window asking .....type the name of the file data source you want to save this connection to. Or, find the location to save to.... etc. etc.

Now i cannot arbitrarily create a file it seems, so I must need to have one already created.... where do I finf this?

by sgt_shultz

ok one thing at a time. you want to odbc to sql server, no? then use the User DSN tab, not the File one. just to get it working, see? pick the sql server driver, way at the bottom. see if that gets you where you want to go. and try Help inside the odbc admin dialog box. good luck

This discussion is closed to new replies.