Tac,
If you are connecting to a SQL Server 7.0. The best method is to go into
Client Network Utility and define your "alias" to the server. Here is where
you would specify the IP of the server, and give it a user friendly name.
Once you have done this go into ODBC Administrator and setup the System DSN
for the server. Using this method, I have so far not had any problems
defining datasource on servers on any remote networks (assuming your
firewall allows a TCP connection through on port 1433). I have found using
the CF Administrator not well suited for defining datasources for SQL Server
7.0. The main reason is that the new SQL 7.0 drivers have require more
settings than CF Admin provides to have it setup correctly.
Thanks,
David Sparkman
iNET Messaging
-----Original Message-----
From: Tac/Smokescreen Action Network [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 19, 2000 6:15 PM
To: inFusion Support List
Subject: Re: [iMS] using an offsite SQL-Server database via ODBC, over
TCP/IP
No, I've been spending a lot of time on the listserver administration stuff,
so I've held off on the back-end processing. I'm doing a demonstration to a
group of potential users next week, and they are much more interested in
ease of administration.
I'm using SQL Auth., but still not connecting. Question: in the ODBC
setup, when it asks for server, do you just need the IP address? I'm
assuming you need something more -- backslashes, alias name, something,
because that's not working.
Right now I have
data source name: TEST
description: <blank>
Server: 209.8.58.3
Cold Fusion Login: (username and password)
This identical configuration works if I give it the NAME of a SQL server,
rather than the IP address. I've also tried
209.8.58.3:1433
since 1433 is the port SQL-Server runs on. To no avail.
Thanks, I'm really stuck on this! I'll move this over to cf-talk if I can't
get this soon (so I won't be OT on this list)
Tac
----- Original Message -----
From: Guillermo Dewey <[EMAIL PROTECTED]>
To: inFusion Support List <[EMAIL PROTECTED]>
Sent: Friday, May 19, 2000 6:43 PM
Subject: Re: [iMS] using an offsite SQL-Server database via ODBC, over
TCP/IP
> we use iMS on a non local machine using tcp ip and had the same problem at
> the begining.. we solved using the sql auth not nt auth, just make sure
the
> user access from machine 1 is ok for machine 2. by other way did you make
> ims work storing files on the sql server instead of making files?
>
> At 06:38 p.m. 19/05/00 -0400, you wrote:
> >This is not iMS-specific, but more CF/SQL-Server (but would apply to
iMS).
> >
> >How does one connect to a SQL-Server database that's not on the local
> >network? I tried setting up my datasource to point the the IP address
where
> >the SQL-Server lives, but the connection fails.
> >
> >Is there a port it needs to specify? Is there something in SQL-Server
that
> >I need to say "Connections via TCP/IP okay"?
> >
> >Thanks!
> >
> >Tac
> >
> >
> >
> >==============================================
> > This list server is Power by iMS
> > --------------------------------
> >To leave this list please complete the form at
> >http://www.CoolFusion.com/iMS.htm
> >==============================================
> >
> >
> >========================================================================
> > This list server is Powered by iMS
> > 'The Swiss Army Knife of Mail Servers'
> > --------------------------------------
> >To leave this list please complete the form at
> >http://www.CoolFusion.com/iMS.htm
> >
> >List archives: http://www.mail-archive.com/infusion-email%40eoscape.com/
> >========================================================================
>
> ********************************************
> * Ing. Guillermo Dewey Guerra
> * Metro Cybercomercio Mexico
> * [EMAIL PROTECTED]
> * ICQ: 25876549 (GDewey)
> *
> * http://www.metro.com.mx
> * http://www.coldfusion.com.mx
> * http://www.ablecommerce.com.mx
> *
> * Tel. (011) (52) (8) 3-90-7000
> * Fax (011) (52) (8) 3-90-7001
> * Cel. (011) (52) (044) (8) 3-09-24-16
> * Monterrey N.L. Mexico
> ********************************************
>
>
> ========================================================================
> This list server is Powered by iMS
> 'The Swiss Army Knife of Mail Servers'
> --------------------------------------
> To leave this list please complete the form at
> http://www.CoolFusion.com/iMS.htm
>
> List archives: http://www.mail-archive.com/infusion-email%40eoscape.com/
> ========================================================================
>
==============================================
This list server is Power by iMS
--------------------------------
To leave this list please complete the form at
http://www.CoolFusion.com/iMS.htm
==============================================
========================================================================
This list server is Powered by iMS
'The Swiss Army Knife of Mail Servers'
--------------------------------------
To leave this list please complete the form at
http://www.CoolFusion.com/iMS.htm
List archives: http://www.mail-archive.com/infusion-email%40eoscape.com/
========================================================================
========================================================================
This list server is Powered by iMS
'The Swiss Army Knife of Mail Servers'
--------------------------------------
To leave this list please complete the form at
http://www.CoolFusion.com/iMS.htm
List archives: http://www.mail-archive.com/infusion-email%40eoscape.com/
========================================================================
