[THIN] Re: MDAC ? And sql
- From: "Jim Hathaway" <JimH@xxxxxxxxxxxxxxx>
- To: <thin@xxxxxxxxxxxxx>
- Date: Wed, 15 Jan 2003 15:39:09 -0800
Have you made sure that you are connecting to the SQL resource via
TCP/IP, not named pipes (the default)?
To check / change this do the following . . .=20
You can check this by opening the file C:\Program
Files\Citrix\Independant Management Architecture\MF20.DSN The file
should have the following lines:
Address=3DYOURSERVERNAME,1433
Network=3DDBMSSOCN
If not include the above two lines in your MF20.DSN file then run the
following command:
dsmaint config /user:SQLusername /pwd:password
/dsn:C:\PROGRA~1\Citrix\INDEPE~1\MF20.DSN
This should successfully connect to the DS via TCPIP. Stop and restart
the IMA service. You should check you are now connecting to the DS via
TCPIP by the netstat -a command. This should show:
on Win2K: TCP yourwtsname:2162 yoursqlservername:ms-sql-s ESTABLISHED
on TSE: TCP yourwtsname:2162 yoursqlservername:1433 ESTABLISHED
J
-----Original Message-----
From: Rowlandson, John [mailto:John.Rowlandson@xxxxxxxxxxxxx]=20
Sent: Wednesday, January 15, 2003 3:36 PM
To: thin@xxxxxxxxxxxxx
Subject: [THIN] Re: MDAC ? And sql=20
Speaking of MDAC
Has anone got their sql datastore on a clustered named sql instance?
Ie my Db is \\sql02\sql02\ (server) MF_MSJ (db)
I've migrated the data from access into the sql DB fine and done a
compare but the ima wont start from it, tried recreating the LHC
sucessfully and it doesn't resolve it, the iMA refuses to start..
I'm going to try on a std sql server today to try and rule out the
double instance naming.ie \\sql01
This is only my dev/test farm but I want to get it 100% perfect before
migrating the production farm
John
-----Original Message-----
From: Ron Oglesby [mailto:roglesby@xxxxxxxxxxxx]=3D20
Sent: Thursday, January 16, 2003 9:30 AM
To: thin@xxxxxxxxxxxxx
Subject: [THIN] Re: MDAC ?
See ya on the train mark (I'm using 2.7 now and it works fine for me)
Ron Oglesby
Senior Technical Architect
=3D3D20
RapidApp
Office 312.372.7188
Mobile 312.961.2380
email roglesby@xxxxxxxxxxxx
=3D3D20
-----Original Message-----
From: Mark Guzzo [mailto:marguz@xxxxxxxxxxxxx]=3D3D20
Sent: Wednesday, January 15, 2003 4:22 PM
To: thin@xxxxxxxxxxxxx
Subject: [THIN] Re: MDAC ?
=3D3D20
Thanks :-)
Hey Ron... looks like I'll see you Monday
Ron Oglesby wrote:
MDAC (for this purpose) is in the Citrix servers. You can check out MS's
sitethey have an MDAC version checker you can download. Ron Oglesby
Senior Technical Architect =3D3D3D20 RapidApp Office 312.372.7188 Mobile =
=3D
=3D3D
312.961.2380 email roglesby@xxxxxxxxxxxx[1] =3D3D3D20 -----Original
Message----- From: =3D3D Mark Guzzo =3D
[mailto:marguz@xxxxxxxxxxxxx[2]]=3D3D3D20
Sent: Wednesday, January 15, 2003 4:02 PM To: thin@xxxxxxxxxxxxx[3]
Subject: [THIN] MDAC ? Reading some past posts, I noticed one on IMA
service locking up. I=3D3D3D20 would love to =3D3D check out what =
version of
MDAC I have installed, but I=3D3D3D20 can't seem to find it anywhere (on =
=3D
my
Citrix XP server). I did find=3D3D3D20 mdac.inf and mdac.pnf but was =3D
unable
to get the version from them. Also, do I install it on the CitrixXP
servers or/and the Win2K SQL data=3D3D3D20 store server? All =3D3D =
servers =3D
in
question are at SP2 (does SP3 come with the new version?). --=3D3D3D20 =
=3D
Mark
Guzzo Sair LCA, LCP Citrix Administrator "Don't Fear The Penguin."
***********************************************=3D3D3D20 This Weeks =3D
Sponsor:
WM Software WMS Messenger for TSE Affordable Instant Messaging for
Terminal Servers http://www.wmsoftware.com/wmsm/[4]
************************************************ For Archives, to
Unsubscribe, Subscribe or=3D3D3D20 set Digest or Vacation mode use the =
=3D
below
link. http://thethin.net/citrixlist.cfm[5]
*********************************************** This Weeks Sponsor: WM
Software WMS Messenger for TSE Affordable Instant Messaging for Terminal
Servers http://www.wmsoftware.com/wmsm/[6]
************************************************ For Archives, to
Unsubscribe, Subscribe or set Digest or Vacation mode use the below
link. http://thethin.net/citrixlist.cfm[7]=3D3D20
-- Mark Guzzo Sair LCA, LCP Citrix Administrator "Don't Fear The
Penguin."=3D3D20
--- Links ---
1 mailto:roglesby@xxxxxxxxxxxx
2 mailto:marguz@xxxxxxxxxxxxx
3 mailto:thin@xxxxxxxxxxxxx
4 http://www.wmsoftware.com/wmsm/
5 http://thethin.net/citrixlist.cfm
6 http://www.wmsoftware.com/wmsm/
7 http://thethin.net/citrixlist.cfm
***********************************************=3D3D20
This Weeks Sponsor: WM Software
WMS Messenger for TSE
Affordable Instant Messaging for Terminal Servers
http://www.wmsoftware.com/wmsm/
************************************************
For Archives, to Unsubscribe, Subscribe or=3D3D20
set Digest or Vacation mode use the below link.
http://thethin.net/citrixlist.cfm
***********************************************=3D20
This Weeks Sponsor: WM Software
WMS Messenger for TSE
Affordable Instant Messaging for Terminal Servers
http://www.wmsoftware.com/wmsm/
************************************************
For Archives, to Unsubscribe, Subscribe or=3D20
set Digest or Vacation mode use the below link.
http://thethin.net/citrixlist.cfm
***********************************************=20
This Weeks Sponsor: WM Software
WMS Messenger for TSE
Affordable Instant Messaging for Terminal Servers
http://www.wmsoftware.com/wmsm/
************************************************
For Archives, to Unsubscribe, Subscribe or=20
set Digest or Vacation mode use the below link.
http://thethin.net/citrixlist.cfm
***********************************************
This Weeks Sponsor: WM Software
WMS Messenger for TSE
Affordable Instant Messaging for Terminal Servers
http://www.wmsoftware.com/wmsm/
************************************************
For Archives, to Unsubscribe, Subscribe or
set Digest or Vacation mode use the below link.
http://thethin.net/citrixlist.cfm
Other related posts:
