| Author |
 Topic  |
|
|
nswan
Starting Member
15 Posts |
 Posted - 26 July 2001 : 07:09:35
|
is there anything wrong with the syntax from the following line from config.asp
strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=151.180.112.83/message/snitz_forums_2000.mdb"
do I have to have ODBC installed on the server?
Many thanks
Nick
|
|
|
gor
Retired Admin
Netherlands
5511 Posts |
Posted - 26 July 2001 : 07:38:14
|
quote:
is there anything wrong with the syntax from the following line from config.asp
strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=151.180.112.83/message/snitz_forums_2000.mdb"
You can't use the IP-number in the connectionstring.
With Access the database has to be on the same server in a folder with write access enabled. Then you would use something like:
strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=/message/snitz_forums_2000.mdb"
Pierre
Join a Snitz Mailinglist |
 |
|
|
nswan
Starting Member
15 Posts |
Posted - 26 July 2001 : 08:56:37
|
what about having odbc set up on the server coz it's still not working!
|
|
|
|
Kat
Advanced Member
United Kingdom
3065 Posts |
Posted - 26 July 2001 : 09:12:31
|
You don't need ODBC because the forums use DSN-less connections. Are you sure your database path is correct?
KatsKorner
|
|
|
|
nswan
Starting Member
15 Posts |
Posted - 26 July 2001 : 09:19:56
|
99% sure!
is it only the wrong path that can bring up -2147467259 error?
|
|
|
|
gor
Retired Admin
Netherlands
5511 Posts |
Posted - 26 July 2001 : 09:25:55
|
You need ODBC on the server, but as far as I know that allready is installed by default.
Pierre
Join a Snitz Mailinglist |
|
|
|
nswan
Starting Member
15 Posts |
Posted - 26 July 2001 : 09:27:54
|
it's an intranet site at work so perhaps they haven't put it on. I'll go and check!
|
|
|
|
Kat
Advanced Member
United Kingdom
3065 Posts |
Posted - 26 July 2001 : 10:03:49
|
quote:
You need ODBC on the server, but as far as I know that allready is installed by default.
Pierre
Join a Snitz Mailinglist
Yep - I was talking about the client 
KatsKorner
|
|
|
|
nswan
Starting Member
15 Posts |
Posted - 30 July 2001 : 05:51:23
|
hi,
can you please tell me what ODBC stuff i need putting on the server?
Thanks
Nick
|
|
|
|
Spoon
Average Member
Ireland
507 Posts |
Posted - 30 July 2001 : 08:04:06
|
quote:
hi,
can you please tell me what ODBC stuff i need putting on the server?
Thanks
Nick
Check out the link in my signature :)
Regards - Spoon
Begineer? Need help installing the forums? - www.aslickpage.com/snitz_help.html
www.ASlickPage.com - Private Messaging |
|
|
|
nswan
Starting Member
15 Posts |
Posted - 30 July 2001 : 09:37:23
|
okay, I've got a bit further now...
I'm using the
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/tools/snitz_forums_2000.mdb")
'## MS Access 2000 using virtual path
line now. The problem is that the script times out. Am i making any progress?
|
|
|
|
Spoon
Average Member
Ireland
507 Posts |
Posted - 30 July 2001 : 11:02:43
|
Hi, one thing i noticed, you have:
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/tools/snitz_forums_2000.mdb")
'## MS Access 2000 using virtual path
It should be without the dash in red like so:
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/tools/snitz_forums_2000.mdb")
'## MS Access 2000 using virtual path
Hope this helps
Regards - Spoon
Begineer? Need help installing the forums? - www.aslickpage.com/snitz_help.html
www.ASlickPage.com - Private Messaging |
|
|
|
nswan
Starting Member
15 Posts |
Posted - 30 July 2001 : 11:05:29
|
sorry,
the apostarphy is only included coz i copied it straight off your webpage!!!
does setup.asp take ages to run as i could change the amount of time before it timesout?
|
|
|
|
Spoon
Average Member
Ireland
507 Posts |
Posted - 30 July 2001 : 11:17:47
|
quote:
sorry,
the apostarphy is only included coz i copied it straight off your webpage!!!
does setup.asp take ages to run as i could change the amount of time before it timesout?
Oh, well the setup.asp thing happened to me before. Are you usind PWS??
If you are download the latest drivers, reboot your computer, then run setup.asp again. Heres the link to download:
http://www.microsoft.com/data/download_250rtm.htm
Regards - Spoon
Begineer? Need help installing the forums? - www.aslickpage.com/snitz_help.html
www.ASlickPage.com - Private Messaging |
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 30 July 2001 : 20:14:41
|
quote:
If you are download the latest drivers, reboot your computer, then run setup.asp again. Heres the link to download:
http://www.microsoft.com/data/download_250rtm.htm
This link is not to the latest MDAC, although it's a good version and should work adequately. Visit msdn.microsoft.com/data for info on the current version MDAC (2.6). Read the special instructions regarding Jet drivers for Access.
======
Doug G
====== |
|
|
|
Spoon
Average Member
Ireland
507 Posts |
Posted - 31 July 2001 : 06:44:32
|
quote:
quote:
If you are download the latest drivers, reboot your computer, then run setup.asp again. Heres the link to download:
http://www.microsoft.com/data/download_250rtm.htm
This link is not to the latest MDAC, although it's a good version and should work adequately. Visit msdn.microsoft.com/data for info on the current version MDAC (2.6). Read the special instructions regarding Jet drivers for Access.
======
Doug G
======
Thanks Doug  . I dont know why i said latest, but hey..... :)
Regards - Spoon
Begineer? Need help installing the forums? - www.aslickpage.com/snitz_help.html
www.ASlickPage.com - Private Messaging |
|
|
| |
Topic |
|
Topic Locked
