search for: sqlstate

...;, "status_publish") puts dbh # get server version string and display it puts "Server version: " + dbh.get_server_info rescue Mysql::Error => e puts "Error code: #{e.errno}" puts "Error message: #{e.error}" puts "Error SQLSTATE: #{e.sqlstate}" if e.respond_to?("sqlstate") ensure # disconnect from server dbh.close if dbh end *OUTPUT: *C:/xampp/htdocs/Ruby187/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:36:in `gem_original_require'': no such file to load -- mysql (LoadError)...

...ning under wine, using an ODBC driver. Since there aren?t any MSSQL drivers for linux i decided to use de native ones, so i installed mdac_typ.exe . Then i configured the DSN using odbcad32.exe but when i tested the connection (configured using tcp/ip) an error message appeared Connection failed: SQLState: '01000' [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets] ConnectionOpen(Connect()) Connection failed: SQLState: '08001' SQL Server Error: 17 Microsoft][ODBC SQL Server Driver][TCP/IP Sockets] Specified SQL server not found. Has anyone been able to connect to a MSSQL server rem...

...t finished checking out Paul McNett's pages, however the MYSQL drivers he used for VFP8 are "no longer supported" when I do "wine setup.exe". I have a saved copy of my .wine that I reload from, so I figured I'd give it a try. The error I get is : Connection failed: SQLState: '01000' SQL Server Error: 2 [Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen (Connect()). Connection failed: SQLState:'08001' SQL Server Error: 17 [Microsoft][ODBC SQL Server Driver][Shared Memory] SQL Server does not exist or access denied. So if isql lets me co...

...restore works OK. The error message we are getting is this: On the 9.7 system: RESTORE DATABASE XYZZY USER db2inst9 using FROM '/db2home/restore1' INTO XYZZZ REPLACE EXISTING WITHOUT ROLLING FORWARD WITHOUT PROMPTING SQL1084C Shared memory segments cannot be allocated. SQLSTATE=57019 On the 10.5 system: RESTORE DATABASE XYZZY USER db2inst9 using FROM '/db2home/restore1' INTO XYZZZ REPLACE EXISTING WITHOUT ROLLING FORWARD WITHOUT PROMPTING SQL1084C The database manager failed to allocate shared memory because an`operating system kernel...

...n the iodbctest where I get an error. The errors are: iODBC Demonstration program This program shows an interactive SQL processor Driver Manager: 03.52.0001.0928 1: SQLDriverConnect = [iODBC][Driver Manager]Data source name not found and no default driver specified. Driver could not be loaded (0) SQLSTATE=IM002 1: ODBC_Connect = [iODBC][Driver Manager]Data source name not found and no default driver specified. Driver could not be loaded (0) SQLSTATE=IM002 I found that the help, at the link above, specifies to edit two files (odbc.ini and odbcinst.ini) in the /Library/ODBC folder. This folder does...

Hi, I have a User model, with a validates_uniqueness_of :login The generated SQL for the validation is: SELECT * FROM `users` WHERE (LOWER(users.login) = ''fernando'' AND users.id <> 10001) LIMIT 1; and it takes 0.13s to happen (my table has 10.000 rows) When I use the EXPLAIN instruction on it, it shows that it will use the primary_key as index, but this is not

...d. Communication protocol being used: TCP/IP. Communication API being used: SOCKETS. Location where the error was detected: Reply.fill(). Communication function detecting the error: InputStream.read(). Protocol specific error codes Read timed out, *, 0. Message: Read timed out Error Code : -4499 SQLState : null com.ibm.db2.jcc.c.DisconnectException: [ibm][db2][jcc][t4][2030][11211] A communication error has been detected. Communication protocol being used: TCP/IP. Communication API being used: SOCKETS. Location where the error was detected: Reply.fill(). Communication function detecting the erro...

i have a client application building power builder 11.5, i want connect with a server sql2008 I cant make this connection, i need help please... I have other application building power builder 9 and no have problem connection with sql2000 because use a driver odbc old

...nd 'wine control' then choose ODBC. then on the screen/page "How should SQL server verify the authenticity of the Login ID?" I select "with Windows NT authentication using the Network Login ID" then click on "Next" and got the following error Connection failed SQLState: 'HY000' SQL Server Error: 11002 [Microsoft][ODBC SQL Server Driver]Cannot generare SSPI context I beleive its not the wine issue, its some thing related to authentication i.e with samba, because I have created odbc connections(via wine) in a non MS AD environment, and then I have to selec...

Hi all! I've been working with openldap for many many years and I have found very usefull to turn debuging all the way on with loglevel -1 in slapd.conf to be able to inspect in the log the queries being sent to the server. I am now using samba 4.10.8 as a DC and a general purpose LDAP server and I havent found how to debug the queries that the server receives to try and figure out what might

...onnect(st, ...) : [RODBC] ERROR: Could not SQLDriverConnect 2: In odbcDriverConnect(st, ...) : ODBC connection failed aka (DBD::ODBC in Perl) Missing server name, port, or database name in call to CC_connect. (SQL-IM002) aka (iodbctest) SQLDriverConnectW = Unknown connect option (Set) (205) SQLSTATE=S1009 Figured it out, though: Leopard comes with iODBC installed, and many people install unixODBC additionally. Then then configure /sw/etc/odbc*.ini and unixODBC works, but iODBC doesn't. Even if you symlink the INI files to /Library/ODBC it doesn't work. Even if you remove theuni...

...rver: The job failed. Unable to determine if the owner (PRUPREF.COM\Administrator) of job Transaction Log Backup Job for DB Maintenance Plan 'Morning Database Backup' has server access (reason: Could not obtain information about Windows NT group/user 'PRUPREF.COM\Administrator'. [SQLSTATE 42000] (Error 8198)). I have turned the samba debuglevel up to 10, and I can see where it fails, but I am not sure why. Administrator is a proper username, and it logs into the domain no problem. It is almost like the NT password is not correct, this happens for any account I use, same error....

I''m trying to connect to a SQL Server db. I thought I installed the DBI component per the instructions, but its not working. When trying to start the ruby server, I get the message: Please install the sqlserver adapter: `gem install activerecord- sqlserver-adapter` But when I try to install the repository, I get this error message: could not find activerecord-sqlserver-adapter