Forums
This topic is locked
ODBC connection to a network file or db
Posted 24 Jan 2007 20:45:58
1
has voted
24 Jan 2007 20:45:58 Alessandro Marchetto posted:
HI,I have a problem that drive me crazy.
I have some foxpro file on a server (\\server1\DB\xxxx.dbf)
I have IIS on other server (\\server2)
On server2 i make an ODBC that connect xxxx.dbf table calle VS_Files
ON Dreamweaver i make a connection to VS_File
i click on the connection and inside table no file are show (none)
If i move the file from \\server1\DB\xxxx.dbf to \\mserver2\DB\xxxx.dbf and i modify the VS_Files ODBC so the ODBC work with local file, every thing work good, under the table i can see the file name and all the field.
All connection made with the ODBC that point to a network drive make the same also if i use other database.
NOTE
Using access and connectin table using the ODBC it work on both way with a local xxxx.dbf and with a network drive xxxx.dbf
PLS Help
Alessandro Marchetto
Replies
Replied 25 Jan 2007 06:38:25
25 Jan 2007 06:38:25 Javier Castro replied:
Check this out perhaps it can help you:
www.connectionstrings.com/?carrier=dbffoxpro
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
HI,
I have a problem that drive me crazy.
I have some foxpro file on a server (\\server1\DB\xxxx.dbf)
I have IIS on other server (\\server2)
On server2 i make an ODBC that connect xxxx.dbf table calle VS_Files
ON Dreamweaver i make a connection to VS_File
i click on the connection and inside table no file are show (none)
If i move the file from \\server1\DB\xxxx.dbf to \\mserver2\DB\xxxx.dbf and i modify the VS_Files ODBC so the ODBC work with local file, every thing work good, under the table i can see the file name and all the field.
All connection made with the ODBC that point to a network drive make the same also if i use other database.
NOTE
Using access and connectin table using the ODBC it work on both way with a local xxxx.dbf and with a network drive xxxx.dbf
PLS Help
Alessandro Marchetto
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
www.connectionstrings.com/?carrier=dbffoxpro
<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
HI,
I have a problem that drive me crazy.
I have some foxpro file on a server (\\server1\DB\xxxx.dbf)
I have IIS on other server (\\server2)
On server2 i make an ODBC that connect xxxx.dbf table calle VS_Files
ON Dreamweaver i make a connection to VS_File
i click on the connection and inside table no file are show (none)
If i move the file from \\server1\DB\xxxx.dbf to \\mserver2\DB\xxxx.dbf and i modify the VS_Files ODBC so the ODBC work with local file, every thing work good, under the table i can see the file name and all the field.
All connection made with the ODBC that point to a network drive make the same also if i use other database.
NOTE
Using access and connectin table using the ODBC it work on both way with a local xxxx.dbf and with a network drive xxxx.dbf
PLS Help
Alessandro Marchetto
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>