Re: SQL conversion

GWood,

This sounds like the method that might work best for me. Unfortunately, I
am into and area that I am not familiar with. I got to stop taking on these
jobs that are over my head.... I have found a guy here that is more
familiar with this than I am and may just sub the job out to him.

Bob S.



"GWood" <sorry@xxxxxxxxxxx> wrote in message
news:fsfUf.3555$kg.1047@xxxxxxxxxxxxxxxx
My earlier response was centered on obtaining the details from the SQL
database. Any reason you want to transfer the entire DB file, rather than
submitting a query and having the results output to a format accessible to
your web page?

The environment I work in uses this method extensively, but I haven't
tried
to simulate it at a micro level. Our "WEB-1" has DB connectivity and
talks
to "SQL-1", asking for and recieving data. We have third party RAD
software
that allows us to massage the retrieved data for presentation on the web
page. Is this SQL data access possible in your setup, without having to do
end runs for file access? If so, SQL Server can likely provide XML
formatted data (http://www.perfectxml.com/articles/XML/ExportSQLXML.asp#4)
or another format usable to your page.

"Robert J. Stuart" <rjstuart@xxxxxxxxxxxxx> wrote in message
news:kDASf.5840$k75.2605@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
OK so let me get some input from you guys. I will be working with 3
separate machines. SQL-1 which is the MS SQL server, Main-1, which is
the
main file server used for print server, docs and other file storage, you
know the rest, and WEB-1 which is the web host and FTP machine.

Now currently I have WEB-1 coming in on a separate IP subnet address on
the
T1 than the SQL-1 and Main-1 machines. I did this to have a complete
firewall system for the web server from the rest of the network. If I
wanted to do a direct link from the web server to the SQL-1 machine, I
would
have to either punch a hole in the firewall or put the WEB-1 machine on
the
same IP subnet as the rest of the network.

This database on the SQL is just basically a membership database, and
the
data is not really that sensitive. Doing a direct link to the active
SQL
file would be pretty hip since the web access would be in real time as
to
the changes being made to the database by the girls in the office.

Bob S.


"GWood" <sorry@xxxxxxxxxxx> wrote in message
news:WelSf.178$tT.111@xxxxxxxxxxxxxxxx
Yes, I should have expanded on this idea as well. Almost every
version
of
RDB these days will talk XML, and most browsers have a plug-in
available
that will also talk XML. The Clipper layer might be familiar to you,
but
really just adds a level of complexity to a task that is pretty
standard.


"E. Fridman" <pm771.am@xxxxxxxxx> wrote in message
news:1142544993.780633.203420@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Bob,

Most likely you should be able to "link" your SQL database directly
to
your web-site bypassing the need to create DBF in-between.









.

Relevant Pages

  • CREATE AGGREGATE failed because type Concatenate does not conform to UDAGG specification due to meth
    ... Now register the assembly and the aggregate in the SQL Server database you want ... I'm trying to do some CLR integration with sql server 2005. ...
    (microsoft.public.sqlserver.programming)
  • Re: How do i move an SQLDatabase to another location?
    ... I went to my clients and installed SQL Server ... Express and copied my database to the same location it was in while i was ... knowing that i can bring a database with me and install ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: New to Windows CE Development - Have some questions
    ... validating against the main database, or querying the database during data ... iterate through the SQL CE table and create new entries in the ... SQL Server database that correspond. ... >>> not connected to the Enterprise. ...
    (microsoft.public.windowsce.app.development)
  • RE: Logging in in background
    ... wold take all kinds of modifictions as I'd need to be checking that each SQL ... my database and all have connection strings associated with them. ... I suspect that there is also an issue on the SQL Server side as I keep ...
    (microsoft.public.access.modulesdaovba)
  • Re: Using Access 2007 to connect to SQL
    ... MDB database file format, ODBC linked tables, passthrough queries ... probably the easiest way of retrieving data from a SQL-Server ... I'm a total newbie w MS SQL Server. ...
    (microsoft.public.access.adp.sqlserver)