June 23rd, 2000, 05:09 PM
I have win98, Access 2000, VS 6.0(professional), install Win NT option pack 4,
Data Access Components2.1, Service Pack 3 for VS ……..
I can’t connect my page with database
Here is what I'm doing in InterDev6
Open my project
Add Data Connection
Data Link Property dialog box
Provider TAB
Microsoft Jet 4.0 OLE DB Provider
NEXT
Connection TAB
1.Select or enter a database name
Select My_file.mdb
2.Enter information to log on to the database
Admin
Test Connection
Test connection succeeded!!!!!!!!!
OK OK
Connection1 Properties dialog box
Connection Name:Connection1
Use Connection String:
Provider=Microsoft .Jet.OLEDB.4.0;User ID=Admin;…….
OK
Add Data Command
Command1 Properties dialog box
Command Name:Commannd1
Connection:Connection1
SQL Statement & SQL Builder:
Select……..
Data Environment Designer
Put my tables, Create connections between them
Query
Run
I have some data into the bottom table
Save
Open my HTML page
Drop Command1 on it
Recordset1
Connection: Connection1
Database Object: DE Commands
Object Name: Command1
From Tools
Drop RecordsetNavBar DTC on my page
RecordsetNavBar Properties dialog box
Name: RecordsteNavBar1
Scriting Platform: Client(IE 4.0…..
Recordset: Recordset1
OK
View my page in browser
All text boxes are empty
Same situation with grid control
Maybe I have to add some references in my project .
Thanks.
Data Access Components2.1, Service Pack 3 for VS ……..
I can’t connect my page with database
Here is what I'm doing in InterDev6
Open my project
Add Data Connection
Data Link Property dialog box
Provider TAB
Microsoft Jet 4.0 OLE DB Provider
NEXT
Connection TAB
1.Select or enter a database name
Select My_file.mdb
2.Enter information to log on to the database
Admin
Test Connection
Test connection succeeded!!!!!!!!!
OK OK
Connection1 Properties dialog box
Connection Name:Connection1
Use Connection String:
Provider=Microsoft .Jet.OLEDB.4.0;User ID=Admin;…….
OK
Add Data Command
Command1 Properties dialog box
Command Name:Commannd1
Connection:Connection1
SQL Statement & SQL Builder:
Select……..
Data Environment Designer
Put my tables, Create connections between them
Query
Run
I have some data into the bottom table
Save
Open my HTML page
Drop Command1 on it
Recordset1
Connection: Connection1
Database Object: DE Commands
Object Name: Command1
From Tools
Drop RecordsetNavBar DTC on my page
RecordsetNavBar Properties dialog box
Name: RecordsteNavBar1
Scriting Platform: Client(IE 4.0…..
Recordset: Recordset1
OK
View my page in browser
All text boxes are empty
Same situation with grid control
Maybe I have to add some references in my project .
Thanks.