| Author |
 Topic  |
|
nwduffer
Starting Member
45 Posts |
 Posted - 29 January 2001 : 11:09:34
|
quote:
What db and connection string are you using ?
that sql is for the access 97 driver
'Resistance is futile'
strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=d:\inetpub\wwwroot\mydomain.com\forum\extras\mydatabase.mdb" '## MS Access 97 (where my domain and database are replaced by actual location and filename)
Paul
Edited by - nwduffer on 29 January 2001 11:10:36 |
 |
|
|
Aznknight
Senior Member
USA
1373 Posts |
Posted - 29 January 2001 : 11:57:28
|
this topic has not been appearing on my active topics at all.
- Alan
|
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 29 January 2001 : 15:04:59
|
quote:
quote:
What db and connection string are you using ?
that sql is for the access 97 driver
'Resistance is futile'
strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=d:\inetpub\wwwroot\mydomain.com\forum\extras\mydatabase.mdb" '## MS Access 97 (where my domain and database are replaced by actual location and filename)
Paul
Edited by - nwduffer on 29 January 2001 11:10:36
try using the Access 2000 connection string
'Resistance is futile' |
|
|
|
nwduffer
Starting Member
45 Posts |
Posted - 29 January 2001 : 16:18:31
|
quote:
try using the Access 2000 connection string
'Resistance is futile'
Cha ching!
Yep that was it. I had been meaning to try the 2K driver anyway, but the board has really been getting used since I put it up last week, so I figured I'd do it some other time..but it works great. Thanks
Two quick notes:
1) Having the same sitch as mentioned above, moderators and admins can't see their private events, and
2) Can't see an event for the next month, even when the days are viewable at the end of this month, until you move to that next month. Not a big deal, just a FYI. (for example, Feb 2 is viewable in Jan month view, but events don't display till you move to Feb.)
Thanks for the help, again.
Paul
|
|
|
|
vortech
Starting Member
10 Posts |
Posted - 30 January 2001 : 12:42:34
|
Get this error when i try to delete a Event this is with sql 2000 every thing else seems to work fine but the delete.
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '*'.
/forum/events.asp, line 87
|
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 30 January 2001 : 12:51:00
|
quote:
Get this error when i try to delete a Event this is with sql 2000 every thing else seems to work fine but the delete.
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '*'.
/forum/events.asp, line 87
Remove the '*' from the DELETE statement, it should be DELETE FROM for SQL not DELETE * FROM
'Resistance is futile' |
|
|
|
ctsolutions
New Member
Germany
69 Posts |
|
|
Aznknight
Senior Member
USA
1373 Posts |
Posted - 31 January 2001 : 16:32:02
|
quote:
Your not using the 3.1sr4 standards for DB and NT modes. this is needed so that it works with both 
Need to change
sSql = "Select Member_ID from Forum_Members where M_Name = '" & Request.Cookies(strUniqueID & "User")("Name") & "'"
TO
sSql = "Select Member_ID from Forum_Members where " & strDBNTSQLName& " = '" & strDBNTUserName & "'"
I'm doing an update on this mod and wanted to use the db nt standards so that people using the nt mode can also use this mod.
Question since M_NAME is selected by strDBNTSQLNAME, does the recordset field use the strDBNTSQLNAME?
To clarify my question, should i also change:
RS("M_Name")
to
RS(strDBNTSQLNAME)
- Alan
|
|
|
|
Aznknight
Senior Member
USA
1373 Posts |
|
|
gor
Retired Admin
Netherlands
5511 Posts |
Posted - 01 February 2001 : 06:16:54
|
Locked ....
Pierre |
|
|
|
Topic |
|
Topic Locked
