>I recently begain to use Visual FoxPro 7.0 as the main DB for my ColdFusion website. But I encounter a problem. When I put the FoxPro DB in the same computer as the ColdFusion_Server I will be able to connect to the DB through ODBC no problem. But when I place the FoxPro DB in a serparate computer, than I won't be able to verified the ODBC DB connection anymore. Have anyone in here ever have the same kinda the problems? Please help me, I'm still a newbie in FoxPro and ColdFusion.....+_+
>Thanx Alot....anything is good at this point@_@
As long as the web server can
see the other computer, you can connect via ODBC to the DB. Example:
lnHandle = SQLSTRINGCONNECT("Driver=Microsoft Visual FoxPro Driver;UID=;PWD=;SourceDB=UNC_Path_To_Other_Server\dbc_name.DBC;SourceType=DBC;Exclusive=No;BackgroundFetch=Yes;Collate=Machine;Null=Yes;Deleted=Yes;")
Mark McCasland
Midlothian, TX USA