| Author |
 Topic  |
|
|
johnhardy
Starting Member
United Kingdom
24 Posts |
 Posted - 24 September 2002 : 11:29:54
|
I downloaded the latest version of snitz today and cant get default.asp running.
Im using XP Pro, Access, ODBC and the connection string in config.asp is
strConnString ="snitz" (DSN) just to get running.
Im also using UD4 (dreamweaver)
The error I get is as follows, sounds like it cant find the database but the connection is OK. Ive done plenty of these.
Has any one any ideas where I am wrong please.
Thanks John
Error Type:
ADODB.Field (0x800A0BCD)
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
/Snitz/TMPdn1df2y7dm.asp, line 95
|
|
|
Roland
Advanced Member
Netherlands
9335 Posts |
Posted - 24 September 2002 : 12:32:00
|
have you edited any files with Dreamweaver? If so: get a clean file and make the changes again this time with a text editor such as Notepad, SourceEdit (http://www.sourceedit.com) or Homesite.
Also, run setup.asp before you go to default.asp
Last thing: you don't need a DSN for local testing. It's just as easy, if not easier, to use either the strConnString using the Vritual Path, or the full path. |
 |
|
|
johnhardy
Starting Member
United Kingdom
24 Posts |
Posted - 24 September 2002 : 12:50:08
|
Many Thanks FrutZle
I ran the setup.asp and it was away.
The original setting were all OK and I prefer to use a dsn as I seem to have less problems with this method.
Thanks again
John |
|
|
|
Roland
Advanced Member
Netherlands
9335 Posts |
Posted - 24 September 2002 : 13:53:24
|
You're welcome 
I've never had any problems using a DSN-less connection, but to each his own  |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 24 September 2002 : 16:46:33
|
quote:
Originally posted by johnhardy
(...) I prefer to use a dsn as I seem to have less problems with this method.
OLEDB drivers are faster and more robust than ODBC drivers (the ones used in DSN connections). I would always recommend OLEDB over ODBC. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
| |
Topic |
|
Topic Locked
