A little help with UltraDev?? VBscript compilation error?

[heavy]

When I try to view live data, I get error 800a0401 which it says is a VBscript compilation error.

It seems that since UltraDev implemented the VBscript itself, it would be good. Or am I understanding it incorrectly?

I am using Microsoft Personal Web Server with the tutorial that came with UltraDev.

Thanks!!

[Hierophant]

Actually its a generic ASP error. It means you can't connect to the database for some reason. Without seeing the code and getting a few specifics it would be hard to determine why though.

------------------
Wayne Luke - Sitepoint Forums Administrator
Digital Magician Magazine - MetaQuark Creations (Coming Soon)
wayne@sitepoint.com

[heavy]

Thanks!

Hmmmm. That's strange becuse in UltraDev, it loads an inspector that contains all of the tables in the database. You then just select the record you want in a certain spot and insert it.
In the inspector (in UltraDev), the database is shown with all of the tables and records and such. This tells me that UltrDev itself is connecting to the database just fine.

So, you are saying then that the error is not with any of the settings inside of UltraDev, but someplace else. Like PWS?

I am really a newbie when it comes to database calls and ODBC. I know absolutely nothing about it. Any help is greatly appreciated.

Thanks!

[Hierophant]

PWS is returning the error. The problem is with how it is parsing the page. If you load the page in your browser by going to http://127.0.0.1/pagename.asp you'll probably get a more detailed error.

------------------
Wayne Luke - Sitepoint Forums Administrator
Digital Magician Magazine - MetaQuark Creations (Coming Soon)
wayne@sitepoint.com

[djh]

A shot in the dark, but have you copied your database to your inetpub/wwwroot/ folder, where your database is supposed to be?

Ultradev might be able to point to a db file on your machine, but if you're publishing it on PWS, the db also needs to be in your inetpub folder....

------------------
Dave Han - webmaster@goboatingamerica.com
"If a question can be put at all, then it can also be answered." - Wittgenstein
Visit goboatingamerica.com

[heavy]

Wayne:Ok, ran it through my browser like you said. Here is the complete error.

Microsoft VBScript compilation error '800a0401'

Expected end of statement

/tutorial/extranet_news.asp, line 13

var rsReleaseSummaries = Server.CreateObject("ADODB.Recordset");
---------------------------------------------------------------^


I think maybe we're getting somewhere?
What to do?

Dave: Yeah, it's in there. I double checked just to make sure though. Thanks!

Thanks a lot for all of the help!

[Hierophant]

Remove the semi-colon. In Visual Basic, statements are delimited by Carriage returns.

------------------
Wayne Luke - Sitepoint Forums Administrator
Digital Magician Magazine - MetaQuark Creations (Coming Soon)
wayne@sitepoint.com

[heavy]

Thanks Wayne! It worked, sort of.

When I looked the code I found that there were two sets of variables defined at the top. (I think I'm saying this right.)

I was in JavaScript mode and then switched to VBscript mode, apparently it didn't remove the JavaScript, it just inserted the VBscript.

It works now, thanks!

~Daniel