Web Based SQL and PC App

reyboy · May 6th, 2004, 12:56 AM

Is it possible for an VB Application to use a WEB BASED SQL Server using ODBC or Connectionstring or whatever?
If so what are the implications? :)

melvik · May 6th, 2004, 04:44 AM

Excuse me Sir,
what do u mean WEB BASED SQL Server?!
U can use Normal SQLObj to connect ur DataBase from Web too!

Always:),
Hovik Melkomian.

Hal Levy · May 6th, 2004, 08:22 AM

as Hovik said, what's a "web based SQL server"?

Hal Levy
Web Developer, PDI Inc.

NOT a Wiley/Wrox Employee

reyboy · May 6th, 2004, 08:29 PM

It's like this, I have an application then i want its SQL Database hosted by a Web Hosting Company(Ex.Ready Hosting). Then I want to know my chances first before trying if its feasible and what are its advantages and disadvantages, coding implications etc.
Sorry for the terminology

Steven · May 7th, 2004, 01:25 AM

I think what reyboy is getting at is a box that is both SQL Server and a Web Server,

If I'm reading this right, you want your VB App to talk to a SQL Server that's not on your network.

That right?

I am a loud man with a very large hat. This means I am in charge

pgtips · May 7th, 2004, 03:01 AM

Quote from http://www.able-consulting.com/MDAC/...erForSQLServer

Quote:

quote:
To connect to SQL Server running on a remote computer (via an IP address)

oConn.Open "Provider=sqloledb;" & _
           "Network Library=DBMSSOCN;" & _
           "Data Source=xxx.xxx.xxx.xxx,1433;" & _
           "Initial Catalog=myDatabaseName;" & _
           "User ID=myUsername;" & _
           "Password=myPassword"
Where:
- "Network Library=DBMSSOCN" tells OLE DB to use TCP/IP rather than
   Named Pipes (Q238949)
- xxx.xxx.xxx.xxx is an IP address
- 1433 is the default port number for SQL Server. Q269882 and Q287932
- You can also add "Encrypt=yes" for encryption

reyboy · May 7th, 2004, 08:47 PM

Thank you very much for the warm response. :)

Steven got what i meant. Thanks PgTips for the code.
Has anyone tried the code? How would ADO react, say we are to query&update a table with 65,0000 Rows, when internet connection is just dial-up? this one is a bonus to me!:D