Re: Connecting to SQL database

On Dec 20, 10:01 pm, bill ramsay <blah@blahdeblah> wrote:
On Fri, 14 Dec 2007 23:35:00 -0300, "Gabriel Genellina"

<gagsl-...@xxxxxxxxxxxx> wrote:
En Fri, 14 Dec 2007 23:24:24 -0300, Unknown <unkn...@xxxxxxxxxxxxxxx>
escribió:

I have successfully connected to SQL2000 and MSDEE databases in the
past, however I have to move to SQL2005 and SQLEXPRESS databases now.

Conn.ConnectionString = "Provider=SQLNCLI;Server=10.1.1.2;
Database=csrctest;Uid=bill;Pwd=bill"

Look for the right spelling athttp://www.connectionstrings.com/

looks like my spelling is ok, any other ideas?

thanks for the suggestion above.

kind regards

bill

This is working for me to the internal network (I'm using adodbapi,
but the connection string should be the same)

'Provider=sqloledb;Data Source=dbserv;Initial Catalog=ndb;User
Id=foo;Password=bar;'

I just tested, and this works well too

'Provider=SQLNCLI;Data Source=dbserv;Initial Catalog=ndb;User
Id=foo;Password=bar;'

and to my local instance (Hermes is my machine)

'Provider=SQLNCLI;Data Source=HERMES\\SQLEXPRESS;Initial
Catalog=;User Id=sa;Password=pw666;'

Can you connect to the server using SqlServer Management Studio? Can
you create an odbc connection to the server? Unlike 2000, SqlServer
2005 has tcp/ip connections turned off by default, so you might want
to check that with the SqlServer Surface Area Configuration tool.

Externally we're still running 2000, so I don't know how connecting
over the interweb differs.

When you've figured out how to connect, and if you're open to a
suggestion, you might want to try out the adodbapi package (http://
adodbapi.sourceforge.net/). It is a thin wrapper over ADO, and works
quite well. Then you'll get to use the Python db-api v.2.0 syntax,
which is oodles less typing than straight ADO.

-- bjorn

.

Relevant Pages

  • copy database error 12291 and 208
    ... when trying to copy a database from SQLSERVER 2000 To SQLSERVVER 2005 using Copy Database Wizard it fails and give two errors in events: ... InnerException-->An error has occurred while establishing a connection to the server. ... destination server is running Windows 2003 server and SQLSERVER 2005. ...
    (microsoft.public.sqlserver.tools)
  • Re: Connection Pool in SQLserver 2005
    ... If the users are constantly in/out of the server, ... using connection pooling. ... through all layers all the way into the sqlserver. ... the sqlserver connection pool cannot be used...If ...
    (microsoft.public.sqlserver.connect)
  • Recurring SQLServer errors
    ... I have a W2k Server with SQLServer 2000 on it. ... All my site connection strings make DSN-less connections and SQLServer ... "SQL Server does not exist or access denied" ...
    (microsoft.public.inetserver.asp.db)
  • Cannot Delete Using ADO and sqlServer 2005
    ... Access 2007 with a backend going from sqlServer 7 to sqlServer 2005. ... "Could not find server "SERVERName" in sysservers. ... The connection "cnn" has already been established elsewhere. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Outgoing POP3 email missing/lost/not received
    ... Funny thing is that I have had this ISP for 8 years and it has always been ... It looks like when you last ran CEICW, you set the ISP's mail server to: ... Internet Connection Wizard. ... After the wizard completes, the following network connection ...
    (microsoft.public.windows.server.sbs)