Board index Database Programming

Tips wanted about VB, ASP and MS-SQL

Tips wanted about VB, ASP and MS-SQL

Post by Wouter van der Veld » Fri, 22 Sep 2000 04:00:00



Hi,

I am designing a system wich that must access a MS-SQL server and display
it's results into html (asp-page).

*What tools are the best to use?
*What is the difference between InterDev and Visual Basic
*Does anyone know a URL with an example about this matter, I'd like to have
an A to Z     manual because I am not familiar with Visual Studio.
*Any book that can be recommended?

Thank You very much!

Wouter

--

'Don't worry about people stealing your ideas. If your ideas are any good,
you'll have to ram them down people's throats.'
-Howard Aiken

 
 
 
Top

Tips wanted about VB, ASP and MS-SQL

Post by Anderea Vaugha » Fri, 22 Sep 2000 04:00:00


If you send this person a link on the tips can one be fowarded to me?
thanks

--
Anderea Vaughan

University of Phoenix Online Student

"Wickedness is always easier than virtue, for it takes the
shortcut to everything."
- Samuel Johnson



Quote:> Hi,

> I am designing a system wich that must access a MS-SQL server and display
> it's results into html (asp-page).

> *What tools are the best to use?
> *What is the difference between InterDev and Visual Basic
> *Does anyone know a URL with an example about this matter, I'd like to
have
> an A to Z     manual because I am not familiar with Visual Studio.
> *Any book that can be recommended?

> Thank You very much!

> Wouter

> --

> 'Don't worry about people stealing your ideas. If your ideas are any good,
> you'll have to ram them down people's throats.'
> -Howard Aiken


 
 
 
Top

1. tips on ASP-MySQL port to VB-MySQL

Hi All,

        anyone out there built a DB applicationin VB 5 or 6 that uses a
MySQL back-end?? I wrote a web interface in ASP but have trouble porting
the code
to VB5. I am told the ADO code should be the same but I am missing
something somewhere.

this is some asp code that creates a ADOServer object
applies the DSN to the connection method
creates a command object and assigns an SQL statement
executes the connection
creates a recordset object and applies the SQL statement to the recodset
objects

Set DataConn = Server.CreateObject("ADODB.Connection")
DataConn.Open "DSN=OSCDB"
Set DataCmd = Server.CreateObject("ADODB.Command")
DataCmd.CommandText = "select * from Suppliers where ID = '" &
Request.QueryString("ID") &"'"
Set DataCmd.ActiveConnection = DataConn
Set rs_main = Server.CreateObject("ADODB.Recordset")
Set rs_main =  DataCmd.execute

I just need to get the ADO syntax correct and I should'nt have too much
trouble after I am getting
a populated recordset

if anyone can give me a few pointers it would much appreciated

Regards

            Steven Holloway

2. Problem Copying Access 2.0 database in VB3

3. Connecting to Sql Server from asp after upgrade from ms sql 7 to ms sql 2000

4. ADO Security, Registry problem and HOT FIX for IIS.....HELP

5. Inserting values into a SERIAL field

6. MS Tips Engine Services tips.exe Application Error

7. Maximum size of one table

8. MD-Silver Spring-109258--Web Development-Windows NT-MS SQL Server-VB Script-ASP-

9. SQL Query Help needed (ASP.NET Tips and Tricks Demo 2)


All times are UTC
Board index