Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: Database: MS SQL Server
 connecting database which is in another host
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

realnus
New Member

Turkey
77 Posts

Posted - 13 May 2004 :  04:37:06  Show Profile
Hi.I have an unlimited web space and a domain (they are related to their eaches).But I have a 10 mb web space and a domain too.The problem is that I want to use snitzforums in 10 mb web space but I want to put the database to the host which is unlimited.So I want to communicate with data which is in another host.I couldn't success on writing the needed codes.
Can anybody help me ?

Thanks for your interest...

Edited by - ruirib on 13 May 2004 18:39:12

HuwR
Forum Admin

United Kingdom
20595 Posts

Posted - 13 May 2004 :  05:04:33  Show Profile  Visit HuwR's Homepage
It is extremely unlikely that you will be able to do this, pretty much any host worth using would not allow this kind of access to your database unless ofcourse you are using SQL.
Go to Top of Page

realnus
New Member

Turkey
77 Posts

Posted - 13 May 2004 :  05:29:12  Show Profile
Thanks for your interest.So my hosts supports ACCESS, MS SQL ,MySQL connections and can I do something like I told with anykind of connection ?? If I can can u write me the codes ??
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 13 May 2004 :  09:20:04  Show Profile  Send ruirib a Yahoo! Message
No, you won't be able to do it with Access. With MS SQL and MySQL it's easier. You'd just need to specificy the IP for the server connection string and fill in the rest of the data just as you would if the DB was local.


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

Gremlin
General Help Moderator

New Zealand
7528 Posts

Posted - 13 May 2004 :  10:24:29  Show Profile  Visit Gremlin's Homepage
Providing the remote database host permits remote connections. There are many hosts who don't allow it.

Kiwihosting.Net - The Forum Hosting Specialists
Go to Top of Page

realnus
New Member

Turkey
77 Posts

Posted - 13 May 2004 :  11:16:22  Show Profile
Hi.I am an asp beginner.I am trying to learn more about asp.So I need sample codes for a while for answering peoples questions in the forums.Can anyone write me about this .I have tried but it didn't work.I used those codes...

for sql server;
strDBType = "sqlserver"
strConnString = "driver={SQL Server};server=http://www.sample.com;uid=server_id;pwd=server_password;database=/db/snitz_forums_2000.mdb" '## MS SQL Server 6.x/7.x/2000 (ODBC connection)

and the folder /db is able to be written and readen..
(didn't work)

If I did sth. wrong can u write the true one?and if ip is needed I think I will ask for it to my host server...?
Go to Top of Page

Doug G
Support Moderator

USA
6493 Posts

Posted - 13 May 2004 :  18:11:07  Show Profile
Take the http:// out of the server url for one thing.

======
Doug G
======
Computer history and help at www.dougscode.com
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 13 May 2004 :  18:38:54  Show Profile  Send ruirib a Yahoo! Message
You also need to ask your host the name of the database and use instead of /db/snitz_forums_2000.mdb, which is not a valid SQL Server DB name.


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

proeder
Junior Member

Australia
230 Posts

Posted - 13 May 2004 :  19:13:57  Show Profile  Visit proeder's Homepage
Let's say your host created a sql database for you, then he would give you the regarding login credentials, let's say:
  • Name of the database: 'test_db'
  • database user: 'test_user'
  • database_password: 'test_password'
  • name of the sql server: 'host.server.com'

Then you rConnectiuon String should like this:
strConnString =
"driver={SQL Server};server=host.server.com;uid=test_user;pwd=test_password;database=test_db"


Hope that helps

Looking for german Snitz forum? Suchst Du ein deutsches Snitz Forum?
Hier findest Du eins...

Hosting with ASP Support available: http://www.sharepointing.com
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.23 seconds. Powered By: Snitz Forums 2000 Version 3.4.07