Re: ODBC connection works, but connection string doesn't

please please.
I'm not trying to waste time - I do have a SQL Client string, but it's not
working - so I used ODBC to test if I could even connect.

Didn't you read through? I have an ASP.NET app that works, but now that
I've connected it to the real IIS server and trying to connect back to my
laptop whose OS is XP (yes, that's all I have right now)

I keep getting an Acces Denied. - My firewall is open to port 1433 and I
even specified my own - 1521 just to be rediculous - but it's not working.
I can't understand why ODBC will let me through.

"William (Bill) Vaughn" wrote:

> Ah, why are you wasting your time using ODBC to connect to SQL Server? Why
> not use the native SQL Client or SqlClient?
>
> --
> ____________________________________
> William (Bill) Vaughn
> Author, Mentor, Consultant
> Microsoft MVP
> INETA Speaker
> www.betav.com/blog/billva
> www.betav.com
> Please reply only to the newsgroup so that others can benefit.
> This posting is provided "AS IS" with no warranties, and confers no rights.
> __________________________________
>
> "jonefer" <jonefer@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:94410C6E-EFC5-4F2F-BD9A-3DE326FACA73@xxxxxxxxxxxxxxxx
> > I'm testing an app at work, the app is installed appropriately on the
> > server
> > and the SQL Server is on my laptop.
> > I've gotten a test ODBC to connect to my laptop (using named pipes)
> > but the connection string which I have in a Web.Config file, isn't
> > working.
> >
> > I don't know how much the summary of an ODBC connection setup could help
> > this but I provided it anyway:
> >
> > Here is my connection string: (the odbc test summary is below)
> >
> > <add key="SQLConn"
> > value = "Data Source=##.###.##.###;Network=dbnmpntw;Initial Catalog=
> > Membership;User=jonefer;Password=12345; " />
> > </appSettings>
> >
> > '==========odbc connection succeeded summary======
> > Data Source Name: CODATesting
> > Data Source Description: Testing SQL Server
> > Server: <IP Address>
> > Database: Membership
> > Language: (Default)
> > Translate Character Data: Yes
> > Log Long Running Queries: No
> > Log Driver Statistics: No
> > Use Integrated Security: No
> > Use Regional Settings: No
> > Prepared Statements Option: Drop temporary procedures on disconnect
> > Use Failover Server: No
> > Use ANSI Quoted Identifiers: Yes
> > Use ANSI Null, Paddings and Warnings: Yes
> > Data Encryption: No
> >
> > Thanks for help anyone can offer.
>
>
>
.

Relevant Pages

  • Re: Linking tables access - sql server 2005
    ... Another advantage of this method is that you don't need an ODBC setting on the local computer, ... Create a linked table to SQL Server without using a DSN ... Name of the table that you are linking to on the SQL Server database ... Function AttachDSNLessTable(stLocalTableName As String, stRemoteTableName As String, stServer As String, stDatabase As String, Optional stUsername As ...
    (microsoft.public.access.adp.sqlserver)
  • Re: database questions ala newbie pythonist
    ... > whatever else is necessary to build a valid SQL statement. ... is less than satisfactory in certain respects, and the odbc module ... I'm not quite sure why string substitution was used for the ProductID ... This does indeed generate a well-formed SQL statement, ...
    (comp.lang.python)
  • Re: Need ODBCDirect-ion
    ... through Jet before going to SQL via ODBC if it is designed well? ... database group asking this question). ... You need experience with sql server. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Problems with DAO and SQL Server
    ... String, Long or Date/Time. ... Will look at what is possible in the SQL string ... SQL or using TRIMin your query (if available, not familiar with SQL Server) ... Dim cnn As DAO.Connection ...
    (microsoft.public.excel.programming)
  • Re: FreeTextTable Search limitations
    ... Do a replace, replacing these illegal characters. ... resulting string is =0 characters, if so exit immediately with a return code ... Looking for a SQL Server replication book? ... > leaves the search blank and submits SQL returns a nice friendly ODBC ...
    (microsoft.public.sqlserver.fulltext)
Loading