search for: connectionopen

I am trying to connect to a remote sql server and I am getting the following error: c:/ruby/lib/ruby/site_ruby/1.8/DBD/ADO/ADO.rb:57:in `connect'': Open (DBI::Databa seError) OLE error code:80004005 in Microsoft OLE DB Provider for SQL Server [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. HRESULT error code:0x80020009 Exception occurred. from c:/ruby/lib/ruby/site_ruby/1.8/dbi/dbi.rb:5 84:in `connect'' In my code I am creating a connection using the following code: ActiveRecord::Base.establish_con...

...r 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 remotely using odbc under wine?? Please Help me Shanku

...e "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 conenct and show tables etc. and "sqlconnect()" in foxpro brings up the dialogue. What is bet...

...owed the instructions in the How-To on the wiki for SQL Server. The problem is that when attempting to connect to the database I receive the following errors: DBI::DatabaseError in RecipeController#new Open OLE error code:80004005 in Microsoft OLE DB Provider for SQL Server [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. HRESULT error code:0x80020009 Exception occurred. RAILS_ROOT: ./script/../config/.. I have done a search on google and have not found anything relevant that will help me alleviate this error. I would really like to get this runn...