Ado Error 80040e14
Contents |
your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: ado error code 80040e14 click the register link above to proceed. To start viewing messages,
Adodb Error 80040e14
select the forum that you want to visit from the selection below. Results 1 to 3 of 3 ado error 2147217900 Thread: ADO/SQL error -2147217900 (80040e14) Tweet Thread Tools Show Printable Version Subscribe to this Thread… Search Thread Advanced Search Display Linear Mode Switch to Hybrid Mode Switch
Error 80040e14 Incorrect Syntax Near
to Threaded Mode 10-11-05,06:56 #1 Trinsan View Profile View Forum Posts Registered User Join Date Oct 2005 Posts 183 Unanswered: ADO/SQL error -2147217900 (80040e14) With the below procedure I want to run a stored procedure on a SQL-server 2000, but for some reason I get run-time error -2147217900 (80040e14), stating that the stored procedure doesn't exist. As it 0x80040e14 ssis does exist, the connection is open, and running the code in query analyzer works, I center the problem down to the database being used. But whats wrong? The user and database has been added to the system dsn AccessSQL, user and passwords works fine in query analyzer.. yet for some reason it apparently sends the ado command to the wrong database, and thus can't find the stored procedure. Thanks in advance, Trin Dim forbindelse As New ADODB.Connection Dim kommando As New ADODB.Command Dim pam1, pam2 As ADODB.Parameter Dim forbindelseDSN As String Dim strSQLland As String Dim strSQLtid As String forbindelse.Open "DSN=AccessSQL;APP=Track Exporter;Database=Gramex_UDV;Network=DBMSSOCN;", "aaaa", "tttt" kommando.CommandText = "TRACK_EXPORT_sp_opdatland" kommando.CommandType = adCmdStoredProc kommando.ActiveConnection = forbindelse Set pam1 = kommando.CreateParameter("land", adChar, adParamInput, 2) Set pam2 = kommando.CreateParameter("org", adChar, adParamInput, 4) kommando.Parameters.Append pam1 kommando.Parameters.Append pam2 pam1.Value = "'" & kombo_land & "'" pam2.Value = "'" & kombo_org & "'" kommando.Execute forbindelse.Close Set kommando = Nothing Set forbindelse = Nothing Reply With Quote 10-11-05,07:37 #2 Trinsan View Profile View Forum Posts Registered User Join Date Oct 200
Unanswered Topics Wrox Programmer Forums > ASP.NET and ASP > ASP 3 Classic ASP Active Server Pages 3.0 > Classic ASP Databases Microsoft OLE DB
80040e14 Incorrect Syntax Near
error '80040e14' User Name Remember Me? Password Reminder Password Register Register | FAQ | Members List | Calendar | Today's Posts | Search Classic ASP Databases Discuss using ASP 3 to work with data in databases, including ASP Database Setup issues from the old P2P forum on this specific subtopic. See also the book forum Beginning ASP.NET Databases for questions http://www.dbforums.com/showthread.php?1198547-ADO-SQL-error-2147217900-(80040e14) specific to that book. NOT for ASP.NET 1.0, 1.1, or 2.0. Search Forums Show Threads Show Posts Advanced Search Find All Thanked Posts Go to Page... Welcome to the p2p.wrox.com Forums. You are currently viewing the Classic ASP Databases section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website http://p2p.wrox.com/classic-asp-databases/41675-microsoft-ole-db-error-80040e14.html developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free . Thread Tools Display Modes #1 (permalink) April 24th, 2006, 10:53 AM griffy99 Registered User Join Date: Apr 2006 Location: , , . Posts: 1 Thanks: 0 Thanked 0 Times in 0 Posts Microsoft OLE DB error '80040e14' I'm receiving Microsoft OLE DB error '80040e14' that states: Line 1: Incorrect syntax near ';'. at Line 41 (which begins with the rsOpen statement) The code is: <% aspUser=Request.ServerVariables("AUTH_USER") aspID=Request.QueryString("ID") Set conn = Server.CreateObject("ADODB.Connection") strConnString="Provider=sqloledb;Data Source=devsql;Initial Catalog=CSOSAPhone;User ID=sa" conn.open strConnString Set rs = Server.CreateObject("ADODB.Recordset") sql="SELECT * FROM Phone WHERE ID=" & aspID & ";" rs.Open sql, conn, 3, 3 %>