database from a remote computer with ODBC. I can connect just fine from
within the workgroup.
In Cliconfg, I have set up an alias pointing to servername.com\INSTANCENAME.
tcp/ip is set. There is not a firewall in play at this time. The server is
also configured to use TCP/IP.
Is it possible to connect to a remote SQL server with ODBC? This is really
frustrating.
I did the same drill with mysql and it is a piece of cake, but I really need
to use SQL server in this instance.
BradI just figured out my problem.
I reviewed the server logs and found that the server was listening on port
1212. So, with cliconfg I set up an alias to use this same port.
Man, what a relief to finally get this figured out.
Brad
"Brad Dennis" <Brad@.f1csp.com> wrote in message
news:eGiujTq5DHA.2732@.TK2MSFTNGP09.phx.gbl...
quote:
> I have been trying on an off for a month to connect to an MSDE (SQL
server)
quote:
> database from a remote computer with ODBC. I can connect just fine from
> within the workgroup.
> In Cliconfg, I have set up an alias pointing to
servername.com\INSTANCENAME.
quote:
> tcp/ip is set. There is not a firewall in play at this time. The server
is
quote:
> also configured to use TCP/IP.
> Is it possible to connect to a remote SQL server with ODBC? This is
really
quote:
> frustrating.
> I did the same drill with mysql and it is a piece of cake, but I really
need
quote:
> to use SQL server in this instance.
> Brad
>
No comments:
Post a Comment