ODBC SQL Server Database Reconnect Questions
Aug 22, 2005
I have an ODBC 3.0 Application on Windows NT Server maintaining a
connection to a SQL Server 2000 database on the same machine. When an
error occurs, I'd like to be able to determine whether the error is
serious enough that the database connection has been lost, so I can
have the application try to reconnect automatically. My understanding
is that any error of severity 20 or above includes a broken connection,
but I'm having difficulty retrieving the error severity through ODBC.
So my first question is, how do I retrieve the error severity through
ODBC?
Also, as a test, I stopped the database while my application is still
running, and the first error I received had a native error code of 55.
There is no 55 error in the sysmessages table, so I'm confused as to
what the severity of the error is. Can anyone shed some light on why I
would be receiving an error code that is not in the sysmessages table,
and where I might be able to find more information about the error?
Thanks in advance,
Abram
View 2 Replies
ADVERTISEMENT
Apr 23, 2002
Hi,
I'm using Oracle 8.1.7 as linked server on SQL Server 2000. Everything works fine. But if is Oracle server is down while executing an query to linked server an errormessage is returned (correct).
When Oracle after that is available and I try to execute the query again the same errormessage is returned again. The only way is to restart the SQL Server.
Is there a better way to reconnect to linked server ???
Thanks.
View 1 Replies
View Related
Jan 26, 2007
I have an old application to maintain that uses CDatabase to connect to SQL Server. If SQL Server is stopped and restarted, such as in a cluster failover (i.e. move group), then the CDatabase connection needs to reconnect. It seems that it's not capable of doing this on it's own so I need to check the state some how. Various methods, such as IsOpen, seem to be useless as far as determining if I have a "good" connection.
Any thoughts?
View 3 Replies
View Related
Feb 13, 2007
I apologize if this is not the correct forum for this posting. Looking at the descriptions, it appeared to be the best choice.
I am running Windows XP Pro SP2. I have installed the SQL Native Client for
XP. However, when I try to add a new data source through ODBC Connection
Manager, SQL Native Client is not listed as an option. I have followed this procedure on three other systems with no problems. What would be causing the
SQL Native Client to not show up in the list of available ODBC data sources?
View 4 Replies
View Related
Jan 25, 2007
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;margin-bottom:.0001pt;font-size:11.0pt;font-family:'Calibri","sans-serif';}
p.MsoPlainText, li.MsoPlainText, div.MsoPlainText
{margin:0in;margin-bottom:.0001pt;font-size:9.0pt;font-family:Consolas;}
span.PlainTextChar
{font-family:Consolas;}
.MsoChpDefault
{;}
@page Section1
{size:8.5in 11.0in;margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
{page:Section1;}
I have several questions about the behavior of 32- and
64-bit ODBC
drivers in Windows.
1. If I have a 64-bit application, can it make use of
32-bit ODBC
connectors?
2. If I have a 32-bit ODBC connector, can it connect to a
64-bit
database application (for instance, a 32-bit SQL Server
ODBC driver
that talks to the 64-bit version of SQL Server)?
3. If I have a 32-bit system that has the 32-bit SQL
Server ODBC driver
installed, can I use that to connect to a remote 64-bit
SQL Server via
named pipes or TCP/IP?
4. Would a scenario like #3 be possible locally? Example: I have a
32-bit SQL Server ODBC driver that talks to a locally
installed
instance of 64-bit SQL Server via TCP/IP or named pipes.
I've scoured a bit for details about the interactions
between 32- and
64-bit databases and data components and the details
still seem very
sketchy, so any help is appreciated.
View 1 Replies
View Related
Feb 27, 2002
We recently upgraded a SQL 7.0 SP2 database to SQL 2000 SP2. The web server that connects to both databases (we have 2 up that we can switch back and forth) is Win2K with the SQL Server ODBC driver of 2000.80.194.00 (I'm thinking this came w/ W2K) But I think I installed the 7.0 client connectivity on the web server.
I have a few questions:
1. Any reason why this would happen with the SQL upgrade?
2. What is the ideal situation for client/server ODBC drivers / MDAC client.. If I have a SQL 2000 SP2 server do I install SQL 2000 client on the web server and also the service pack on the web server?
Thanks and please ask if you need more info..
-Kelly
View 1 Replies
View Related
Feb 11, 2008
Hi,
Our environment is:
Windows Server 2003, Service Pack 2
SQL Server Express 2005
SQLServer JDBC driver 1.2
Sun JDK 1.6 (we tried this on JDK 1.5 as well)
There is no virus protection software on the host, and no firewall is enabled.
Our problem is that the JDBC connection running on the localhost periodically gets disconnected, and then we can't reconnect to the database at all, unless we physically power cycle the server. The error message we receive is: "Software caused connect on abort: recv failed"
This is a very strange situation, and to illustrate, I created the following command-line program:
public class DBTest {
public static void main(String[] arg) throws Exception {
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
Connection conn =
DriverManager.getConnection("jdbcqlserver://127.0.0.1:1433;databaseName=datamart",
"username", "password");
System.out.println("Connected");
conn.close();
}
}
Essentially, this program verifies that a database connection can be made to the SQL Server instance on the local host.
Executing this from the command line works the vast majority of the time.
However, once the Web application running on the same host encounters the JDBC disconnection issue, executing this program from the command line results in the following exception:
C:Documents and Settingsfrank>java -cp sqljdbc.jar;. DBTest
Exception in thread "main" com.microsoft.sqlserver.jdbc.SQLServerException: Software caused connect on abort: recv failed
at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(Unknown Source)
at com.microsoft.sqlserver.jdbc.TDSChannel.read(Unknown Source)
at com.microsoft.sqlserver.jdbc.TDSReader.readPacket(Unknown Source)
at com.microsoft.sqlserver.jdbc.TDSReader.readPacket(Unknown Source)
at com.microsoft.sqlserver.jdbc.TDSCommand.startResponse(Unknown Source)
at com.microsoft.sqlserver.jdbc.TDSCommand.startResponse(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.sendLogon(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.access$000(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(Unknown Source)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.loginWithoutFailover(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at DBTest.main(DBTest.java:7)
There is no way to obtain further access to the database, except by power-cycling the machine. Shutting down and then re-starting the SQL Server instance does not help, nor does restarting any individual process on the server.
Something permanently disables connection to the database server, and only a hard reset of the OS solves that problem.
Any suggestions would be most appreciated, as this is a serious, mission-criticial problem for us right now.
Thanks,
-- Frank
View 6 Replies
View Related
Apr 18, 2008
Hi,
I'm testing performance of OPENROWSET,
I executed OPENROWSET 3 times in a sequence. But in Profiler i see only following events..
Audit Login
Batch Started
Batch Completed
RPC:Completed.
RPC:Completed.
:
:
:
:
RPC:Completed.
I'm intersted only to see if the login happens three time, but i'm not able to see that. Also, there was no Audit Logout.
Does SQL Server automatically pool connections ?
If i run Openrowset 3 times, shouldn't it open & close connection 3 times ?
Please clarify.
Thanks.
Sandeep.
View 3 Replies
View Related
Feb 29, 2008
I need detailed instructions on how to connect to a database from a Microsoft Access 2007 database to a Microsft Office Accounting 2007 database. The accounting database is an SQL 2005 datbase. It has an instance name of "MSSMLBIZ".
When I try I get an SQL error 53. Do not have permissions or database does not exist.
Thanks in advance for any help.,
View 1 Replies
View Related
Nov 23, 2006
I have a SQL Server 2005 database (called BDHSE) in a PC which i call PC1. I have a second PC (PC2) and both are within a network (a WLAN).
What i want is to have access to BDHSE from an application in VB6 (APP1) running in PC2. All the INSERT, DELETE, UPDATE records process is done through APP1.
APP1 ia currently running in PC1 and is to be installed on PC2.
I have these questions:
1. What do i need to install in PC2 since all the INSERT, DELETE, and UPDATE is done using APP1? I guess i only have to install the Microsoft SQL Native Client (with all the prerequisites of course) but i am not sure.
2. In the APP1 made in VB6, do i have to change the connectionstring since i am accesing the database which physically is at PC1 and the APP1 will be used in PC2?
3. Any advice you can give me on doing this will be well received.
Thanks in advance,
BSc Fernando Martinez
View 4 Replies
View Related
Jan 21, 2007
I am trying out a simple ASP.NET application which includes access to an SQL Server Database. It works fine on my local machine when I connect to the SQL Server and use SQL commands (via C#) to access it.
But my web hosting provider uses ODBC drivers for database access (they support the SQL database type). I would like to find out how I should connect to my SQL Server database and program the access in order for it to be ODBC compatible, so that I can deploy it to my web hosting server. I should also mention that I am using Visual Web Developer 2005 Express Edition.
Thanks for any help or pointers.
Kumar
View 3 Replies
View Related
Sep 24, 2007
Hi
I'm a newbie at SQL 2005 and I'm trying to create linked tables to our ERP system through ODBC. I can do this in MS Access or vb.net by using the ERP system's ODBC driver, but I am lost when it comes to SQL Server 2005.
Thanks for any help
View 1 Replies
View Related
Jan 17, 2008
Hello,
pls. let me know where I could post if this is the wrong place.
I have a Firebird 1.5 application. I created a linked server from my SQL
Server 2000 to the firebird database. In SQL Server Query Analyzer I get errors from various ODBC drivers with "normal" queryies like
SELECT LVNR FROM LINKEDSRV...LVVERW
Pls. note, this all works perfectly in MS Access databases with ODBC-Links to Firebird!
From a programmer of a commercial ODBC driver I heard that this problem may be caused internally by SQL Server, there may be no solution possible in the ODBC driver. One workaround would be to use the OPENQUERY-Syntax like
SELECT * FROM OPENQUERY(LINKEDSRV, 'select LVNR from LVVERW ')
Are there any other solutions? Are there any known issues with firebird odbc-drivers and sql server? Are
there any known good drivers for the use with sql-server? What is the purpose of OPENQUERY - workaround ODBC problems? Are there any settings in SQL Server 2000 (2005 Express) that could help? Are there any settings in ODBC DSN that would help?
regards
arno
PS: Here are my favorite error messages
Error -2147217900 [OLE/DB provider returned message: Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, char 89
"Col1014"] (Source: Microsoft OLE DB Provider for SQL Server) (SQL State:
01000) (NativeError: 7312)Error -2147217900 OLE DB-Fehlertrace [OLE/DB
Provider 'MSDASQL' ICommandPrepare:repare returned 0x80004005: ].
(Source: Microsoft OLE DB Provider for SQL Server) (SQL State: 01000)
(NativeError: 7300)Error -2147217900 Der OLE DB-Provider 'MSDASQL' meldete
einen Fehler. (Source: Microsoft OLE DB Provider for SQL Server) (SQL
State: 42000) (NativeError: 7399)
This "tricky" query does not work:
SELECT LVNR FROM LINKEDSRV...LVVERW;
Error -2147217900 OLE DB-Fehlertrace [Non-interface error: Column
'ERHALTENABSCHLAG' (compile-time ordinal 35) of object 'LVVERW' was reported
to have a DBTYPE of 5 at compile time and 131 at run time]. (Source:
Microsoft OLE DB Provider for SQL Server) (SQL State: 01000) (NativeError:
7300)Error -2147217900 Der OLE DB-Provider 'MSDASQL' hat inkonsistente
Metadaten für eine Spalte übergeben. Die Metadateninformationen wurden zur
Ausführungszeit geändert. (Source: Microsoft OLE DB Provider for SQL
Server) (SQL State: 42000) (NativeError: 7356)
View 2 Replies
View Related
Apr 16, 2008
Hi all,
Have just tried my sql server 2005 connected asp classic website on II7 for the first time and have gotten some errors.
First off I have unchecked show friendly errors in IE and have enabled ASP to send error messages to the browser.
My error I get is when I execute a basic .asp page:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database "mydatabasename" requested by the login. The login failed.
/index.asp, line 10 which is dbConnect.Open cstring
from this peice of code:
sub dbOpen()
set dbConnect = Server.CreateObject("ADODB.Connection")
cstring = "DSN=mysqldsn; Trusted Connection=yes"
dbConnect.Open cstring
end sub
I have gone into ODBC and have setup both a user dsn and file dsn that equals mysqldsn and points to my database (I know you only need to set up one DSN but I'm not sure which)
I also notice under mywebsite home panel there is a connection string option. Do I do anything with that?
Definatley a lot more to it than XP's II6!
Any help or advice would be greatly appreciated.
View 3 Replies
View Related
Dec 10, 2003
Hi Everybody,
On localhost this application works fine but when I put on remote server. I am getting following errors. For both localhost and server, I am using same remote sql 2000. I will appreciate any help.
Thanks,
Arif
Server Error in '/' Application.
--------------------------------------------------------------------------------
ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near ')'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: Microsoft.Data.Odbc.OdbcException: ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near ')'.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[OdbcException: ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near ')'.]
Microsoft.Data.Odbc.OdbcConnection.HandleError(IntPtr hHandle, SQL_HANDLE hType, RETCODE retcode) +27
Microsoft.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method) +838
Microsoft.Data.Odbc.OdbcCommand.ExecuteNonQuery() +80
Calgary.venues.Page_Load(Object sender, EventArgs e) in c:inetpubwwwrootCalgarySitevenuesvenues.aspx.vb:32
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +731
View 5 Replies
View Related
Jul 20, 2005
We are negotiating with a vendor and we have a few questions:1) From a licensing point of view, what is a database? Can we installmultiple copies of SQLServer on one box? In that case, would eachcopy be a different database?2) Within a single SQL Server installation, I can create multipledatabases, as listed in the Enterprise Manager. I can switch amongthem using "use ..." commands. Would these be treated as differentdatabases?3) We have copies of our transactional database in identicaldevelopment, QC, and production environments. Is this a singledatabase, or 3 databases?
View 3 Replies
View Related
May 17, 2008
Hey guys, this is my first post here. I just joined recently and I am loving the videos as they've really helped me step into ASP.NET and VB. Just some background, I used to be a CS major several years ago and programmed in Java and C, though I only went through 2 years before I moved majors. I didn't like the focus of my universities program, and decided to pursue other options. Ironically, I am now delving back into programming, but with a focus on web development, hence learning VB and ASP.NET. Anyways I am developing my first web application and I needed some help.Basically, what the program does is allow users to login to this web site and then store private information, which they can then access at a later time from any computer that is connected to the web. I have already setup user membership by following the video (lesson 8 of the ASP.NET series - Securing your Web site with Membership and Login Controls) from the Learnvisualstudio.net series. I can login to my site just fine, as well as creating a new user etc. The next step is designing the SQL database, and setting up the page that retrieves a users data, allowing them to view the private information they've stored, as well as to edit, create, and delete information.Unfortunately, while I can see the broad method of doing this, I am a bit lost in actually implementing it. The first stumbling block I am coming across is the SQL database itself. I have attached an image of how I have the database designed so far. Note that the aspnet_user table is the one that ASP.NET creates automatically when you enable membership controls and such.So basically, a user logs in, and they are greeted with a list of all of the "stickies" they have created. Each sticky has a title, as well as up to 4 fields, and you can enter the name of the field, as well as enter the actual data. It's foreign key ties back to the UserId that ASP.NET already created. The user can also organize their stickies into categories, hence that table. The Settings table will be where a users settings will be saved, such as which view mode they prefer etc. At this stage of development, that table is un-important and un-developed.So on to some of my questions. As it is designed now, there will be one table with every users stickies, as well as categories, and when a user logs in, the program will look at the category and stickies tables, and grab the ones that are associated to the users UserId. So one of my first questions is; is this a good design? I ask this from a security standpoint as well as a speed and efficiency standpoint. I want this site to be able to support at least 50,000 to 100,000 users, each with any number of "stickies" and "categories" With that size of a user base, would each user be looking at massive load times because the program would have to go through a very large table to grab only the ones that are linked with the users UserId? Say I have 50,000 users, and each user has 5 "stickies", that means that my user_stickies table would have 250,000 rows of data, and the program would be trying to find only 5 of those. Is this a really inefficient way of doing this? Should each user have their own category and stickies table? If so, how would I go about doing this? And in that case, instead of having a couple giant tables, my SQL DB would instead have a ton of tables, is this even any better?I have other questions, but I guess I'll start with this. What are your guys' thoughts? I am a newbie, so this may be a silly set of questions. I try to read up and research as much myself as I can, but sometimes you have so much information thrown at you at once its hard to grab out the specific answers you need.
View 4 Replies
View Related
Dec 6, 2004
I’m trying to design a database that allows the users to give each individual client/company unlimited addresses and salutations. I can build the design that accommodates this, but I cannot figure out how to handle them knowing which salutation to use with a mailing they might do to the clients.
I have put the Company Name and Position (title) in the address table so that when doing a mailing the company name and title are associated with the company address being mailed too. But again, I’m not sure how they would choose a salutation if they have many choices.
Looking for any of your thoughts or suggestions.
Thank you,
View 1 Replies
View Related
Jan 19, 2004
Hi,
I designed the database and there are two points I'm not sure that my design was correct:
1) In my search engine (in interface) i have an expression builder and user can save the expression he created. In this case don't chreate view in database, but I have a table named "Expressions" which saves expression name and expression. The reason I made it was: If I create view it doesn't make db to work faster because the select query in view runs every time when view was opened, but it makes my code more generic . But isn't it a design error?
2) I save 3 reserved fields in each table, and I don't know if I'll use them some day. The reason: adding a column to database is heavy operation. But isn't it a design error?
Thank you for advice
View 4 Replies
View Related
Apr 24, 2007
I have a few questions here about designing a database:
1. What is normalisation and de-norminalisation?
2. A quote:
normalisation has a series of steps (or rules) called forms the more steps you take, the more normalised your tables are......If you use the first 3 steps you would say that the tables are in their Third normal form
What is all that about - whats forms got to do with tables or what is he trying to say in the above quote?
3. When would you decide to create a new table in a database - i.e. what rules does everyone follow to say "ok i better capture this data in a new table and create a relationship to another table"
Thanks in advance
View 6 Replies
View Related
Oct 2, 2007
Hello,
I'm new to databases but not to programming in general. I've got a few applications which currently sit on a single PC and read/update a particular XML file on the box. The applications are C# apps and use FileSystemWatchers and a mutex to keep watch for changes and update the XML file as needed. It has worked reasonable well for me.
Now, I need to run these applications on separate machines, so it seemed a good point to consider moving toward a database solution.
I'm hoping that there is a straightforward solution using SQL Server that will ensure that my applications alway have the current view of the world. I had run into instances with my existing setup where once in a while an application thought its DataSet was up to date, but wasn't.
Can someone point me in the right direction to implement the solution? I suspect that this is a really common need for lots of programs that are distributed. I'm still quite a newbie with databases and SQL Server, so I'm not even sure I'm using the right terms to describe things.
Thanks,
Matt
View 1 Replies
View Related
Apr 19, 2007
Hello Gurus,
I wanted to restore a database to multiple data files from backup which has got only few data files. Is it possible do this?
Example : Backup has 4 data files and I need to restore it to 8 data files.
Thanks
Subbu
View 1 Replies
View Related
Jan 31, 2006
Our company is looking to move to a more robust database platform/setup, and it looks like sql 2005 + database mirroring is what we are looking for. First I have some questions about it.
Can a server that is functioning as a mirror for one database be the primary server for a seperate database? Basically think of a triangle of three sql servers, each serving as a primary server for a specific database, and using the next server in the triangle as a mirror for that specific database. To be more specific:
Server 1, Primary Database A, Mirroring Database C
Server 2, Primary Database B, Mirroring Database A
Server 3, Primary Database C, Mirroring Database B
If that is possible, how many witness servers would be needed to accomplish the above topology? On that note, how robust hardware wise should the witness server be?
On a completely seperate note, what method is recommended for interconnecting these servers? Is gigabit ethernet fast enough, or does it require something like fibre channel or infiniband?
Thank You!
View 1 Replies
View Related
Sep 10, 2012
We have a SQL database that uses Active Directory with Windows Authentication. Can users that are members of the Active Directory group that has read/write access to the SQL database create ODBC connections to access the database directly and update the data? They dont have individual logins on the server. They are only members of the Active Directory group that has a login?
View 1 Replies
View Related
Oct 28, 2004
Hi,
Please help share with me if you know the version compatibility matrix of Ms SQL Server, ODBC driver (sqlsrv32.dll), Driver Manager (odbc32.dll) and ODBC API spec. For instance, how can I know Ms SQL Server 2000 can work with which version of sqlsrv32.dll, a particular version of sqlsrv32.dll can work with which version of odbc32.dll and a certain version of sqlsrv32.dll/odbc32.dll conforms to which version of ODBC API spec (e.g. 3.5).
Any help will be appreciated.
Thanks,
vtluu.
View 1 Replies
View Related
Apr 9, 2008
I've a 32 bits application that runs on 64 bits Windows Server+MS-SQL.
I've created an ODBC DSN using c:WindowsSysWow64odbcad32.exe.
Sp, the program recognize the ODBC but having problem connecting.
The error look likes this:
***
[Microsoft][ODBC SQL Server Driver][SQL Server]Could not find server '<name>' in sys.server. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers.
***
Any help is appreciated.
Regards,
Ben
View 1 Replies
View Related
Jan 12, 2008
Hi Guys,
The ReorderList control has driven me to desperate ends tonight. I found that it will only work if my database has a field (OrderID in this case) of type int that it can use to keep track of the order. The problem is that I'm not using the ReorderList control for inserting into the database. This requires me to keep track of the OrderID myself and I have found that simply setting the OrderID field as the "Identity" will cause it not to work.
Common sense tells me that using the Identity is the best way to keep track of a ReorderList because it automatically numbers things as ther're inserted. If something is deleted, it shouldn't matter because it will still be in order even to there's a gap in the numbering.
The only solution I can think of is trying having TWO identity fields in the database, but since that's not possible, a field that mirrors the Identity. Can anyone advise me on how to do that? The below datasource does not insert anything into the OrderID field:
<asp:SqlDataSource ID="sdsItems" runat="server" ConnectionString='<%$ ConnectionStrings:testConnectionString %>'
SelectCommand="SELECT * FROM [Items]"
InsertCommand="INSERT INTO [Items] ([Name]) VALUES (@Name) SET @OrderID = SCOPE_IDENTITY()"
UpdateCommand="UPDATE [Items] SET [Name] = @Name, [OrderID] = @OrderID WHERE [ItemID] = @original_ItemID"
OldValuesParameterFormatString="original_{0}" DeleteCommand="DELETE FROM [Items] WHERE [ItemID] = @original_ItemID">
<InsertParameters>
<asp:Parameter Name="Name" Type="String" />
<asp:Parameter Direction="Output" Name="OrderID" Type="Int32" />
</InsertParameters>
<UpdateParameters>
<asp:Parameter Name="Name" Type="String" />
<asp:Parameter Name="OrderID" Type="Int32" />
<asp:Parameter Name="original_ItemID" Type="Int32" />
</UpdateParameters>
<DeleteParameters>
<asp:Parameter Name="original_ItemID" Type="Int32" />
</DeleteParameters>
</asp:SqlDataSource>
View 1 Replies
View Related
Aug 8, 2006
I have a db in SQL server 2000 developer edition. I am using Visual Studio 2005 standard, and also VWD Express. I would like to just access the database that is in SQL server 2000 so I can get on with developing the site, but VS2005 refuses to recognize the instance. It recognizes 2005 instances right away.The services are all running, the network protocols are enabled, uid's/pw all of that is correct. I am getting the "named pipes" error (the named pipes protocol is enabled).Any suggestions? I'd really rather just work with the db as-is in SQL 2000. But I can't get it to connect. I can connect to it if I export it to SQL 2005, (on the same development machine) but can't get the stored procs over to the 2005 db. So my web app is not finding the stored procs and won't run.Do I need to uninstall SQL 2005 from this box if I want to use SQL 2000?Thanks,--Donnie
View 13 Replies
View Related
Aug 28, 2007
All,
We have SQL 2005 db mirror configured with a witness server for high availability. Node 1 is the principal and Node 2 is the mirror. A nightly job creates a snapshot on Node 2. The snapshot is used for previous day reporting queries. We have now been asked to present another copy of the database for near-time reporting. I thought about possibly adding a peer-to-peer replication as part of my environment but was hoping to see what everyone else out there is doing.
Regards,
Ian
View 1 Replies
View Related
Dec 16, 1998
Hi,
we tried to set up a replication from SQL Server 6.5 to
an Oracle database via ODBC but all our attempts failed.
Where can I find a description about this subject ?
Cheers
Rainer
View 1 Replies
View Related
Sep 27, 2006
Is there a way to choose which database you want to connect to in the ODBC connection?
And does this differ from one ODBC connection to another, say for instance Teradata and SQL Server?
I was looking up the syntax and it seems like you can say Database=LACPP and it will choose the database....
I have also seen username/password@LACPP.SQLSERVER
Are there any documents out there that talk about how to create different kinds of ODBC strings and if you can always limit which database you are looking at?
-Bob
View 1 Replies
View Related
Aug 17, 2004
Hi, does anybody know how to access data in filemaker using ODBC.
I have read the help files that we can connect to filemaker database via ODBC.
I have tried to create DSN for that, but when I tried to connect using that DSN my C# application, It failed to retrieve the catalog information, it said that login failed.
I have no idea what the username and password that I have to used in my connection because as i knew that filemaker only use password, and i have tried to use that password too.
I never used filemaker before, but this time i need to retrieve data from filemaker, so please help :)
Thanks.
View 2 Replies
View Related
Jan 22, 2006
I'd like to set up an ODBC DSN to a table in a linked SQL Server, viamy local SQL Server.I'm having a few problems:1. When I use Enterprise Manager to link the remote SQL Server, itdoesn't allow me to select the database in the remote server. It onlyshows one database.2. When I use the Data Sources program to set up the ODBC DSN, it onlyshows databases in the local SQL Server, not in the linked one. If Itry typing it in: [NAMEOFLINKEDSERVER].databasename - it tells me thatit is an invalid table.
View 5 Replies
View Related
