If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
ODBC filename
I have an Access front end connecting to SQL for the data. I have made my
ODBC connections for each machine through File DSN and they all work except one. I have one machine that came with Windows Vista and has been converted back to XP like all the others. On this machine when I open the ODBC Administrator, I select SQL and type in my name for the dsn, and no matter what name I type in, I get an error that says "the filename entered is invalid" and my only choice is "OK". Can anybody help me with what it wants for a filename? I have simply used "fea" for all the others, but that won't work here. I've tried adding letters to get it up to seven characters, but it still gives me the same error message. Thanks for any advice!! Susan |
#2
|
|||
|
|||
ODBC filename
This doesn't seem to be an Access issue. However, I have gotten away from
creating DSNs on user PCs opting for DSN-less connections as documented on Doug Steele's site http://www.accessmvp.com/djsteele/DSNLessLinks.html. -- Duane Hookom Microsoft Access MVP "Susan" wrote: I have an Access front end connecting to SQL for the data. I have made my ODBC connections for each machine through File DSN and they all work except one. I have one machine that came with Windows Vista and has been converted back to XP like all the others. On this machine when I open the ODBC Administrator, I select SQL and type in my name for the dsn, and no matter what name I type in, I get an error that says "the filename entered is invalid" and my only choice is "OK". Can anybody help me with what it wants for a filename? I have simply used "fea" for all the others, but that won't work here. I've tried adding letters to get it up to seven characters, but it still gives me the same error message. Thanks for any advice!! Susan |
#3
|
|||
|
|||
ODBC filename
Hello Susan,
I seem to be having the same issue. Please let me know if you found a solution to the problem. Thanks, Kiran |
Thread Tools | |
Display Modes | |
|
|