I want to fetch data from Oracle 8i,
so how do I connect with SQL Server 2005?
I want to use the connection in SQL IS, RS & AS and also perhaps using a
Linked Server.
And what do I need to install on my server?
Any good/bad experience out there?
Please help!
Search for
SQL Server 2005 64-bit - Fetch data from Oracle
in microsoft.public.sqlserver.dts
"Olof" wrote:
> I want to fetch data from Oracle 8i,
> so how do I connect with SQL Server 2005?
> I want to use the connection in SQL IS, RS & AS and also perhaps using a
> Linked Server.
> And what do I need to install on my server?
> Any good/bad experience out there?
> Please help!
Showing posts with label product. Show all posts
Showing posts with label product. Show all posts
Sunday, 25 March 2012
Connect to Oracle8i Enterprise Edition Release 8.1.7.4.0 - Product
I want to fetch data from Oracle 8i,
so how do I connect with SQL Server 2005?
I want to use the connection in SQL IS, RS & AS and also perhaps using a
Linked Server.
And what do I need to install on my server?
Any good/bad experience out there'
Please help!Search for
SQL Server 2005 64-bit - Fetch data from Oracle
in microsoft.public.sqlserver.dts
"Olof" wrote:
> I want to fetch data from Oracle 8i,
> so how do I connect with SQL Server 2005?
> I want to use the connection in SQL IS, RS & AS and also perhaps using a
> Linked Server.
> And what do I need to install on my server?
> Any good/bad experience out there'
> Please help!
so how do I connect with SQL Server 2005?
I want to use the connection in SQL IS, RS & AS and also perhaps using a
Linked Server.
And what do I need to install on my server?
Any good/bad experience out there'
Please help!Search for
SQL Server 2005 64-bit - Fetch data from Oracle
in microsoft.public.sqlserver.dts
"Olof" wrote:
> I want to fetch data from Oracle 8i,
> so how do I connect with SQL Server 2005?
> I want to use the connection in SQL IS, RS & AS and also perhaps using a
> Linked Server.
> And what do I need to install on my server?
> Any good/bad experience out there'
> Please help!
Thursday, 8 March 2012
Connect 2 DropDownList and Received "Input string was not in a correct format"
I have 2 DropDownList, the first one to display the product category and the other one to display the products based on the selected category. However, when I run code I received the following error message:Input string was not in a correct format.
Please find the code below.
Thanks,
Andy.
<%@.PageLanguage="C#"AutoEventWireup="true"CodeFile="Default.aspx.cs"Inherits="_Default" %>
<!DOCTYPEhtmlPUBLIC"-//W3C//DTD XHTML 1.0 Transitional//EN""http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><htmlxmlns="http://www.w3.org/1999/xhtml">
<headrunat="server">
<title>Untitled Page</title></head>
<body>
<formid="form1"runat="server">
<div>
<asp:DropDownListID="DropDownList1"runat="server"DataSourceID="SqlDataSource1"
DataTextField="Name"DataValueField="Name">
</asp:DropDownList>
<asp:SqlDataSourceID="SqlDataSource1"runat="server"ConnectionString="<%$ ConnectionStrings:Assignment2ConnectionString %>"
SelectCommand="SELECT [Name] FROM [Category]"></asp:SqlDataSource>
<br/>
<asp:DropDownListID="DropDownList2"runat="server"DataSourceID="SqlDataSource2"
DataTextField="Name"DataValueField="Name">
</asp:DropDownList>
<asp:SqlDataSourceID="SqlDataSource2"runat="server"ConnectionString="<%$ ConnectionStrings:Assignment2ConnectionString %>"
SelectCommand="SELECT [Name] FROM [Product] WHERE ([CategoryID] = @.CategoryID2)">
<SelectParameters>
<asp:ControlParameterControlID="DropDownList1"Name="CategoryID2"PropertyName="SelectedValue"
Type="Int32"/>
</SelectParameters>
</asp:SqlDataSource>
</div>
</form></body>
</html>
Assume you have a categoryID field in your Category table: You add CategoryID to the SELECT statement and changeDataValueField="CategoryID" .
<asp:DropDownListID="DropDownList1"runat="server"DataSourceID="SqlDataSource1"
DataTextField="Name"DataValueField="CategoryID">
</asp:DropDownList>
<asp:SqlDataSourceID="SqlDataSource1"runat="server"ConnectionString="<%$ ConnectionStrings:Assignment2ConnectionString %>"
SelectCommand="SELECT [Name],[CategoryID] FROM [Category]"></asp:SqlDataSource>
<br/>
Connect .mdf file to MSDE 2000
I'm using a product (SAP Business one) using MSDE 2000A. Another product I
receintly bought also uses SQL. According to this products manual I need to
connect the *.mdf database to my SQL server using SQL Enterprise Manager. How
does it work?
hi,
GV wrote:
> I'm using a product (SAP Business one) using MSDE 2000A. Another
> product I receintly bought also uses SQL. According to this products
> manual I need to connect the *.mdf database to my SQL server using
> SQL Enterprise Manager. How does it work?
you are required to "attach" the provided database to an existing SQL
Server/MSDE instance...
as MSDE does not provide Entrprise Manager, you have to resort on the
command line tool, oSql.exe, to execute the corresponding Transact-SQL
statement to attach the database using the system stored procedure
sp_attach_db...
you can find the full synopsis of the introduced stored procedure at
http://msdn.microsoft.com/library/de...ae-az_52oy.asp
at http://support.microsoft.com/default...;EN-US;q325003 you will
find some information on how to use oSql.exe to perform this task as long as
other related management tasks..
for your convenience, you can have a look at a free prj of mine, available
at the link following my sign., which provides a graphical user interface
similar to Enterprise Manager in order to accomplish management tasks,
including the one here discussed..
futher tools for MSDE, both commercial and free, are listed
http://www.microsoft.com/sql/msde/partners/default.asp and/or
http://www.aspfaq.com/show.asp?id=2442
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
receintly bought also uses SQL. According to this products manual I need to
connect the *.mdf database to my SQL server using SQL Enterprise Manager. How
does it work?
hi,
GV wrote:
> I'm using a product (SAP Business one) using MSDE 2000A. Another
> product I receintly bought also uses SQL. According to this products
> manual I need to connect the *.mdf database to my SQL server using
> SQL Enterprise Manager. How does it work?
you are required to "attach" the provided database to an existing SQL
Server/MSDE instance...
as MSDE does not provide Entrprise Manager, you have to resort on the
command line tool, oSql.exe, to execute the corresponding Transact-SQL
statement to attach the database using the system stored procedure
sp_attach_db...
you can find the full synopsis of the introduced stored procedure at
http://msdn.microsoft.com/library/de...ae-az_52oy.asp
at http://support.microsoft.com/default...;EN-US;q325003 you will
find some information on how to use oSql.exe to perform this task as long as
other related management tasks..
for your convenience, you can have a look at a free prj of mine, available
at the link following my sign., which provides a graphical user interface
similar to Enterprise Manager in order to accomplish management tasks,
including the one here discussed..
futher tools for MSDE, both commercial and free, are listed
http://www.microsoft.com/sql/msde/partners/default.asp and/or
http://www.aspfaq.com/show.asp?id=2442
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
Subscribe to:
Posts (Atom)