Board index Database Programming

SQL Server in VB6 and FrontPage

SQL Server in VB6 and FrontPage

Post by Tom Collin » Fri, 11 May 2001 03:22:53



Newbie with all of this ... I've got SQL Server 2000, VB6, and FrontPage
2000 loaded on my system. Right now I'm trying to learn VB6, but will
shortly build a web application using SQL Server, possibly VB6 as an
interface, maybe putting the whole thing together with FrontPage.

My problem is, how/where do I define SQL Server to VB6 and FrontPage. When I
add a Data control to a VB6 form, SQL Server is not one of the connect
options.

Can someone tell me what needs to be set up to make this happen?

Thanks.
Tom

 
 
 
Top

SQL Server in VB6 and FrontPage

Post by Parth » Fri, 11 May 2001 09:04:50


You have to create a DSN to access SQL Server. In the Data control choose ODBC
data sources and then choose the SQL Server DSN.
Quote:-----Original Message-----
Newbie with all of this ... I've got SQL Server 2000, VB6, and FrontPage
2000 loaded on my system. Right now I'm trying to learn VB6, but will
shortly build a web application using SQL Server, possibly VB6 as an
interface, maybe putting the whole thing together with FrontPage.

My problem is, how/where do I define SQL Server to VB6 and FrontPage. When I
add a Data control to a VB6 form, SQL Server is not one of the connect
options.

Can someone tell me what needs to be set up to make this happen?

Thanks.
Tom

.


 
 
 
Top

SQL Server in VB6 and FrontPage

Post by Joshua Hear » Sat, 12 May 2001 01:50:19


Visual Studio does a better job then FrontPage when working with VB and
building an internet app.


Quote:> Newbie with all of this ... I've got SQL Server 2000, VB6, and FrontPage
> 2000 loaded on my system. Right now I'm trying to learn VB6, but will
> shortly build a web application using SQL Server, possibly VB6 as an
> interface, maybe putting the whole thing together with FrontPage.

> My problem is, how/where do I define SQL Server to VB6 and FrontPage. When
I
> add a Data control to a VB6 form, SQL Server is not one of the connect
> options.

> Can someone tell me what needs to be set up to make this happen?

> Thanks.
> Tom

 
 
 
Top

SQL Server in VB6 and FrontPage

Post by Jeff Mille » Sat, 19 May 2001 22:23:01


I use Front Page for most everything even though there are better tools out
there for building data access apps (visual interdev, etc.)  I normally save
VB for serious web apps.

Take a look at these sites, I think it will get you started...

http://www.4GuysFromRolla.com

http://www.aspsamples.com

http://msdn.microsoft.com/library/default.asp?URL=/library/psdk/iisre...
hmb.htm

Or just search the net for ASP samples...

Jeff Miller
El Paso

Quote:> Newbie with all of this ... I've got SQL Server 2000, VB6, and FrontPage
> 2000 loaded on my system. Right now I'm trying to learn VB6, but will
> shortly build a web application using SQL Server, possibly VB6 as an
> interface, maybe putting the whole thing together with FrontPage.

> My problem is, how/where do I define SQL Server to VB6 and FrontPage. When
I
> add a Data control to a VB6 form, SQL Server is not one of the connect
> options.

> Can someone tell me what needs to be set up to make this happen?

> Thanks.
> Tom

 
 
 
Top

1. Need Help with ODBC/MS SQL Server 6.5/Peer Web Server 3.0/Frontpage Problem

I am looking for help with the following problem:

I receive the following error when trying to execute a stored procedure
that is called through an .idc file in my FrontPage web:

" [State=37000][Error=103][Microsoft][ODBC SQL Server Driver][SQL
Server]The identifier that starts with 'A01,B01,C01,D01,' is too long.
Maximum length is 30. "

The stored procedure gets passed a variable which is a variable length
string made up of comma separated values (values from a multiple-select
checkbox set).  In my stored procedure, I have allowed for this to be a
maximum of 60 characters in length, and when I execute it in a SQL
Server query window, the stored procedure works just fine.  However,
when I execute it through the .idc file in the Frontpage web, I get the
above error.

Here is another interesting feature to this problem...I have a local
copy of the same web.  When I execute the sp from my machine (so, I am
going over the network using ODBC to get the data from another machine),
it does work.  It just doesn't work on the machine on which the web and
database both are.

My ODBC SQL Server Driver is version 2.65.0240.  The one on the other
machine is 2.65.0201.  I have service pack three.  The other machine has
service pack 1.  We tried updating it to service pack three, but that
did not update the driver to the .0240 version, and the problem remains.

I would really appreciate it if anyone could help with this.

Thanks,
Sudha

2. Problems with DB connections and Multi-threaded apps

3. FrontPage won't connect to SQL server in seperate domain

4. oracle course

5. SQL Server in Frontpage

6. I would like to access SQLCA from a stored procedure

7. Placing and Getting Image Files using Frontpage, ASP and SQL Server

8. Debugging in T-SQL

9. Using Frontpage 98 and SQL Server 7 to build dynamic web site

10. connecting to SQL Server DB across web from Frontpage 2000

11. Connecting to cubes in Analysis Server from Frontpage

12. Connect to cubes in Analysis Server from Frontpage

13. MS FrontPage 2000 Active Server Page


All times are UTC
Board index