I am new to Visual Interdev and I am trying to connect to the pubs database on MSSQL server on the local machine.
This is what I have done.
1. create new project in master mode
2. create new asp page
3. create a dataconnection to pubs via machine dsn
4. create a data command to the new connection
5. double clik on some of the tables to make sure they work
5. drag the command object into the asp page under the <body> tag.
6. save and test, but it dosnt' work. It sais error (8cxbla bla) Exception has occured. On line 22.
Line 22 = var rsTmp = DE.RecordSets("Command1"
;
Any ideas why this dosn't work??
It all works if I connect to an access machine dsn.
Thanks,
Jai
This is what I have done.
1. create new project in master mode
2. create new asp page
3. create a dataconnection to pubs via machine dsn
4. create a data command to the new connection
5. double clik on some of the tables to make sure they work
5. drag the command object into the asp page under the <body> tag.
6. save and test, but it dosnt' work. It sais error (8cxbla bla) Exception has occured. On line 22.
Line 22 = var rsTmp = DE.RecordSets("Command1"
;Any ideas why this dosn't work??
It all works if I connect to an access machine dsn.
Thanks,
Jai