| Author |
 Topic  |
|
|
Cool Surfer
Starting Member
India
32 Posts |
 Posted - 19 October 2004 : 12:57:57
|
Hello friends,
I am using invision forum version2, and have a sql ~40mb.
I want to convert to snitz 3.4x version. Is it possible, is there
a script to convert the invision sql to make it work with snitz forum pl.
Secondly: my database is quite big, I got 750gigs space on linux
server, but only 20mb on nt server. Is it possible for me to use the
sql database on linux server or use .mdb file on linux server and
keep the .asp files of forum on nt server ??
Regards |
Cool Surfer
 |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 19 October 2004 : 14:16:34
|
I don't think there is such a script.
Regarding the 2nd question, yes you can use a MySQL DB on a linux server from a NT server. You could also use an Access DB on the NT server, with the ASP files on the linux server, if you had Sun One ASP installed, but it's a lot more complex to do it. Go for the first solution if you can. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
 |
|
|
Cool Surfer
Starting Member
India
32 Posts |
Posted - 19 October 2004 : 14:58:36
|
Thanks, I will try to setup sql on linux server. And try to copy posts manually.
If I am not wrong in interpreting your post, it means that I can
upload snitz forum files on my linux server, eg www.onlinemedicalforum.com/snitzforum , all asp files will run on the
apache server ?? In apache handlers, do I need to add any extensions??
I am not sure if Sun One ASP is installed.
if I create a
sql db= dbsnitz
user= test
pwd= test
then is this the line which i will uncomment in config.asp pl ??
It will help me a lot.
Thanks. |
Cool Surfer
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 19 October 2004 : 15:05:58
|
You cannot upload your ASP files on the linux server unless it has SUN One (which is a paid product) installed on your server. As probably Sun One is not installed, you will need to upload the ASP files to the NT server. The database, however, can be created in the linux server, admiting that you can access it from the NT server (are they on the same network?).
The line you will uncomment in config.asp is this one:
strConnString = "driver=MySQL;server=SERVER_IP;uid=UID;pwd=PWD;database=DB_NAME"
where you will need to fill in the info in red. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
Cool Surfer
Starting Member
India
32 Posts |
Posted - 19 October 2004 : 15:14:50
|
The database could not be opened !!
Check your config.asp file and set the
strConnString so it points to the database.
Also check if strDBType is set to the right databasetype.
Code : 80004005
Error Description :
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
I am getting this error. The asp files are on nt server, I have modified the concerned line like this pl.
strConnString = "driver=MySQL;server=**.***.**.**.;uid=test;pwd=test;database=dbsnitz"
|
Cool Surfer
|
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 19 October 2004 : 15:20:43
|
Have you installed the MyODBC driver on the windows server?
|
======
Doug G
======
Computer history and help at www.dougscode.com |
|
|
|
Cool Surfer
Starting Member
India
32 Posts |
Posted - 19 October 2004 : 15:21:51
|
I entered server_ip=onlinemedicalforum.com , but didnt work, then filled the ipaddrerss like
~~~~~~~~~~~~~~~~~~~~~~~
strConnString = "driver=MySQL;server=66.332.66.118.;uid=dom_test;pwd=test;database=dom_dbsnitz"
Its giving the same error. sorry for double post .
|
Cool Surfer
|
|
|
|
Cool Surfer
Starting Member
India
32 Posts |
Posted - 19 October 2004 : 15:27:18
|
Have you installed the MyODBC driver on the windows server?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~``
no sir, I made a sql database on linux server. And configured config.asp on nt server. Pl tell me what should I enter in the server
details, should it be http://onlinemedicalforum.com or the ip address of onlinemedicalforum.com?? |
Cool Surfer
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
|
|
Cool Surfer
Starting Member
India
32 Posts |
Posted - 19 October 2004 : 22:57:06
|
Thank you, I will try it today evening. But dont think there is any
provision to install odbc driver on windows nt server.
I just have one dsn in my control panel. |
Cool Surfer
|
|
|
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
Posted - 20 October 2004 : 02:12:15
|
| Your host will have to install the driver, it will not be user installable if your using shared hosting no. |
Kiwihosting.Net - The Forum Hosting Specialists
|
|
|
| |
Topic |
|
Topic Locked
