I create a Test database in SQL server, also I add new user in security folder. Also I add this user in Test database, the permission are: Public, and db_owner. But when I let the user try to open the database, it is ODBC – Connection failed. I add another user a few months ago, she works fine. But the new user I added in didn’t work, did you know why. I am sure I add the same permission as the later user. Thanks.
View 2 RepliesRunning a database using sql server. User, rights, password set up on the server side and is functioning fine on the users normal desktop. But here is the problem. When the user goes to a different desktop they have never been on before and a new user profile is created on that desktop, they are unable to access the database. When using the front end (access), an odbc connection failure popup occurs when trying to retrieve data. The wierd part is that the odbc connection was set up under admin tools just like it is setup on the working desktop. Also the connection tests successfully. This leads me to believe that it is a desktop side problem and not server side. It is only a problem when a new user profile is setup on a desktop that the user has never been on before.
Any help would be appreciated.
Barry
I have installed SQL2014 on a server [hostname: sql2014]. Â I created an user "ABC" and even granted "system admin" server role. Â I tested login from the Management Studio in the local server and succeeded.Now I would like to create an ODBC connection from a IIS server to this SQL2014. When I tried create the system DSN with the user "ABC" by selecting the "With SQL Server authentication using a login ID and password entered by the user". Â It gave me the following error: Connection Failed:
SQLState: '28000'
SQL Server Error: 18456
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'ABC'.
From the sql server log file viewer, I found an event with the following:
Source: MSSQLSERVER
Category: (4)
Event: 18456
Computer: SQL2014
Message
Login failed for user 'ABC'. Reason: Could not find a login matching the name provided. [Client: 192.168.0.1]I can create the ODBC connection with the option "With Windows NT authentication using the network login ID". Â But for security reason, I need to use SQL server authentication.Here are some more information.Both SQL and IIS servers are running Windows 2012 DataCenter.I am using Mix mode authentication for the SQL server.I turned off firewall on both servers.I can ping each other successfully.I tried install the SQL server native client for SQL2012, but the error is just the same.
We are using an Access 2002 front-end with SQL Server 2000 as the database.
There is a table (dbo_PrivateGroup) that if you try to open it in the table view, in a query, in a report, or through the application, you get the following Error message:
ODBC--connection to 'unlocking' failed.
Does anyone know what this means and how I am supposed to get around this?
I tried it on the actual server itself and I can read the table through Access, through the application when it is running, and through Enterprise Manager. This machine is logged in with "Administrator" as the user id.
The table is on a different database than the other tables in the application.
It is a user table. And I checked the permissions and all users have select, insert, and delete permissions allowed. However, when I go to look at the columns property, none are checked for any user and when I go to check the boxes for all columns, I hit Apply, then Close. When I go back into that screen for that given user, the columns weren't saved.
My database knowledge is creating tables, stored procedures, and triggers. They don't have a DBA here and my knowledge is limited. Is the problem in SQL Server or Access?
I don't know if any of this makes sense. But if it does, any help would be greatly appreciated.
Thanks.
I moved a sql 2000 database to a sql 2005 server. I have a front end in access 2003. I manually created an ODBC data source system DSN using the ODBC Data Source Administrator just like it was on the other server. I can connect fine but users are saying their getting an odbc call fail. I created the connection and relinked the tables to the new server with the moved database. I completed the same task with another database and the user can connect fine. What could be the problem?
View 1 Replies View RelatedDear all,
I want to create an ODBC connection using windows authentication but it always failed. The error display that the database server not found. Is the any configuration I should set before create the ODBC ?
Thanks in advance.
Best regards,
Hery
i have msde 2000 running on a server i am able to create an odbc connection to my db on that pc. when i try to create anpther odbc connection on another pc on that network i get the following error:
sql state '01000'
server error 2
[microsoft][odbc sql server driver][named pipes] connectionopen (connect()).
connection failed
sql state '08001'
server error 17
[microsoft][odbc sql server driver][named pipes]server does not exist or access denied.
what do i have to do to get this odbc connection on this pc working?
Thank You,
Thomas
hello,
im trying to create an ODBC data source from a SQL SERVER 2005 database located in a remoted pc.
Client----------->PC1 : win 2000 sp4, not sql server
Remote server--->PC2 : win 2000 sp4, sql server 2005 express
From the Command Prompt, im typing "ping PC2" successfully.
After, in the ODBC datasource administrator-->System DNS tab, i choose "sql server" as a new data source , and in the server box , i'm typing PC2/SQLEXPRESS.
In the next steps, im typing the user-passwords.
The error :
connection failed
...
[microsoft][odbc sql server driver][named pipes]ConnectionOpen(CreateFile()).
Connection failed:
SQLState: '08001'
..
Client unable to establish connection
What goes wrong?
I follow the same steps locally, and everything is OK.
Sorry for my bad english:cool:
I hope this is a fairly simple problem that I'm just missing. I've installed SQL Server 2005 Developer Edition on Windows XP Professional. I'm trying to create an ODBC data source under an ID I created ("InstallOwner") that is part of the administrators group. In the Wizard, I give it a name and default to the "local" server. I selected to authenticate the ID using SQL Server authentication. However when I enter the ID and Password, I get the following error.
"Connection Failed - SQL State=28000, SQL Server Error: 18456, [microsoft][SQL Native Client][SQL Server] Login Failed for user "InstallOwner". If I use the "sa" account, it works fine. Can someone point me in the right direction?
SQL State: '28000'
SQL Server Error: 18452
[Microsoft][ODBC SQL Server Driver][SQL Server] Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server Connection.
Another NT Account (Previously created account) has no problem to connect to the database, however a new NT Account assisged to a new DB role cannot login.
Any special rights required for the new NT Account (at NT or SQL database)?
Sir i am trying to connect sql from my LAN to my networked computers but whenever i tried to register it through Enterprise manager i get following "SQL Server registration failed because of the conection failure displayed below.Do you wish to Register anyway? Login failed for user 'SW17/Guest'
where SW17/ is my another computer name...
i have checked tcp and named pipes
and confirm username for sql authentication too
please help me as i being late submit my project
I am using SSIS 2014 with the below .net framework version and installed in Windows server 2012 R2 . I have installed my client's odbc drivers (both 32 bit and 64 bit) in my production server and created ODBC system DSNs for 32 bit and 64 bit.
When i open SSIS 2014 and tried to create the odbc connection but i can able to see only the 32 bit system DSN connection ,i can't able to see my 64 bit odbc system dsn connection.
Microsoft Visual Studio 2012 Shell (Integrated)
Version 11.0.50727.1 RTMREL
Microsoft .NET Framework
Version 4.5.51650
SQL Server Integration Services  Â
Microsoft SQL Server Integration Services Designer
Version 12.0.1524.0
And i installed my client odbc drivers(32,64 bit) and created ODBC system DSNs in my local system and when i open ssis 2014 and i can able to see both the ODBC system DSNS(32,64) connections from SSIS ODBC connection.
I am using below version of .net framework in my local system which was installed in windows 7 and i have SSIS 2012 also installed in my system and i can able to see both ODBC connections using 2012 as well in my local system.
Microsoft Visual Studio 2012 Shell (Integrated)
Version 11.0.50727.1 RTMREL
Microsoft .NET Framework
Version 4.5.50938
SQL Server Integration Services  Â
Microsoft SQL Server Integration Services Designer
Version 12.0.1524.0
why i can not see the ODBC 64 bit system DSN connection from SSIS in my production server ?
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?
Can anyone give a quick description of the meaning of this message andwhat needs to be done to get a connection.I'm running DBArtisan with SQLServer 2000 client SP4 installed.I also get the same message with MS Enterprise Manager so this iscoming out of the actual ODBC connection attempt.Thanks in advance!
View 1 Replies View RelatedWhen I create a new odbc connection to a SQL server 2005 Db I get a failure telling me dat de SQL server does not allow remote connections.
How can I allow the server to allow this.
Any help appreciated
regards
I have a package that uses a for loop to iterate through an unknown amount of excel files and pull their data into a table. However, there will be cases when the file is corrupted or has some sort of problem so that either the transformation will fail or the excel data source will fail with an oledb connection error.
Could anyone suggest a clean way to trap these errors? Specifically, the "Cannot Aquire Connection from Connection Manager", which is the excel connection.
Thanks,
John T
Full message:
Connection handshake failed. An OS call failed: (8009030c) 0x8009030c(The logon attempt failed). State 66
Under these conditions, setting trustworthy on on the sending and receiving databases will solve this issue
1) Communicating between multiple instances
2) Using Kerberos security (NT Authentication, i.e. not certificates)
I am running the Sept CTP. I have created a SSIS package that pulls data from a text file and inserts into a database. When I run the package on the DB server it runs fine. I have moved the package the the web server (we are attempting to kick off the package from a web site) and we get connections errors. We are running the package using dtexec from the command line.
View 7 Replies View RelatedIn my ssis package,
I have a DSN connection like this: "DSN=myDSNname". Which decide from i have to pull the data.
By using OLE DB Source Editor, I want to assign that ODBC Connection to it.
By data source Reader i can achive this but where i have to pass the hard-code SQL Query that i don't want.
i'm using the variable for dynamic SQL command.
Thanks.
Manoj
Hello all.
Please excuse my lack of poper terminology when describing my issue to you, as I am very new to databases.
I have set up a SQL Server database which connects via MS Access. The application works fine, except when trying to connect through VPN.
Through System DSN, I changed the server name (FSERVER) to the server IP address, and test completed successfully. I am also able to ping the server when connected via VPN. However, when I try to start the application, I receive the following error after several seconds:
ODBC-- call failed.
That's it. No other information about the error. I read somewhere to make sure the MDAC versions are the same, which they are.
As I say, I am quite new to this, but would really appreciate any guidance to help me through.
Thanks in advance!
Nils
I am running SQL Server 2000 sp4 in Win Server 2003. I have a DTS
packages which connects to FileMaker 6 files via the ODBC driver
installed with FielMaker.
The DTS packages work correctly when
executed directly. However, when executed from a SQL Server Agent job,
the same DTS packages fail. Always with the same message:
Error: -2147467259 (80004005);
Provider Error: 16394 (400A)
Error string: [FileMaker][ODBC FileMaker Pro driver][FileMaker Pro]Connect failed
Error source: Microsoft OLE DB Provider for ODBC Drivers
Searching
for info on the above message seems to indicate a permissions problem.
However, I am running the jobs with an full administrator account. All
connections and the FielMaker files reside on the one server.
Any help on this would be greatly appreciated.
Thank you.
Hello all,
I have a problem which I can't seem to understand what is the cause. Please help!!!
I have this access which run under oracle 10g. Here is the code (below) that I always get error in. When I got into this error, I go to Control Panel -> Administrative Tools-> Data Sources (ODBC) then I choose on acc (microsoft Access Driver (*.mdb)) and click Configure. I select the access and click repair. It get through and I thought that I solve the error, but every time that I close and open the access when try to run, I receive the same error again. If I goes to the same process, click repair. It work, but I have to do it every time that I close and re-open the access. Does anyone know how to make it default so that I don't have to go the same process every time. Thank you.
Run-time error '-2147467259 (80004005)':
ODBC -- call failed.
Code Snippet
Dim White As Object
Set White = CreateObject("APToolkit.Object")
White.openoutputfile "C:White_" & controlno & ".pdf"
White.openinputfile "C:White.pdf"
White.setmasterquery "DSN=acc", "", "", "-1", "select e.*, f.* from prod_test e, stc f where e.control_number=" & controlno
White.addrelatedquery "DSN=acc", "", "", "-1", "select *, PROD_items.TOT & ' (kgs)' as TOT, CDbl([qty]/300)*CDbl([price]) as PRICE from PROD_ITEMS where control_number=" & controlno & "", "True"
White.setdbmultirowseparator ""
White.doformformatting = True
White.SetDefaultDBMergeFlag -998
White.FlattenRemainingFormFields = True
White.dbtoform False
White.resetformfields
White.closeoutputfile
Set White= Nothing
I created a single step plan that does integrity checks. It fails with the error below. I created a new connection using our clusters virtual sql name.
Executed as user: ACCTCOMsqlagent. ...n 9.00.3042.00 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 1:10:06 PM Error: 2008-02-15 13:10:49.02 Code: 0xC00291EC Source: {0CF32F3D-A8D1-492A-9C0F-AD4E0FC67D14} Execute SQL Task Description: Failed to acquire connection "Local server connection". Connection may not be configured correctly or you may not have the right permissions on this connection. End Error Warning: 2008-02-15 13:10:49.02 Code: 0x80019002 Source: OnPreExecute Description: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors. End Warning Error: 2008-02-15 13:11:31.26 Code: 0xC0024104 Source: Check Database Integrity Ta... The package execution fa... The step failed.
The agent and db are running under domain accounts and the job is owned by sa.
Thanks for your help.
Hi,
i am getting this exception i.e."
The TCP/IP connection to the host has failed. java.net.ConnectException: Connection timed out: connect" whenever i try to connect to the remote DB which is present at a different system.
Hi All,
I am getting the following error if I am using the package "Transaction Option=Required" while running through Sql Job:
The AcquireConnection method call to the connection manager "<connection name>" failed with error code 0xC0202009.
while I running the SSIS package on BI environment, I am getting the following error:
[Connection manager "<connection name>"] Error: The SSIS Runtime has failed to enlist the OLE DB connection in a distributed transaction with error 0x8004D00A "Unable to enlist in the transaction.".
I know the alternative solution is to make the "Transaction Option=Supported", but in my case I have run the whole flow in a single transaction. I came to know that this has been fixed in the service pack1(ref. to http://support.microsoft.com/kb/914375). FYI.. some time it was running successful.
I have taken all the necessary step to run the SSIS package in a distributed transaction(like the steps for MSDTC) and also created the package flow in a sequence.
I was going through the link - http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=160340&SiteID=1 but all those didn't solve my problem.
If anyone can help me it will be great. or it is a bug in SSIS?
Thanks.
Jena
I am working in a distributed environment, I verified msgs have been successfully send from server1 db1 to server2 db2, but I still get the following error msg from the sender server through SQL profile:
Connection attempt failed with error: '10061(No connection could be made because the target machine actively refused it.)'.
Does anyone experienced the samething?
Thanks!
Hello, I have a sql 2005 server, and I am a developer, with the database on my own machine. It alwayws works for me but after some minutes the other developer cant work in the application
He got this error
Login failed for user ''. The user is not associated with a trusted SQL Server connection. [CLIENT: 192.168.1.140]
and When I see the log event after that error, it comes with another error.
SSPI handshake failed with error code 0x8009030c while establishing a connection with integrated security; the connection has been closed. [CLIENT: 192.168.1.140]
He has IIS5 and me too.
I created a user on the domain called ASPSYS with password, then in the IIS on anonymous authentication I put that user with that password, and it works, on both machines.
and in the connection string I have.
<add key="sqlconn" value="Data Source=ESTACION15;Initial Catalog=GescomDefinitiva;Integrated Security=SSPI; Trusted_Connection=true"/>
I go to the profiler, and I see that when he browses a page, the database is accesed with user ASPSYS, but when I browse a page, the database is accesed with user SElevalencia.
Thats strange.
The only way that the other developer can work again on the project is to restart the whole machine. He has windows xp profession, I have windows 2000.
If you want me to send logs please tellme
hi all,
i got the error, when i run my package after deploy into the server machine;
i can able to run that package in my local machine, if i deploy it to the server or some remote machine, its not running, and rises error messages, that says cant accquire connection from the connection manager;
the problem might be with the login name and password; i could not see any password in any of my config file, or connection manager while running the package.
how to resolve this problem?? please help me!
Hi!It has been weeks now that I have been trying to fix an error that Iencounter everytime it gets to the code at runtime:SQLStmt = "SELECT Sum([Quantity in Stock]) As TotalInStock,Sum([Cost] * [Quantity in Stock]) AS TotalCost " & _"FROM [Inventory Products] WHERE [ItemNumber] = '" & ItemNum & "'"Set InvP = CurDB.OpenRecordset(SQLStmt, DB_OPEN_DYNASET) '==>it gets the error hereI tried also to implement the same code using ADODB but still go the sameerror: "ODBC--call failed".There are other events where similar code is executed without any problemsat all.Any guidance would be helpful.Thanks
View 2 Replies View RelatedWe have this fairly simple Access database with a link table to a view in an SQL Server. The Select Query in Access is a simple select from this view with a view criteria set. Nothing fancy. What is driving is moderately crazy is that this Select Query in Access seems to work fine for months and than all of a sudden (same query performed around the same time with about the same workload on the SQL-Server) it responses with the helpful "ODBC-Call Failed" message. Closing the Access database, taking a coffee, coming back againg and try the exact same Select Query normally works, no "ODBC-Call Failed" message.
It not happens always, mosty we're fine.
When it happens it happens for all subsequent queries tried. We have to close and reopen the Access database and pray to the good Lord that it works.
We would be very interested in someone with a solution to this problem.
Dear all,
I have a problem when I tried to create an ODBC to SQL Express from Windows 98. Is there any component that I have to install first ?
Thanks in advance.
Best regards,
Hery
I am having an issue that i can't seem to resolve. By no means am I an expert with odbc connections and what not but any help would be great.
here is my issue. I have a 64 Bit terminal server that is running MS Access. I have defined my DSN within the 32 bit admin utility and it connects without a problem As soon as i try to link tables and make a connection to the database from within Access i recieve an "ODBC CALL FAILED" message.
I enabled tracing and here is what i got.....this doesn't mean anything to me but hopefully it does to someone.....
PaintJobShip_Ma 1388-ecc ENTER SQLAllocEnv
HENV * 002DB3C4
PaintJobShip_Ma 1388-ecc EXIT SQLAllocEnv with return code 0 (SQL_SUCCESS)
HENV * 0x002DB3C4 ( 0x07f42538)
PaintJobShip_Ma 1388-ecc ENTER SQLAllocConnect
HENV 07F42538
HDBC * 002DB4D4
PaintJobShip_Ma 1388-ecc EXIT SQLAllocConnect with return code 0 (SQL_SUCCESS)
HENV 07F42538
HDBC * 0x002DB4D4 ( 0x07f425e0)
PaintJobShip_Ma 1388-ecc ENTER SQLSetConnectOption
HDBC 07F425E0
SQLINTEGER 103 <SQL_LOGIN_TIMEOUT>
SQLPOINTER 0x00000014
PaintJobShip_Ma 1388-ecc EXIT SQLSetConnectOption with return code 0 (SQL_SUCCESS)
HDBC 07F425E0
SQLINTEGER 103 <SQL_LOGIN_TIMEOUT>
SQLPOINTER 0x00000014 (BADMEM)
PaintJobShip_Ma 1388-ecc ENTER SQLSetConnectAttrW
SQLHDBC 07F425E0
SQLINTEGER 30002 <unknown>
SQLPOINTER [Unknown attribute 30002]
SQLINTEGER -3
PaintJobShip_Ma 1388-ecc EXIT SQLSetConnectAttrW with return code 0 (SQL_SUCCESS)
SQLHDBC 07F425E0
SQLINTEGER 30002 <unknown>
SQLPOINTER [Unknown attribute 30002]
SQLINTEGER -3
PaintJobShip_Ma 1388-ecc ENTER SQLDriverConnectW
HDBC 07F425E0
HWND 000800D4
WCHAR * 0x4BF78088 [ -3] "****** 0"
SWORD -3
WCHAR * 0x4BF78088
SWORD 2
SWORD * 0x00000000
UWORD 1 <SQL_DRIVER_COMPLETE>
PaintJobShip_Ma 1388-ecc EXIT SQLDriverConnectW with return code -1 (SQL_ERROR)
HDBC 07F425E0
HWND 000800D4
WCHAR * 0x4BF78088 [ -3] "****** 0"
SWORD -3
WCHAR * 0x4BF78088
SWORD 2
SWORD * 0x00000000
UWORD 1 <SQL_DRIVER_COMPLETE>
DIAG [S1000] [Oracle][ODBC][Ora]ORA-06413: Connection not open.
(6413)
DIAG [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed (0)
DIAG [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed (0)
PaintJobShip_Ma 1388-ecc ENTER SQLErrorW
HENV 07F42538
HDBC 07F425E0
HSTMT 00000000
WCHAR * 0x002DB390 (NYI)
SDWORD * 0x002DB3DC
WCHAR * 0x036A4458
SWORD 4095
SWORD * 0x002DB3C8
PaintJobShip_Ma 1388-ecc EXIT SQLErrorW with return code 0 (SQL_SUCCESS)
HENV 07F42538
HDBC 07F425E0
HSTMT 00000000
WCHAR * 0x002DB390 (NYI)
SDWORD * 0x002DB3DC (6413)
WCHAR * 0x036A4458 [ 102] "[Oracle][ODBC][Ora]ORA-06413: Connection not open. a 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0"
SWORD 4095
SWORD * 0x002DB3C8 (102)
PaintJobShip_Ma 1388-ecc ENTER SQLErrorW
HENV 07F42538
HDBC 07F425E0
HSTMT 00000000
WCHAR * 0x002DB390 (NYI)
SDWORD * 0x002DB3DC
WCHAR * 0x036A44D6
SWORD 4032
SWORD * 0x002DB3C8
PaintJobShip_Ma 1388-ecc EXIT SQLErrorW with return code 0 (SQL_SUCCESS)
HENV 07F42538
HDBC 07F425E0
HSTMT 00000000
WCHAR * 0x002DB390 (NYI)
SDWORD * 0x002DB3DC (0)
WCHAR * 0x036A44D6 [ 66] "[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed"
SWORD 4032
SWORD * 0x002DB3C8 (66)
PaintJobShip_Ma 1388-ecc ENTER SQLErrorW
HENV 07F42538
HDBC 07F425E0
HSTMT 00000000
WCHAR * 0x002DB390 (NYI)
SDWORD * 0x002DB3DC
WCHAR * 0x036A456C
SWORD 3957
SWORD * 0x002DB3C8
PaintJobShip_Ma 1388-ecc EXIT SQLErrorW with return code 0 (SQL_SUCCESS)
HENV 07F42538
HDBC 07F425E0
HSTMT 00000000
WCHAR * 0x002DB390 (NYI)
SDWORD * 0x002DB3DC (0)
WCHAR * 0x036A456C [ 66] "[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed"
SWORD 3957
SWORD * 0x002DB3C8 (66)
PaintJobShip_Ma 1388-ecc ENTER SQLErrorW
HENV 07F42538
HDBC 07F425E0
HSTMT 00000000
WCHAR * 0x002DB390 (NYI)
SDWORD * 0x002DB3DC
WCHAR * 0x036A4602
SWORD 3882
SWORD * 0x002DB3C8
PaintJobShip_Ma 1388-ecc EXIT SQLErrorW with return code 100 (SQL_NO_DATA_FOUND)
HENV 07F42538
HDBC 07F425E0
HSTMT 00000000
WCHAR * 0x002DB390 (NYI)
SDWORD * 0x002DB3DC
WCHAR * 0x036A4602
SWORD 3882
SWORD * 0x002DB3C8
PaintJobShip_Ma 1388-ecc ENTER SQLFreeConnect
HDBC 07F425E0
PaintJobShip_Ma 1388-ecc EXIT SQLFreeConnect with return code 0 (SQL_SUCCESS)
HDBC 07F425E0
any help would be great....thanks.
Hi All,
I have a database with primary and Unique key contraints on SQL Server 2000. I'm front ending it with Access 2k.
I want to trap the error when the Unique key constraint is hit, but i can't capture the error number. All attempts return error 0.
The error i get is
[Microsoft][ODBC SQL Server Driver][SQL Server]Violation of UNIQUE KEY constraint 'IX_lut_Referral_Source'. Cannot insert duplicate key in object 'lut_Referral_Source'. (#2627)[Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated. (#3621)
I've tried the soultion given here http://support.microsoft.com/kb/q185384 but now get a Type mismatch error on errStored
SaveRecODBCErr:
' The function failed because of an ODBC error.
' Below are a list of some of the known error numbers.
' If you are not receiving an error in this list,
' add that error to the Select Case statement.
For Each errStored In DBEngine.Errors
Thanks for your help