Tuesday, March 20, 2012
Cant access Northwind database
I then entered the following on my IE browser:
http://<IIServer>/nwind?sql=SELECT FirstName, LastName FROM Employees FOR XML AUTO&root=root
the result is:
"The page cannot be displayed..."
I'd appreciate any help.
Thanks,
Pathttp://<IIServer>/nwind?sql=SELECT FirstName, LastName FROM Employees FOR XML AUTO&root=root
Is that a typo, or are you trying to pass a variable to a directory? when you say /nwind?sql='foo' then you should get page cannot be displayed, right? Don't you have to say /nwind/default.asp?sql='foo' ??
or will the virtual directory/IIS understand what you mean?sql
Sunday, February 19, 2012
Cannot Set Connection String For Bulk Insert Source Connection
I came across something strange today. I was wondering I was doing something wrong.
I want to go through a directory and get files and assign the Fully Qualified File Name to a User Variable. I want to use that variable as a connection string within Expression in Bulk Insert Task Source Connection, Data Flow Task and File System Task. It is working fine within Data Flow Task and File System task. It is NOT working for Bulk Insert. Did you come across this or am I doing something wrong?
- Expressions
ConnectionString @.[User::FileName]
Did anyone come across this before?
Thanks
Sutha
Seems to be a problem to me, it does not work within the context of a for each loop, keep getting the error message, connection not valid.
I have written this script and placed it into an activex task before the bulk insert, this seems to fix it.
Dim connmgr As ConnectionManager = Dts.Connections("[your connection name]")
connmgr.ConnectionString = Dts.Variables("User::filename").Value.ToString()
connmgr.AcquireConnection(Nothing)
Hope this helps !
Mark|||
Cheers Mark. It does work fine. I put a script task inside Foreach, just before Bulk Insert to set the connections.
Still thinks its a Bug. Anyone from MS can confirm it. If so do you want me to raise a Bug for this?
Thanks for your help
Sutha
|||Hello Sutha,
I am trying to achieve the same. Can you help me.
Foreach loop container is reading all the files in the specified folder.
I can also read the variable. But I am having difficulties in assiging this variable file name to Bulk Insert, connection, Source connection.
thanks & regards
radha.
|||I could not reproduce this issue.1. I could set the value of the "SourceConnection" property to the name of the connection I want to use in my bulk insert task and it works.
2. I can also assign the value of the "ConnectionString" property of the connection to a variable that points to the file and it works.
|||
I am having same issue:
Simple package: Foreach Loop, inside ForEach Loop is a Bulk Insert Task.
I set the variable User::FileName in the variable Mappings of the Foreach Loop. I create a FlatFile connection in connection manager and go into the Expressions of the flat file connection and set the ConnectionString to be @.[User::FileName]. I set the connection in the Bulk Insert to be the Flat file connection I created and I run the package... I get the error: "The specified connection "XYZ Files" is either not valid, or points to an invalid object. To continue, specify a valid connection." Its very reproduceable.
Been fighting with this all day... can someone post step-by-step how to do the workaround where the script sets the connection?
|||Dim connmgr As ConnectionManager = Dts.Connections("Name of Flat File Conn Manager")connmgr.ConnectionString = Dts.Variables("Var Name of Full path and filename").Value.ToString()
connmgr.AcquireConnection(Nothing)|||See this link for a Dec 27 Blog. http://denster.spaces.live.com/
Cannot Set Connection String For Bulk Insert Source Connection
I came across something strange today. I was wondering I was doing something wrong.
I want to go through a directory and get files and assign the Fully Qualified File Name to a User Variable. I want to use that variable as a connection string within Expression in Bulk Insert Task Source Connection, Data Flow Task and File System Task. It is working fine within Data Flow Task and File System task. It is NOT working for Bulk Insert. Did you come across this or am I doing something wrong?
- Expressions
ConnectionString @.[User::FileName]
Did anyone come across this before?
Thanks
Sutha
Seems to be a problem to me, it does not work within the context of a for each loop, keep getting the error message, connection not valid.
I have written this script and placed it into an activex task before the bulk insert, this seems to fix it.
Dim connmgr As ConnectionManager = Dts.Connections("[your connection name]")
connmgr.ConnectionString = Dts.Variables("User::filename").Value.ToString()
connmgr.AcquireConnection(Nothing)
Hope this helps !
Mark|||
Cheers Mark. It does work fine. I put a script task inside Foreach, just before Bulk Insert to set the connections.
Still thinks its a Bug. Anyone from MS can confirm it. If so do you want me to raise a Bug for this?
Thanks for your help
Sutha
|||Hello Sutha,
I am trying to achieve the same. Can you help me.
Foreach loop container is reading all the files in the specified folder.
I can also read the variable. But I am having difficulties in assiging this variable file name to Bulk Insert, connection, Source connection.
thanks & regards
radha.
|||I could not reproduce this issue.1. I could set the value of the "SourceConnection" property to the name of the connection I want to use in my bulk insert task and it works.
2. I can also assign the value of the "ConnectionString" property of the connection to a variable that points to the file and it works.
|||
I am having same issue:
Simple package: Foreach Loop, inside ForEach Loop is a Bulk Insert Task.
I set the variable User::FileName in the variable Mappings of the Foreach Loop. I create a FlatFile connection in connection manager and go into the Expressions of the flat file connection and set the ConnectionString to be @.[User::FileName]. I set the connection in the Bulk Insert to be the Flat file connection I created and I run the package... I get the error: "The specified connection "XYZ Files" is either not valid, or points to an invalid object. To continue, specify a valid connection." Its very reproduceable.
Been fighting with this all day... can someone post step-by-step how to do the workaround where the script sets the connection?
|||Dim connmgr As ConnectionManager = Dts.Connections("Name of Flat File Conn Manager")connmgr.ConnectionString = Dts.Variables("Var Name of Full path and filename").Value.ToString()
connmgr.AcquireConnection(Nothing)|||See this link for a Dec 27 Blog. http://denster.spaces.live.com/
Cannot Set Connection String For Bulk Insert Source Connection
I came across something strange today. I was wondering I was doing something wrong.
I want to go through a directory and get files and assign the Fully Qualified File Name to a User Variable. I want to use that variable as a connection string within Expression in Bulk Insert Task Source Connection, Data Flow Task and File System Task. It is working fine within Data Flow Task and File System task. It is NOT working for Bulk Insert. Did you come across this or am I doing something wrong?
- Expressions
ConnectionString @.[User::FileName]
Did anyone come across this before?
Thanks
Sutha
Seems to be a problem to me, it does not work within the context of a for each loop, keep getting the error message, connection not valid.
I have written this script and placed it into an activex task before the bulk insert, this seems to fix it.
Dim connmgr As ConnectionManager = Dts.Connections("[your connection name]")
connmgr.ConnectionString = Dts.Variables("User::filename").Value.ToString()
connmgr.AcquireConnection(Nothing)
Hope this helps !
Mark|||
Cheers Mark. It does work fine. I put a script task inside Foreach, just before Bulk Insert to set the connections.
Still thinks its a Bug. Anyone from MS can confirm it. If so do you want me to raise a Bug for this?
Thanks for your help
Sutha
|||Hello Sutha,
I am trying to achieve the same. Can you help me.
Foreach loop container is reading all the files in the specified folder.
I can also read the variable. But I am having difficulties in assiging this variable file name to Bulk Insert, connection, Source connection.
thanks & regards
radha.
|||I could not reproducethis issue.
1. I could set the value of the "SourceConnection" property to
the name of the connection I want to use in my bulk insert task and it
works.
2. I can also assign the value of the "ConnectionString" property of the connection to a variable that points to the file and it works.
|||
I am having same issue:
Simple package: Foreach Loop, inside ForEach Loop is a Bulk Insert Task.
I set the variable User::FileName in the variable Mappings of the Foreach Loop. I create a FlatFile connection in connection manager and go into the Expressions of the flat file connection and set the ConnectionString to be @.[User::FileName]. I set the connection in the Bulk Insert to be the Flat file connection I created and I run the package... I get the error: "The specified connection "XYZ Files" is either not valid, or points to an invalid object. To continue, specify a valid connection." Its very reproduceable.
Been fighting with this all day... can someone post step-by-step how to do the workaround where the script sets the connection?
|||Dim connmgr As ConnectionManager = Dts.Connections("Name of Flat File Conn Manager")connmgr.ConnectionString = Dts.Variables("Var Name of Full path and filename").Value.ToString()
connmgr.AcquireConnection(Nothing)|||See this link for a Dec 27 Blog. http://denster.spaces.live.com/
Cannot Set Connection String For Bulk Insert Source Connection
I came across something strange today. I was wondering I was doing something wrong.
I want to go through a directory and get files and assign the Fully Qualified File Name to a User Variable. I want to use that variable as a connection string within Expression in Bulk Insert Task Source Connection, Data Flow Task and File System Task. It is working fine within Data Flow Task and File System task. It is NOT working for Bulk Insert. Did you come across this or am I doing something wrong?
- Expressions
ConnectionString @.[User::FileName]
Did anyone come across this before?
Thanks
Sutha
Seems to be a problem to me, it does not work within the context of a for each loop, keep getting the error message, connection not valid.
I have written this script and placed it into an activex task before the bulk insert, this seems to fix it.
Dim connmgr As ConnectionManager = Dts.Connections("[your connection name]")
connmgr.ConnectionString = Dts.Variables("User::filename").Value.ToString()
connmgr.AcquireConnection(Nothing)
Hope this helps !
Mark|||
Cheers Mark. It does work fine. I put a script task inside Foreach, just before Bulk Insert to set the connections.
Still thinks its a Bug. Anyone from MS can confirm it. If so do you want me to raise a Bug for this?
Thanks for your help
Sutha
|||Hello Sutha,
I am trying to achieve the same. Can you help me.
Foreach loop container is reading all the files in the specified folder.
I can also read the variable. But I am having difficulties in assiging this variable file name to Bulk Insert, connection, Source connection.
thanks & regards
radha.
|||I could not reproducethis issue.
1. I could set the value of the "SourceConnection" property to
the name of the connection I want to use in my bulk insert task and it
works.
2. I can also assign the value of the "ConnectionString" property of the connection to a variable that points to the file and it works.
|||
I am having same issue:
Simple package: Foreach Loop, inside ForEach Loop is a Bulk Insert Task.
I set the variable User::FileName in the variable Mappings of the Foreach Loop. I create a FlatFile connection in connection manager and go into the Expressions of the flat file connection and set the ConnectionString to be @.[User::FileName]. I set the connection in the Bulk Insert to be the Flat file connection I created and I run the package... I get the error: "The specified connection "XYZ Files" is either not valid, or points to an invalid object. To continue, specify a valid connection." Its very reproduceable.
Been fighting with this all day... can someone post step-by-step how to do the workaround where the script sets the connection?
|||Dim connmgr As ConnectionManager = Dts.Connections("Name of Flat File Conn Manager")connmgr.ConnectionString = Dts.Variables("Var Name of Full path and filename").Value.ToString()
connmgr.AcquireConnection(Nothing)|||See this link for a Dec 27 Blog. http://denster.spaces.live.com/
Cannot Set Connection String For Bulk Insert Source Connection
I came across something strange today. I was wondering I was doing something wrong.
I want to go through a directory and get files and assign the Fully Qualified File Name to a User Variable. I want to use that variable as a connection string within Expression in Bulk Insert Task Source Connection, Data Flow Task and File System Task. It is working fine within Data Flow Task and File System task. It is NOT working for Bulk Insert. Did you come across this or am I doing something wrong?
- Expressions
ConnectionString @.[User::FileName]
Did anyone come across this before?
Thanks
Sutha
Seems to be a problem to me, it does not work within the context of a for each loop, keep getting the error message, connection not valid.
I have written this script and placed it into an activex task before the bulk insert, this seems to fix it.
Dim connmgr As ConnectionManager = Dts.Connections("[your connection name]")
connmgr.ConnectionString = Dts.Variables("User::filename").Value.ToString()
connmgr.AcquireConnection(Nothing)
Hope this helps !
Mark|||
Cheers Mark. It does work fine. I put a script task inside Foreach, just before Bulk Insert to set the connections.
Still thinks its a Bug. Anyone from MS can confirm it. If so do you want me to raise a Bug for this?
Thanks for your help
Sutha
|||Hello Sutha,
I am trying to achieve the same. Can you help me.
Foreach loop container is reading all the files in the specified folder.
I can also read the variable. But I am having difficulties in assiging this variable file name to Bulk Insert, connection, Source connection.
thanks & regards
radha.
|||I could not reproduce this issue.1. I could set the value of the "SourceConnection" property to the name of the connection I want to use in my bulk insert task and it works.
2. I can also assign the value of the "ConnectionString" property of the connection to a variable that points to the file and it works.
|||
I am having same issue:
Simple package: Foreach Loop, inside ForEach Loop is a Bulk Insert Task.
I set the variable User::FileName in the variable Mappings of the Foreach Loop. I create a FlatFile connection in connection manager and go into the Expressions of the flat file connection and set the ConnectionString to be @.[User::FileName]. I set the connection in the Bulk Insert to be the Flat file connection I created and I run the package... I get the error: "The specified connection "XYZ Files" is either not valid, or points to an invalid object. To continue, specify a valid connection." Its very reproduceable.
Been fighting with this all day... can someone post step-by-step how to do the workaround where the script sets the connection?
|||Dim connmgr As ConnectionManager = Dts.Connections("Name of Flat File Conn Manager")connmgr.ConnectionString = Dts.Variables("Var Name of Full path and filename").Value.ToString()
connmgr.AcquireConnection(Nothing)|||See this link for a Dec 27 Blog. http://denster.spaces.live.com/
Tuesday, February 14, 2012
Cannot See a Newly Installed SQL Server 2000 (No Active Directory)
has Windows-2003 Server on it. Now, we cannot get access to that
database server from other computers. Seem like this may be an issue
with Active Directory.
Our network consists of Windows-2000 Servers (SP 4) and Windows-2000
workstations and Windows-XP workstations. We also have SQL Server 2000
(SP2) in three Windows-2000 servers. All work fine. Recently, we get a
new server that has already had Windows-2003 Server pre-installed.
After we have installed SQL Server 2000 (SP 3A) on the new server, we
find that we cannot get access to that new database server from other
computers.
I have tried connecting to that new database server using Query
Analyzer (using both the sa account and Windows Authentication), and I
get this error message:
Unable to connect to server NEWDBSRV:
Server: Msg 17, Level 16, State 1
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not
exist or access denied.
I have tried connecting to that new database server using ISQL (using
both the sa account and Windows Authentication), and I get this error
message:
DB-Library: Unable to connect: SQL Server is unavailable or does not
exist.
Unable to connect: SQL Server does not exist or network access
denied.
Net-Library error 53: ConnectionOpen (Connect()).
I have also tried to register the new database server using Enterprise
Manager (again, using both the sa account and Windows Authentication),
and I get this error message:
NEWDBSRV - SQL Server does not exist or access denied.
ConnectionOpen(Connect())
The only way that I can get access to the new database server is to
open Enterprise Manager directly on the new server.
I have compared the properties of the new database server and those of
the other existing database servers. The only differences are:
-Other database servers are running Windows-2000. The new database
server is running Windows-2003.
-The new database server is missing the "Active Directory" page-tag
when I check its properties using Enterprise Manager. We use Active
Directory in our network, and the Active Directory is being run from a
Windows-2000 server (that is currently also a database server).
According to our network administrator, he has already put the new
server into our Active Directory. He doesn't know why it is missing
the Active Directory page-tag. He believes this has something to do
with its having Windows-2003 that is different from other servers
(that have Windows-2000).
Thanks in advance for any info.
Jay Chanif you can connect with Query analizer on the server but not on a client
then tcp/ip is not activated. Look for SVRNETCN.exe (normaly in
C:\Programs\Microsoft SQL Server\80\Tools\Binn) and check if
tcp/ip is activated. Since version sp3A tcp/ip is disabled per default,
if you do the installation without DISABLENETWORKPROTOCOLS=0
Read more about it in "3.7.3 MSDE 2000 Setup Parameters" on
http://support.microsoft.com/defaul...0/SP3ReadMe.asp
hth,
Helmut|||Thanks for the suggestion.
Our network administrator has fixed this problem. The IP address in
the DNS server didn't match the one that was actually assigned to the
new server. The story was that he let the installation program to pick
a IP address that ended up saved in the DNS server. Later on when he
assigned the actual IP address to the new server, he didn't realize
that the DNS server still had the outdated IP address. I am not
exactly sure whether I get the story right; but this sounds like the
one our network administrator told me.
Jay Chan