| Author |
 Topic  |
|
|
clorix
Starting Member
35 Posts |
 Posted - 19 April 2001 : 06:53:53
|
I am being hosted on a dual T1 line so I know its not my host. I am usin a DSN and my forum is really slow in loading, and I go to other people's forum and theirs is fast.
Heres my forum:
www.neocom.ph/forum/
Why is it so slow? If I used access instead, would it be faster instead of SQL usin a DSN? Which is better security wise?
Thanks
Stephen
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 19 April 2001 : 12:13:18
|
We recommended using a DSN-less connection. A DSN-less connection is faster than a DSN connection.
No, only use access if you can't use anything else. SQL and MySQL is much faster than access.
|
 |
|
|
clorix
Starting Member
35 Posts |
Posted - 19 April 2001 : 17:16:57
|
I am being hosted through fineshost.com. So I can't get on their servers and create a DSNless connection. They made a DSN for me to use, but how do I create a DSN-less connection if I am being hosted?
Thanks
Stephen
|
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 19 April 2001 : 17:36:01
|
There is nothing to create when you're using a DSN-less connection. Are you using SQL?
If you look in your config.asp file you will need to use the SQL connection.'strConnString = "driver={SQL Server};server=SERVER_NAME;uid=SQL_USER;pwd=PASSWORD;database=DATABASE_NAME" '## MS SQL Server 7Make sure to remove the ' from the front of the line. Use that to connect to your SQL database. If you don't know your server name, the username and password, or the name of your database you will need to ask your host for it. Just tell them you don't want to use a dsn connection.
|
|
|
|
clorix
Starting Member
35 Posts |
Posted - 19 April 2001 : 17:36:22
|
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC SQL Server Driver]Timeout expired
/forum/inc_functions.asp, line 1268
I always get this error, and only half the time my board loads up, its so slow.
|
|
|
|
clorix
Starting Member
35 Posts |
Posted - 19 April 2001 : 22:01:15
|
Okie, I e-mailed my host and Im askin them about it, I'll post here in the morning to tell you what they said to me n such. so check back :O)
Thanks,
Stephen
|
|
|
|
clorix
Starting Member
35 Posts |
Posted - 19 April 2001 : 23:28:53
|
It works now, they gave me the wrong database name. Thank you guys so much.
www.neocom.ph/forum/ :O)
Thanks,
Stephen
|
|
|
|
clorix
Starting Member
35 Posts |
Posted - 22 April 2001 : 22:18:11
|
Help again!!!! I thought it was fixed but its not, every once in a while i'll get a ODBC error with like TCP/IP or something, but it doesn't happen all the time. And my board is really slow in loading
Here go to my board and click through the forums:
www.neocom.ph/forum/
Why is it so slow? what can I do? I have a DSN-less connection and its TCP/IP instead of numbered pipes or whatever. I am also being hosted. so why?
thanks clorix
|
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 22 April 2001 : 22:50:23
|
| My guess would be that your host's DB Server might be overloaded, or the server your forum is running on is overloaded, or there is a slow connection between the server your forum is on and the server your DB is on. |
|
|
|
clorix
Starting Member
35 Posts |
Posted - 23 April 2001 : 02:25:51
|
Oh, I dunno, I told them about the slowness of their sql server and they said they are looking into it. Does anyone else have any ideas on why my board would be slow? Visit my board, www.neocom.ph/forum/ and reply to tell me if its slow or not. Thanks
Stephen
|
|
|
|
Luke
Starting Member
4 Posts |
Posted - 23 April 2001 : 22:12:05
|
Slow...
|
|
|
|
clorix
Starting Member
35 Posts |
Posted - 23 April 2001 : 23:59:21
|
anyone know what I can do or suggestions to make it faster? Changing to access?
|
|
|
|
clorix
Starting Member
35 Posts |
Posted - 24 April 2001 : 09:48:48
|
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]General network error. Check your network documentation.
/forum/topic.asp, line 450
Thats the error I get sometimes. Whats going on? Is this why my forum is so slow in loading?
|
|
|
| |
Topic |
|
Topic Locked
