I have been fighting this problem for three days and the prior thread is to long so here is the problem simplified:
1) The Error:
Error opening Grid table/view: Host/Server not found
2) On the Alpha Five Ver 10.5 database platform it works fine. I can publish and launch the browser. It connects to the sql database and shows me the data.
3) On another workstation running the App Web Server on the Lan (Vista),when I access the the website either form the Main Internet or from our local Lan I receive the error opening grid. The correct A5W page comes up, but the it is unable to access the table.
4) The App Web Server is running on Port 8080. I am using NO-IP to tell the DNS the ip address of the Vista station. That seems to work fine.
5) I am using a named connection string (digitalstreak_sql), which reference is found on the app web server in:
a5_application.a5i and my grid componet called grd_add_emails.a5wcmp
This is the actual connection string (Alpha Five Hides the password:)
{A5API='SQLServer',A5DBVersion=2008,Server='216.243.10.125',database='digitalhahn',A5ANSINullPadWarn=Default,UserName='digitalhahn',Password='��������'}
The actual connection string literal is found in the following files on the Alpha Web Server Vista Machine:
a5_application.a5i under the pathalias.adb_path reference.
In a file called quickpublish.settings is the name of the profile I used to publish the project.
There is only one form and one component grid in the project.
I am able to use access 2000 or the control panel odbc and connect to the remote sql server on the vista alpha web app server machine without a problem.
I am really stuck.
Any ideas?
Thanks,
Michael (mrh)
1) The Error:
Error opening Grid table/view: Host/Server not found
2) On the Alpha Five Ver 10.5 database platform it works fine. I can publish and launch the browser. It connects to the sql database and shows me the data.
3) On another workstation running the App Web Server on the Lan (Vista),when I access the the website either form the Main Internet or from our local Lan I receive the error opening grid. The correct A5W page comes up, but the it is unable to access the table.
4) The App Web Server is running on Port 8080. I am using NO-IP to tell the DNS the ip address of the Vista station. That seems to work fine.
5) I am using a named connection string (digitalstreak_sql), which reference is found on the app web server in:
a5_application.a5i and my grid componet called grd_add_emails.a5wcmp
This is the actual connection string (Alpha Five Hides the password:)
{A5API='SQLServer',A5DBVersion=2008,Server='216.243.10.125',database='digitalhahn',A5ANSINullPadWarn=Default,UserName='digitalhahn',Password='��������'}
The actual connection string literal is found in the following files on the Alpha Web Server Vista Machine:
a5_application.a5i under the pathalias.adb_path reference.
In a file called quickpublish.settings is the name of the profile I used to publish the project.
There is only one form and one component grid in the project.
I am able to use access 2000 or the control panel odbc and connect to the remote sql server on the vista alpha web app server machine without a problem.
I am really stuck.
Any ideas?
Thanks,
Michael (mrh)
Comment