>
>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.
is the sql server on the local area network?
have you try setting the db from the cf admin ? if you are in the local
area network just put the machine name on the server input user and pass.
First time I had the same problem it worked using the cf admin page.. not
sure what was the difference
>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/
>========================================================================
********************************************
* 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/
========================================================================
